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. Self learning ability and Leadership Quality.
• Excellent Knowledge of Software Development Life Cycle, RDBMS, Data Warehouse & Data Modeling concepts.
• Expertise in Extraction, Transforming and Loading (ETL) data using SSIS creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities.
• Strong experience in creating T - SQL objects, working with DDL/DML, performs most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• Proficient in creating Indexed Views, complex Stored Procedures, effective functions, constraint and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Experience in writing Distributed Queries between SQL Servers.
• Expert 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.
• Hands on 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.
• Strong Experience in Migrating/Re-writing DTS packages to SSIS packages using Upgrade Advisor/Package Migration Wizard.
• Expertise in generating reports using SQL Server Reporting Services, and Microsoft Access & Excel spreadsheet.
• Experience in creating various reports like drill down, sub reports, parameterized, multi-valued and various adhoc reports through Report model creation.
• Good SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes.
• Consistent and dependable performer with the flexibility to adapt to constantly shifting priorities.
• Strong troubleshooting and problem solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS

• MS SQL Server 2008/2005/2000
• MS SSRS 2008/2005/2000
• MS SQL SSAS 2008/2005/2000
• MS SSIS 2008/2005/2000
• DTS
• Erwin Designer 2000
• DB2 SQL syntax
• MS-Access 2000
• C
• C++
• VB 6.0
• Developer 2000
• Erwin 7.3/4.2/4.2/4.0
• Oracle 9i/10g
• T-SQL
• PL/SQL
• ASP.NET
• HTML
• XML
• XSL
• Visual Studio 2005
• T-SQL
• PL-SQL
• ODBC
• MS Office
• Windows NT/ 2000 Server/ XP.

PROFESSIONAL EXPERIENCE

Confidential, Harrisburg, PA

ETL Developer/SSIS/SSRS Developer

Responsibilities:

• Responsible for Conceptual, logical and physical design with a significant effort towards application using ERWIN.
• Involved in designing the data warehouse and core Database for the system including tables, Stored Procedures, Indexes, UDF and triggers.
• Responsible for design code database schema, support SQL development and write a complex SQL code and troubleshoot SQL code.
• 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.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Used Query Analyzer and SQL Server Profiler for tuning report queries and improves performance in SQL Server.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Designed SSIS Packages in SQL Server 2008 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• 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.
• Configured SQL Mail agent for sending automated alerts/email.
• Provided documentation for all kinds of reports and SSIS packages.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• 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.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Generated reports using SSRS which were send to different Primary Vendors, Clients, and managers.
• Created reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services.
• Developed high level daily summary report (Flash Report) and monthly business summary report (Monthly Management Report) and distributed these reports across different business units.
• Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.

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

Confidential, Chicago, IL

ETL Developer/MS SQL Developer/SSIS/SSRS/SSAS 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.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Fine tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Created SSIS package to load data from staging environment to production environment 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.
• Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).
• Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• 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.
• Designed, Developed and Deployed reports in MS SQL Server environment 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.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Responsible to create all the SSRS report using Cube as data source.
• Responsible for Monitoring and Tuning Report performance.
• Configured the report viewing security for various users at various levels using Report Manager.

Environment: SQL Server 2005 enterprise edition SP3, BIDS, SSRS, SSIS, SSAS, Oracle 10g, Crystal Reports.

Confidential, Houston, TX

ETL Developer/MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Migrated 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.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, ForEach Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components.
• Used BCP to transfer the data file to other server.
• 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 Views to reduce database complexities for the end users.
• Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.
• Extensively used join and sub queries involved multiple tables.
• Wrote documentation for the packages and scripts and job created for migrate data.
• Responsible for creating all reports such as matrix report, drill down report, drill through report, sub report and chart report etc.
• Involved in creating different Parameterized reports like standard parameter reports, cascading parameter reports.
• Created Linked report, Ad-hoc report based on the requirement, Linked report are created in the report manager to reduce the repetition the report.
• Created and Deployed reports to Report Manager and Troubleshooting for any error occur in execution.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Participated in testing during the UAT (QA testing). Mentored and monitored team development and status.

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

Confidential, Birmingham, AL

ETL Developer/MS SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• 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.
• Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Identified slow running query and optimization of stored procedure and tested application for performance, data integrity using SQL profiler.
• 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.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Designed the Data Warehousing ETL procedures for extracting the data from all source systems to the target system
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Analyzed the current architecture to propose an ETL design solution DWH
• 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 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.
• 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, Bridgewater, NJ

ETL Developer/MS SQL Server 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.
• Analyzed the current architecture to propose an ETL design solution DWH.
• Designed the Data Warehousing ETL procedures for extracting the data from all source systems to the target system.
• 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: MS SQL Server 2005, 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, MS Office 2000, Erwin.