Venkata Siva Teja Meka
Hyderabad
Summary
- Over 12 years of IT and Business Experience in software design, development, debugging, deployment, documentation and testing of Client-Server, Web/Windows based Applications, SQL server Development and business intelligence of Microsoft SQL Server 2008(R2)/2012/2016.
Overview
14
14
years of professional experience
Work History
Developer Advisor
Tata Consultancy Services (TCS)
01.2020 - Current
- Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to RDBMS tables
- Migrated 2008 SSIS packages to 2012, later from 2012 to 2016
- Created complex SSIS packages using proper control and data flow elements with error handling
- Created tabular reports, and parameterized reports per business requirement using SSRS & Tableau
- Designed and implemented SQL code, stored procedures and triggers for automating tasks in SQL, Teradata, PostGre SQL, Oracle servers
- Developed PL/SQL packages, Procedures, Functions, Shell scripts to validate the data and insert the validated data into oracle standard interface tables and then into Oracle base tables using API's
- Databases SQL Server 2016/2012/2008 R2, Oracle and MS Access
- Database Tools SQL Server Management Studio, Query Optimizer, SQL Profiler, Oracle 10g, 11gR2, 12I, ETL, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio(BIDS), SQL CMD
- Languages C#, T-SQL, VB.Net, ASP, ASP.Net, UNIX, C, C++
- Reporting Tools SQL Server Reporting (SSRS), Micro Strategy 8.x/9.x/10.x, Tableau Reports, Business Objects, Crystal Reports
- Change Management Tool Visual Source Safe, TFS
- Environment: SQL Server 2016/2014/2012/2008 R2 Enterprise Edition, SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, DOS Scripting, Shell scripting, C#, VB
- Net Framework 4.0, JavaScript, jQuery, HTML, CSS, Visual Studio 2012, MVC 4.0, ADO .NET, Java, Oracle 11g
Technology Analyst
Cap Gemini
11.2015 - 12.2019
- Analyze, design and develop .NET, Windows Forms, MVC, WCF, WebAPI applications
- Designed web pages using ASP.net server controls, HTML, CSS, AJAX, Bootstrap and JavaScript
- Used JQuery and JavaScript for client side validations
- Created and consumed restful services
- Implemented .Net classes for Business Logic Layer using C#
- Involved in development and implementation of the Inbound and Outbound System of the LO Platform using Microsoft .Net, Oracle 10g, MSMQ, XML and Web Services
- Involved in understanding user requirements, designing and developing web application and back end applications
- Coordinating with business clients, supporting the application and implementing the process as per specifications provided
- Discussing business solutions with client business team, resolving existing problems and improving the application stability
- Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to RDBMS tables
- Created complex SSIS packages using proper control and data flow elements with error handling
- Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in Incremental data loading
- Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, and triggers
- Experience in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches
- Environment: NET Framework 4.0, MVC 4.0, JavaScript, HTML5, C#, VB, SQL Server 2012, SSIS, SSRS, XML, NUnit, Team Foundation Server (TFS)
Senior System Engineer
HCL Technologies Ltd
10.2014 - 11.2015
- Designed and developed applications using Microsoft .Net technologies, WCF, VB.NET, Microsoft SQL server and Oracle PL/SQL
- Used web API to develop service methods and developed windows services for batch update processes
- Designed and developed Web services using Service Oriented Architecture
- Transformed data into objects using LINQ
- Extensively designed the packages and data mapping using Control flow task elements, Sequence container task, Dataflow Task, Execute SQL Task, For Each Loop Container, For Loop Container and Script Task in SSIS Designer
- Experience in using different transformations like fuzzy lookup, derived column, Look up, Row count, OLEDB Command, Data conversion task transformations etc
- In SSIS
- Experience in creating complex SSIS packages using proper control and data flow elements with error handling
- Enhancing and deploying the SSIS Packages from development server to production server
- Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing and Scheduling the SSIS packages and Jobs
- Effectively used views to prevent unauthorized access
- Tuned SQL queries using execution plans for better performance
- Environment: .Net Framework 4.0, C# .Net, SQL Server 2012, JavaScript, JQuery, SSIS, SSRS, SSAS, HTML, CSS, Visual Studio 2012, MVC 4.0, ADO .NET, Web services
.Net Developer/Senior Developer
CAT Technologies
08.2012 - 10.2014
- Developed windows and web applications using C#.NET and ASP.NET
- Troubleshot and resolved bugs in .Net applications to ensure optimal development environment
- Implemented Data Access Layer using ADO.NET to communicate with the database
- Performed front end validations at the browser level using ASP.Net validation controls
- Actively involved in Normalization of database
- Designed DDL and DML for MS SQL Server 2008(R2)
- Worked with SQL and PL/SQL to create Tables, Views, and triggers and stored Procedures
- Create rules, defaults, clustered & non-clustered index, user defined data types, and user defined functions
- Responsible for tuning T-SQL procedures, triggers and other database objects
- Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL Queries, Stored Procedures
- Designed and developed DTS packages for transferring data from flat files and Access files
- Involved in merging existing databases and designed new data models to meet the requirements
- Perform daily database backup & restoration and monitor the performance of Database Server
- Create joins and sub-queries for complex queries involving multiple tables
- Use DDL and DML for writing triggers, stored procedures, and data manipulation
- Environment: Visual Studio 2005, C#, .NET 2.0/3.0/4.0, XML, Visual Basic, MS SQL Server 2008(R2), T-SQL, DTS, SQL Server Enterprise Manager, SQL Profiler
Personal banking Advisor
Santander bank
11.2011 - 03.2012
- Profile management position accountable for soliciting accounts and developing clientele
- Interviewing clients to determine and analyzing the risk tolerance and suggesting suitable products and options to meet their financial objectives, future goals
- Cross checking client's current protection needs and providing them with best possible options to choose an insurance plan
- Cross-sell banking services and products to clientele
- Analyzed financial statements and pertinent information to determine creditworthiness of prospective customers
- Counseled clients and high net-worth individuals with regard to their borrowing needs
Customer Advisor/ Cashier
Barclays Bank
12.2010 - 11.2011
- Profile management position accountable for soliciting accounts and developing clientele
- Interviewing clients to determine and analyzing the risk tolerance and suggesting suitable products and options to meet their financial objectives, future goals
- Cross checking client's current protection needs and providing them with best possible options to choose an insurance plan
- Cross-sell banking services and products to clientele
- Analyzed financial statements and pertinent information to determine creditworthiness of prospective customers
- Counseled clients and high net-worth individuals with regard to their borrowing needs
Education
Master in International Business and Finance -
University Of Dundee
Dundee12.2010
Bachelors of Technology - Electronics and Communication Engineering
Jawaharlal Nehru Technological University
Hyderabad, A.P.05.2008
Skills
- C#
- T-SQL
- VBNet
- ASP
- ASPNet
- UNIX
- C
- C
- SQL Server Management Studio
- Query Optimizer
- SQL Profiler
- Oracle 10g
- Oracle 11gR2
- Oracle 12I
- ETL
- Bulk Insert
- BCP
- ODBC
- Business Intelligence Development Studio(BIDS)
- SQL CMD
- SQL Server 2016
- SQL Server 2012
- SQL Server 2008 R2
- Oracle
- MS Access
- SQL Server Reporting (SSRS)
- Micro Strategy 8x/9x/10x
- Tableau Reports
- Business Objects
- Crystal Reports
- JavaScript
- HTML
- CSS
- JSON
- XML
- Angular JS (Beginner)
Timeline
Developer Advisor
Tata Consultancy Services (TCS)
01.2020 - Current
Technology Analyst
Cap Gemini
11.2015 - 12.2019
Senior System Engineer
HCL Technologies Ltd
10.2014 - 11.2015
.Net Developer/Senior Developer
CAT Technologies
08.2012 - 10.2014
Personal banking Advisor
Santander bank
11.2011 - 03.2012
Customer Advisor/ Cashier
Barclays Bank
12.2010 - 11.2011
Master in International Business and Finance -
University Of Dundee
Bachelors of Technology - Electronics and Communication Engineering
Jawaharlal Nehru Technological University
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Amol PhansekarAmol Phansekar
Business Analyst at Diligenta (TCS- UK Subsidiary), TATA CONSULTANCY SERVICES(TCS) PVT.LTDBusiness Analyst at Diligenta (TCS- UK Subsidiary), TATA CONSULTANCY SERVICES(TCS) PVT.LTD
RAYNER C. NARSHALLRAYNER C. NARSHALL
I.T Services Desk Analyst – BPO 3 at Tata Consultancy Services (TCS)I.T Services Desk Analyst – BPO 3 at Tata Consultancy Services (TCS)
Chhatrapalsinh JhalaChhatrapalsinh Jhala
Senior Process Associate at Tata Consultancy Services (TCS)Senior Process Associate at Tata Consultancy Services (TCS)
Tejaswini LankeyTejaswini Lankey
Senior SAFe Scrum Master at Tao DigitalSenior SAFe Scrum Master at Tao Digital