Summary:

• Around 8 years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite Development, UAT and Production Environment
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting
• Strong knowledge working with all phase of Software Development Life Cycle SDLC involving Systems Analysis, Design, Development and Implementation.
• Transformed data from one server to other servers using tools like Bulk Copy Program BCP , Data Transformation Services DTS and SQL Server Integration Services SSIS 2005/2008
• Expert in developing SSIS Packages to Extract, Transform and Load ETL /DTS data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase, Excel and MS Access.
• Strong experience working with BCP, DTS, SSIS packages, creating jobs and linked servers for MS SQL Server/Oracle/ Sybase databases.
• Expert in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services SSIS .
• SQL Server 2005 OLAP database development including KPIs, Data mining, working with changing dimensions.
• ETL implementation using SQL Server Integration Services SSIS .
• Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• Thorough understanding of Kimball's' theory, KPIs, SQL 2005 Architecture
• Created calculated measures and dimension members using Multi-Dimensional Expressions MDX .
• Excellent experience in implementing Key Performance Indicator KPI objects in SSAS and creating calculate members in MOLAP cube using MDX in SSAS.
• Strong experience in logical and physical database design and development using Erwin and SQL server enterprise manager.
• Expert in using Performance Tuning tools like MS SQL Profiler, Index Tuning wizard, SQL Server Database Engine Tuning Advisor.
• Extensive experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions.
• Strong experience in database installation, capacity planning, implementing backup and recovery strategy for application and database.
• Worked in collaborative team environment with other developers, business analysts, and a project management team.
• Exposure to CMMI, ISO and QA processes, change control management, source safe, version controlling etc.
• Excellent communication skills, analytical skills, understand business requirements in various domains.

Technical Skills:

• Hardware: HP/Compaq ML 380 Servers, Dell Power edge series
• Database: SQL Server 2000, 2005, Oracle 10i
• Operating Systems: HP UNIX, Windows XP/2000/2003/2007.
• Programming Languages: SQL, PL/SQL, C, C , java
• BI Suite: SSAS, ProClarity, SSRS, MOSS, PPS, Hyperion
• ETL TOOLS: DTS, SSIS, Informatica 7.1.3/6.2,ODI
• Database Tools: DBArtisan, SQL Litespeed.
• SCM Tools: Visual Source Safe, Star Team.

Professional Experience:

Confidential

Sr. ETL Developer/SQL BI Developer

Credit card is a growing division and is striking strategic business deals to drive additional expansion. To ensure the business is optimizing its current card portfolio and finding opportunities for profitable growth, a robust Credit Card and Loan Analytics platform is required to serve the enterprise needs of Underwriting, Marketing, Credit Risk Management and Fraud. The project would consolidate functions across reporting systems and provide the necessary platform to derive insight for profitable decision making.

Responsibilities:

• Designed and developed SSIS ETL packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Used various SSIS tasks such as Conditional Split, Derived Column etc, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and Reporting tools.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
• Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.
• Applied various Created Tabular reports, Cross Tabs, Drill down, Charts, Functions and Maps using SSRS.
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services SSRS in Business intelligence development studio BIDS .
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.

Environment: SQL Server 2000/2005/2008R2 Enterprise Edition, SSIS, T-SQL, SSRS, Windows Server 2003,Java

Confidential

Sr. ETL Developer/SSIS Developer

Responsibilities:

• Designed and developed SSIS ETL packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Used various SSIS tasks such as Conditional Split, Derived Column etc, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column in SSIS
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and Reporting tools.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
• Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.
• Applied various Created Tabular reports, Cross Tabs, Drill down, Charts, Functions and Maps using SSRS.
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services SSRS in Business intelligence development studio BIDS .
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.

Environment: SQL Server 2000/2005/2008 Enterprise Edition, SSIS, T-SQL, SSRS, Windows Server 2003

Confidential

Sr. ETL Developer/SSIS Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Updated functional specification and technical design documents and also created new design documents
• Helped in the design of the Architecture of the Data Warehouse and helped in performance tuning of the data base.
• Designed the Entity Relationship ER models and logical data LDM , physical data PDM models in Power Designer based upon the design documents.
• Modeling new fields/tables in Operational Data Store ODS as per new requirements.
• Extensively worked on full Software Development Life Cycle SDLC of the project from Database Design and Modeling to implementation and maintenance.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Designed SSIS Packages to transfer data from various sources like Text Files, SQL Server, and Excel to SQL Server using Business Intelligence Development Studio.
• Wrote T-SQL queries, Stored Procedures and used them to build packages.
• Designed, Developed and Deployed packages in SQL server environment using SSIS-2008.
• Designed, modified and troubleshoot SSIS packages.
• Used SSIS to load data from various sources into on SQL Server 2005 database and created packages.
• Involved in tuning and configuration of SSIS.
• Deployed SSIS packages from Development to Testing Servers
• Debugging of SSIS packages.
• Responsible for Import and export data from various data sources like SQL Server Databases, Flat Files, MS Access, MS Excel and other OLE DB providers achieved through Importing and Export Wizard in SSIS.
• Event handlers, which are workflows that runs in response to the events raised by a package, task or container in SSIS.
• Involved in utilizing SSIS Checkpoint, Loading Dimension with the SSIS slowly changing Dimension Wizard and used different SSIS Control Flows.
• Worked on Data Profiling in SSIS and applied Fuzzy Lookup.
• Loaded RAW Files into SQL Server using SSIS.
• Running and Scheduling SSIS Packages

.

Environment: Windows 2003/2000, XP, SQL Server 2005, SQL Server Integration Services 2005, SQL Server Analysis Services, T-SQL, SQL Query Analyzer, IIS 5.0 , Power Designer, Visual Studio 2005,T-SQL, Windows Server 2000

Confidential

ETL Developer/SSIS Developer

Responsibilities:

• Involved in Migration of SQL Server 2000 to SQL Server 2005.
• Installed and maintained 2-Node Active-Active Clustering as a High availability solution.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Analyzed the project environment and sub systems of the project, and prepared a high level documentation for application designing.
• Interact with the clients and gather the requirements and analyzed.
• Responsible for gathering business requirements, developing and reviewing of design documents
• Did trouble shooting of Client connections, viewing error log and applications.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Transferred data ETL to Data ware house Environment using SSIS.
• Used Data Partitioning, Snapshot Isolation in SQL Server 2005.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large VLDB and Complex Databases
• To analyze long running queries and tune the same to optimize application and system performance.
• Maintained the database consistency with DBCC at regular intervals.
• Involved in development activities included hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting.

Environment: MS SQL Server 2005/2000 Enterprise Edition, SSIS, SSRS and Windows Server 2003, MS Access.

Confidential

SQL Server/SSIS Developer

Responsibilities:

• Managed Enterprise and Distributed Data Warehouses in Developmental and Production Environments using SQL 2005.
• Build and maintain complex SQL queries using T SQL for data analysis, data mining and data manipulation. Organize analytical data ensure data quality and aggregate data for strategic reporting and performance optimization on database solutions.
• Created/designed reports using SQL Server Reporting Services according to user requirements.
• Responsible for writing SQL queries, Procedures, Functions and Database triggers.
• Good Experience in Tuning and Optimization of T- SQL stored procedures.
• Optimizing the current ETL process, identifying and eliminating bottle necks and decreasing data latency. Created synchronized mechanism for data management in SQL Server. Set the job dependencies of SQL jobs using MSDB objects.
• Standardized company reports by implementing SQL Server Reporting Services SSRS .
• Deployed and Scheduled the Reports in Report Manager.
• Extensively used the SSIS package to write the data from the flat files into tables.
• Extensively used Explain Plan, SQL Optimizers, Partitioning Tables and Gather Statistics to analyze and improve the performance of the Queries.
• Different database triggers were created and stored in the database and fired off when contents of database were changed.
• Created and Executed the Stored Procedures and Complex Queries for Reports.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Involved in Performance Repository Project, where we collect data and generate report to Proactively Monitor the Servers and try to avoid any kind of Server and database related outages.
• Develop documentation of database architecture, system processes and procedures. Create, review and produce migration scripts of database objects from development to production environments.

Environment/Tools: MS SQL Server 2005/2000, MS SQL SSRS, SSIS, SSAS, T-SQL, PL/SQL, Windows 2003 Server.

Confidential

ETL Developer/SSIS Developer

Responsibilities

• Managing of database objects like Tables, views, indexes etc.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Transformed data from various data sources using OLE DB connection by creating DTS packages.
• Scheduling Jobs and Alerting using SQL Server Agent if necessary.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Documented daily tasks operations.

Environment/Tools: Windows NT, Microsoft SQL Server 2000/2005, Microsoft Excel, SQL Query Analyzer, DTS Packages.