Professional Summary

• Over 8 years of experience in the field of Information Technology with proficiency in ETL design/development and Data Warehouse Implementation/development forBanking, Finance, easHealth Care, Pharmaceutical, Telecommunications, B2B and Sales POS business sectors.
• Experience in BI Architecting, Design and development for various Data ware housing projects usingInformatica 9.1.0/8.5/8.6/7.1, SSIS, SSRS, Oracle, DB2,MS SQL Server 2005 Sybase, and Teradata.
• Developed complex Stored Procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Good hands-on working experience with using all kinds of SQL Server Constraints Primary Keys, Foreign Keys, Defaults, Checks, and Unique , Writing Transact SQL T-SQL Queries, Dynamic-queries.
• Efficient in creating SSIS Packages. Created packages to extract data from flat files, Teradata, Oracle and DB2 and transform the data according to the business requirements and load the data in SQL server tables.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load ETL solutions for data warehousing using SQL Server Integration Service SSIS and Informatica.
• Experienced in performing Incremental Loads and Data cleaning in SSIS. Expert in handling errors, logging using Event Handlers using SSIS.
• Experienced in ETL Extracting, Transforming and Loading development using DTS and SSIS for migration of data between legacy systems, ERP to SQL Server 2000/2005/2008.
• Highly skilled in creating dynamic and customized packages for ETL from various data sources using SSIS.
• Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources Excel, CSV, Oracle, flat file, Text Format Data by using multiple transformations provided by SSIS such as Data Conversion, ConditionalSplit, Bulk Insert, merge and union all.
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, ErrorHandlers etc.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Created various SSRS Reports involving variety of features like Reports,Charts,Filters,Sub-Reports,DrillDown,Drill-Through,Multi-valued parameters etc.
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups, Aggregators, and Re-usable transformations
• In-depth knowledge and understanding of dimensional modeling Star schema and Snowflake schema, SCD types- 1, 2, 3 , and data modeling star schema at logical and physical level.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Excellent problem solving skills with strong technical background and good inter-personal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure

Technical skills

Project Information

Confidential

SQL BI Developer

Description

The aim of the Project is to help the CE Department in their underwriting process from application through policy delivery, security, and controls, document retention which primarily includes loading and routing the submissions.

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design docs for development.
• Deployed the SSIS Packages and created jobs for efficient running of the packages.
• Expertise in creating ETL packages using SSIS to extract data from heterogeneous database and then transform and load into the database.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Creation of useful indexes.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Developed, monitored and deployed SSIS packages.
• Expertise in Deploying SSIS Package to Production and used different types of Package configurations to export various package properties to make package environmentindependent.
• Experience with SQL Server Reporting Services SSRS to author, manage, and deliver both paper-based and interactive Web-based reports.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Created different types of Tabular reports like Cascaded Parameters, Drill through, Drilldown, sub-reports and Matrix reports and developed some graphical reports using Report Designer.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default queried and non-queried parameters .
• Wrote complex SQL Queries using multiplejoins for creating Adhoc reports using Report builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.

Environment

SQL Server 2008/2012 Enterprise Edition, SSRS, SSIS, T-SQL, Visual SourceSafe, Visual Studio 2010

Confidential

Sr. ETL Developer

Description

This project was to implement an Enterprise data warehouse EDW by means of integrating data from different feeder systems situated across various locations into a central repository of business information. The EDW provides quick access to data to enable a more informative decision making process.

Responsibilities

• Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment.
• Working with the Business Analysts and the QA team for validation and verification of the development
• Involved in designing relational models for ODS and datamart.
• Data Quality Analysis to determine cleansing requirements.
• Responsible for developing, support and maintenance for the ETL Extract, Transform and Load processes using Informatica power center.
• Extract data from flat files, Oracle,Sybase,DB2, and SQL Server 2008 MS SQL Server 2005/2008 and to load the data into the target database.
• Extensively used Informatica to load data from fixed width and delimited Flat files.
• Worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor, alsoimported and created Source Definitions using Source Analyzer and Target Definitions using Warehouse Designer.
• Developed complex mappings using corresponding Source, Targets and Transformations like update strategy, lookup, stored procedure, SQL, sequence generator, joiner, aggregate, Java and expression transformations in extracting data in compliance with the business logic.
• Created SSIS Packages to migrate slowly changing dimensions
• Extensively used Informatica Power center and created mappings using transformations to flag the record using update strategy for populating the desired slowly changing dimension tables.
• Implementation experience of CDC Change Data Capture using stored procedures, triggers and using informatica power exchange.
• Querying and analyzing multiple databases and handling the errors as per the client specifications.
• Created server optimized database routing and mappings and focused on performance tuning.
• Handling larger database queries and applying transformations to make the business solution applicable to project.
• Involved in Performance tuning.
• Created Transformations andMappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Designed dynamic SSIS packages to transfer data crossing different platforms, validate data and data clearing during transferring, and archived data files for different DBMS.
• Extensively used Informatica for loading the historical data from various tables for different departments.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Wrote stored procedures in PL/SQL and UNIX Shell Scripts for automated execution of jobs
• Identified the errors by analyzing the session logs.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed Debugged the mapping of the failed session to check the progress of data load.
• Involved in Unit and System Testing of ETL Code Mappings and Workflows
• Implemented best practices suggested by Informatica to simplify deployment Process.
• Created Test scripts and executed in the Test Director.
• Worked with PMCMD to interact with Informatica Server from command mode and execute the shell scripts.
• Wrote documentation to describe program development, logic, coding, testing, changes and corrections.

Environment

Informatica Power Center 8.6 Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, Repository Server Administration Console , Erwin, SQL, PL/SQL, Sybase, SSIS, MS SQL Server 2005/2008,Java,Oracle 11g, UDB, DB2, Flat Files, Solaris 10

Confidential

SQL/ETL/SSIS/SSRS Developer

Description

PennDOT is responsible for motor vehicle titles and registration along with issuing driver licenses. Through a system of decentralized, privatized providers, driver services are available at over 1700 sites statewide.PennDOT is responsible for constructing and maintaining a system of roads at the sole expense of the state.Responsible for understanding and documenting current processes, identifying process improvements, documenting business requirements and ensuring that those requirements are translated in the delivery of effective business solutions.

Responsibilities

• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Thorough analysis and testing of database objects T-SQL statements before deployment to the production server.
• Collaborated in dramatically increasing OLTP transactions on systems handling several billion transactions weekly through the implementation of advanced database techniques such as join optimization, table structure and fragmentation analysis, bulk inserts, analysis of indexes and locks, creation of custom timers to detect bottlenecks.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Involved in the data analysis and database modeling of both OLTP and OLAP environment.
• Project involved maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Created various complex reports and manage those using SQL Server Reporting Services SSRS 2008/2005 according to ERLC.
• Generated Custom ETL scripts using SSIS 2005 and unit test SSIS load processes for performance check.
• Involved in migration and Conversion of Reports from SSRS 2005 to 2008.
• Created Tabular reports, Matrix reports, List Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate the special reports according to client's need.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.

Environment

SQL Server 2005/2008/2012 Enterprise Edition, .Net 3.5,SQL BI Suite SSAS, SSIS, SSRS ,OLTP, OLAP, Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 Windows Server 2003, Oracle, Crystal Reports, Cogon's, Business Objects ,SharePoint, MOSS 2007,

Confidential

SQL/ETL/SSIS/SSRS Developer

Description

IMS Health is a leading provider of information, services and technology for the healthcare industry around the world. This assignment will cover coding and test of new application, planning and executing of multiple projects such as EDW, Rebate settlement, Coverage Gap, Rebate Ready, I-Output files and Informatics conversion projects.

Responsibilities

• Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.

Created and configured an OLTP replication database for disaster recovery purpose.

• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Tasketc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house.
• Extracted data from XML to SQL server.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications. Provided knowledge transfer to the company's SQL programmers.
• Created several materialized views and UDF's to be accessed by the new front end applications.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Successfully tested all task in staging and stored all versions of data using team foundation server TFS .

Environment

SQL server 2008/2005. BIDS 2005, Reporting services 2005, Integration Services 2005, Analysis Services 2005, Windows Server 2003, HealthCare database, Oracle 9i, DB2,TFS,

Confidential

ETL/SSIS Developer

Description

The project was Campaign Reporting Infrastructure CRI part of Retail data group and was interacting with different systems in WAMU. Major objective of this project was to load txt files into SQL Server's tables all txt files are located at FTP sites in a zip folder.

Responsibilities

• Modification of database object such as addition of triggers, modification of table, stored procedure to meet new customer's requirements.
• Database performance tuning, monitoring, scalability and Testing. This includes optimization of slow running stored procedures, deployment of locking mechanism to increase concurrency.
• Created DTS SSIS packages to get data from various sources mainframe, Informix, Oracle .
• Administer, maintain, develop and implement policies and procedures for ensuring the security and integrity of the department database.
• Performed Weekly Application Builds, including some troubleshooting and debugging of Multi-tier financial applications.
• Automation of monitoring all the failed jobs in the database using DTS SSIS and SQL mail.
• Prepared patch and upgrade scripts for service packs and new releases
• Index optimization, Performance, Disk management, Disk partitions and optimizing.
• Worked on locking strategy which is used for various batch Programming structures Transactions.
• Memory management, data storage, user connections and load balance.
• Prepare and set up environment for disaster recovery.
• Transformation of data from one server to other servers using tools like bulk copy program BCP , data transformation services, data conversions from legacy systems to SQL server.

Environment

SQL Server 2005, Enterprise Manager, SQL Profiler, Data Model, T-SQL, SQL Query Analyzer, Replication, Backup/ Recovery, DTS/SSIS, Windows 2000/Advanced server.

Confidential

SQL Server Developer

Description

This application is used to supply data to different customers. Depending upon the requirements of customers, data is supplied in appropriate formats. All the data related to customers, in their respective data formats and the schedule details are stored in database. This application will generate tab delimited text files from database, in the required format and these text files will be uploaded to the customers through FTP. These applications have greater flexibility in the sense that there is no need to change the code for each and every new customer. Whenever a customer requires new data / new customer is added, then all the details about the data requirement and schedule details are added to the database using VB application. BCP, Bulk insert, Snapshot Replication and DTS package technologies are extensively used throughout the application. This project eliminated the human Intervention to greater extent and reduced the Database Maintenance work.

Responsibilities

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000
• Actively participated in gathering of Requirement and System Specification.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
• Worked on complex T-SQL statements, and implemented various codes and functions.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Wrote Transact SQL utilities to generate table insert and update statements
• Developed and optimized database structures, stored procedures, DDL triggers and user-defined functions.
• Implemented new T-SQL features added in SQL Server 2005 that are Error handling through TRY-CATCH statement, Common Table Expression CTE
• Created Stored Procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Environment

SQL Server 2005/2000, C .NET, ASP, .NET, Windows 2003.