SUMMARY

• MS SQL Server Developer 2012/2008R2/2008/2005 with over 8 years of IT experience as a MS SQL Server Developer 2012/2008R2/2008/2005 in various Industry verticals like Health Care, Finance, Insurance and Service. Maintained positive communications and working relationships at all business levels.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensive experience in MS SQL Server 2012/2008R2/2008/2005, Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.
• Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Expert in Creating, Configuring and Fine - tuning SSIS packages, SSRS reports and T-SQL queries using tools like SQL Profiler, Performance Monitor and Database Engine Tuning advisor.
• Strong experience in designing and developing more than 100+ enterprise reports(SSRS/Business Objects) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Expert in creating MOLAP Cubes using SSAS and created multiple cubes with dimensions and facts.
• Highly experienced in optimizing MOLAP Cubes by partitioning them, Designing Aggregations, implementing Hierarchies and Calculated Members.
• Hands on experience in implementing Key Performance Indicator (KPI) Objects and Create Calculate member using MDX in SSAS 2008/2005.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Extensive experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2005.
• Experienced in Logical and Physical Database design & development, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Strong experience in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
• Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports using SQL Server Reporting Services (SSRS) based on client requirement.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R2/2008/2005
• MS SQL Server 2008/2005 Analysis Services (SSAS)
• MS SQL Server Integration Service (SSIS)
• MS SQL Reporting Services (SSRS)
• Microsoft Access 2007/2003/8.0
• Microsoft Excel
• Outlook
• MS SQL Profiler
• SQL Query Analyzer
• MS SQL Server Index Tuning Wizard
• Erwin Data Modeler 4.2/4.1/4.0
• Excel VBA
• .NET
• VB.NET
• Crystal Reports 8.5
• T-SQL
• MS Visio 2003
• Microsoft Share Point Server
• Windows 2003/2000 Advanced Server/Professional
• Windows NT 4.0 Server/Workstation.

PROFESSIONAL EXPERIENCE

Confidential, Trenton, NJ

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of Clients.
• Involved in preparing Technical specification document based on the BRD and interact with the Business Analyst to analyze and understand the Business needs.
• Created various SQL objects such as schema, tables, field definitions and mappings, stored procedures, CTE, Triggers, views and indexes/keys.
• Involved In migration of various objects like stored procedures, tables, views from Sybase to SQL server
• Involved in compiling of store procedures in SQL server and troubleshoot errors.
• Created documents for code review in test and prod server.
• Used complex query statements like subqueries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of hub.
• Conducted performance tuning of complex SQL queries and stored procedures by using SQL Profiler and index tuning wizard.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Created Dynamic SSIS Packages using package configuration, variables and expressions to load data in various environments.
• Involved in creating dynamic reports using SSRS for the monthly Claims and details of all locations, generated report models using report builder for the end users.
• Involved in scheduling reports on hourly, daily, weekly basis that contains reconciliation data between source and target and also reports to provide business with member’s and policy information.
• Generated Complex reports like reports using Cascading parameters, Snapshot reports Drill- down Reports, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports using SQL Server Reporting Services (SSRS) based on Business Requirement Document.
• Create various Metadata driven reconciliation Stored Procedures to compare the data from Source to data warehouse and data warehouse to Reporting Data Store and display the inconsistency between them in reports and fix it.
• Provided Production support to analyze and fix the problems and errors on daily basis by modifying SSIS Packages and Stored Procedure if necessary.

ENVIRONMENT: Microsoft SQL Server 2012, Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Integration Services (SSIS), XML, SQL Server Business Intelligence Development Studio, MS Visio, Microsoft Share Point Server, Team Foundation Server(TFS), Team Foundation Version Control, T-SQL, .NET, MS Word and Excel, SQL Profiler, Database Engine Tuning Advisor, BIDS Helper

Confidential, Yonkers, New York

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Interact with Development Teams and Managers to analyze business needs. Provide software product design and develop a technical roadmap for the solution through the project lifecycle and beyond.
• Involved in preparing SSIS package flowcharts, Technical specification document showing all the necessary steps to be taken for the project and scheduling Technical design meetings with team leader and manager.
• Actively participated in gathering Business Requirements and System Specification. Participated in implementing the logical design to the physical design by creating tables.
• Analyzed the existing data and performed the appropriate changes from SQL Server 2005 to SQL Server 2008 by following the Normalization standards to maintain data consistency and by performing data validation.
• Involved in the design of new schema, new tables, field definitions and mappings, stored procedures, views, indexes/key and SSIS Configuration Scripts
• Designed and modified existing SSIS packages to load the data from SQL Server 2000/2005 to the ETL tier.
• Created SSIS Packages by using advance transformations (i.e. Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate) and also used Custom components such as Audit on Pre-Execute, Audit On Post-Execute, Custom Email Task and Statistics Logging Component.
• Created Dynamic SSIS packages using complex expressions, variables and control flow components such as ForEach Loop, For Loop to loop over a Directory to load inbound files coming daily.
• Tested, Cleaned and Standardized Data to meet the business standards using Fuzzy /Exact lookups and String manipulations.
• Enforced the Business Rules to filter bad data from the system by using Complex T-SQL Statements, and implemented various Constraints and Triggers for Data Consistency..
• Responsible for creating the reports based on the requirements using SSRS 2008.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).
• Created different type of reports which include: A Cross-tab, Conditional, Sub report, Drill-down and Parameterized, Linked reports and deployed and scheduled Reports in Report Manager using SSRS to generate all daily, weekly, monthly and quarterly Reports.
• Monitoring performance and optimizing SQL queries for maximum efficiency.
• Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Nonclustered Indexes for significant performance boost.
• Preparing the Migration document showing the paths for input and output files, configuration files, table scripts, stored procedures and SSIS packages.
• Involved in performing Unit Test, Regression Test, Functional Test, Integration Test, Stored Procedure Performance Test, on Test server and preparing combined Developer Testing document.

ENVIRONMENT: Microsoft Windows Server 2003 Enterprise Edition, Microsoft SQL Server 2008R2, Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Integration Services (SSIS), XML, SQL Server Business Intelligence Development Studio, MS Visio, Microsoft Share Point Server, T-SQL, .NET, MS Word and Excel, Visual Sourcesafe, SQL Profiler, Database Engine Tuning Advisor, BIDS Helper

Confidential, New York, NY

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Planned, Defined and Designed data based on business requirement and provided documentation.
• Gathered data and documenting it for further reference and designed Database using Erwin data modeler.
• Created SSIS package to load data from Flat Files and SQL Server 2005 to SQL Server 2008 a using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database object like stored procedures, functions, tables, views
• Configured the report viewing security for various users at various levels using Report Manager
• Deployed the generated reports on to the server.
• Defined attribute properties in a Parent Child Dimensions.
• Scheduled report and exported in PDF format.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

ENVIRONMENT: MS SQL Server 2008R2 Analysis Services (SSAS), Reporting Services (SSRS), Integration Services(SSIS), T-SQL, Win 2003 Advanced Server, Erwin v7.3, SQL Profiler, Database Engine Tuning Advisor, .NET, VB.NET, SQL Server Agent.

Confidential, Atlanta, GA

MS SQL Server/ SSIS/ SSRS/SSAS Developer

Responsibilities:

• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources. .
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Analyzed and designed the business rules for data cleansing that are required by the staging & OLAP and OLTP databases.
• Implemented the Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Migrated packages from development server to production server using package configuration.
• Created Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, Drill through, Subreports using SSRS.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Deployed generated reports onto the Report Server to access it through browser.
• Created various geographical and time dimension reports of fiscal year, quarter month, week and daily reports for all domains and published through Report Server.
• Created various reports by comparing the growth of company based on each quarter by using bar charts.
• Responsible for generating annual reports based on the growth of company with respect to customers.
• Created calculated measures and dimension members using multidimensional expression (MDX), mathematical formulas, and user-defined functions.
• Developed MDX expressions for cube calculations and Key Performance Indicators (KPIs).
• Used Visual Source safe for repository and maintaining versions.
• Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Improved Performance of the database by creating Clustered and nonclustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Conducted user training sessions and supported the requests for enhancements, modifications and new reports.

ENVIRONMENT: MS SQL Server 2008 Analysis Services (SSAS), Reporting Services (SSRS), Integration Services(SSIS), Microsoft Performance Point Server 2008, Microsoft Share Point Server, T-SQL, .NET, C#, MS Access and Excel, Visual Sourcesafe, SQL Profiler

Confidential, Morristown, NJ

MS SQL Server/ SSIS/ SSAS Developer

Responsibilities:

• Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
• Successfully installed and configured MS SQL Server 2005 on the production server.
• Automated the migration of data from Oracle DB to MS SQL Server 2005 DB using Microsoft SQL Server Migration Assistant (SSMA).
• Generated assessment reports to analyze the scope and complexity of the migration projects.
• Converted the Oracle DB objects to MS SQL Server 2005 DB objects like tables, views, and stored procedures.
• Designed a new schema design for the data warehouse using dimensional modeling and developed it using the Erwin tool.
• Migrated the entire schema as well as data into MS SQL Server 2005 and also validated the migration process to ensure that it has been successfully migrated.
• Created SSIS packages to load data from the OLTP system to a Data mart for analyzing data.
• Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multidimensional expression (MDX) to access them.
• Identified and modified the Key Performance Indicators (KPIs), measures in co-ordinance with the requirement.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
• Defined referential relationships with the measure groups and fact tables.
• Generated automatically grouping attribute members and implemented the calculations to aggregate physical measures.
• Defined granularity within a measure group and drill through actions.
• Created cube reports that can be browsed at summary level and can be drilled down to the detail level.
• Defined the browsing perspectives and browsing translations since most transactions were online.
• Documented the development work and production release for future reference.

ENVIRONMENT: MS SQL Server 2005 Analysis Services (SSAS), Integration Services(SSIS), Visual Studio 2005, T-SQL, MS Access, Windows XP, Erwin v4.0., Microsoft SQL Server Migration Assistant (SSMA).