PROFESSIONAL SUMMARY:

• Over 8 years of IT experience with a strong background in Data warehousing projects design, development and implementation with SQL Server 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 OH

ETL/SSIS/SSRS Developer/Data Analyst

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.
• 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.

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

Confidential OH

ETL/SSIS/SSRS Developer/Data Analyst

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, Adhoc, Cross tab report using SSRS to fit business requirements.
• 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 FL

ETL 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.
• 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.
• 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.
• Responsible for Monitoring and Tuning Report performance.
• 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, Exchange Place NJ

ETL Developer/SSIS/SSRS Developer

Responsibilities:

• Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Involved in designing the physical databases model on SQL Server 2005 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity.
• 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.
• Created interface stored procedures used in SSIS to load/transform data to PRMS.
• 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.
• Diagnosing and tuning the server optimal performance using SQL server 2005 Dynamic Management Views (DMV), Profiler and database engine tuning advisor.

Environment: Microsoft SQL Server 2005 Enterprise Edition, T-SQL, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, Windows server 2003 and IIS 5.0, Visual Source Safe.

Confidential, Nutley NJ

ETL Developer/SSIS/SSRS/SSAS 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, New York, NY

MS SQL Server/SSIS/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 incorporate the flow of business and called various stored procedures from DTS to make the flow of DTS 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 DTS 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: MS SQL Server 2000, MS Excel, Windows 97/2000/XP

Confidential

SQL Server Developer

Responsibilities:

• Installed and configured MS SQL Server and Applied service packs and hot fix.
• Migrated databases from SQL7.0 to MS SQL 2000.
• 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 2000.
• Worked in a Team on SQL Server 7.0 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 7.0, T-SQL, Enterprise Manager, Windows 2000 Server, MSProfessional Summary: