SUMMARY

• Total 12+ years of IT experience with nearly 7 years exclusively as a Microsoft Business Intelligence Developer in Production, Development and Staging Environment.
• Proficient in SQL Server 2000/2005/2008 suite of products, esp. Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS).
• Strong Communication and Management skills with Excellent Role playing capabilities.
• Involved in Huge data migrations, transfers using utilities SQL Server Integration Services (SSIS), Bulk Copy Program (BCP), Bulk Insert and T - SQL.
• Extensively involved in SSIS, SSRS, T-SQL, Procedures, Functions, Views and implement best practices to maintain Optimal Performance.
• Experience in BI Development and Deployment of SSIS Packages from MS-Access, Excel, Oracle, Teradata, Flat Files etc.
• Familiar with teh principals and implementation of Data Warehouse with Fact Tables, Dimension Tables, Aggregations, Star & Snowflake schema.
• Expertise in Designing and Deployment of Reports for teh End-User requests using SSRS.
• Expert in creating various reports with tables, matrix, sub-report, chart, parameters, expressions, drilldown, drill-through using SSRS.
• Involved in teh deployment process of SSIS, SSRS and MSSQL objects for different environment (SIT/UAT/PROD) and maintaining/monitoring on Higher to lower level environment server.
• Experienced in programming tasks-Stored Procedures, Triggers, and Cursors using SQL Server 2008/2012 with T-SQL.
• Worked on optimization in T-SQL programming to optimize Stored Procedures, Functions/indexes.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Very Good knowledge in SQL Jobs configuration, Database Performance/optimization tuning, index rebuilding and reorganize etc.
• Working knowledge of databases like SQL Server, their integration with programming languages likeVB.NET, ASP.NET, C#.
• Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions.
• Working knowledge of .Net Framework (VB.NET and C#), IIS Web Server.
• Excellent record as a team player with TEMPeffective communication skills.

TECHNICAL SKILLS

Databases: SQL SERVER 2000/2005/2008/2012 , MS-Access, Teradata, Oracle 11g

Programming: VB.NET, C#, T-SQL

Operating System: Windows 2003/2012 Advanced Server, NT & Windows 7/8x

ETL Tools: SSIS, SSAS, SSRS 2008/2012, Crystal Reports

Web Tools: XML, ASP.NET

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL BI Consultant

Responsibilities:

• Developed SSIS Packages to Load Claims, Provider, and Person Data from Third Parties.
• Used T-SQL to Load/Transform Data from Third Parties
• Defined and developed logical and physical data models to support business needs.
• Created tables, stored procedures, views, User-Defined functions, indexes, partitions and other T-SQL code to support application development.
• Developed stored procedures using T-SQL to suit Business Needs and for Auditing.
• Developed complex SSIS mappings to facilitate daily, monthly and yearly loading of data.
• Developed Adhoc Queries to meet teh Business requirements and to validate teh Process.
• Involved in Data Completion and Data Accuracy of ETL process.
• Designed and implemented database objects like Tables, Views, Index, Sequences, Functions and Stored Procedures in SQL Server 2008/R2/2012 and Oracle 11g.
• Created ETL job to load teh data into teh Third Party Applications using SSIS.
• Performed Unit/integration testing for teh ETL jobs
• Reviewing teh ETLs and T-SQL Code developed by other Team Members
• Involved Design and Development of Data Feed from legacy systems to CPDM application.

Confidential, CA

Lead SQL BI Analyst / Sr. SQL BI Consultant

Responsibilities:

• Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
• Actively involved in teh development/deployment of Front-end and ETL packages in .NET, MS-SQL 2008, SSIS and SSRS.
• Supporting project resource scheduling and capacity planning.
• Provide regular and TEMPeffective progress to work closely with Project managers.
• Line management and personal development of a team of highly skilled developers.
• Involved in formulate queries using T-SQL in meeting business needs.
• Participate in reviews and meetings and provide updates on project progress.
• Formulate implementation design/technical document and mapping document on business logic.
• Work closely with team internally to ensure alignment of work within teh project.
• Benefitted handling brainstorming discussions design, development process and deployment of SSIS projects.
• Supporting multiple projects and being responsible for coordinating with on-site.
• Proactively associated with teh business users to jointly come up with user requirements.
• Formulated High Level Design reviews with business client and implementation of teh Low Level Design documents.
• Supporting project resource scheduling and department capacity planning.

Confidential

Lead SQL BI Analyst/ Sr. SQL BI Consultant

Responsibilities:

• Actively involved in teh development/deployment of Front-end and ETL packages in .NET and MSSQL Server 2008.
• Involved in formulated queries in T-SQL in meeting business needs.
• Formulate implementation design/technical document and mapping document on business logic.
• Benefitted handling brainstorming discussions design, development process and deployment of SSIS projects
• Supporting multiple projects and being responsible for coordinating with on-site.
• Proactively associated with teh business users to jointly come up with user requirements.
• Formulated High Level Design reviews with business client and implementation of teh Low Level Design documents.

Confidential

Sr. SQL Developer

Responsibilities:

• Analyzing user requirements and preparing LLD based on teh given HLD from Line of Business.
• Involved in backend development, bug fixing and enhancements for this application.
• Writing stored procedures, SQL Scripts for adhoc requirement from LOB.
• Creating tables, and creating proper indices for performance optimizing of queries.
• Preparing unit test cases and test plan to upload to Quality Center.
• End to End handling of PCRs single handedly.
• Monitoring jobs running night on daily basis and recovering teh failed jobs within SLA time.
• Co-coordinating with DBA while recovering jobs.
• Daily verification of jobs and checking all production servers are in sync.
• Successfully implemented ETL Packages to load data into TQ Servers from different sources.
• Actively involved in teh development of ETL Packages to load data.
• Involved in training teh new joiners and make them work ASAP on Turquoise application.

Confidential

Sr. SQL Developer

Responsibilities:

• Analyzing user requirements and preparing LLD based on teh given HLD from Line of Business.
• Involved in backend development, bug fixing and enhancements for this application.
• Writing stored procedures, SQL Scripts for adhoc requirement from LOB.
• Creating tables, and creating proper indices for performance optimizing of queries.
• Preparing unit test cases and test plan to upload to Quality Center.
• End to End handling of PCRs single handedly.
• Monitoring jobs running night on daily basis and recovering teh failed jobs within SLA time.
• Co-coordinating with DBA while recovering jobs.
• Daily verification of jobs and checking all production servers are in sync.
• Successfully implemented ETL Packages to load data into SQL Servers from different sources.
• Actively involved in teh development of ETL Packages to load data.
• Involved in training teh new joiners and make them work ASAP on application.

Confidential, NY

Developer

Responsibilities:

• Analyzing user requirements and preparing LLD based on teh given HLD from Client.
• Involved in front-end and backend development for this application.
• Writing stored procedures, SQL Scripts for adhoc requirement from LOB.
• Creating tables, and creating proper indices for performance optimizing of queries.
• Preparing unit test cases and test plan to upload to Quality Center.
• End to End handling of PCRs single handedly.
• Monitoring jobs running night on daily basis and recovering teh failed jobs within SLA time.
• Co-coordinating with DBA while recovering jobs.
• Daily verification of jobs and checking all production servers are in sync.
• Successfully implemented ETL Packages to load data into SQL Servers from different sources.
• Actively involved in teh development of ETL Packages to load data.
• Involved in training teh new joiners and make them work ASAP on application.
• Created Front-end pages using C#, ASP.NET.

Confidential

VB.NET & SQL Developer

Responsibilities:

• Analyzing user requirements and preparing LLD based on teh given HLD from Client.
• Involved in front-end and backend development for this application using VB.NET.
• Creating tables, and creating proper indices for performance optimizing of queries.
• Preparing unit test cases and test plan to upload to Quality Center.
• End to End handling of PCRs single handedly.