SUMMARY

• Over 7+ years of total experience in the analysis, design and development of business intelligence applications using Microsoft Technologies.
• Involved in requirement gathering, daily interaction with business users.
• Preparation of analysis and design documents
• Preparing the dimension modeling sheet that included studying the data and designing the required tables as per the architecture we have in place and also follows all the norms that in place.
• Creating the required tables that are used in particular project as per the dimension modeling sheet.
• Developing the SSIS packages that will be used to get the data from the flat files into the database and also do the necessary transformations to the data.
• Developing the configuration files for all the packages that are developed.
• Used SQL Server Analysis services to develop and deploy multidimensional cubes.
• Used MDX Queries for creating calculated measures, retrieving Cube data.
• Created many to - many relationships in SSAS Dimension usage.
• Created SSRS reports, scorecards based on client’s predefined templates.
• Created stored procedures which will be used as SSRS reports dataset.
• Used SQL Queries as source query for OLEDB source in data flow task.
• Involved in unit testing and writing unit test cases.
• Performing regression testing on the packages, reports and also the cubes that are developed.
• Trained team in SSIS, SSAS, SSRS and MDX.
• Achieved best contributor award from clients couple of times.

TECHNICAL SKILLS

GUI Tools: SQL Server Data tools, BIDS, SSMS, Profiler

Databases: SQL Server (2005,2008, 2012),T-Sql

Source Control: VSS, TFS

Web Technologies: HTML, XML

Operating Systems: Windows XP, Windows 2008 R2 Server & Windows 7/8

PROFESSIONAL EXPERIENCE

Confidential, Richardson Texas

Sr. SQL Developer

Environment: SQL Server Data Tools for SSIS & SSAS, SSMS for SQL Server 2012

Responsibilities:

• Involved in getting Business knowledge.
• Writing SQL inline queries, procedures and user define functions
• Involved in designing SSIS packages for data migration.
• Handling Client Meetings, and status updates to clients
• Designing SSAS cubes as per requirement by client.
• Writing MDX script for calculations in SSAS cubes.
• Designing SSRS reports using fetch XML & SQL Server queries as data source.
• Deploying SSIS packages from Dev to SIT & UAT environments
• Deploying SSAS cubes from Dev to SIT & UAT environments.
• Deploying SSRS reports to CRM Solutions.
• Developing Drilldown and Drill through reports.
• Designing and implementing cascading parameters.
• Creating subscriptions of SSRS Reports.
• Assigning the tasks, follow up on status on daily bases, and addressing/working with the team members to complete the task in time.

Confidential, Mount Laurel NJ

SQL / BI Developer

Environment: SQL Server Data Tools for SSIS & SSAS, SSMS for SQL Server 2012

Responsibilities:

• Involved in Requirement gathering meetings with the client, capture all the requirements and documented
• Writing SQL inline queries, procedures and user define functions
• Involved in designing SSIS packages for data migration.
• Handling Client Meetings, and status updates to clients
• Designing SSAS cubes as per requirement by client.
• Writing MDX script for calculations in SSAS cubes.
• Designing SSRS reports using fetch XML & SQL Server queries as data source.
• Deploying SSIS packages from Dev to SIT & UAT environments
• Deploying SSAS cubes from Dev to SIT & UAT environments
• Deploying SSRS reports to CRM Solutions.
• Developing Drilldown and Drill through reports.
• Designing and implementing cascading parameters.
• Creating subscriptions of SSRS Reports.
• Creating POC to address their requirements in different ways and finally we are implementing for which the client interested.
• Regularly updating the FDD document on every meeting with respect to any design and requirement change

Confidential, Lincolnshire IL

SQL / BI Sr Developer

Environment: SQL Server Data Tools for SSIS & SSAS, SSMS for SQL Server 2012.

Responsibilities:

• Involved in Requirement gathering meetings with the client, capture all the requirements and documented.
• Travelled onsite for project delivery.
• Writing SQL inline queries, procedures and user define functions
• Involved in designing SSIS packages for data migration.
• Handling Client Meetings, and status updates to clients
• Designing SSAS cubes as per requirement by client.
• Writing MDX script for calculations in SSAS cubes.
• Deploying SSIS packages from Dev to SIT & UAT environments
• Deploying SSAS cubes from Dev to SIT & UAT environments.
• Creating SSIS packages with script task in C# to handle dynamic roles in SSAS cube.
• Regularly updating the FDD document on every meeting with respect to any design and requirement change

Confidential, Houston Texas

SQL Developer

Environment: BIDS for SSIS & SSAS, SSMS for SQL Server 2008 R2

Responsibilities:

• Involved in Requirement gathering meetings with the client, capture all the requirements and documented.
• Writing SQL inline queries, procedures and user define functions.
• Involved in designing SSIS packages for data migration.
• Handling Client Meetings, and status updates to clients.
• Designing SSAS cubes as per requirement by client.
• Writing MDX script for calculations in SSAS cubes.
• Deploying SSIS packages from Dev to SIT & UAT environments.
• Deploying SSAS cubes from Dev to SIT & UAT environments.
• Creating SSIS packages with script task in C# to create dynamic cubes.
• Created Japanese translations for SSAS cubes.

Confidential

SQL Developer

Environment: BIDS for SSIS & SSAS, SSMS for SQL Server 2005.

Responsibilities:

• Involved in designing SSIS packages for data migration.
• Designing SSAS cubes as per requirement by client.
• Writing MDX script for calculations in SSAS cubes.
• Involved in designing SSRS reports like tabular, matrix, charts.
• Involved in writing low level design document and unit test case document
• Deploying SSIS packages from Dev to SIT & UAT environments.
• Deploying SSAS cubes from Dev to SIT & UAT environments.
• Creating SSIS packages with script task in C# to create dynamic cubes.