adbklw@r.postjobfree.com +1-210-***-****

Overview: Proven experience as a Data Stage Lead/Developer/Data Analyst and my experience encompasses creating Requirement Doc/Specification document, Architecture Diagram, ER Diagram, Source to Target Mapping, Test Plans, Training Assets, User Guide, Root Cause Analysis on Data/Defect and Reports. Developed ETL jobs to load data from DB2 databases, Flat files, CSV files to target and has strong experience with high volume databases. Have Hands-on experience in working and reviewing with Relational Database Modeling and Dimensional Modeling and worked on Erwin 4.0/3.5.2.

CORE COMPETENCIES:

5+ Years of IT experience in playing lead/developer roles with ETL Tools and Concepts using Oracle, DB2, SQL Server, Teradata, Netezza and Systems using IBM Information Server Datastage (Datastage Designer, Director, Administrator), SQL & UNIX Shell Scripting.

Over 2+ Years of Experience in Conducting Trainings on Datastage and Datawarehousing concepts.

Experience in Projects including Production Support, Development in various domains and played various roles like Sr. ETL Lead/Developer and Business Analyst.

Played Key role in Focusing on Customer Needs, Identifying Stakeholders, Requirements Gathering, creating functional and detail design documentation along with Business/SME and Decomposed Business Requirements to Functional Requirements and leveraged the design to the Technical team for Development and driven until Implementation.

Performed the Technical Lead by interacting with business SME and Development team.

Involved in all phases like Requirement Gathering, Design, Develop, Test, UAT and Implementation in Software Development Life Cycle (SDLC) and Project Methodologies as well as tools and techniques within each phase.

Good Knowledge on Agile Methodology Life Cycle.

Good understanding of practicing requirements engineering according to several software development life cycles in a team environment.

Worked with the project/ product /manager/ project sponsor to document the product’s vision and the project’s scope.

Experience encompasses creating Requirement Doc/Spec, Architecture Diagram, ER Diagram, Source to Target Mapping, Test Plans, Training Assets, User Guide, Root Cause Analysis on Data/Defect and Reports.

Hands-on experience in working and reviewing with Relational Database Modeling and Dimensional Modeling

Excellent Interpersonal Skills with Problem Solving, Multitasking, Prioritizing, Analytical Thinking, Continuous Learning and ability to work independently as well as in a team and in a tight deadline.

Strong communication skills (oral and written) along with good organizational skills and Possessing good attitude

Proven track record of meeting project deadlines and goals

Involved in preparation of Requirement Traceability Matrix (RTM), Defect Prevention and Weekly Status Reports.

Strong Knowledge in dimensional Star Schema/Snowflakes Schema methodologies to develop data marts.

Excellent knowledge in extracting data from heterogeneous source and loaded to target system. Also Hands-on in Data quality assessment (DQA) methodology like Missing data, default values, Spelling errors, Special characters, data in wrong fields and (Different or inconsistent standards) in structure, format and values.

Excellent knowledge in IBM WebSphere Information Analyzer 8.x function dependencies like Column Analysis, Primary Key Analysis, Foreign Key Analysis, cross domain Analysis and Baseline Analysis.

Have Taken Trainings on ETL Concepts, Datastage, SQL.

Good Experience in Insurance, Healthcare and Retail domain.

TECHNICAL SKILLS:

ETL Tools IBM Data stage 8.1/8.5 (Parallel), SSIS, FastTrack

Databases Oracle 11g/10g/9i, SQL Server 2008,Teradata, DB2,Netezza, MS Access

Database Tools TOAD, SQL Plus, SQL Developer

Languages SQL, Transact SQL (T-SQL), PL/SQL, UNIX Shell Scripts, Perl, C, C++, HTML, XML, Python

Data Modeling SQL Server Management Studio 2008, Erwin 4.0/3.5.2, MS Visio

Data Profiling IBM Information Analyzer, Informatica Data Quality (IDQ)

Load Utilities SQL Loader

Scheduling Tools UC4, Unicenter, Control-M, Autosys

BI Reporting Tools BISSRS, Tableau

Operating Systems UNIX, Linux, Windows 9x/2000/NT/XP, 2003/2008 Windows Server

EDUCATION:

B.Tech. (Information Technology)

PROFESSIONAL EXPERIENCE:

Nationwide Insurance Aug 2017 to Jan 2018

ERPA Group Inc., Columbus, OH

Lead ETL Data Analyst/Developer

Responsibilities:

Involved in requirements gathering, preparing design/spec and related documents, creating data models and data analysis.

Gathered Requirements for complex system from Business by setting up the meetings, communication to the technical team and handled through all stages of project. Represented the team as single point of contact by providing status frequently.

Involved in analyzing and resolving complex data, data governance, data profiling and analytic issues.

Involved in creating Technical Specification Documents and Data Requirement Documents.

Make sure that the PDM matches NW standard guidelines.

Query data repositories to determine level of data quality and completeness.

Adhere data models as per enterprise standards and appropriate as per business requirements.

Prepare data lineage documents.

Developed SQL Scripts for extractions of the data from DB.

Worked with Winscp, Unix in handling various datastage jobs and scripts.

Analyze the source data to determine natural keys and parent-child relationship.

Created source to target data mapping documents (STM) based on business requirements for ETL solution.

Identified data risks and opportunities by participating in reviews, evaluations, and analysis.

Determined the cause of risk and suggested approaches to improve results.

Good exposure to agile methodology.

Performed data analysis to identify data quality using Informatica Data Quality (IDQ).

Perform Data Governance and Data Profiling using IBM Information analyzer.

Provided status everyday in stand up meetings.

Build Dashboards using Tableau.

Environment: IBM Infosphere Information Analyzer, Informatica Data Quality, SQL Server, Teradata, Oracle, MS Access Database, Putty, UNIX Shell Scripting, UC4, Windows XP Prof, Microsoft Office (Excel, Word, Visio and PowerPoint), Tableau

Bhrigus Inc., - Princeton, NJ Jan 2017 to Jun 2017

Sr Datastage Lead/ Developer

Responsibilities:

Involved in Requirements Gathering, Preparing Design/Spec and related documents, development, testing.

Involved in Data Modeling, Source to Target Mapping and Prepared Root Cause Analysis Document.

Developed ETL jobs to load data from DB2 databases, Flat files, CSV files to Target and experience with high volume databases.

Provide planning, estimation, scheduling, prioritization and coordination of technical activities related to system development

Identify opportunities for system reuse and system simplification

Developed many SQLs, Training Materials.

Created DS Jobs for the business process to pull the file from Unix system.

File handling with Windows and Unix.

Created, Modified, applied permissions to the files in unix.

Maintain and manage file transfers between the systems

Provided Status Every Biweekly.

Trained Resources on ETL Datastage and Informatica.

Environment: IBM Information server 8.1, SQL Server, Teradata, Oracle, DB2, PL/SQL, UNIX Shell Scripting, Windows XP Prof, Microsoft Visio, Microsoft Office (Excel, Word and PowerPoint

The Nielsen Company (AC Nielsen) Feb 2013 to Oct 2014

Tata Consultancy Services, Chennai, India

Sr. Datastage Developer/Team Lead

Responsibilities:

Involved in Requirements Gathering, Preparing Design/Spec and related documents, development, testing and production Implementation.

Involved in Data Modeling, Source to Target Mapping and Prepared Root Cause Analysis Document.

Collaborate with IT partners to devise capacity plan and ensure appropriate infrastructure for the end to end system delivery

Provide planning, estimation, scheduling, prioritization and coordination of technical activities related to system development

Prepared High Level, Detailed Level Design Documents and Requirement Traceability Matrix.

Assisted business partners in applying data to evaluate and tackle business problems

Organized Business Meeting with Customers along with SMEs and provided weekly status report.

Involved in facilitating User Acceptance Testing and Test Plans.

Designing ETL jobs incorporating complex transform methodologies using Data Stage tool resulting in development of efficient interfaces between source and target systems.

Developed ETL jobs to load data from DB2 databases, Flat files, CSV files to Target and experience with high volume databases.

Worked on Various Parallel/Sequence Job Stages like Lookup, Dataset, Remove Duplicate, Sort, Transformer, Join, Modify, Funnel, Job Activity, Terminator etc.

Worked with stages like Complex Flat File, Transformer, Aggregator, Sort, Join, Lookup, etc.

Coordinated with client managers, business architects and data architects for various sign offs on data models, ETL design docs, testing docs, migrations and end user review specs.

Experience in generating and interpreting mapping documentation and translating into detailed design specifications using ETL code.

Communicate Expectations, Roles and Responsibilities to team members and hold them accountable to meet the expectations

Worked in UNIX for handling DS jobs, File Transfer, File Manipulation.

Develop team members by providing coaching, code review, and process guidance

Performed the Unit testing and Resolved the QA and UAT issues for Data Stage jobs

Data stage 8.5 was used to transform a variety of financial transaction files from different product platforms into standardized data.

Environment: IBM Information server 8.5, SQL Server, Oracle, Netezza, Putty, UNIX Shell Scripting, Perl Scripting, TIBCO, PL/SQL, Windows XP Prof, Microsoft Visio, Microsoft Office (Excel, Word and PowerPoint)

Cardinal Health Mar 2011 to Feb 2013

Virtusa Polaris, Chennai, India

Datastage Developer/Team Lead

Responsibilities:

End-to-End implementation, maintenance, optimizations and enhancement of the application.

This involves various phases in the project, starting from project estimation, Requirement Gathering and Analysis, Designing, Coding, User Acceptance Testing to deployment in production, including post implementation support.

Prepared High Level, Detailed Level Design Documents and Requirement Traceability Matrix.

Involved in End to End process in meeting SDLC Process.

Lead the team of 5 members by solving technical issues, guiding, mentoring and coordinating with business.

Analyzed and Researched in detail with data and reports. Prepared Root Cause Analysis Document

Conducted Business, Team Meetings and Status Calls.

Worked with Subject matter experts for Data Requirement Documents (DRD) and created a data dictionary to map the business requirements to attributes to design logical data model implementing star schema.

Involved in Data Modeling and Developed many jobs

Extensively worked with Datastage Shared Containers for Re-using the Business functionality.

Extracted data from DB source using connector, and performed transformations using XML Transformer (Mapping) and generated XML output file.

Translate complex business data requirements into efficient ETL packages.

Worked on Various Parallel/Sequence Job Stages like Lookup, Dataset, Remove Duplicate, Sort, Transformer, Join, Modify, Funnel, Job Activity, Terminator etc.

Worked on Database performance tuning techniques and modifying the complex join statements.

Worked in UNIX for handling DS jobs, File Transfer, File Manipulation.

Developed many interfaces to Populate Message Queue.

Worked on performance tuning to address very critical and challenging issues.

Leading the team and ensuring the delivery happens on time with the best quality and least defects. This is important in living up to the Quality standards of Cardinal Health.

Handling Change requests - Understanding the application work flow in the existing jobs on Datastage and applying new changes to them, testing & Review activities.

Adhering to the Process and creating and posting all the required documents and deliverables like the UTC document, Review Checklist, etc.

Environment: IBM Information server 8.1, SQL Server, Teradata, Oracle, DB2, PL/SQL, Putty, UNIX Shell Scripting, Control-M, Windows XP Prof, Microsoft Visio, Microsoft Office (Excel, Word and PowerPoint)

John Hancock Financial Services Aug 2010 to Feb 2011

Virtusa Polaris, Chennai, India

ETL Developer

Responsibilities:

Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications.

Understood Functional Specification Document and Written Technical Spec

Involved in Data Modeling and worked in Source to Target Transformations.

Developed Jobs using SSIS as per ETL flow to meet the requirement.

Performed Analysis using SSAS between dimensions and facts.

Generated Reports using ETL results with the help of SSRS

Created Drill down report, Drill through reports, parameterized reports etc. in SSRS to develop the solution.

Develop reusable reports by passing parameters based on business needs and created Visio diagrams to explain the design process.

Involved in creating SSIS packages to migrate large amounts of data. Involved in using SSAS data sources in SSRS reports. Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers

Troubleshooting the already existing SSIS packages.

Unit testing document prepared and solved issues from the UAT team

Prepared Root Cause Analysis/Research for the Change Requests or Defects.

Carried out performance integration and system testing.

Worked in UNIX for handling DS jobs, File Transfer, File Manipulation.

Developed many SQLs, Training Materials.

Conducted Internal Training on Data warehousing/SSIS/SSAS/SSRS.

Conducted Business and Team Meetings every week and when necessary.

Environment: SSIS, SSAS, SSRS, SQL Server 2008, PL/SQL, UNIX, Toad, Putty, Autosys

Contact this candidate