Professional Summary

• IT Professional with over 10 years of experience in all phases of SDLC out of which 8 years expertise experience in Data Warehousing, ETL, Analytic Statistics and Business Intelligence projects using Microsoft BI Stack SSIS, SSRS, SSAS with Oracle, DB2, SQL Server, MySQL RDBMS.
• Business knowledge in Finance, Banking, Retail and Distribution domains.
• Database expertise including SQL, ETL, Reporting, Database Modeling, and Tuning.
• Data Warehousing experience on Data Modeling using Star schema and Snowflake schema with Facts, Measures and Slowly Changing Dimensions SCD Type1, Type2, and Type3.
• Specialty expertise with Talend most used components tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, tRowGenerator, tSetGlobalVar, tHashInput, tHashOutput, tJava, tJavaFlex and many more
• Specialty expertise with SSIS most used components Data Flow task, Merge Join, Conditional Split, Copy Column, Multicast, OLEDB Command, Script component, and many more
• Involved in Customization Implementation of Paradox, DB2, SQL Server and MySQL Applications.
• Specialty expertise converting SAS code into T-SQL algorithms intended to run on SQL Server 2008 and 2012
• Specialty expertise in software development using Object orient languages, with C/C , java C .
• Web interface development expertise with C and ASP.Net, and PHP
• Developed Test Plans, Test Scenarios and Test Cases based on Business Requirements and Technical Documents for Data Warehousing and ETL.
• Development of Banks and Insurance corporation solutions on stock options market and administrative applications running under Windows and OS2/PM.
• Twain drivers and interface running under Windows systems using C .
• Excellent communication, interpersonal and Team Lead skills.
• Highly motivated team player with excellent analytical, problem solving, interpersonal and communication skills, commitment, result oriented and zeal to learn new technologies and undertake challenging tasks.

Technical Skills

• ETL Tools: Talend Integration Suite 3.2, SQL Server Integration Services SSIS
• Data Modeling Tools: ERWIN, ER/Studio, MSBI
• Reporting Tools: SQL Server Reporting Services SSRS , Crystal Reports 8.5
• Data Mining: SQL Server Analysis Services SSAS
• Languages Technologies:
• C/C , ASP .NET, C , PHP, VB, XML, HTML, JavaScript, COBOL, BAL, T-SQL, SAS
• Versioning Tools: Sub-Version, Microsoft SourceSafe
• RDBMS: MS SQL Server, MS Access, ORACLE, Paradox, DB2, MySQL
• Operating System: Windows 2003/XP/2000/NT4/98/95, HP UNIX, IBM OS/2 PM

Professional Experience

Environment: Properties mortgage data management.

Project Description:

Data warehouse and BI Reporting project to analyze and manage mortgage related Data. Intranet tool development to produce data entry. Test engineering on all project phases.

Role: Datawarehouse Analyst.

Responsibility:

• Analyzed High level System requirement Specifications, Business Requirements Documents and the data model, checking for system integrity and reliability of an application.
• Design and create Logical and Physical data Models using ER/Studio.
• Identified functionality and performance issues, including: deadlock conditions, database connectivity problems, and system crashes under load.
• Deployed physical objects including tables, views, stored procedures, and Indexes to SQL Server 2008.
• Architecture design of Extract, Transform, Load ETL environment, also Design and Implement ETL for data load from Source to target databases and for Fact and Slowly Changing Dimensions SCD-Type1 and SCD-Type2.
• Designed ETL Jobs/Packages using SQL Server Integration Services SSIS.
• Designed ETL Jobs/Packages Talend Studio..
• Performed requirement gathering, Data Analysis using Data Profiling scripts, Data Quality DQ scripts, and unit testing of ETL jobs.
• Designed ETL jobs for Data-Mart history and Change data capture load.
• Created and managed Source to Target mapping documents for all Facts and Dimension tables
• Create Reports using SQL Server Reporting Services SSRS sourcing from Staging and Data-Marts.
• Converting SAS code into T-SQL algorithms.
• Monitored the server performance under severe load.
• Performed the unit testing of Back end testing by using T-SQL for data integrity.
• Developed reports and also create Data Model for users to generate ad-hoc reports
• Perform DBA activities like Backup Restore, routine check of server logs.
• Interacted with developers other team members to discuss about database design and ETL architecture and improvements.
• Develop a data entry tool running on intranet to feed databases, using ASP .NET and C .

Skills Used: MS SQL Server 2005/2008, SAS, T-SQL, SSIS, SSRS, ASP.NET, C , Talend

Confidential

Environment: Customer Loyalty management Application

Project Description:

Data warehouse and BI Reporting project to manage Customer Loyalty, Reward and Gift Card Marketing. Goals of the project are managing and track marketing campaigns, promotions and Gift card emissions for customer loyalty.

Role: Lead Datawarehouse Analyst

Responsibility:

• Conducted JAD sessions for Requirements gathering with Client and Application team.
• Analyzed High level System requirement Specifications, Business Requirements Documents and the data model, checking for system integrity and reliability of an application.
• Design and create Logical and Physical data Models using ER/Studio.
• Identified functionality and performance issues, including: deadlock conditions, database connectivity problems, and system crashes under load.
• Deployed physical objects including tables, views, stored procedures, and Indexes to SQL Server 2008.
• Architecture design of Extract, Transform, Load ETL environment, also Design and Implement ETL for data load from Source to target databases and for Fact and Slowly Changing Dimensions SCD-Type1 and SCD-Type2.
• Designed ETL Jobs/Packages using Talend Integration Suite TIS and SQL Server Integration Services SSIS.
• Performed requirement gathering, Data Analysis using Data Profiling scripts, Data Quality DQ scripts, and unit testing of ETL jobs.
• Designed ETL jobs for Data-Mart history and Change data capture load.
• Created and managed Source to Target mapping documents for all Facts and Dimension tables
• Create Reports using SQL Server Reporting Services SSRS sourcing from Staging and Data-Marts.
• Monitored the server performance under severe load.
• Performed the unit testing of Back end testing by using T-SQL for data integrity.
• Developed reports and also create Data Model for users to generate ad-hoc reports
• Perform DBA activities like Backup Restore, routine check of server logs.
• Interacted with developers other team members to discuss about database design and ETL architecture and improvements.
• Participate in Project related meetings with Clients/Development Teams.

Skills Used: Talend Integration Suite 3.2, MS SQL Server 2005/2008, DB2 9, ER/Studio 7.6/Architect, T-SQL, SSIS, SSRS

Responsible for MT/MT2 Manifest Too currently shipped with MS SDK System. Responsible for pulling all needed information about the tool in order to write and document implementation procedure. Create data and develop logic to implement full automation testing. Planned, developed and implemented unit tests.

Role: Software Engineer in SDET2

Responsibility:

• Member of the CCP Core Components Platform team responsible for the new Windows 7 OS delivery phase. Advanced Servicing Installers, Critical Installers, upgrades.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Involved in performance tuning using indexing Cluster Index, Non Cluster index tables.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Created T-SQL procedures to generate DDL scripts that modified database objects based on business requirements.
• Created many SSIS jobs for data exchange from and to SQL Server and various other systems including RDBMS, XML, CSV, and Flat file structures.
• DDL Scripts for generating Tables, Views, Functions.
• Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database.
• Scheduling Jobs, Backups and Restore database
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Extensively used T-SQL to create triggers and stored procedures used by the enhancements modules to update the SQL Server database.
• Performance tuning, query optimization and execution plan of queries for better performance.
• SSRS installation and report server configuration.
• Configured IIS and Deployed Reports and Analysis Project in to server.
• Used Application Studio to raise bugs/tickets according to build/version failures and as bug-tracking tool to centralize bugs and monitoring defect status
• Worked closely with developers on hot fixes, before and after testing new enhancements and bug fixes.
• Schedule and monitor massive performance and integrity tests on different platforms and OSs using TPET.

Confidential

Skills Used: C/C , Borland C , T-SQL,PL-SQL, Oracle 8i, SQL Server 2005/2000 WinRunner

Project Description:

MMW Markdata Media Workstation and PPM Personal People Metter are systems to perform statistical analysis on media TV, Radio, Newspapers, Magazines, Outdoors and more broadcasting audiences. The package includes also tools to perform Advertising investment analysis, Campaign planning and management, Production tools.

Role: Software Engineer / Technical Lead

Responsibility:

• Creation, management, training and leading the Software team.
• Defining, planning, developing, and setting up the IT framework.
• Analyzed High level System requirement Specifications, Business Requirements Documents and the data model, checking for system integrity and reliability of an application.
• Performing Database Administrator DBA jobs like creation and design of Tables, creating Stored Procedures using T-SQL, DTS Packages for SQL Server 2000.
• Design and Implement ETL SSIS tasks for data load from Source to Target database for Fact and Dimensions table in Data-Mart.
• Design and develop data reports using SSRS and Report Builder.
• Performed Functional, Integration, Usability, Regression testing during different stages of the application development manually as well as Automated using WinRunner.
• Participate in Project related meetings with Clients/Development Teams.
• Identified business rules for data migration and Perform data administration through data models and metadata.
• Design, create and maintain cube analysis using MS Business Intelligence studio.
• Data Modeling with the ERWIN Modeler tool in Data Modeling for OLAP and OLTP systems. Experienced in Full Life Cycle and Methodology for implementing Data warehouse and Business Intelligence Reporting System, Data Modeling with Erwin.
• Using ERWIN created logical and physical models, performed Reverse engineer, Forward engineer, and complete compare.
• Hands on experience in Star and Snowflake schema design and De-normalization techniques
• Created Executed the Test cases according to the Test plan.
• Performed stress, and performance tests for system using WinRunner and in-house developed analysis loader.
• Developed scripts in WinRunner based on the given specifications.
• Developed C/C DLL loaded by WinRunner in order to produce and support specific analysis tests.
• Created, Executed and Load Tested Scenarios with different Load Options in Controller and analyzed the results using reports, graphs and suggested the recommendations to the management team.
• Involved in monitoring test execution and system resource monitoring of different host machines.
• Monitored the server performance under severe load.
• Conducted System and Functional, User-Acceptance Testing UAT .
• Identified functionality and performance issues, including: deadlock conditions, database connectivity problems, and system crashes under load.
• Provided management with analysis reports and recommendations.
• Successfully identified bottleneck, Calculation and functionality issues with the application under heavy load.
• Successfully lead and mentored a team of four.
• Interfaced between testing team and developing team.
• Interacted with developers other team members to discuss about the defects and improvements.

Confidential

Environment: C/C , Borland C , SQL

Project Description:

MMW Markdata Media Workstation and PPM Personal People Metter are systems to perform statistical analysis on media TV, Radio, Newspapers, Magazines, Outdoors and more broadcasting audiences. The package includes also tools to perform Advertising investment analysis, Campaign planning and management, Production tools.

Role: Senior C/C Developer

Responsibility:

• Actively participated in development and design of MMW Markdata Media Workstation , a world leader integrated information system for audience and advertising analysis using Boroland C MS Visual studio and SQL. Defining, planning, developing, and setting up the Test framework.
• Member of the development team of Arbitron's PPM portable People Meter , a radio broadcasting statistical system using Visual Studio, MF and SQL
• Design and development of statistical chart library with Visual C , MFC and Olectra chart library as well as Borland C and OWL.
• Data retrieving development using SQL.
• GUI development using MFC and third party libraries Objective Grid .