Professional Summary

• Extensive Experience in IT as a professional specializing in MS SQL Server 2008/2005/2000 ETL / Warehouse Developer / SQL Developer / Database administration in Windows environment
• Extensive experience in Software Development Life Cycle (SDLC) methodologies and gathering business requirements.
• Experience of accommodating and facilitating Joint Application Development (JAD) session, documented, analyzed and synthesized the results as parts of business requirements.
• Experience in Data Modeling and Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs.
• Strong experience in T-SQL to write Stored Procedures, Batches, Views and complex queries.
• Created complex SQL Stored Procedures, Triggers and User Defined Functions to manage incoming data as well as to support existing applications.
• Hands on experience in creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views and Cursors.
• Optimized Stored Procedures by fine tuning queries and joins, and using SQL Profiler and Database Tuning Advisor.
• Created several CTEs and recursive CTEs to improve performance of queries.
• Supported the migration of data from heterogeneous sources and different formats to relational data warehouses, staging databases using complex stored procedures and SSIS.
• Hands on Experience in Forward / Reverse Engineering Data Models between ERWin and MS SQL Server
• Proficient in implementing business logic and batch process in backend using Stored Procedures and Functions.
• Experience in Data Extraction, Transforming and loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, Data Transformation Services (DTS), Bulk Insert, BCP).
• Good Experience in creating Master Child Packages, SSIS Loggings, User Loggings, Breakpoints, Data viewers, Checkpoints and Transactions.
• Good Experience in managing SSIS Package Configurations
• Experience in pulling data from DB2, Oracle to SQL Server using SSIS.
• Experience in Data modeling (Dimensional & Relational) like Star-Schema Modeling, Snowflake Modeling, fact and dimension tables.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Experience in creating multidimensional optimized cubes using the SQL Server Analysis Services (SSAS).
• Partitioned Cubes in several drives on the SAN for better query performance.
• Actively involved in Processing Cubes, adding KPIs and Calculated Members using SSAS.
• Good experience in Designing Aggregations and pre-calculating the same in SSAS.
• Applied security measures on a server and database level as well as encrypting sensitive data using symmetric and asymmetric keys as well as certificates
• Extensive experience automating administrative tasks using SQL agent, event notifications, and scheduled maintenance plans according to Microsoft best practice.
• Excellent knowledge in migrating data and databases using side by side migrations with methods like attach detach, SSIS packages as well as copy database tasks.
• Proficient in maintenance and optimization of Database and Server.
• Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities.
• Excellent communication and verbal skills.
• Excellent interpersonal, Analytical and Communication skills.

Technical Skills

RDBMS/DBMS:

MS-SQL Server 2008, 2005, 2000, DB2

Database Technologies/Tools:

SQL Server Entreprise Manager, SQL
T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP

Reporting Tools:

Microsoft SQL Server Reporting Services (SSRS).

Operating Systems:

Windows XP, 2000, NT, 98, 95, Windows 2003

Programming Languages:

HTML, Visual Studio, VB.NET, T-SQL, ASP.NET

Design Technologies/Tools:

Erwin, MS Visio

Data Warehouse / Business Intelligence Tools

SQL Server Analysis Services 2008/2005 (SSAS), Business Intelligence Development Studio

Professional Experience

Confidential,Texas JAN 2010 to Present
Sr. Application Systems Analyst and SSIS/ETL Developer

Confidential, is one of the leading university in south east Texas, provides academic, healthcare and research services. InfoEd application is research administration software being used by Confidential, since longtime ago. This application needs to maintain with current Finance, HR, research and student information. It takes data from several data mart, which we have developed and maintained using ETL strategy. The project required the development of the database and data warehouse which would cater to the reporting needs of the business.
Responsibilities:

• Converted the requirements into an ETL Technical Design document for ETL development.
• Analyzed the source data and worked with the source data team to understand the data.
• Designed and setup the ETL Architecture for the Corrigo application.
• Created Staging Databases as intermediate stages for populating Data Mart to perform various ETL data massaging operations like data profiling, data cleansing and data verification.
• Requirements gathering from the business users (IRB and IACUC) and translating into technical specifications.
• Analyzed the source data (Investigator certificates) and worked with the IS team to understand the data.
• Guided the ETL development team with their design and development and helped them with ETL standards.
• Developed complex stored procedures and User Defines Functions with input and output parameters to support front end applications.
• Created stored procedures to backup and restore databases.
• Developed several complex stored procedures for index maintenance
• Optimized Stored Procedures by fine tuning joins and using SQL Server Profiler and Database Tuning Advisor for better performance.
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFS, CTEs and System stored procedures.
• Reviewed the existing stored procedures and improved efficiency by critically evaluating the code or by replacing them with UDFs to optimize performance of front end applications.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Created complex SSIS packages and optimized them to the fullest depth to reflect required business logic to implement designed ETL Strategy.
• Modified SSIS and DTS Packages for transferring data from heterogeneous sources to the staging database.
• Efficiently managed complex ETL packages by creating logging, checkpoints, transactions, configurations and deployed it on the production server using push and pull deployment methodology.
• Implemented the Master Child Package Model for easier maintenance and better performance.
• Managed Package Configurations using Indirect Configurations to efficiently Promote Unit Tested Packages to Live Environment from Development Environment.
• Scheduled Packages using SQL Server Agent Jobs.
• Created bottom up designed cubes using the SQL Server Analysis Services in support of front end applications, reports.
• Create new and/or modify existing reports for Department Directors, middle managers and staff.
• Created documentations of all objects and code created in support of the project as well as keeping records of all change request documents.

Environment:
Microsoft Windows Server 2000/2003 Enterprise Edition, Microsoft SQL Server 2000/2005/2008, Microsoft SQL Server Integration Services, Microsoft SQL Server Reporting Services, Microsoft SQL Server Analysis Services, Epiphany (SSA Tool), ASP.NET, VB.NET, C#.NET, Flat Files, Excel Sheets, Toad 8.0, Batch Files, Oracle SQL developer.

Confidential, San Fransicso, CA JUNE 2008 to DEC 2009
Sr. ETL Developer

Project: Support DB for Front end Application
The project initiated to create a front-end application to support finantial reports. Project started with creating logical and physical schema for the relation databases which would be frequently populated from OLTP databases using efficient ETL strategy. The main goal of the project was to support the creation of dynamic reports through front end application.

Responsibilities:

• Design and Develop an SSIS template that would serve as the standard template which all other SSIS developers would use.
• Designed and troubleshoot some of the front-end application forms and GUI’s supported UI team specifically working on MS .net platform.
• Analyzed and identified various heterogeneous data sources like DB2, ORACLE, FLAT files and Excel sheet and created Data Mapping Documents (DMD) to efficiently incorporate them in ETL strategy.
• Working with the SSIS team in suggesting identifying loop holes in the template design and suggesting alternative solutions.
• Used a variety of transformations including Execute SQL Task, Union All, Merge Join, Lookup, OLE Db Command, Fuzzy Lookup, and Derived Column.
• Analyze reports, data and systems when existing reports do not function properly. Correct these reports and/or data. Recommend solutions to keep the data correct in real-time.
• Created SSIS Packages and SSRS Reports for their Reporting Project which involved implementing the business logic within the package and placing the end result in a table which would be used within SSRS to build the reports.
• Created Drill Down, drill through, sub and linked reports using the SQL Server Reporting Services SSRS as well as managed the subscription and authentication of these reports.
• Developed complex stored procedures and User Defines Functions with input and output parameters to support front end applications.
• Created bottom up designed cubes using the SQL Server Analysis Services in support of front end applications, reports.
• Converted complex business logic into SQL stored procedures and user-defined functions to achieve functionality required by the UI team.
• Data migration (import & export BCP) from text, CSV files to SQL server 2005 and 2000.
• Generated payroll reports, mailing labels, ad-hoc reports using SQL reporting services SSRS 2005.
• Designed new Aggregations by creating Hierarchies and then pre-calculating the Aggregations using Aggregation Wizard in SSAS.
• Implemented new and complex Calculated Members that will be permanently stored in cubes to boost query performance of reports.
• Created KPIs that will track the response and behavior of customers based on the project Requirement Documents.
• Worked closely with third-party software vendors.

Environment:
SQL Server 2000/2005, SSIS, SSAS, SSRS, ER-Win, T-SQL, Windows 2000, DTS, Excel, Microsoft .net platform

Confidential,San Diego CA MAY 2006 to JUNE 2008
SSIS/ DW Developer

Projects - BI Solution
The new system would support the Sales, Regulatory Reporting, and Operations departments. The scope of the project was to replace the general ledger and the associated reporting only. Since SQL server only contained General Ledger information, a reporting warehouse was needed in order to replace the entire legacy reporting and implemented both an ad hoc and a batch reporting solution using SQL server reporting services.
Reporting
CR (Customer Relation) Tool Issues
CR Tool was used by the customer relation agents. The project was to solve several issues with the tool and to provide enhancement to existing tool. Tool was coded in ASP .NET with SQL Server 2008 backend.
There were several other projects like working with petco.com, central messaging system, NCOA, CAS and others.

Responsibilities:

• Participated in designing the Logical model by using Erwin based on the business requirement.
• Implemented the logical design to the physical design by creating tables, views and relationships.
• Worked on SQL Server 2005, in implementing the data mart involving new functionality and advancement in T-SQL as well as taking advantage of new features of 2005 BI tool.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS.
• Wrote several stored procedures to extract data for generating reports.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Worked on troubleshooting HTTP Errors, Server and Database Connection Problems and Delivery Problems.
• Scheduled several jobs using the SQL server agent as well as created alerts and mail confirmation of all packages and cube processes.
• Created an effective backup plan for both the data warehouse and the cubes data.
• Created documentations of all objects and code created in support of the project as well as keeping records of all change request documents.
• Worked hand to hand with the QA team to quickly and effectively fix all bugs that had been raised by applications and dashboards using the new objects.

Environment:
Microsoft Windows Server 2000/2003 Enterprise Edition, Microsoft SQL Server 2000/2005, Microsoft SQL Server Integration Services , Microsoft SQL Server Reporting Services, ASP.NET, VB.NET

Education

• Master of Computer Science, Lamar University, TX-USA
• Bachelors of Computer Engineering, Sardar Vallabhbhai Patel Institute of Technology, India