SUMMARY

• Over 8+ years of IT experience with a strong background in Data warehousing projects design, development and implementation with SQL Server 2012/2008/2005/2000 in a high transaction and multi server production environment.
• Well - organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.
• Excellent Knowledge of SDLC, RDBMS, Data Warehouse & Data Modeling concepts.
• Expert knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Expert in Extraction, Transforming and Loading (ETL) data using SSIS/DTS; creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities.
• Expert in creating T-SQL objects, working with DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• Expert in creating Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Experience in writing Distributed Queries between SQL Servers.
• Experience in using tools like Index Tuning Wizard, database engine tuning advisor, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning Server Performance.
• Handled huge financial data, expert level query optimization and performance tuning experience
• Experience in creating Jobs, Alerts, setting up SQL server mail agent for SSIS packages.
• Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Expertise skill in Migrating/Re-writing DTS packages to SSIS packages using Upgrade Advisor/Package Migration Wizard.
• Expertise in generating reports using Crystal Reports, SQL Server Reporting Services, and Microsoft Access & Excel spreadsheet.
• Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS).
• Good SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes.
• Self learning ability and Leadership Quality.

PROFESSIONAL EXPERIENCE

Confidential, Columbus OH

ETL/SSIS/SSRS Developer/Data Analyst

Responsibilities:

• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse using SQL Server 2012.
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Created OLAP Cubes and was responsible for OLAP processing, Optimizing Dimensions, creating hierarchies and adding the Aggregations to the Cube.
• Performed partitioning of cubes as well as cube optimization in order to increase the performance of cubes.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created Parameterized reports and linked reports using Bookmark links and Hyperlinks.
• Created subscription for the windows file share and implemented three layer securities for the reports, SSRS website, and in the Intranet web application.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.

Environment: Microsoft SQL Server 2012, T-SQL, SQL Server Reporting Services, SQL Server Integration Services,, Windows server 2003 and IIS 5.0, Team foundation server(TFS).

Confidential, Belleville IL

ETL Developer/SSIS/SSRS Developer

Responsibilities:

• Implemented SSIS (ETL) to extract and transform data from RDBMS,and Flat files/CSV, SQL Server 2005 instances and to load into staging and then to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• 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.
• Configured SQL Mail agent for sending automated alerts/email.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Provided documentation for all kinds of reports and SSIS packages.
• Performed operations such as Fine-tuning queries and stored procedures and providing consultation to other developers.
• Extract the data from XML and load it to dimensional model.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Generated SQL Server Drill down, Drill through, Cross tab report using SSRS to fit business requirements.
• Enhanced the business logic using User Defined Functions to retrieve information on the services like billing, customer, and requests from the residential, business and large business databases.
• Closely worked with data modeler to design the data warehouse.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.

Environment: Microsoft SQL Server 2008/2005 Enterprise edition SP3, SSMS, SSIS, SSRS, SSAS, BIDS, Microsoft Visual studio 2005, Windows server 2003,Clear case 9.1.2.0,SVN.

Confidential, Camp Hill PA

SQL Server/SSIS Developer

Responsibilities:

• Responsible for Conceptual, logical and physical design with a significant effort towards application using ERWIN.
• Designed SSIS Packages in SQL Server 2008 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Involved in designing the data warehouse and core Database for the system including tables, Stored Procedures, Indexes, UDF and triggers.
• Performed operations such as Fine-tuning queries and stored procedures and providing consultation to other developers.
• Performed activities like analyzing and improving the architecture of databases, creation & indexing of the tables.
• Implemented SSIS (ETL) to extract and transform data from RDBMS,and Flat files/CSV, SQL Server 2005 instances and to load into staging and then to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008.
• Generated SQL Server Drill down, Drill through, Cross tab report using SSRS to fit business requirements.
• Worked with data modeler to design the OLTP database as well as data warehouse.
• Used Query Optimization and SQL Server Profiler for tuning report queries and improves performance in SQL Server.

Environment: Microsoft SQL Server 2008/2005 Enterprise edition SP3, SSMS, SSIS, SSRS, SSAS, BIDS, Microsoft Visual studio 2005, Windows server 2003,Clear case 9.1.2.0,SVN.

Confidential, Jersey City NJ

SQL Server Developer/SSIS Developer

Responsibilities:

• Planned, Defined and Designed database based on business requirement and provided documentation.
• Coordinated with DBA in creating and managing tables, indexes, triggers, database links and privileges.
• Gathered data and documented it for further reference and designed Database using Erwin data modeler.
• Created SSIS package to load data from Flat Files and SQL Server 2000 to SQL Server 2005 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.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• 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 2005.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2005.
• Created reports which retrieve data using Stored Procedures that accept parameters.
• 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.

Environment: SQL Server 2005 enterprise edition SP3, BIDS, SSRS, SSIS, SSAS, Crystal Reports

Confidential, Miami FL

ETL Developer/SSIS Developer

Responsibilities:

• Migrating SQL Server 2000 DTS Packages to SSIS Packages for uploading various formats of files and data from the legacy databases and SQL Server 2000 to MS SQL Server 2005 Data warehouse using SQL Server Integration Services (SSIS).
• Created complex scripts to do chucking and massaging of legacy data in staging area of SSIS package.
• Dropped and recreate Index on the DSS system while data migrating.
• Schedule Jobs to run SSIS package in night feed to DSS system for fresh day data.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Modified existing databases by adding/removing tables there by altering referential integrity, primary key constraints and relationships according to requirements.
• Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.
• Wrote documentation for the packages and scripts and job created for migrate data.
• Created and Deployed reports to Report Manager and Troubleshooting for any error occur in execution.
• Participated in testing during the UAT (QA testing). Mentored and monitored team development and status.

Environment: SQL Server 2000/2005, DTS, SQL Server Integration Services, MS Excel 2003, MS Access 2003, Enterprise Manager, Management Studio, SQL Profiler and SSRS.

Confidential, NJ

ETL Developer/SSIS/SSRS/SSAS Developer

Responsibilities:

• Assisted project manager in project planning schedule for database module.
• Used highly complex TSQL queries and SQL Scripts to perform efficient data load based on complex business rules and produced results for users.
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from SSIS to make the flow of SSIS effective.
• Used multiple join statements to retrieve data from multiple tables.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Tested procedures and triggers before moving into production.
• Created various SSIS packages for data transfer and migration from OLTP to OLAP.
• Configured replication servers and transactional replication between production and standby server for disaster recovery.
• Analyzed and designed disaster recovery / replication strategies along with business managers to meet the business requirements.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: SQL Server 2000/2005, DTS, SQL Server Integration Services, MS Excel 2003, MS Access 2003, Enterprise Manager, Management Studio, SQL Profiler and SSRS.

Confidential

SQL Server Developer

Responsibilities:

• Installed and configured MS SQL Server and Applied service packs and hot fix.
• Migrated databases from MS SQL 2000 to MS SQL 2005.
• Logically and physically designed database for projects on basis of user requirements using ERWIN.
• Wrote various Stored Procedures for the purpose of application development
• Performed Database backups (operating system, flat file backups & export/import).
• Created complex Stored Procedures.
• Used Query Analyzer to optimize SQL Queries.
• Converted various SQL statements into Stored Procedures thereby reducing the Number of database accesses (since Stored Procedures passes the whole block at one time).
• Coded Procedures & Functions in MS SQL 2005.
• Worked in a Team on SQL Server 2005 Application Development.
• Successfully loaded data from an EXCEL, Access into a SQL Server database Table.
• Loaded data from Flat files (. txt) into SQL Server. Using BCP.
• Involved in query monitoring for the queries that were parsed through Cogon’s.
• Provided technical support to internal developers and external clients Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Environment: MS SQL Server 2000/2005, T-SQL, Enterprise Manager, Windows 2000 Server, MS Office 2000, Erwin.