SUMMARY

• 7 years of experience in database analysis, database design and development in SQL 2012/ 2008/2005/2000 in production and support environment.
• Experienced in implementing business logic using objects like tables, views, Cursors, stored procedures, roles, triggers and constraints using Data Definition Language (DDL) and Data Manipulation Language (DML) concepts.
• Expertise in BI applications reporting tool SQL Server reporting services (SSRS) and SQL Server integration services (SSIS)
• Experienced in designing complex reports including sub reports and formulas with complex logic using SQL Server Reporting Services (SSRS).
• Worked on activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SQL Server SSIS
• Strong knowledge of Relational Database Management Systems (RDBMS) concept in several databases like SQL Server 2008/2005/2000 and Oracle 10g/9i/8i.
• Experienced in data import/export, data migration between homogenous system using Data Transformation Service (DTS) Packages, Bulk Copy command (BCP) and Bulk Insert.
• Proficient in Designing and Documentation of SQL Server Strategies and plans.
• Conversant with all phases of Software Development Life Cycle involving Systems Analysis, Design, Development and Implementation using Water fall model and Agile methodology.
• Generated Crystal Reports, MS Data Reports using different Reporting tools.
• Strong experience in data transfer from Oracle 8i/8.0, Sybase 11.5/11.0 and MS Access to MS SQL Server 2000 using ETL tools like SSIS and MS DTS.
• Provided 24x7 support and trouble shoot production issues on high availability systems.
• Excellent team player and efficient in handling multiple project priorities with outstanding communication, presentation, interpersonal skills and good work ethics.

TECHNICAL SKILLS

• MS SQL Server 2000/ 2005/2008/2012
• SQL Server Integration Services(SSIS)/SQL Server Analysis Services(SSAS)/SQL Server Reporting Services(SSRS)
• Oracle 8i/9i/10g
• MS Access
• MS Share point
• Windows NT
• Windows XP/ 2003/2000/98
• UNIX
• ERwin 7.0
• MS VISIO
• MS SQL
• Profiler
• SQL Query Analyzer
• SQL
• PL/SQL
• C
• C++
• C#
• VB
• MS ACCESS
• MS Office 97/2003/2007
• Quality Center
• Load Runner
• Facets 4.51
• IBM DB2.

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

MS SSIS/SSRS/ SQL Server Developer

Responsibilities:

• Captured requirements from Business & Systems Analysts and business users, documenting them as detailed statements and requirements to be used for design and development of code.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Documented and updated bugs/defects along with workaround solutions using Quality Center.
• Optimized SQL queries for efficiency and the front end developer with their queries and procedures.
• Configured Server for sending automatic mails to the respective people when a job is failed or succeed.
• Included Report Design and Coding for Standard Tabular type reports, including Drill Down and Drill through Functionality and Graphical presentations such as Charts and Dashboard type metrics for effective analysis.
• Involved in Creating SSIS packages to integrate the data coming from various data sources.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.

Environment: MS SQL Server 2005/2008/2012, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), Windows XP, Microsoft Office 2010, Microsoft Outlook, Quality Center, AJACS.

Confidential, Basking Ridge, NJ

MS SQL Server Developer/BI/ETL Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation for the public data collected.
• Creating Error and Performance Reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Also used DTS packages for creating job on the SQL Server 2000.
• Creating and integrating User Defined Functions and Stored Procedures for reporting purpose.
• Developed Ad-Hoc reports, sub reports, drill down reports, parameterized reports and dirty reports.
• Using various SSIS tasks such as Conditional Split, Derived Column on the data retrieved, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.
• Designing and testing (Unit, Integration and Regression) packages to extract, transform and load data using (SSIS)
• Designing packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command and Derived Column.
• Moving the entire phase from the Staging to the Production.
• Fine tuning of database objects and server.
• Job Monitoring and making sure all jobs run successfully every night.
• Creating reports using the Crystal Reports and publishing them on the server.

Environment: MS SQL Server 2000/ 2005/2008/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Transformation Services (DTS), Windows XP, IBM DB2, Crystal Reports, XP2, Microsoft Office 2003, Microsoft Outlook.

Confidential, Sylmar, CA

MS SQL Server Developer/BI/ETL Developer

Responsibilities:

• Planned and Designed SSIS packages based on the business requirements.
• Participated in the full lifecycle of ETL software development - analysis, design, build, documentation and testing for the project.
• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using (SSIS)
• Used Data Flow task, Execute package task, Execute SQL Task, for each loop container in SSIS for transformation of data.
• Performed error handling using Script Task and event handlers.
• Used various SSIS tasks such as Conditional Split, Merge Join, Derived Column on the data retrieved, Data conversion, OLE DB Command, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, SSRS reports.
• Wrote complex T-SQL queries and Stored Procedures for generating reports.
• Created sub-reports, drill down reports, summary reports, parameterized reports and ad-hoc reports using SSRS.
• Worked on report like the Loan Comparison Report, Loan Portifolio Report, Syndicate Pledged Report, FHLB Pledged Report and Paidoff Report.

Environment: MS SQL Server 2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Profiler, Windows XP, Lotus Notes, Microsoft Word 2003, Visual Source Safe.

Confidential

MS SQL Server/BI/ETL Developer

Responsibilities:

• Helped in translating business requirements into technical design specifications and preparing high-level documentation for the Database Design and Database Objects.
• Provided and managed QA task estimations within a scrum/agile team.
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.
• Created SSIS packages to extract data from OLTP to OLAP systems and created alerts for successful and unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column on the data retrieved, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.
• Configured and Maintained Report Manager and Report Server for SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters depending upon the client requirements.
• Involved in Debugging and Deploying reports on the production server.

Environment: MS SQL Server 2005/2008, Business Intelligence Studio, SQL Server Reporting Services (SSRS), SQL Server Integration Services(SSIS), Data Transformation Services(DTS), TSQL, PL/SQL, SQL Profiler, Windows XP/ NT / 2000/2003, SQL Query Analyzer, SQL Profiler

Confidential

MS SQL Developer/BI/ETL Developer

Responsibilities:

• Participated in the full lifecycle of ETL software development - analysis, design, build, documentation and testing for the project.
• Experienced in agile software development process, using pair programming, unit testing, short iterations, and close customer relationship.
• Experienced in working with XML document structures and hierarchical data.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command and Derived Column.
• Incorporated the DTS Packages into MS SQL Server 2005 Integration Services by using Package Migration Wizard and Execute DTS 2000 Package Task.
• Worked as a developer in creating complex Stored Procedures, SSIS packages.
• Analyzed Reports and Fixed Bugs in stored procedures.

Environment: MS SQL Server 2005, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), Business Intelligence Studio, Data Transformation Services(DTS), SQL Profiler, Crystal Reports, Windows XP / NT / 2000/2003, Microsoft Access, ODBC, Oracle, Microsoft Visio, Erwin 6.5, MS Office 2003,Excel 2003,HIPAA, FACETS 4.51

Confidential

MS SQL Server Developer

Responsibilities:

• Identified and resolved the query performance using SQL Profiler and Index tuning wizard.
• Used Data Transformation Services (DTS) to populate data from various data sources.
• Research on upgrading the SQL Server from
• Worked on Migration of SQL Server 2000 instances to SQL Server 2005.
• Modified the existing stored procedures, views and triggers to meet the current design.
• Monitored of database size, disk space in all (Production, Model & Development) the environments.
• Created and monitored all maintenance jobs (backups, integrity, optimization, etc.) on all databases.
• Created, modified and monitored replication on all databases.
• Worked on upgrading DTS packages to SSIS packages.
• Attended team meetings regularly.

Environment: MS SQL Server 2000/2005, T-SQL, Data Transformation Services(DTS), Windows 2003, Server SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL profiler, Upgrade Advisor.