Summary

• 5 years of Experience in design, development, coding and testing of business/commercial applications on MS SQL Server 2000/2005/2008, MS Access, Windows XP, and Windows 2000/2003.
• Experience in creating database, tables, indexes, stored procedures, views, triggers, T-SQL,
• DTS/SSIS using MS SQL Server 2008/2005/2000.
• Extensively used SSAS, SSIS SSRS for various BI requirements.
• Experience in Extracting, Transforming and Loading ETL data from Excel, Flat file, Oracle to
• MS SQL Server by using BCP utility, DTS and SSIS services.
• Very Good Experience in Using SQL Server Reporting Services.
• Experience in MS SQL Server Migration from SQL Server 2005 to SQL Server 2008.
• Good understanding of Normalization /De-normalization and database design methodology.
• Extensive experience in development of T-SQL scripts, DTS Packages, Integration Services, Stored Procedures and Triggers for business logic implementation.
• Good knowledge of Data Marts, Data warehousing, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Excellent knowledge in RDBMS concepts.
• Modified and redesigned existing database by adding tables and relationships to support online
• system in the development database.
• Very good experience in Creating SSAS OLAP CUBES.
• Experience in query optimization performance tuning.
• Involved in Creating Data warehouse using Ralph-Kimball Data warehousing methodology.
• Defined relationship between dimensions and measures groups, calculated slowly changing dimensions, KPI for different OLAP cubes.
• Scheduled and monitored all maintenance activities of SQL Server to meet business requirements activities including database consistency check.
• Strong troubleshooting and organizational skill independent, self-managing and teamwork.
• Ability to work in-groups as well as independently with minimal supervision.

Skills

Professional Experience

Confidential

Designation: Business Intelligence Specialist

Responsibilities:

• Design and develop various standard reports in SSRS and ad-hoc reports in report model using MS 2005/2008/2012.
• Design and implementation of ETLs from various source systems using SSIS.
• Contribute in Data Warehouse development lifecycle including gathering and understating of requirements, development, implementation and maintenance using SQL Server 2005/2008/2012.
• Provide support for ad-hoc reports analysis.
• Database design and development for OLTP and OLAP systems using normalized and DE normalized systems.
• Worked on creating SSAS cube using star and snow flex schemas.
• Responsible for working with both business functional and technical groups to gather, manage and document detailed system requirements for Operational data store, data warehouse and data mart efforts.
• Worked on internal Compass project to create custom reports like fix bid, Time and material report, , utilization and project status report using SSRS, created matrix reports with drill through, drill down and multi parameters and chart reports.

Confidential

Designation: BI Developer

Responsibilities:

• Responsible for analyzing, planning and developing, configuring the solution architecture to ensure that it is in line with business requirements.
• Works with business users to optimize information and analytic usage
• Develops and communicates project plans, work assignments, target dates and other aspects of projects.
• Ensures that data projects follow prescribed development life cycle and meet quality standards
• Worked on data validation, object testing on UAT, SIT, BAT, PAT, and PROD environments.
• Created test cases based on specific application for mortgage server and loan accounting system using HP quality center and tested and logged the defects in there.
• Design and build Reports using SSRS.
• Created ETL process for pulling large volume of data from various data sources using SSIS packages and Staging stored procedures.

Confidential

Designation: Sr. SQL Developer/SSIS/SSAS/SSRS

Responsibilities:

• Based on the technical document and the business needs Created and designed a data mart with
• star schema to support the requirement of ECM system.
• Discussed the data mart design with appropriate fact and dimension tables with the team members.
• Created an SSIS package to load the data from Oracle as a source to SQL tables.
• Designed cubes with star schema using SQL Server Analysis Services SSAS .
• Based on the requirement I have created MDX queries to generate the SSRS reports.
• Created SSRS Reports using MDX and Stored Procedures
• Created DEMAND/CAPACITY Analysis reports, End of life report, Setup verification report which show the percentages for demand and the capacity associated for a machine, Relation between Items and machines using SSRS.
• Worked on Complex T-sql Queries using Inner joins pivot, UN pivot, Stored Procedures with
• Multiple parameters, Functions, and Views.
• Created a Linked Server to query the analysis server SSAS using sql server data base engine .
• Worked on Team Foundation server TFS to store and save my work on TFS.
• Created a Sql agent job to run the SSIS packages and added a step to run the cube in the job and scheduled this to run every morning and send alerts as emails if the job fails.

Confidential

Designation: SQL Developer

Responsibilities:

• Created and schedule SSIS packages to load the data form Expense management system to data staging environment and then data warehouse environment.
• Experience in creating complex SSIS packages using proper control and data flow elements and
• have deployed packages on different servers by configuring it.
• Worked on different kinds of transformations like conditional split, data conversion, derived column, lookup, join, merge join, sort, union all, multicast, slowly changing dimension, in SSIS as per the clients Requirement.
• Worked with different methods of logging in SSIS.
• Used Event Handling in SSIS to handle the event at package level and task level using on error, on warning and configured it using send email task and script task.
• Use SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Created packages in SSIS with error handling.
• Created several reports using SSRS.
• Performance tuning of SQL queries and stored procedures using SQL Profiler.
• Worked as a developer in creating complex Stored Procedures, views, functions and other SQL joins and statements for applications.