PROFESSIONAL SUMMARY:

• Over 12 years of experience in SQL Server T - SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing, SQL joins, performance tuning and query optimization.
• Strong in Data warehouse concepts, dimensional star schema and snow flake schema methodologies.
• Wrote and modified stored procedures/Triggers (DML/DDL) to implement complex business rule.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.
• Well versed in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS with MS SQL Server 2012/2008-R 2/2008/2005.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Teradata, Sybase, Flat File and MS Access.
• Extensively worked on SSIS, Data Cleansing, Data Scrubbing and Data Migration.
• Expertise in Creating, Configuring, Deploying and Fine-tuning MS SQL Server Integration Service (SSIS) packages.
• Experience in creating jobs, alerts, SQL mail agent, and database mail and scheduled in SSIS packages.
• Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drilldown reports using MS SQL Server Reporting Services 2012/2008R 2/2008/2005.
• Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• Experience on Developing and Publishing Power BI reports on dashboards in Power BI Server.
• In depth knowledge in designing new reports, enhancing existing reports, and wrote ad hoc reports for client using Crystal Reports. Manipulated and created new data sets using SQL, MS Access, Excel, and/or Crystal Reports. Expert in generating Sub Report, Standard, Cross Tab Reports and Graph Reports by Using Chart expert of Crystal Report.
• Extensively used Erwin for Logical Data Modeling, Physical Data Modeling, Forward engineering, Reverse engineering and model to model comparison.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.
• Intensive experience as a scrum master to lead and guide all the team members in all the meetings proposed by agile like pre-planning meeting, planning, daily scrum, review and retrospective meetings.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS:

Microsoft SQL Server 2012/2008: R2/2008/2005, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), T-SQL, PL-SQL, Erwin Data Modeler v7.0/v4.x, MS SharePoint, Microsoft Visual studio, TFS, Tortoise SVN, Crystal Reports, Power BI, Netezza,Azure, Microsoft Access, C#, Visual Basic 6.0 and Microsoft Visio.

PROFESSIONAL EXPERIENCE:

Confidential

MS SQL Server/SSIS/Power BI Developer

Responsibilities:

• Creating/Modifying the complex Power BI reports and Dashboards.
• Power BI Mobile user support for viewing dashboards and reports.
• Analyzing the SSAS Cubes, Adding new measures/calculations with KPI’s.
• Business requirement discussions and Documentation.
• Managing 4 client internal maintenance projects for development and support.
• Analyzing the SSAS Cubes, Adding new measures/calculations with KPI’s.
• Business requirement discussions and Documentation.
• Proactively managed changes in project scope, identified potential issues and implemented contingency plans.

Confidential

MS SQL Server/ SSIS Developer/Power BI Developer

Responsibilities:

• Created Database schema, tables, writing complex stored procedures and views.
• Worked extensively on SSIS packages to transfer data between Staging database and DW.
• Worked on ELT for bulk load source files for staging into DW.
• Created data warehouse modeling with Star/snow flake schema using SQL server analysis services(SSAS).
• Responsible for building reports in Power BI from Scratch.
• Responsible for creating and changing the visualization in Power BI reports and Dashboards.
• Created user interface web pages using .net and JavaScript.
• Created SSAS cubes and processed, deployed on server for data pre-calculated aggregations, KPI’s which can be modeled into reports accordingly.
• Created SSRS reports using OLAP/OLTP.
• Created data driven SSRS report subscriptions for different users using report manager.
• Configuration and Installation of Netezza Database and Aginity work bench for Data refresh using SSIS.
• Performance tuning and code reviews.
• Meetings with business group for requirements and status update.
• Implemented SQL CLR and created windows service for SQL agent job automation.
• Received client appreciation for automating the SQL jobs.

Tools: Microsoft Visual Studio 2013, Microsoft SQL Server 2012/2008-R2, SSIS, SSRS, SSAS, Power BI, JavaScript, SVN and Aginity workbench for Netezza.

Confidential

MS SQL Server/ SSIS Developer/Agile Practitioner

Responsibilities:

• Worked in T-SQL to create Tables, Function and Stored Procedures, View, sub-query, correlated sub-query, complex Stored Procedures and ad-hoc TSQL statement
• Performance monitored and tuned TSQL queries using SQL Profiler and database engine tuning advisor
• Created SSIS packages to transfer data between Staging database and DW.
• Worked with the ETL architect and lead to ensure ETL developers have the required data schema and metadata information and participate in knowledge transfer with the goal to remove any knowledge gaps that might exist.
• Using SDLC method document all SSIS packages and Stored procedure.
• Creating Change requests for Production deployment.
• Team Foundation server task management.
• Monitoring the Database Users, roles and Active Directory groups and permissions.

Tools: Microsoft Visual Studio 2013, Microsoft SQL Server 2012/2008-R2/2008, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Erwin Data Modeler v7.0/v4.x, MS SharePoint and TFS.

Confidential, NY

Developer (MS SQL Server/SSIS/SSRS and .Net)

Responsibilities:

• Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Designed and developed Data Models using Power Designer and also responsible for Forward and Reverse Engineering of data models.
• Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into 4 Weeks "sprints."
• Generated Database Objects like Stored Procedures, Triggers, Functions, Indexes, Views, Index.
• Created and updated stored procedures and functions to meet the requirements and changes specified by the users.
• Worked on performance tuning of T-SQL scripts.
• Highly responsible for scheduling and delivery of jobs using SQL Server Agent.
• Formulated and documented the ETL (SSIS) process design based on business requirements and system specifications with strong ETL (SSIS) design skills, including source to target mappings, transformations, look ups, aggregations, and expressions.
• Extracted data using SSIS 2012 from Oracle and Excel Files.
• Created packages in SSIS 2012 (.dtsx files) with error handling as well as created complex SSIS packages using various Data Transformations like Conditional Splitting, Fuzzy Look Up, For Each Loop, Multi Cast, Column Conversion, Fuzzy Grouping, Script Components.
• Responsible for implementation of Data Viewers, SSIS Logging, Error Configurations for error handling the packages.
• Deployed and configured various SSIS packages.
• Based on required reports, identified various data sources and established the connections using SSRS and constructed data source view.
• Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as Interactive reports according to business requirements in time restricted environment using sql server reporting services(SSRS) 2012.
• Designed and developed report with running value, interactive sorting as well as conditional formatting. Experience with creating reports using stored procedure. Involved in scheduling, creating snapshot and subscription for the reports.
• Designed and delivered dynamic reporting solutions using MS SQL Server Reporting Services.

Tools: Microsoft SQL Server 2012, Microsoft SQL Server 2008 R2, MS SQL Server Integration Services, SQL Profiler, Power Designer, MS SQL Server Reporting Services, MS SQL Server Analysis Services, Microsoft Visual Studio 2010.

Confidential, NY

MS SQL Server/SSRS/Crystal Reports Developer

Responsibilities:

• Worked in T-SQL to create Tables, Function and Stored Procedures, View, sub-query, correlated sub-query, complex Stored Procedures and ad-hoc TSQL statement
• Performance monitored and tuned TSQL queries using SQL Profiler and database engine tuning advisor
• Designing development, implementing and maintenance Crystal and Investran reports using Investran reports wizard.
• Contributing to documentation, group knowledge sharing and best practices initiatives.
• Designed and developed the staging databases and loaded from source to staging and from staging to the destination tables applying different transformations.
• Utilized several transformations like Lookup, Fuzzy lookup for implementing the transformation logic in the packages.
• Coordinate with team members and cross-functional team members, both onshore and offshore for solutions and development tasks on projects.
• Deployment of reports in QA and DEV environments, produce accurate deployment instructions for efficient and error free implementations.
• BAU Support, unit and integration testing including preparing test scripts and execution.
• Performing code reviews.
• Configured the report viewing security for various users at various levels using Report Manager.

Tools: Microsoft SQL Server 2005, MS SQL Server Integration Services, MS SQL Server Reporting Services, Crystal reports XI and Investran Report wizard.

Confidential

MS SQL Server/SSRS/Crystal Reports Developer

Responsibilities:

• Developed reports using efficient data retrieval techniques and tested the reports.
• Created Cross-Tab, Drill-down and Sub-Report using SSRS 2008.
• Responsible for stylish Report Layouts and Deployed the Reports using SSRS 2008.
• Identified and worked with Parameters using complex expressions for parameterized reports and managed report subscription in SSRS 2008.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Wrote Complex Stored Procedures, Triggers, Views and Queries.
• Writing standard and complex t-SQL queries to perform data validation and graph validation to make sure test results matched back to expected result base on business requirements.
• Used execution plan, SQL profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Created various DB objects like indexes, Constraints, views etc.

Tools: MS SQL Server 2008, Crystal Reports XI, SSIS, T-SQL, MS Visual Studio 2008.

Confidential

MS SQL Server/Crystal Reports/VB 6.0/Sage AccPac.

Responsibilities:

• Worked as an end to end developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Developed various T-SQL stored procedures, functions and packages.
• Designed all the Module User interface using the VB.Net and Accpac Interface.

Tools: MS SQL Server 2005, T-SQL, VB.Net, Crystal Reports and Sage Accpac,