SUMMARY

• Over 15 years of IT experience as an accomplished Senior ETL Architect / Sr. ETL Developer with proven ability to successfully develop and manage BI, DW and advanced analytics programs and projects.
• Experience in leading global, regional and enterprise wide BI implementations. Previous background in consulting, program and project management and enterprise information architecture using TOGAF.
• Experienced with data applications that deal with Retail, Government, Chemical, Industrial, Media, Health Insurance, telecommunications and Automobile companies.
• Experienced in Data Warehouse standard Design templates, Architectures and Development Methodologies, Snow Flake, Star Schema, slowly changing Dimensions, Fact Tables, OLAP, and ROLAP for trend analysis and Data Marts.
• Extensively Worked on Data warehousing with Data Marts, ODS, Data Modeling, data Cleansing, ETL tools DataStage 11.7.1 Information Analyzer, Fast Track, BDR, IDA Informatica and data analyzing reporting Tools, Micro Strategy, Business Objects and Cognos and SAS Market Campaign Tool.
• Experience with Webservice technologies with SOAP and REST.
• Good knowledge with IBM MDM tool, worked with Data Governance team to inventory the best Master Record.
• Experienced with SAP, IDOC, FIXED ASSET, OPEN AR, ABAB and standard load programs. PeopleSoft Enterprise Performance Management version 8.8 data. Knowledge of EPM functionality and security.
• Expert level skills with PL/SQL functions, procedures, cursors, triggers, Materialized views, simple views.
• Experience in software design and development of applications in ORACLE 11g
• Unidata, Teradata, INFORMIX, TOAD, SQL Plus, SQL Navigator SQL*Loader, Developer 2000, including Forms and Reports, Database design using Erwin 7.0, C, C++, VB.
• AIX & Unix shell scripting on Sun Solaris and HP - UX on Korn, C and Bourne Shells for scheduling job for daily uploads of data from flat files into RDBMS tables.
• Experience in the analysis and development of applications primarily using SAP ECC, SIEBEL, AS 400, JD- Edwards, COBOL, JCL, IMS-DB, Informix 11, DB2, UDB and JD Edwards.
• Working Knowledge with web-based N-tier and client/server applications using J2EE technologies (JAVA 2.0, EJB, JSP, XML, Web services). Cloud computing with Microsoft Azure and Amazon AWS.
• Maintain and update team process work metrics and artifacts to ensure accurate and transparent communication to Product Owner and other stakeholders by creating JIRA, JENKINS and automate the code migration by U-Deploy.
• Experience with GITHUB, Fisheye, AQT tools.
• As an energetic self-starter with a strong ability to understand complex problems, I'm always eager for new challenges and learning opportunities. Interested in teaching and presenting acquired knowledge.

TECHNICAL SKILLS

LANGUAGES: Java, Python, Scala, PL/SQL, T-SQL, C, JCL, COBOL, JAVA2.0, UNIX, PERL, Shell Scripting.

OPERATING SYSTEMS: MVS, WIN NT/ 2000, XP, SUN SOLARIS, HP-UX, AIX 4.2, IBM PC’s && Compatible.

RDBMS: ORACLE 11g/9i/8i, DB2, MS SQL server 2000, Uni Data, Informix 11, IMS-DB, UDB, TERADATA.

TOOLS: Data Stage, Informatica, OWB, Erwin, Enterprise Manager, SQL Trace, JD Edwards, TOAD, Cognos, Business Objects, SQL* Loader, SQL*Net. Workforce Planning, Workforce Communications, Workforce Analytics, Supply Chain Warehouse and Business Integrator.

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

Sr. Data Stage Developer

Responsibilities:

• Understanding the data structure and meaning in both the source and the target systems and created Source to Target Mappings (STM) and apply business rules as transformations.
• Experience in leading/best practices in BI Development Stand-up/Governance/Implementation in client consulting projects/engagements
• Used the ETL DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse.
• Used ETL DataStage Server Manager for importing and Export Data Stage jobs from DEV to QA, and migrate the code into PROD.
• Process the OPTUM RX files into EDW using DataStage Stages like Sequential Stage, Join Stage, Lookup. SORT and Aggregator Stage.
• Create the Data models physical and logical for ODS and EDW.
• Resolve complex incidents, monitor solutions, and establish standards, procedures and guidelines; includes supporting and maintaining existing reports and BI solutions
• Involved in the Design of mappings using DataStage Designer from Source to Staging and staging to Data warehouse.
• Created Stored procedures to Extract and Transform the data.
• Developed Job templates, shared components and DS function in order to reduce the level of effort for future development.
• Designed Data Stage Master Sequence using the job activities stages in job sequencer to call Data Stage jobs so as to maximize the performance.
• Used Data Stage Director and Job score to monitor, view log, handle unwanted warning messages, analyze performance of individual stages and run jobs. Incorporated Environment variables ($PROJDEF) in all DataStage jobs to maintain consistency across different environment (dev, test, prod).
• Create records Recompilation process for Audit purpose.
• Create test planning and write queries to extract data for test case data comparison

Environment: IBM Info sphere DataStage 11.7.1.0, AQT, DB2,Oracle 11g, Jira, SQL SERVER, Unix, Windows 10

Confidential, Atlanta, GA

Sr. ETL Data Stage Developer.

Responsibilities:

• Understanding the data structure and meaning in both the source and the target systems and created Source to Target Mappings (STM) and apply business rules as transformations.
• Determining and implementing the Data Stage best techniques & standards for extracting data from heterogeneous source system and moving it to the Target system.
• Working closely with the ETL team to ensure compliance with all standards, and that the project deliverables are consistent with long-term infrastructure plans.
• Created ETL Templates for other developers to use.
• Created multi instance DataStage jobs, used master record for the customer using MDM tool.
• Developed transformation code/logic/programs for environment and also data transport and population processes for environments like STAGE, ODS and DM Flatten Structures.
• Building and unit testing source data transport and population processes for environment.
• Working with production data to monitor and report on data conditions and quality.
• Designing data cleanup processes
• Defining and capturing metadata and rules associated with ETL processes
• Experience in leading/best practices in BI Development Stand-up/Governance/Implementation in client consulting projects/engagements
• Facilitate and lead business discussions and formal meetings.
• Used different data stage plugins Oracle Connector, Aggregator, SORT, Data set.
• Created stored procedures for complex ETL extracts.
• Created Unix scripts, Control-M Jobs for nightly loads.
• Designed and developed entire error processing data.

Environment: IBM Info sphere DataStage 11.3.1.0, Oracle 11g, HP ALM, Jira, SQLServer, Unix, Windows 10, TOAD .

Confidential, Atlanta, GA

Sr. ETL Architect/ Sr. Developer

Responsibilities:

• Define and develops strategic architectural frameworks and roadmaps; lead the execution plan for the strategic technical roadmap
• Responsible for communication of the architectural strategy with enterprise architecture, business stakeholders, IT delivery partners, and IT Operations/Infrastructure teams
• Develop and enforces ETL DataStage coding standards, technical documentation and code reviews, establishes processes for code management, release management and migration
• Understands and deploys optimal development methodology approaches to meet enterprise/client needs (Waterfall, Agile, etc.)
• Extensively used Data Stage designer to develop Jobs for extracting, transforming, integrating and loading data into data warehouse tables.
• Used stages like, Change Data Capture, Join, Merge, Aggregator, Sort, Look-up, Funnel, Pivot, Filter, Peek to perform various development and de-bugging operations.
• Used DataStage director to schedule the DataStage scripts.
• Guided clients ETL process implementation as per DataStage Best Practice document and wrote best practice documents for client
• Involved in creation of design documents and designing the logical flow of data in the business process using Microsoft Visio.
• Extensively worked with DataStage administrator, manager, director, and Designer in the design and development of data stage jobs.
• Developed data stage jobs to convert stored procedures and metalized views for better management of the new reporting requests.
• Created test plans for Attribute check, Row check, Row check, Duplicate check, Reconciliation check and data integration check.

Environment: JIRA, Project office, DataStage 9.1, Cognos 10,Oracle, SQL Server 2012, Oracle 11g, WINDOWS 2012.

Confidential, Dunwoody, GA

Sr. ETL Applications Architect

Responsibilities:

• Identified the facts and dimensions using Erwin Data Modeling tool to represent the star schema Data Marts.
• Used DataStage Designer, Aggregator, Join and Look up Stages.
• Created technical documents to extract data from different source systems, create transformations for Date and Currency and Decimal to String, source to target mapping for ETL jobs using annotations and following naming standards and QA procedures for code maintenance.
• Designed and developed complex ETL jobs to implement the business logic based on the requirements. Used Data Stage to extract, transform and load from different input sources like flat files, DB2 and XML files into SQLSERVER 2008 database.
• Sent Data to the third-party Federal compliance company using DataStage XML output stages.
• Used DataStage Director to monitor and run ETL jobs.
• Used DataStage to call and execute Oracle Procedures.
• Involved in the Design of mappings using DataStage Designer from Source to Staging and staging to Data warehouse. Created stored procedures and Used in data stage.
• Developed Job templates, shared components and DS function in order to reduce the level of effort for future development.
• Designed Data Stage Master Sequence using the job activities stages in job sequencer to call Data Stage jobs so as to maximize the performance.
• Used Data Stage Director and Job score to monitor, view log, handle unwanted warning messages, analyze performance of individual stages and run jobs.
• Incorporated Environment variables ($PROJDEF) in all DataStage jobs to maintain consistency across different environment (dev, test, prod).
• Used DataStage XML assembler and produced XMLs and posted to the third-party site.
• Implemented SCD Type2 using CDC stage and used transformer stage to create new files for insert and update records.
• Used Quality stage and Information Analyzer for column profiling.
• Created Test plan for regression and integration testing and UAT.

Environment: IBM RTL, DataStage 9.1, Information Analyzer, Cognos 10, SAP ECC, ROSS, SYSPRO, JDE, SQL Server 2008, Oracle 11g, PVCS, Curl, XML, AIX and WINDOWS 2012.

Confidential, Alpharetta, GA

Sr. ETL DataStage Lead

Responsibilities:

• Involved in Business meetings to understand the business requirement specifications and implemented the ETL jobs using DataStage 8.1.
• Created technical documents for transformations, source to target mapping for ETL jobs and Business objects reporting documents.
• Imported the required table definitions from heterogeneous sources at the project level.
• Designed ETL jobs to identify and remove duplicate rows using Remove Duplicate stage..
• Used Erwin Data Modeling tool to create tables.
• Performed code reviews of the developed jobs and fixed the defects identified in the jobs.
• As per data architect’s directions, created and executed the Slowly Changing Dimension Type2 implementation on Dimensional data.
• Extensively did performance tuning on ETL jobs by sorting the data before sending it to the aggregator stage.