SUMMARY

• Over 8 years of strong experience in the IT industry as a MS SQL Server 2012/2008R 22008/2005/2000 Developer/BI Developer, Data warehouse developer in various domains.
• Maintained positive communications and working relationship at all levels.
• An enthusiastic and goal - oriented team player possessing excellent communication, interpersonal skills with good work ethics
• Skilled professional with experience in all stages of SDLC: planning, analysis, design, implementation and Worked with SDLC methodologies like Waterfall, RUP, Agile (Scrum).
• Extensive experience in SQL Server 2012/2008R2/2005/2000, Business Intelligence in SQL Server Integration Services, SQL Server Reporting Services, and SQL Server Analysis Services.
• Proficient in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Exceptional Ability of writing ad-hoc queries utilizing Dynamic SQL and SQLCMD command line utility.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert and BCP).
• In-depth Knowledge in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN 7.1 and Visio
• Proficient in Importing/Exporting Data from various data sources like Excel, Oracle and Flat file using SSIS utility. Involved in transformation of OLTP data to the Data Warehouse using SSIS 2012/2008r2/2008/2005 and SQL commands.
• Expertise in installation, upgrade and configuration of Microsoft SQL Server and databases.
• Proficient in designing, creating, processing of cubes using SSAS 2012/2008r 2/2008/2005.
• Generated calculating measures and dimension members using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Experience in creating KPI and Calculated Measures using SSAS.
• Experience in working with Sybase Adaptive Server Enterprise, TFS.
• Proven ability in defining Query for generating Drill down reports, Matrix reports, Chart reports and handling parameterized reports, creating on demand and scheduled reports in SSRS 2012/2008r2/2008/2005
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS) 2012/2008r 2/2008/2005.
• Expert in using tools like SQL Profiler, Database Engine tuning wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Ability to handle Microsoft SQL Server Database Administration including planning, backup, and recovery strategies.
• Proficient in Migration of database, successfully migrated database from SQL Server 2000 to SQL 2005 and SQL Server 2005 to SQL 2008.

TECHNICAL SKILLS

• SQL Server 2012/2008r2/2008/2005
• SQL Server Enterprise Manager
• Query Analyzer
• Transact-SQL (T-SQL)
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• MS SQL Server Integration Services (SSIS)
• Data Transformation Services (DTS)
• SQL Server Management studio (SSMS)
• Qlikview
• Business Intelligence Development Studio (BIDS)
• MS Access
• MS Visual Studio
• Bulk Copy Program (BCP)
• Microsoft Office
• MS Visio 2003/2007
• C#
• HTML
• ASP .NET
• Crystal Report
• Erwin 7.3/4.1/4.0
• Sybase Adaptive Server
• Team Foundation Server
• Performance Point Server
• Visual SourceSafe (VSS)
• SQL Server Profiler
• Data Base Tuning Advisor.

PROFESSIONAL EXPERIENCE

Confidential, Harrisburg, PA

Lead MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Designed data architecture, data model and Mapping Process to load data based on business requirement and provided documentation.
• Implemented Table, Views, Function, Stored Procedures and Triggers for load data and validation purpose.
• Worked with Agile Methodology tracking the product backlog and resolved the defects/Solution assigned in daily scrum.
• Created SSIS package to load data from XML Files, Excel, CSV file, Ftp server and SQL Server to SQL Server 2012 by using Derived Columns, Condition Split, Data Conversion, Ole DB Command, Term Extraction, Aggregate, Pivot Transformation, Execute SQL Task and Script Component Task.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Transaction and Data Ware House.
• Converted DTS Package to SSIS package for synchronizes existing process.
• Used Team Foundation Server to retain Project code during deployment process.
• Part of Code review during Production deployment and QA deployment.
• Designed SSIS Package step process to load data, validate data and Recommending task to resolve performance issue with loading data in to the Data Ware House.
• Designed Console application to generate Single .CSV and text file from Different relational Database table using SSIS and C#.
• Created Process for Error Details in Application system, Control-M Job, SQL agent Job to easily identify Issue for Support and Solution.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Created reports to retrieve data using function, views, cube and Stored Procedures using parameters.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012 and Qlikview.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2012.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.

Environment: MS SQL Server 2012, SSIS Package, SQL BI Suite(SSMS,SSIS, SSRS,SSAS), XML, MS Excel, MS Access 2007 & Windows Server 2008, SQL Profiler, Sybase Adaptive Server, TFS, Qlikview, SQL Profiler, Erwin r 7.3.,Net 4.0/4.5.,TFS 2010.

Confidential, Pittsburgh, PA

MS SQL Server Developer/Report Programmer and Developer

Responsibilities:

• Defined and Designed data based on business requirement and provided documentation.
• Created SSIS package to load data from XML Files, Ftp server and SQL Server to SQL Server 2008 by using Lookup, Derived Columns, Condition Split, Ole DB Command, Term Extraction, Aggregate, Pivot Transformation, Execute SQL Task and Slowly Changing Dimension.
• Worked with Agile Methodology tracking the product backlog and resolved the defects assigned in daily scrum.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse.
• Used C# and .net for error handling in SSIS
• Developed Validation Plans for SSIS packages for checking the functionality of each component and Code review.
• Used C# in script task.
• Planned and executed SSIS Package step process to load data, validate data and Recommending task to resolve performance issue with loading data in to the Data Ware House.
• Modified the existing SSIS packages to meet the changes specified by the users and adding column to the newly design table and to the existing table.
• 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.
• Job overlap alert
• Worked in setup auditing, logging environment to track the status of the events like error raise, task fail.
• Designed tool to Automatic added Derived column, Parameter and Configuration value to the package.
• 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 function, views, cube and Stored Procedures using parameters.
• Created various database objects like stored procedures, functions, tables, views, triggers.
• Configured the report viewing security for various users at various levels using Report Manager
• Fine tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Provided documentation for all kinds SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Environment: MS SQL Server 2008/2012, SQL BI Suite (SSMS,SSIS, SSRS), XML, MS Excel, MS Access 2007 & Windows Server 2008 Access 2003 & Windows Server 2003, SQL Profiler, Data Analyzer, Erwin r 7.3.,Net 4.0/4.5.,TFS 2005/2008/2010/2012 , Microsoft .net, C#

Confidential, NYC, NY

SSAS/SSRS Developer

Responsibilities:

• Gathered user requirements to develop the business logic and analyzed and designed database solutions.
• Defined Technical Design Specifications, ETL workflows and Source to Target Mapping (STTM) spreadsheets for each Vendor system interfacing with the High Point system.
• Designed, developed and deployed complex SSIS packages based on STTM conversion rules for the transformation of Pre-staging data from AS400 systems to subsequent target layers in SQL Server 2008R2.
• Optimized queries and tuned performance using SQL Server tools including SQL Profiler, SQL Performance Monitor and Execution Plan.
• Generated SQL Server Database objects including Tables, Views and Indexes.
• Created and modified stored procedures, triggers and queries for automating various interface tasks using T-SQL.
• Analyze and Created SSAS cube and set up role based security in the cube.
• Defined Testing strategies and designed Test Plans to test each system Interface output and validated output data from each Interface based on respective Test Plans.
• Ensured the quality of the output for each system Interface by conducting Meetings with the respective vendors to review the output and obtain continuous feedback.
• Identified and defined Key Performance indicators (KPIs) for vendor reporting.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008R2.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008R2.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008R2.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.
• Created Tabular reports, Cross Tabs, Drill down, Charts, Functions and Maps.
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Supports the development, implementation and daily administration of SQL Server databases, performs database design, modeling and implementation of new database structures, as required.

Environment: SQL Server 2005 Enterprise Edition, Access 2003, T-SQL, MS-Excel, MS-Access, Query Analyzer, Crystal Reports.

Confidential, Providence RI

SQL Server/SSIS/SSAS Developer

Responsibilities:

• In-Depth Knowledge with requirements gathering, analysis, design, development, change management, deployment and user training.
• Created Stored Procedures in T-SQL that were invoked to load Dimensions and Fact tables and also for Error handling during the SSIS process.
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schemas using Dimensional Modeling principles in SSAS.
• Analyzed and Designed and developed MOLAP cubes with SSAS.
• Developed and implemented partitioning and security in cubes based on user roles.
• Implemented Member properties, virtual Dimensions, Dimension custom rollups, write back, action and drill through.
• Created MDX expressions/queries for accessing cubes; involved in query structuring and performance optimization.
• Developed role based Dashboards to monitor KPIs and Ad hoc reports for Accounting and Claims using SSRS.
• Design and Developed complex canned reports using SSRS 2005 from multiple data providers in Underwriting and Claims systems, User defined objects, Aggregate Aware Objects, Charts and synchronized queries.
• Conversion of Crystal Reports to Reporting Services and also existing SAS reports to Reporting Services 2005.
• Optimized queries and did performance tuning using various MS SQL Server tools such as SQL Profiler, SQL Performance Monitor and Execution Plan.
• Validated reports to ensure quality of data and conducted Meetings with business users to review reports and obtain continuous feedback.
• Coordinated the activities of subordinates in the Data warehouse Team and organized weekly status Meetings.
• Designed a backup and recovery solution based on the link between disk design, database layout, backup retention, database performance for efficient backup and restore.
• Implemented a well-planned Backup and Restoration strategy that protects databases against data loss due to damage caused by a variety of failures.

Environment: Microsoft SQL Server 2005, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Query Analyzer, Microsoft SharePoint, Microsoft Visio Professional 2005, Optimal Trace, Crystal Reports, ETL Tool.

Confidential, Trenton, NJ

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Designed ER diagrams (Physical and Logical using ERWIN) and mapping the data into database objects.
• Developed the procedures for getting the data from source systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
• Extensively participated in functional and technical meetings for designing the architecture of ETL load process (mappings, sessions, workflows from source systems to staging to DW) and offshore team management
• Extensively used ETL to load data from flat file to SQL Server database.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSISPackages.
• Created SQL server configurationsforSSISpackages.
• Responsible for creating reports based on the requirements using SSRS 2005.
• Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
• Defined the report layout and identified Datasets for the report generation.
• Created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Created and tuned stored procedures, triggers and tables.

Environment: SQL Server 2005,Query Analyzer, Enterprise Manager, SSIS,SSRS,SQL Management Studio, Business Intelligence Development Studio(BIDS), Erwin 7.1,Microsoft Visual Studio, Windows 2000/2003 servers, XP Professional.

Confidential

SQL Server Programmer

Responsibilities:

• Interacted with business users and analysts and gathered and documented the technical and business metadata.
• Designed Database, Tables and Views structure for the new data mart.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2005 using SSIS Packages.
• \Created complex Stored Procedures and Functions for integrity checks of transferred data.
• Performed Unit Testing and SQL Performance Tuning.
• Helped end users with the ability to access and utilize the data stored in the data mart.
• Generated Reports and Charts using Crystal Reports.
• Tuned SQL statements using Indexes and Stored Procedures.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assisted end users with development of complex Ad Hoc queries.
• Involved in Implementation and Maintenance of Disaster Recovery solutions such asReplicationand Log Shipping.