SUMMARY

• More than 8+ Years of IT experience in Analysis, Designing & Development, Implementation & Maintenance of Database and BI Applications using MS SQL Server 2012,2010, 2008R2, 2008, 2005 and 2000 in Development and Production Environments.
• Experienced in all the stages of Software Development Life Cycle and in the migration and up gradation of databases.
• Accommodated and facilitated Joint Application Development (JAD) session, documented, analyzed and synthesized the results as parts of business requirements to prepare Business Requirement Document (BRD).
• Extensively worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.
• Experience in database design with T - SQL through conceptual Entity Relationship Diagrams and Erwin.
• Expertise in creating database objects such as Stored Procedures, Tables, Constraints, Indexes, Views, Indexed Views, and Triggers using SQL Server.
• Created Indexes, Views, Index views, Constraints, Stored Procedure, User-Defined functions, CTEs, and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency.
• Experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC utilities.
• Experience in troubleshooting SQL issues by using SQL Tools, Execution Plans, Trace, Statistics and Index Tuning Wizard.
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
• Hands on experience in creating end to end ETL strategies that will include data profiling as well as extracting transforming, conforming and loading data warehouses/ data marts for reporting purpose.
• Designed SSIS packages using various Transformations such as Fuzzy Lookup, Fuzzy Grouping, Aggregate and Derived Column Transformations.
• Experience in Error Handling and Debugging packages using Checkpoints, Data Viewers, Breakpoints, Event Handlers and Loggings (SSIS or Custom Loggings) and securing packages secured packages with Encryption in conjunction with passwords.
• Created package configurations to provide an easy solution to migrating packages from different business environments.
• Adept knowledge in creating calculated members and KPI's using basic MDX expressions.
• Created automated backup of OLAP cubes as well as normal backup using SQL server management studio.
• Proficient in configuring the Report Server and Report manager to set up roles and security on the reports.
• Hands-on experience of setting up schedules for push and pull delivery methods using Standard and Data Driven subscriptions in SSRS.

TECHNICAL SKILLS

Operating systems: Windows 98/NT/2000/XP/Vista/Windows7/8

Databases: MS SQL Server 2000/2005/2008, 2010 MS Access

Database Tools: SQL Enterprise Manager, SQL Profiler, DTS Import/Export, SQL Client Configuration utility, Backup Server, Replication Server, OLAP Services, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS)

ETL Tools: DTS, SQL Server Integration Services, SQL Server Analysis

Reporting Tools: SSRS, Crystal Reports, Cogno’s, Micro Strategy

Development Skills: Transact SQL (T-SQL), PL/SQL

Languages: C, C++, HTML, XML, VB.Net, Asp.Net(C#)

Application Packages: Microsoft Office Suite

PROFESSIONAL EXPERIENCE

Confidential, New York City, NY

SQL/ETL/SSIS Developer

Responsibilities:

• Responsible for creation and maintenance of tables, indexes, stored procedures, triggers, and UDF’s
• Debugging of stored procedures, Indexes, Triggers, Views, User Defined Functions and Cursors
• Tuned Poor performing SQL Queries with SQL Profiler Trace and Query Analyzer.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Used DTS/SSIS for ETL processes
• Used various script tasks, look up transformations, control flow tasks like FTP, bulk insert task, transfer job task etc. and different data flow tasks using T- SQL and Visual Basic (VB) scripts
• Created and scheduled SSIS packages to pull data from SQL Server database and export the data to various data sources like excel spreadsheets, flat file etc. and vice versa
• Deployed the packages in different Server and Schedule the packages to run automatically.
• Created SSIS Packages using the concepts of incremental loading and slowly changing dimensions
• Worked on performance tuning of SSIS packages using error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Implemented free text parser for FTP and web data feed inC# .Net
• Generated Custom ETL scripts using SSIS 2012 and unit test SSIS load processes for performance check.
• Documented all the migration process documents for future reference
• Involved in complete Software Development Life Cycle (SDLC), which includes requirement gathering, analysis, design, development, and Implementation
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, administering SQL Server security and SQL Server backup strategy and automation.

Environment: SQL Server 2012 Enterprise Edition, .Net 3.5,SQL BI Suite ( SSIS), PPS, XML, MS PowerPoint, MS Access 2010 & Windows Server 2012R2, Oracle, MOSS 2007

Confidential

SQL/ETL/SSIS/SSRS Developer

Responsibilities:

• Responsible for creation and maintenance of tables, indexes, stored procedures, triggers, and UDF’s
• Debugging of stored procedures, Indexes, Triggers, Views, User Defined Functions and Cursors
• Tuned Poor performing SQL Queries with SQL Profiler Trace and Query Analyzer
• Conversion / Migration of SQL Server 2005 to SQL Server 2008
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting including SharePoint integration
• Used various script tasks, look up transformations, control flow tasks like FTP, bulk insert task, transfer job task etc. and different data flow tasks using T- SQL and Visual Basic (VB) scripts
• Created and scheduled SSIS packages to pull data from SQL Server database and export the data to various data sources like excel spreadsheets, flat file etc. and vice versa
• Created SSIS Packages using the concepts of incremental loading and slowly changing dimensions
• Worked on performance tuning of SSIS packages using error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Implemented free text parser for FTP and web data feed inC# .Net
• Generated Custom ETL scripts using SSIS 2005 and unit test SSIS load processes for performance check.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Involved in writing MDX queries and performance optimization of the SSAS cubes for calculated members and measure groups.
• Involved in migration and conversion of Reports from SSRS
• Created Parameterized, Cross-Tab, Drill Down & Drill Through reports by using SSRS 2005/2008
• Created report models for the ad-hoc reporting of the end users using Report Builder
• Deployed SSRS reports in share point for web based access for multiple end users
• Documented all the migration process documents for future reference
• Involved in complete Software Development Life Cycle (SDLC), which includes requirement gathering, analysis, design, development, and Implementation
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.

Environment: SQL Server 2005/2008/2012 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS, SSRS),OLTP, OLAP, Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Crystal Reports, Cogon's, Business Objects, SharePoint, MOSS 2007

Confidential, Richmond, VA

SQL/SSAS/SSIS/SSRS Developer

Responsibilities:

• Responsible for creation and maintenance of tables, indexes, stored procedures, triggers, and UDF’s
• Debugging of stored procedures, Indexes, Triggers, Views, User Defined Functions and Cursors
• Tuned Poor performing SQL Queries with SQL Profiler Trace and Query Analyzer
• Conversion / Migration of SQL Server 2005 to SQL Server 2008
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting including SharePoint integration
• Used various script tasks, look up transformations, control flow tasks like FTP, bulk insert task, transfer job task etc. and different data flow tasks using T- SQL and Visual Basic (VB) scripts
• Created and scheduled SSIS packages to pull data from SQL Server database and export the data to various data sources like excel spreadsheets, flat file etc. and vice versa
• Created SSIS Packages using the concepts of incremental loading and slowly changing dimensions
• Worked on performance tuning of SSIS packages using error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Involved in writing MDX queries and performance optimization of the SSAS cubes for calculated members and measure groups.
• Involved in migration and conversion of Reports from SSRS
• Created Parameterized, Cross-Tab, Drill Down & Drill Through reports by using SSRS 2005/2008
• Created report models for the ad-hoc reporting of the end users using Report Builder
• Deployed SSRS reports in share point for web based access for multiple end users
• Documented all the migration process documents for future reference
• Involved in complete Software Development Life Cycle (SDLC), which includes requirement gathering, analysis, design, development, and Implementation
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.

Environment: SQL Server 2005/2008/2012 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS, SSRS),OLTP, OLAP, Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Crystal Reports, Cogon's, Business Objects, SharePoint, MOSS 2007

Confidential, Milwaukee, WI

SQL/ETL/SSIS/SSRS Developer

Responsibilities:

• Implemented the agile process in the scrum methodology and integrated all the scrum processes with our TFS environment.
• Created new database objects like Procedures, Functions, Indexes and Views using T-SQL.
• Utilized Dynamic SQL for user customizable queries to be answered by the SQL Server.
• Created Views for each ETL Requirement so that all the data that has already been pulled from data sources are not pulled again into the staging database.
• Managed ETL strategy to extract, clean and deliver data to OLAP environment and ensure accuracy, consistency and integrity of the data warehouse.
• Implemented different built in transformations tasks including SCD, Aggregate, Lookups and Data Conversion to implement complete ETL strategy.
• Used various Package configurations available for SSIS Packages like XML files and SQL Server Tables.
• Implemented the Master Child Package Technique to manage big ETL Projects efficiently.
• Involved in debugging the Packages by utilizing SSIS features like breakpoints, Data-Viewers and custom loggings.
• Designed SSIS package templates as base code for package development incorporating package configurations, connection managers and logging in it.
• Created QA (Quality Assurance) scripts and sanity checks to further test ETL packages by comparing QA output with output from ETL package.
• Tested the packages developed to find out any bug and handled the errors encountered at the time of testing.
• Created ad-hoc reports using power pivot and performance point extracting data from heterogeneous sources.

Environment: SQL Server 2005/2008 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Share Point, MOSS 2007, OLTP, OLAP

Confidential

SQL Server DBA/Developer

Responsibilities:

• Study and understand the requirements of the information required by company’s Procurement Department about the vendors.
• Designed T-SQL scripts to identify long running queries and blocking sessions
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions
• Data migration (import & export - BCP) from Text to SQL Server
• Developed Backup and Restore scripts for SQL Server 2005
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions
• Written T-SQL queries for the retrieval of the data.
• Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
• Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration.

Environment: SQL Server 2000 Enterprise Edition, T-SQL, Enterprise manager, VBS, MS Office & Windows 2K platform.