SUMMARY

• Over 12+ years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Reporting, Development, UAT and Production Environment).
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing and debugging new and existing client - server based applications).
• In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
• Experience with Ad-hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data
• Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008 R2, 2016).
• Experience in creating dashboards, scorecards and building reports using performance point server 2007. SQL Server 2000/2005/2008 R2, 2016 RDBMS database development including T-SQL programming.
• SQL Server 2005 OLAP database development including KPIs, Data mining, working with changing dimensions.
• ETL implementation using SQL Server Integration Services (SSIS).
• Developing reports on SSAS & SSRS on SQL Server (2000/2005/2016 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, good verse in ERWIN
• Thorough understanding of Kimball’s’ theory, KPIs, SQL 2005 Architecture.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• Worked in Data modeling, creating star and snowflake schemas in SSAS.
• Involved in DBA activities such as backups, restores, replication etc.
• Excellent communication skills, analytical skills, understand business requirements in various domains.

TECHNICAL SKILLS

Hardware: HP/Compaq ML 380 Servers, Dell Power edge series

Database: SQL Server 2000, 2005, 2008 R2, 2016, Oracle 10i.

Operating Systems: Windows Server 2008 R2/2003, HP UNIX, Windows 10.

Programming Languages: SQL, PL/SQL, C

BI Suite: SSAS, ProClarity, SSRS, Crystal Reports, Power BI

ETL TOOLS: DTS, SSIS, SSRS, SSAS, Informatica 7.1.3/6.2

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL Server SSIS/SSRS Developer

Responsibilities:

• Created various reports like tabular, matrix, parameterized etc. using SQL server 2012 and crystal reports.
• Responsible for creating stored procedures for monthly, quarterly, semi-annual and annual reports base data which will be used in SSRS or Crystal reports.
• Creating Dashboards and reports on Power BI for interactive client reporting.
• Created and automated SSIS packages to export the reports in various formats like excel, pdf, flat files, csv files etc.
• Used VB scripts in SSIS packages to created different formats of reports.
• Also for all the reports automation purpose I have created and maintained the jobs for SSIS packages in SQL server agent which created and put the various files on various folder location.
• Responsible for gathering requirements from the clients and multiple program directors for the deliverable reports and wrote complex codes.
• Involved in unit testing of the team members’ code and reports.
• Responsible for mentoring and guiding the new team members who joined the team recently, help them understand various technical tools, business and work flow of the company.
• Worked closely with other team members to help and support them to be more productive and effective.
• Created hundreds of ad-hoc reports for clients auditing and testing purposes.

Environment: SQL Server 2008 R2/2008/2012,2016 Enterprise Edition, Toad 4.0, SSIS, SSRS, SSAS, T-SQL, Share-point, Power Pivot, Windows 7, Crystal Reports, Power BI

Confidential

Sr. SQL Server SSIS/SSRS Developer

Responsibilities:

• Responsible for creating, designing and optimizing SSIS package.
• Created SSIS packages using the different source systems and the database using the mapping documents and helped the BA for creating functional requirement documents.
• Validated all the reports using the new source and fixed all the issues with the new data.
• Writing complex queries per Client requirements.
• Created staging tables from various sources like .csv files, flat-files, SQL tables using SSIS.
• Used various transformations like derived columns, lookup, merge, Row count.
• Wrote complex stored procedures with functions and joins.
• Created new reports using SSRS for clients to validate the data, involved in each step from gathering requirements.
• Involved in designing and writing Stored Procedures, functions and packages using T-SQL for SQL Server.
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, Implementation.
• Upgrade enhancements, maintenance, support and bug fixing for the product.

Environment: SQL Server 2008 R2/2008/2005 Enterprise Edition, SSIS, T-SQL, SSRS, Windows Server 2008/2003