SUMMARY:

• To pursue the position of an Enterprise Data Architect or Data integration Architect and utilize my technical and business domain skills along with excellent analytical and inter - personal skills, detail oriented with the ability to multitask and effectively communicate verbally and in-writing that are gained over 11 years in data integration services with highly advanced data warehousing and BI solutions to help the organization achieve their long term and short-term goals.
• Over 11 years of experience in business requirements analysis, application designs, data modeling, coding, development, testing and implementation of business applications with RDBMS, data warehouse/data mart, ETL, OLAP, OLTP and client/server environment applications.
• Strong knowledge in in complex data warehouse, Big data and Data Lake environments and data analytics solutions
• Proficient in architectural, governance, integration, real-time, replication, reporting/analytical concepts using reporting tools such as Business Objects XI and Microstrategy 9.3 and big data analytics thru hadoop/Talend/Map reduce model, realtime data replicaction & integration thru oracle golden gate, data encryption methods such as TDE/vault and Microsoft dynamics CRM, Talend Studio/Big Data Integration thru Hadoop Eco systems such as Hive, Hue, Spark SQL, Sqoop.
• Strong experience in Informatica Power Center and cloud integration and IDQ/IDA/IDD and Informatica data validation option (DVO) 9.5 & SSIS 2005/2008/2014/2016 .
• Excellent knowledge and experience in UNIX/LINUX shell scripting.
• Integrated various data sources/targets systems with multiple relational databases such as Oracle, Teradata, Flat Files, COBOL files, DB2 and MS SQL Server &SSIS 2005/2008/2012/2016, and Oracle performance tuning, constituting analysis of Informatica codes and PL/SQL scripts.
• Proficient in Software Development Life Cycle (SDLC) Methodologies, ISO 9001:2000, SEPG, CMM Level 5 and validations to ensure complete quality assurance control.
• Acted as liaison between the clients, programmers and managers of the project development. Instrumental in the development and implementation of several project/module phases, maintenance and application testing.
• Experience in bio-pharmacy, biotech, healthcare and financial business industries.
• Strong team player with excellent analytical and inter-personal skills, detail oriented with the ability to multitask and effectively communicate verbally and in-writing.

TECHNICAL SKILLS:

ETL Tools: Informatica Powercenter, B2B and cloud integration 10.2/9.6/9.5/9.1/8.5/8.1.1/7.4/7.1 ; IDQ/IDA/IDD 9.6/9.5/9.1; DVO 9.5; SSIS 2005/2008/2014/2016

Databases: Oracle 12c/11g/10g/9i, Teradata V2R5/V2R 6/12.0/13.10, DB2 11.1, MS SQL Server 2005/2008/2014/2016, MS Access and Netezza 5.0

Hadoop: HDP 2.6.3, HDFS, Spark 2.2.0, Hive 2.1.0, Sqoop 1.4.6, Zookeeper 3.4.6, Yarn, Hbase 1.1.2, Kafka 0.10.1,Talend Big Data Integration 6.4 and Hortonworks Ambari and TAC

Data Modeling: MS Visio 2003/2007/2010, ER/Studio, Erwin and Toad.

Linux: (Red hat, AIX and HP-UX)

Languages: SQL, PL/SQL, C, C++, Java, HTML

Scripting: Shell Scripting, SQL, PL/SQL, C/ C++, MATLAB, VBA

Querying Tools: TOAD, SQL developer, SQL Navigator, Query Analyzer

Application: MS Office 2003/2007/2010, HTML, XML

Misc. Tools: SalesForce, MKS Tool Kit 8.7 (OS Inter-operability software). Aqua Data mapping validator

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, MO

Enterprise Data Architect

• Develop solution architectures for Data Management that support Risk & Regulatory compliance for brokerage, wealth and retirement services.
• Assess enterprise, line of business, and staff group architectures, strategies, roadmaps and designs for potential alignment opportunities.
• Actively participating in Data Governance meetings
• Define ownership, usage, security and data quality and profiling standards
• Develops strategies for data acquisitions, profiling, quality, integration, archive recovery, and implementation of a data warehouse.
• Guide and recommend on futuristic data policies and cost effective tools to enable robust quick and reliable decision support applications
• Follow appropriate enterprise standards, processes and governance applicable to the architecture practice.
• Responsible for the legacy subject areas, source systems, target system, jobs and the deployment processes with minimal supervision.
• Defining the batch Job flow sequences, Data validation checks and jobs scheduling dependencies.
• Involving the architecture, design and code reviews.
• Fine tuning the performance of various slow mappings especially for historical load related jobs and involved closely with the administrator to get code deployments in production and different environments.
• Research and Recommending appropriate tools based on the requirements of data profiling, data quality, data integration, data consolidation and reporting.
• Prepare high level and low-level technical specifications along with data modeling
• Design and ETL process to load WIMT data in ODS (Oracle Exadata) using Oracle loader and Informatica and then integrate in WIMT Data warehousing in IBM DB2 thru Db2 Load and Informatica process. And, eventually WiMT data gets integrated in to EIW (Enterprize information Warehouse) that’s lives on Teradata thru automated scheduling of the UNIX scripts and Informatica workflows/sessions/mappings/APIs using autosys.
• Performed the POC of the big data integration requirements thru big data integration tools such as Talend Spark jobs, which collects data from Oracle/Teradata databases, and load the data in to HDFS in HDP 2.6.3.
• Performed the real-time data replication/integration using Oracle Golden gate 12c.
• Provided status reports to management as specified. Transferred the requirements and coordinated with cross platforms on development activities.
• Participated with the software configuration management to promote the codes to live environments.

Environment: Oracle 12c & Exadata, DB2 11.1, XMLs, Informatica 10.2/9.6,IDA/IDQ 9.5, DVO 9.6 Teradata 13.x, Sql server/SSIS 2014 SP2/2016 and Unix (AIX 7.x)/Linux (Red Hat 7.4 Maipo), oracle golden gate 12c, HDP 2.6.3, HDFS, Spark 2.2.0, Hive 2.1.0, Sqoop 1.4.6, Zookeeper 3.4.6, Kafka 0.10.1 and IBM MQ,Talend Big Data Integration.

Confidential, San Ramon, CA

Data Architect - Business Intelligence & Data Management

• Analyzed customer requirements and design solutions in accordance with banking industry standards
• Provided technology support for innovation activities and cost effective data integration solutions
• Worked with business innovation champions and evaluate emerging FinTech business models, technology, architecture, integration with Bank
• Developed and maintained data architecture roadmap indicating current, transition, and future state architectures, focused around clear benefits to the corporate as a whole
• Responsible overall data warehouse, big data and analytical data science architecture including direction, principles, various levels of abstraction, and current state
• Design and deploy state-of-the-art, data-driven learning algorithms to solve business problems using the latest technologies in decision support systems.
• Design of data warehouse, data lake, big data, Hadoop systems and data science analytical frameworks
• Designed Metadata management and creation of logical data architecture within Data Lake
• Evaluated vendor technology and architecture
• Worked with business teams to provide IT and technology input for data integration initiatives - develop conceptual and solutions architecture designs; work with other IT partners to produce solutions development options, costs, timelines, risks
• Prepared high level and low-level technical design specifications.
• Solution designs for ETL process using Informatica, sql/plsql scripts, data quality and reviews
• Evaluate the integration of a various data sources like Oracle, SQL server, COBOL, Xml and flat files into staging area and then data store on oracle and integrating into EDW on Teradata
• Implements data cleanup procedures, transformations, scripts, stored procedures, and execution of test plans for loading the data successfully into the targets thru shell script driven batch process
• Identify Performance bottlenecks and fine-tune SQL Queries, ETL mappings and Workflows to improve performance
• Perform Data analysis, profiling, mapping, loading, integration, validation and reporting with thorough understanding of Entire life cycle of Software and various Software Engineering Methodologies
• Apply data analysis, data cleansing, data matching, exception handling, and reporting and Monitor the capabilities of IDQ/IDA/IDD/MDM
• Adhere to SDLC life cycle work, including analysis, systems solutions, design, development, Enhancement, testing, maintenance and technical support for this project and communicate the status
• Counsel team members: providing mentoring, technical assistance, troubleshooting and alternative development solutions
• Coordinate the systems administrators for code deployments to production and different

Environment: Oracle 12c/11g, SQLServer 2014,COBOL files, XMLs, Teradata 13.x, Informatica 9.6, IDQ 9.5, DVO 9.5 and RED Hat Linux 6.7, Control M, Oracle dataguard. Oracle TDE, Oracle RAC, HDP 2.6.1, HDFS, Spark 1.6.3 and Hive 1.2.1

Confidential, St. Louis, MO

Data Integration Architect

• Analyzed customer requirements and design solutions which go beyond traditional industry standards.
• Provided in-depth technical expertise regarding design and development of the data integration and analytics platforms for effective pricing.
• Applied knowledge of data warehousing and ETL to architect scalable applications to load, unload, and query data.
• Worked closely with the technology team, product management and leadership team to establish the technical strategy and communicate it to the executive team and externally.
• Made design decisions and optimize them on the basis of performance, scalability and future expansion.
• Applied in-depth knowledge of Informatica ETL/IDQ/IDA/IDD tool, relational databases, SQL server/Oracle/DB2/Teradata/CFD and database technologies to resolve complex technical issues and drive innovation that improve scalability, relevance and the user experience of products.
• Lead as a hands-on developer contributing high quality, production-ready code and providing detailed feedback in design and code reviews.
• Defined information delivery architecture and establish the appropriate tools usage for data migration and database design. Research, evaluate, and recommend new business intelligence (BI) technical approaches, technologies and tools (applications, databases and reporting)
• Responsible for the legacy subject areas, source systems, target system, jobs and the deployment processes with minimal supervision.
• Involved in all phases of the software development life cycle.
• Improved performance of various slow mappings especially for historical load related jobs and involved closely with the administrator to get code deployments in production and different environments.
• Prepared high level and low level technical specifications.
• Designed and developed the ETL process to load and extract data using Db2 Load and Oracle the SQL loader and automated scheduling of the UNIX scripts and Informatica sessions using autosys.
• Analyzed and coordinated the testing related activities with various stakeholders.
• Provided status reports to management as specified. Transferred the requirements and coordinated with cross platforms on development activities.
• Participated with the software configuration management to promote the codes to live environments.

Environment: Oracle 11g, DB2,SQL Server & SSIS 2012/2014, XMLs, Informatica 9.5, IDQ 9.5, DVO 9.5 and Linux

Confidential, Denver, CO

Sr. ETL Analyst & - Integration Hub

• Primary responsible person to drive the whole project activities from the technical stand point.
• Involved in all phases of SDLC: requirements gathering, impact analysis, designing, architecting, constructing and testing.
• Identified and worked on the enhancement based on the business requirements and transferred the requirements and coordinating with the cross platforms on the development activities.
• Analyzed and developed the new codes as per the requirements and validated and tested the changes done by the team.
• Tracked the development activities and reported to the project management and participated with the software configuration management to promote the codes to live environments.
• Organized meetings with the clients to review the production bugs if there were any existing roadblocks.

Environment: Oracle 10g, XMLs, Informatica PowerCenter 9.5, B2B data transfermation and Linux

Confidential, New Brunswick, NJ

Sr. ETL developer

• Transferred the business requirements to technical requirements.
• Analyzed and developed cognos and Informatica code as per the requirements
• Validated and tested the codes to ensure it was aligned with source to target matrix.
• Tracked the development activities and reporting to the project management.
• Data refresh loads as per business on-demand analyzing and resolving the production issues.
• Provided status reports on production and development activities to the business.
• Identified the performance bottlenecks of the Informatica code and tuned them.

Environment: Informatica 9.1, IDQ 9.1, Teradata 12.x, SQL server 2008, Oracle9i, UNIX shell scripting.

Confidential, Thousand Oaks, CA

Sr. ETL Systems Analyst

• Performed impact analysis for various applications such as IRPC and legacy PCMT.
• Involved in complex designs, code enhancements, testing documents and reviews.
• Implemented performance tuning techniques for the existed PCMT 3.x.
• Involved in coordinating with the offshore development teams for technical code reviews and migrations.
• Involved in all phases of SDLC: requirements gathering, impact analysis, designing, architecting, constructing and testing.
• Tracked the development activities and reported to the project management
• Learned and implemented Informatica DVO for validation to meet FDA reports.

Environment: Informatica 9.1/ 9.5, DVO 9.5, Teradata V2R6/12.x, SQL server 2008, microsort dynamics CRM 2011,Oracle10g

Confidential, Thousand Oaks,CA

ETL Developer & On-site Co ordinator

• Involved in performing analysis for various applications such as contracts and Chargeback System (CCS),Product Master (PM) and External Data Exchange (EDX)
• Involved in the preparation of effort estimations for major enhancements, issue tracking, prioritization and resolving technical issues and business enhancements.
• Involved in efforts estimation and gathering technical requirements.
• Implemented performance tuning techniques on daily, weekly, monthly processes and prepared Analysis and solution approach document, design documents, unit testing review documents.
• Involved effectively in all phases of project phases.
• Meeting clients for project document deliveries and gathering enhancements

Environment: Informatica power center and cloud 9.5, Teradata V2R6/12.x, Oracle10g, MKS tool and UNIX shell scripting, salesforce.

Confidential, Thousand Oaks, CA

ETL Developer & On-site Coordinator

• Developed ETL jobs using Informatica, oracle and Teradata tools.
• Created detailed planning and estimation documents for the enhancements/projects and shared it with the Confidential system analyst and business teams for discussion/approvals to the project sponsor/manager.
• Responsible for the offshore deliverables from a technical stand point.
• Involved in preparation of effort estimation for major enhancements, Issue tracking, prioritization and resolving technical issues and business enhancements
• Participated in analysis, solutions approach, design and unit testing review documents.
• Involved effectively in all phases of project phases such as requirements gathering, impact analysis, designing, architecting, constructing and testing.
• Met the clients for project document deliveries and gathered enhancements.
• Participated in production support activities along with offshore teams.

Environment: Informatica Power Center 7.4/9.1, Teradata V2R6/12.x and Oracle10g.

Confidential, Groton, CT

Sr. ETL Developer & On-site Coordinator

• Developed mappings and from multiple sources to a single staging area using the ETL process.
• Automation of Informatica jobs and error handling via UNIX shell scripting.
• Involved in the client processes to meet targets and deliver solutions.
• Peer review (Mappings/Mapplets/Workflows and shell scripts), Defect tracking and control.
• Coordinated with the offshore about requirements, issues and deliverables.
• Involved in the major enhancements, issued tracking, prioritized and resolved the technical issues.
• Involved in analysis, Solution Approach, Design and unit testing review documents.
• Involved in all phases of SDLC: requirements gathering, impact analysis, designing, architecting, constructing and testing.
• Tracked the development activities and reported to the project management.

Environment: Informatica Power Center 8.6,Sql server/SSIS 2008, Oracle10g and UNIX shell scripting.

Confidential, Danbury, CT

ETL Developer, Secondary Factory (DF2)

• Developed the ETL codes across various layers.
• Requirement analysis according to the business demand and standard.
• Requirements review, coding and unit-testing of the Informatica mappings.
• Prepared design, test plans, defect reports, unit test case documents.
• Responsible for Offshore deliverables from technical stand point
• Prepared estimates, issued tracking, prioritized and resolved the technical issues.
• Involved in all phases of SDLC: requirements gathering, impact analysis, designing, architecting, constructing and testing.

Environment: Informatica Power Center 8.1/8.5, Oracle9i, Netezza 5.0, flat files and UNIX shell scripting.

Confidential, Pleasanton, CA

ETL Developer

• Analyzed technical needs and developed ETL mappings.
• Participated in the client processes to meet targets and deliver solutions.
• STM (requirement) review, coding and unit-testing of Informatica mappings.
• Peer review (Mappings/Mapplets/Workflows and shell scripts), defect tracking and control.
• Involved in all phases of SDLC: requirements gathering, impact analysis, designing, architecting, constructing and testing.
• Tracked the development activities and reported them to project management.

Environment: Informatica Power Center 8.1/7.4, Oracle 8i and UNIX shell scripting

Confidential, Groton, CT

ETL Developer

• Developed mappings using the Informatica process across various layers.
• Requirement analysis, design, STM (requirement) review, coding and unit testing of Informatica mappings.
• Peer review (ETL codes and shell scripts), defect tracking and control.
• Responsible for deliverables from the technical stand point.
• Prepared effort estimation, Issue tracking, prioritization and resolving technical issues
• Tracked the development activities and reported to the project management.

Environment: Informatica Power Center 8.1, SQLserver /SSIS 2005, Oracle clinical 9i, flat files and UNIX shell scripting.