PROFESSIONAL SUMMARY

• Having over Ten years of experience in Analysis, Design, Implementation, deployment of complex Data Warehousing Business Intelligence products and solutions
• Strong experience in data research, analysis to build ETL solutions for Business Analytics
• Good knowledge on Data Analytics, Big Data, Hadoop, Yarn, Hive, Pig, HBase, Sqoop, NoSQL
• Experience in evaluating the technical feasibility and proposing the best suitable ETL and BI tools
• Thorough understanding of Kimball's Bus Architecture and Inmon's Information Factory theories
• Extensive experience in implementing Large Data Warehousing solutions using MS-SQL Server Integration Services, Data Stage server Data Stage Parallel Extender and Informatica
• Experience in working at On-shore and Off-Shore in onshore-offshore model.
• In-depth knowledge of T-SQL, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
• Experience in SQL Server Data Tools and SSIS Integration Service package design, constructing, and deployment
• Good knowledge on logical, physical, and dimensional data modeling, data mapping, and data normalization, well verse in ERWIN.
• Proficiency in creating different types of SSRS reports such as Matrix, Conditional, Drill-Down, Top N, Summary and Sub reports.
• Hands on experience on writing T-SQL Procedures, Functions, Views and Indexes.
• Good Expose on usage of different RDBMS like MS-SQL Server, IBM UDB, Oracle and MYSQL
• Proficient in Dimensional modeling star and snowflake schemas and Relational database management systems.
• Experienced in Developing, Deploying, Scheduling the ETL packages in the Production and UAT environments
• Performance Tuning Databases using Execution Plan, Query Tuning Advisor and ETL.
• Experience in package logging, error logging and event handling to redirect Errors rows and fix the errors in SSIS.
• Good Experience on creating ETL Jobs using Data Stage Server and Data Stage PX to implement the business scenarios like Validations, tedious reject processing and jobs that had to be aborted based on empty source.
• Knowledge on Informatica Mappings development and usage of different transformations to meet mapping logic.
• Knowledge on Power View, MS Excel Power Pivot, SSAS usage and development.
• Experience on leading, mentoring teams and strictly adhering to SDLC/PDLC/Agile processes.
• Ability to adapt to new skills and technologies and dedicated to maintaining high quality standards.
• Possess strong Analytical, Problem Solving skills and flexible to work with new environments.
• Excellent team Player with very good communication and interpersonal skills.

TECHNICAL SKILLS

• ETL Tools : MS-SQL Server Integration Services, Data Stage 7.5.1
• Database : MS-SQL Server, Oracle, DB2 MySQL
• Data Modeling Tools : MS-Visio, Erwin
• Predictive Analytics : Machine Learning, Statistical Modeling, Deep Learning
• Big Data : Hadoop, MR, Yarn, Hive, Pig, Sqoop, No-SQL
• BI Tools : MS-SSRS, Hyperion IR, SSAS, R, Tableau 8.2
• Operating Systems : Windows 2000/XP/7, Windows Server 2003/2008, Linux, UNIX
• Scheduling Tools : MS-SQL Agent, Control M, Data Stage Director
• Project/Process Management : MPP, MS-Visual Source Safe, Version One, Tortoise SVN, TFS
• Business Tools : MS Word, Excel, Power Point, Outlook
• Programming : SQL, PL/SQL, C, Java, R
• Internet Tools : IIS, FTP, TCP/IP, SFTP, WinSCP

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Lead

Confidential is the business intelligence solution for claims group to make better business decisions based on the claim trends. Also, enhance the usability, performance and limitations from the existing transactional reporting system. Accurate point-in-time claim activity and financial reporting needs without having to create custom history logic per report.

Responsibilities

• Participating in the discussions with stake holders to validate the business requirements, infrastructure and software requirements
• Analyzed the requirements and created Extraction Transformation and Loading strategies and defined source to target mapping rules.
• Created ETL project plan, periodic deliverables, ETL and DB object dependencies matrix
• Designed Extraction Transformation and Load process flow diagram using MS-Visio
• Created overall project load process flow, customized the auditing and logging and maintained the project artifacts in Share Point
• Worked with Business Analysts to understand, analyze the systems and priorities
• Closely worked with Data Modular to understand and resolve the business requirement deviations
• Discussed the possibilities and provided the suggestions to ease the reporting requirements
• Created on-going and history load SSIS packages for Dimensions and Fact tables using as Data Flow tasks, FTP, Merge, SCD, Script components etc.
• Implemented customized Claim Status logic using T-SQL and SSIS to populate the claim status
• Worked with reporting team to make them understand the data and the data model
• Created and presented the project status on daily/weekly/monthly to the management
• Involved in design of data model.
• Responsible for work distribution, worked closely with the team members and provided technical solutions to insuring high levels of quality and flexibility.
• Created audit summary describing statistics of load process, new records, error records, skipped records etc.
• Responsible for code review of the team members and delivering the scalable and quality code.
• Prepared unit test case template and scripts for each possible scenario documented the results.
• Produced development status reports and coordinating with the Project Manager in effective planning and scheduling of the deliverables.
• Prepared the design, deployment and release artifacts
• Worked closely with different teams in performing the system integration and testing.

Environment

SQL Server 2012, SSIS, COGNOS, Windows Server 2008, Windows 7, Share Point, Guide Wire, Trello Microsoft Excel

Confidential

ETL Lead

Confidential business intelligence IPad application. This solution provides an ability to analyze the trends using FACTs at various geographic levels across the Confidential- Data Operations is the one of the groups within the CoreLogic, this division acquires raw data from several sources and pumps the data into respective systems for analytical groups Products. Also, customer requests are fulfilled correspondingly on the respective systems.

Responsibilities

• Responsible for executing and delivering the projects parallel.
• Worked with the Business Analysis and/or Product Management staff to help refine their requirements and deliver results
• Worked with the Business Intelligence team members to design, develop, implement and manage data and data flow for business intelligence applications while insuring high levels of quality and flexibility.
• Defined the ETL flow used at a project level.
• Analyzing, understanding, creating, distributing, communicating and coordinating with on-shore and off-shore teams.
• Designed complex ETL strategies to pull data from different sources, like SQL server, flat files and load it to the destination database after using multiple transformations.
• Developed SSIS packages that populate data into the SQL Server 2012 tables.
• Created SSIS packages to send mail task on error and on completed and send email notification with error message as attachment.
• Scheduled/monitored SSIS ETL job using SQL server agent in Dev and Prod and responsible to troubleshoot if it fails.
• Generated Import Summary describing statistics of successful import, new records, error records, skipped records etc.
• Developed Detailed, Summary, Drill-down, Drill-through and Sub-reports for Billing using SSRS.
• Determining the optimal approaches for obtaining data from diverse source system platforms and moving it to the BI.
• Reviewing and involving customer live fulfillment requests execution and delivery.
• Establishing and enforcing Technical Quality standards for deliverables of the projects.
• Mentoring project ETL specialists on data acquisition techniques, decision rules and how to apply them

Environment SQL Server 2012, SSIS, SSRS, Windows 7, Team Forge, Version One

Confidential

ETL Lead

Confidential is a system for providing information for products data operations. Organization is moving away from Legacy Mainframe environment to Microsoft environment. The objective of this project to re-produce all the different extracts, services, product seeds and elements those are there in the Mainframe from Microsoft environment.

Responsibilities

• Responsible for leading the design, documentation and deployment of an enterprise data model and supporting component data stores
• Understanding, analyzing and reviewing Mainframe mapping sheets and updating with Diablo related mappings, tables and transformation logic.
• Created re-usable SSIS template to minimize the development effort
• Created re-usable utility to compare the data between the new legacy system to determine the 98 bench mark for all the fields using SSIS and T-SQL
• Analyzing source systems and creating T-SQL scripts to extract the data for the related mapping extracts to generate the fixed width flat files.
• Monitored data warehouse load procedures to ensured information to accurate.
• Review of Diablo SSIS extracts, naming standards and test cases.
• Data quality testing between the diablo extract and Mainframe extract, preparing the discrepancy list.
• Interacting with client for resolving issues occurred for extracts.
• Review of ETL Packages, Naming standards, Test cases.
• System Testing and Trouble shooting

Environment SQL Server 2008 R2, SSIS, SSRS, Windows 7, Teamforge, VersionOne

Confidential

Sr. ETL Developer

Confidential facilitates the necessary Data Integration process that would help the business to analyze and assess the performance of the products and services such as AVM, HistoryPro, and IdentityPro

Responsibilities

• Participating actively on Clients Calls, meetings with Project Manager, Senior Business Analyst, Senior System Analyst and QA lead to discuss and produce alternatives of problems and creating Technical design specifications
• Lead the team and trained the subordinates on the advanced techniques in SSIS.
• Creating and modified SSIS packages to load data from one server to another server as well as from one table to another table within the same server.
• Doing Data Extraction and Conversion using SSIS SQL Server Integration Services , through data flow tasks, Look up transformations and script tasks
• Extracted data from various sources like SQL Server 2005, DB2, MySQL, Oracle, CSV, Excel, XML and Text file from Client servers.
• Worked on the summary level SSRS dashboards with in-built drill down capabilities for slicing and dicing the data.
• Worked on creating Cross-Tab, Conditional, Drill-Down, Top N, Summary and Sub-reports using SSRS

Environment DB2, SQL Server 2005, SSIS, SSRS, Hyperion Interactive reporting, Windows 2003/XP, VersionOne

Confidential

Technical Lead

Confidential Customer Rules Monitoring is a framework that provides the ability to monitor customer activities and product's behavior by comparing current usage against historical trends and alerts. The primary objective being to ascertain the problem before customer knows them.

Responsibilities

• Involved in Requirements Analysis, Data Modeling and Implementation.
• Leading the offshore team and communicating with the client for the requirements clarifications.
• Interact with business users / other application groups for resolving issues arising out of data feeds/interfaces of their applications
• Implemented the Master Package Model for easier maintenance and better performance of SSIS Packages.
• Used Best Practice approach with SSIS, redesigned queries to improve their performance.
• Created Database Objects like Tables, Stored Procedures, Functions and Views using T-SQL.
• Involved in Performance Tuning of ETL packages, review of ETL Packages, Naming standards, Test cases, System Testing and Trouble shooting
• Involved on creating OLTP database for the use case to meet the business needs.

Environment DB2, SQL Server 2005, SSIS, Erwin, Windows 2003/XP, Team forge, Version One

Confidential

Sr.ETL Developer

Confidential is a fraud detection product. Multi-lien is an extremely profitable scam and very difficult to detect with the traditional methods. This scam takes the advantage of the lag between closing and recording to multiple loans on a single property.

Responsibilities

• Involved in Requirements Analysis, Data Modeling and Implementation.
• Responsible for Onsite and Offshore coordination
• Analyzing the requirements and creating Technical design specifications.
• Lead the team and trained the subordinates on the advanced techniques in SSIS.
• Developed logic for implementing new lender in to the program with minimal changes
• Implemented Metadata driven lender specific rules
• Automated the process end to end
• Data refresh in UI for each run to validate and confirm the identified Liens OR required additional information to determine the Liens for operational groups
• Performance Tuning of ETL packages
• Review of ETL Packages, Naming standards, Test case sand System Testing, Trouble shooting, and Scheduled Jobs to run the SSIS Packages on timely manner.

Environment SQL Server 2005, SSIS, SSRS SQL Server 2005 Reporting Services , Erwin, MySQL and Windows XP

Confidential

ETL Developer

Confidential acts as a consolidated repository of all CoreLogic Transactions. So BPDM accumulate data from all the necessary sources and data is organized in a way to help the users to perform Customer Analysis, Product Analysis, COGS Analysis, Operational Reporting, Revenue Analysis, Support Tax Related Reporting and Vendor Cost Analysis...

Responsibilities

• Create/Setting up Development Environment at Off-Shore like creating source database DB2 and SQL Server tables and loading test data into corresponding tables.
• Understanding Source Systems, Creating Design Specifications and Test Plan.
• Creating Tables, Views, Indexes and Stored Procedures
• Developing various Packages using SSIS ETL Tool as per business/technical scenarios like Extraction, Validations, tedious reject processing as well.
• Integrating SSIS ETL Process and Testing.
• Responsible for Review of Packages, test cases and naming standards as well bug fixing.
• Communicating client like status /issue resolutions/clarification on the business requirements

Environment SSIS, SSRS, DB2 7.5 and SQL Server 2000/2005

Confidential

ETL Developer

Confidential project is to build single confirmed dimensional database to enable users to query, analyze, and use the data from multiple disparate source systems in place with various end user tools such as Unica, Affinium Campaign and SAS.

Responsibilities

• Developing various Data Stage Parallel jobs by using Data Stage Designer as per business scenarios like Validations, tedious reject processing as well naming standards.
• Communicating client for issue resolutions/understanding the business requirements
• Responsible for Meta Data import/export and Parameterization and metadata lineage for the jobs as well bug fixing
• Writing Test cases, executing pasting results for the jobs.
• For the purpose of execution of test cases need to load test data into MS-Access

Environment Data Stage 7.5.1 PX, Oracle 10g, DB2 7.5 and SQL Server 2000

Confidential

ETL Developer

Confidential the world's best fashion brands to create sustained growth of shareholder value. It approximately 4000 stores throughout the continental United States with familiar brands Created low level design documents based on the requirements and high level design documents.

• Generating Source/Target Metadata for jobs as per the path provided in technical specification.
• Performing job backups using Data Stage Manager Importing Exporting
• Developing various Data Stage Parallel jobs by using Data Stage Designer as per FS/TS business scenarios like Validations, tedious reject processing and jobs that had to be aborted based on source empty ..
• Data Stage Director is using to view log for error handling
• Developing Data Stage Parallel Jobs by using various stages like Sequential file, Oracle, ABAP Extract stage for SAP R/3, IDOC Extract stage for SAP R/3, SAP BW Open Hub Extract Stage, Join, Transformer, Remove Duplicates, Pivot, Lookup
• Performed Unit Testing and Bug fixing

Environment IBM Data Stage 7.5.1 PX, Oracle 9i, SAP, DB2 and Teradata, Linux, Windows XP

Market Analysis

Software Engineer

launches and comparison of against competitors. Market Analysis utilizes the company's patented InfoXtract engine. InfoXtract engine extract information across different type of source like broadcasting, newspapers, magazines etc, into database in the predefined format.

Responsibilities:

• Involved in writing test cases and execution of test cases
• Responsible for Functionality and Regression Testing
• Responsible for analyzing the executed results and reporting results through bug reporting tool like Bugzilla
• Worked with database team on data extraction, transformation and load process

Environment J2ee, EJB, Servlets, JSP and Oracle, Manual Testing, Win Runner and Test Director

Trainee

Cruises with different considerations like price, different popular luxury cruise lines etc, for this considerations traveler can search crises in different ways using traveler site. Before doing these, traveler has member of Cruise Travel to reach destination.

Responsibilities

• Creating test cases and executing test cases with automated scripts for WinRunner
• Test scripts has maintained and executed through test director
• Responsible for conducting Functionality and Regression testing
• Prepared defect log report Defect reported using test director

Environment J2EE, Struts, Xml, Oracle, Manual Testing, WinRunner and Test Director