PROFILE:

• Over 10+ years of IT experience in designing and leading Enterprise Data Warehouse, data mart, and BI solutions with various integration areas, such as data integration, application integration, business process integration, and UI integration .
• Around 8+ years of rich experience in IBM Web sphere Datastage 7.0/7.5.1/8.0/8.1/8.5/9.1

SUMMARY:

• As an ETL Lead/Architect/Administrator/Developer with expertise as an architect and designing in IBM Websphere Data stage 7.0/7.5//8.1/8.5/9.1 experience as well as performance tuning of mappings, identifying resolving bottlenecks in various levels like sources, targets, mappings and sessions.
• Extensively worked on data extraction, Transaction and loading data from various sources like Oracle, SQL Server, DB2,My SQL, Teradata, Netezza and Flat files using Datastage, Informatica and UNIX shell scripting.
• As a Senior Consultant responsible for setting direction across the enterprise, and ensuring that project and program architecture aligns to the organization vision.
• Possess strong hands - on experience and functional knowledge in Information management stream that includes Data warehousing/Business intelligence. Knowledge of best practices on Process Sequence, Dictionaries, Data Quality Lifecycles, Naming Convention, Version Control.
• Lead discussions with client leadership explaining architecture options and recommendations.
• Have both hands-on as well as have ability to define and explain complex concepts and solutions and design to technical and business audiences.
• As a data architect I possess the knowledge of Data analysis, Dataintegration, Datamodeling, Data warehousing & Database designing
• Having complete domain and development knowledge of Data Warehousing Life Cycle. Experience in Design, Development, and Maintenance & Support of Enterprise applications using DWH technologies with Software Development Life Cycle.
• Design sustainable and optimal database models to support the client’s business requirements.
• Ability to work with all levels within the IT and Business organization, influence business and IT in order to align to an Enterprise Data Roadmap.
• Well versed in the following data domains: Master Data, Operational Data, Analytical Data, Unstructured Data, and Metadata.
• Advise clients on database management, integration and BI tools .Assist in performance tuning of databases and code.
• Plan the data analytics rules as per OCC guidelines, validate the reports for daily data movements and loads.
• Experience in Agile Methodology project execution model and expertise in coordinating the teams between multi locations.
• Implement validation rules and on-screen errors within the user interface. Retrieve exceptions (i.e. unmapped items) from ETL processes (i.e. loading trial balance). Integrate with the TDM for seamless committing of approved changes to data.
• Have sound knowledge on Installation / upgrade Information Server product suite on different tiers (Server and Client). Which includes Data Stage, Info Analyzer, and Business Glossary etc.
• Responsible for setting direction, and development support for the ETL development team as well as support to the developers.
• Ability to Trouble shoot the infrastructure issues with Information analyzer, Metadata Workbench, data stage job execution and resolve.
• Expertise in data warehouse technologies such as IBM Web sphere Data stage & Informatica.
• Sound in ETL design (server jobs, Parallel jobs, job sequencer and shared containers) using data stage designer.
• Expertise in identifying the performance related bottle-necks in the Architecture.
• Expertise in parsing XML files, java API connectors from data stage, and using custom build stages..
• Expertise in Oracle, SQL Server, Teradata, DB2 UDB and DB2 Mainframe.
• Extensive knowledge on normalized and dimensional modeling techniques, And Dimensional Data modeling, Star Schema modeling, Snow-Flake modeling, Fact and Dimensions tables, slowly Changing Dimensions (SCD’s).
• Mentor development team members in design and development of complex ETL.
• Experience in Teradata, upgrade planning analysis and pre and post validation.
• Expertise in Change Management tools such as CVS, VSS and Star Team. And experience in Scheduling tools Autosys, Control-M, UC4
• Experience in MDM (Master data Management) tool Siperian XU Hub.
• Experience in Prepare the Business Requirement Documents (BRD), Functional Specification Documents (FSD) and Design Specification Documents.
• Willingness and ability to learn and adapt quickly to the emerging new technologies and paradigms.
• Have strong analytical skills with proficiency in debugging, problem solving.
• Strong skills in writing Unix shell scripts and Perl scripts.
• Sound knowledge in RDBMS concepts and extensively worked with Oracle 8i/9i/10g, MySQL, Teradata, Ms-Access, Netezza,, DB2, Microsoft SQL server 2005, Derby.
• Well versed in the stored procedures, functions, triggers, etc. using SQL and PL/SQL.
• Having Knowledge and Trained on Big Data concepts & tools (Hadoop, Pig, Hive ) .

TECHNICAL SKILLS:

ETL: IBM InfoSphere Data Stage 7.0/7.5.1/8.0/8.1/8.5/9.1 , Informatica Power Center 6.1 .

OLAP: Microsoft SQL Server Analysis Services (SSAS) 2005, SAS Enterprise Guide 4.2 & 4.3

Business Intelligence: Microsoft SQL Server Reporting Services (SSRS) 2005, SAP Business Objects XI3.1/XIR2/XI/6.5, SAP Business Objects Dashboards (formerly Xcelcius).

Business Analysis-: Functional and System requirement Requirements Gathering, User Road shows and Interviews, Business Requirements Gathering, Process Flow Diagrams, Data Flow Diagrams, System Context Diagrams, Systems Analysis, Data Analysis, System Requirements Analysis, Design, Data Modeling, Data Architecture, Data Flow, Data Cleansing.

Data Warehousing & Data modeling-: Dimensional data modeling using Ralph Kimball methodology, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Entity relationship modeling, ERWIN 7.x & 8.x, Visio ( Materialized Views, Partitioning, Advanced SQL Tuning, Parallel Execution, Table and Index Compression, and Change Data Capture, slowly changing dimensions(SCD)).

Databases: Oracle 9i/8i, IBM UDB DB2 V8.0 & V9.0, MS SQL Server 2005, MS SQL Server 2008R2, 12.x/11.x, MS Access, My SQL, Teradata, Netezza .

Programming Unix Shell Scripting: Perl Programming, SQL, PL/SQL, Transact SQL, VB,C#,ASP.net Vendor Tools IBM Cognos Incentive Compensation Management V7.x and V8.0 (formerly Varicent SPM) and Sungard-Protegent (Compliance), Business Objects XI

Other Tools & Utilities -: Borland Star Team, ControlM 6.3 & 7.0, PVCS, Visual Source Safe, Mercury quality Center, Autosys,, Version Ones, Embarcadero DBArtisan 7.1 & 7.2, Squirrel SQL Client 3.4, TOAD, SQL Developer

DWH Technologies: IBM Web Sphere Data stage 7.0/7.5/8.0/8.1/8.5/9.1 , Informatica

Data modeling: Erwin 4.1

Databases: OO Oracle 10g/9i/8i, DB2, My Sql, Teradata, Netezza, SQL Server, MS Access

Programming Languages: C, C++, Sql, PL/Sql, AQL,T-Sql

Operating Systems: Windows 95/98/NT/2000/XP, Unix

Front End: HTML, XML,Java Script, VB6.0

OLAP Tools: Business Objects XI R2, Crystal Reports

Other Tools: Squirrel Client, TOAD

MDM Tools: Siperian XU HUB

Scheduling: Autosys, Control-M, UC4

Scripting: Unix, Perl, HTML,Python

DATA Analytics Tools: IBM System - T, SAS

Big Data Tools: Hive, Pig, Hadoop

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, Texas

Technical Lead / Architect

Responsibilities:

• Responsible for building and driving alignment to an Enterprise Reference Architecture.
• Lead discussions with client leadership explaining architecture options and recommendations.
• Coordinating with UNIX admins and DBAs & communicating with IBM support.
• Responsible for managing risk within an organization through a reusable framework and process
• Responsible for creating design patterns and best practices for data and the integration of data through the enterprise.
• Responsible for setting standards and providing governance through a process or framework, such as an Architecture Review Board
• Design sustainable and optimal database models to support the client’s business requirements.
• Advise clients on database management, integration and BI tools .Assist in performance tuning of databases and code.
• Mentor development team members in design and development of complex ETL and BI implementations.
• Perform architectural assessments of the client's Enterprise Data Warehouse (EDW).
• Work with the sales team to create and deliver client proposals and demonstrations.
• Understanding the existing rules of analyzing risk and develop a strategy (ETL) to reduce false positives
• Coordination between Onsite, Offshore & Near shore teams
• Preparation of the estimates, time lines of the deliverables and project execution plan.
• Analysis of the data sources.
• To determine the ETL jobs design flow for the (Extract, transform .load, reconciliation process ...etc.)And Data quality reports. parsing XML files, extensively used java API connectors
• Adhering to cleanup standards using Data Clean.
• Quality Process Management using IQMS.
• Review data validation strategies & provide support to the teams for End-to-end data verification.
• Prepare and validate product architecture and design model.
• Configuration and defect management using star team.
• Guiding project team to prepare UTP and UTRs for the functionality testing
• Integration of all the modules.
• Co-ordination with third party vendor teams.
• Used agile methodologies (Scrum) for software development. Involved in daily status meetings and team code reviews.
• Involved in story writing’s for the Scope items.

Environment: Oracle 10g, Perl, Unix shell scripting, python,plsql. UNIX, IBM Web sphere Data Stage 8.1 & 9.1, DB2, My Sql,Teradata, Sql Server, Netezza, XML, Win SCP, Command Centre, Star team, SQL developer, Squirrel, RDC, Bridger XG, choice point, Hadoop, humming bird, putty, IPMS, IQMS,NORKOM .

Confidential, San Antonio, Texas

Technical Lead / Systems Analyst

Responsibilities:

• Gathered System requirements from the Chief Risk Officer Team.
• Conducted Road shows and interviews with LoB SMEs.
• Project implementation in offshore-onshore model.
• Analyzing and identified primary, secondary and tertiary sources.
• Finalized preferred sources.
• Created metadata documentation and system context diagrams.
• Conducted design and coding peer reviews.
• Analyzed Business and systems requirements and playing a key role in implementing the system using Data Stage as ETL tool.
• Designed ETL Architectural approach
• Implemented project in Rapid BI and Lean Agile/Sprint methodology.
• Created FACT and Dimension load ETL via internal ETL Reusable flow framework.
• Applied performance tuning techniques for optimizing the performance of the Data Stage jobs.
• Extensively using Data Stage PARAMSETs for parameterize the ETLs.
• Designed Data Stage Job Sequencer to automate the whole process of data loading.
• Involved in ETL Unit Testing and also in integration testing.
• Created job execution flows via Control M and scheduling ETLs.
• Created UNIX scripts in support of ETLs.
• Supported Data modeling/dimensional modeling.
• Provided architectural support.
• Demonstrated the functionality of each Tier 1 risk mart to the end Users.
• Trained Business users in understanding the reports and their functionalities. Used agile methodologies (Scrum) for software development. Involved in daily status meetings and team code reviews.
• Involved in story writing’s for the Scope items.

Environment: Data Stage 8.0.0, SAP Business Objects XI, UNIX, Windows 2000/NT, IBM UDB-DB2, Squirrel Client, Erwin, Star Team, Mercury Quality center, Control-M and Version One, Shell & PERL Scripting.

Confidential, San Antonio, Texas

Technical Lead

Responsibilities:

• Analyze the Business Requirements and Involved in Analysis, Design, Development, UAT and Production phases for new modules and enhancements of the application.
• Understanding the existing rules of analyzing risk and develop a strategy (ETL) to reduce false positives
• Coordination between offshore & Onsite teams
• Preparation of the estimates, time lines of the deliverables and project execution plan.
• Analysis of the data sources.
• Preparation of S2T, A&D and design documents
• Created parallel jobs using data Stage Designer.
• Excessively used complex stages like aggregator, Lookup. Change capture, joiner, Funnel, etc...
• Created sequential file sets and Data sets as per the requirements.
• Specified the partitioning methods as per the stages where ever required.
• Debugged the jobs and resolved the formatting and other data quality issues.
• Created and scheduled the sequencers.
• Involved in creating the Control-M tables to schedule the jobs
• Adhering to cleanup standards using Data Clean.
• Quality Process Management using IQMS.
• Knowledge transition about the existing systems to the new joiners.
• Prepare and validate product architecture and design model.
• Configuration and defect management using star team.
• Guiding project team to prepare UTP and UTRs for the functionality testing
• Integration of all the modules.
• Co-ordination with third party vendor teams.
• Involved in the project and views creation in StarTeam while moving the code to UAT and Runways
• Involved in all the configuration management activities till code moved to production.
• Involved in Release Management of the application and Production Support for fixing the issues.
• Co-Ordination with off shore teams (Development & Testing teams).

Environment: Oracle 10g, Perl, Unix shell scripting, python,plsql. UNIX, IBM Web sphere Data Stage 8.1, DB2, My Sql, Win SCP, Command Centre, Star team, SQL developer, Squirrel, RDC, Bridger XG, choice point, humming bird, putty, IPMS, IQMS,NORKOM .

Confidential, San Antonio, Texas

ETL Developer

Responsibilities:

• Analyze and Understanding the existing rules of analyzing risk and develop a strategy (ETL) to reduce false positives.
• Coordination between Onsite, Offshore & Near shore teams
• Automated the jobs thru scheduling using TIDAL which runs every day by maintaining the data validations.
• Preparation of the estimates, time lines of the deliverables and project execution plan.
• Analysis of the data sources.
• Preparation of S2T, A&D and design documents
• To determine the ETL jobs design flow for the (Extract, transform .load, reconciliation process ...etc.)and Data quality reports.
• Involved in creating the parallel jobs & sequencers with using data stage.
• Adhering to cleanup standards using Data Clean.
• Quality Process Management using IQMS.
• Knowledge transition about the existing systems to the new joiners.
• Prepare and validate product architecture and design model.
• Configuration and defect management using star team.
• Guiding project team to prepare UTP and UTRs for the functionality testing
• Integration of all the modules.
• Co-ordination with third party vendor teams.
• Involved in the project and views creation in StarTeam while moving the code to UAT and Runways
• Involved in all the configuration management activities till code moved to production.
• Involved in Release Management of the application and Production Support for fixing the issues.

Environment: Oracle 10g, Perl, Unix shell scripting, python,plsql. UNIX, IBM Web sphere Data Stage 8.1, DB2, My Sql, Win SCP, Command Centre, Star team, SQL developer, Squirrel, RDC, Bridger XG, choice point, humming bird, putty, IPMS, IQMS,NORKOM .

Confidential, Jersey, City, New Jersey

ETL Developer

Responsibilities:

• Analysis of Business Requirements and System Requirements.
• Providing the feasible and efficient design approach of the application to fit according to the requirements.
• Study the application management process, procedures, identifying areas for improvements and implementing the same.
• Work Assignment from the functional & technical perspectives.
• Determination of the resource requirements for the project.
• Debug the existing ETL code
• Define Future task and prioritize task according to client priority.
• Managing delivery expectation from Client and managing concerns and escalations point from client
• Define responsibilities and reviewing deliverables.
• Tracking project schedule & Change Request
• Track project risk and prepare detailed mitigation plan.
• Knowledge, process, and configuration management.
• Effort and delivery estimations.
• Team management and address personal and team related issues or concerns.
• Production support request prioritization.
• ETL & Siperian jobs Monitoring
• Constructing and Changing the Data Stage jobs as per requirements provided by the clients.

Environment: Siperian XU, data stage 7.5x2, Autosys, Toad, Unix, Oracle 10g,Perl, Unix shell scripting, plsql, humming bird, putty,DB2, My Sql, Win SCP, Command Centre, Star team, SQL developer, Squirrel .

Confidential, Naperville, Illinois

ETL Developer

Responsibilities:

• Primary responsibilities include assisting project teams on ETL Architecture /Design / Development / Deployment.
• Built Interfaces and automated with Informatica ETL tool, PL/SQL and Unix Shell Scripting.
• Designed ETL processes and develop source-to-target data mappings, integration workflows, and load processes.
• Designed, developed, and implemented enterprise-class data warehousing solutions.
• Review of source systems and proposed data acquisition strategy.
• Designed Sequencers to automate the whole process of data loading.
• Gave expert solution to the users for problem in Datastage .
• Translated the business processes into Datastage mappings.
• Collect, analyze, and process data for business clients and senior management using multiple databases or systems, spreadsheets, and other available tools for reporting and/or decision making that have a major impact on various clients / organizations.
• Facilitating problem solving and decision making in business groups by building business cases and providing insights through complex analysis using multiple databases or systems.
• Collecting and analyzing process, performance, and operational data for generating reports and graphs.
• Interpreting user requests to determine appropriate methods and data files for extracting data.
• Designing and/or developing specific databases for collecting, Tracking, and reporting data.
• Analyzing and interpreting the data to produce clear, concise information that aids decision making.
• Prioritizing and coordinating requests with various stakeholders to meet deadlines.
• Developed and maintained documentation to client standards / provide feedback on standards where they can be improved.
• Helped in establishing ETL procedures and standards for the objects improving performance enhancements and migrated the objects from Development, QA, and Stage to Prod environments.

Environment: - Oracle 9i, RACE, SAS, MS DOS scripting, IBM Web sphere Data Stage 7.5, DB2, Win SCP, Command Centre, Star team, SQL developer, Squirrel, humming bird, putty .

Confidential

ETL Developer

Responsibilities:

• Translated the business processes into Datastage mappings.
• Collect, analyze, and process data for business clients and senior management using multiple databases or systems, spreadsheets, and other available tools for reporting and/or decision making that have a major impact on various clients / organizations.
• Facilitating problem solving and decision making in business groups by building business cases and providing insights through complex analysis using multiple databases or systems.
• Collecting and analyzing process, performance, and operational data for generating reports and graphs.
• Interpreting user requests to determine appropriate methods and data files for extracting data.
• Designing and/or developing specific databases for collecting, Tracking, and reporting data.
• Generating reports on a periodic/ad-hoc basis in accordance with business requirements.
• Performing required due diligence before presenting reports/ outputs; ensuring the integrity of data is maintained.
• Analyzing and interpreting the data to produce clear, concise information that aids decision making.
• Prioritizing and coordinating requests with various stakeholders to meet deadlines.
• Developed and maintained documentation to client standards / provide feedback on standards where they can be improved.
• Helped in establishing ETL procedures and standards for the objects improving performance enhancements and migrated the objects from Development, QA, and Stage to Prod environments.
• Primary responsibilities include assisting project teams on ETL Architecture /Design / Development / Deployment.
• Built Interfaces and automated with Informatica ETL tool, PL/SQL and Unix Shell Scripting.
• Designed ETL processes and develop source-to-target data mappings, integration workflows, and load processes.
• Designed, developed, and implemented enterprise-class data warehousing solutions.
• Review of source systems and proposed data acquisition strategy.
• Designed Sequencers to automate the whole process of data loading.
• Gave expert solution to the users for problem in Datastage.

Environment: Data Stage 7.5, UNIX, Windows 2000/NT, IBM UDB-DB2, DBArtisan, Star Team, Mercury Quality center, Autosys, Shell & PERL Scripting

Confidential

ETL Developer

Responsibilities:

• Translated the business processes into Data stage mappings.
• Developed and implemented technical best practices for data movement, data quality, data cleansing, and other ETL related activities. Developed and ensured adherence to globally defined standards for all developed components.
• Provide weekend production support in rotation.
• Database Design (Relational and Dimensional models) using Erwin.
• Developed and implemented technical best practices for data movement, data quality, data cleansing, and other ETL-related activities. Developed and ensured adherence to globally defined standards for all developed components.
• Support the database architecture team to accomplish enterprise objectives.
• Design and implement data models according to the project requirement.
• Participate in data architecture strategy and policy making initiatives.
• Archive, recover and delete data as directed by the seniors.
• Maintain and prepare documentation of the data architectural process and progress.
• Report to the senior architect with regular job progress.
• Drilled into the data / profile the data / sort out what data will work.
• Assessed scope and assist in determinations of what can be done in the time and budget available / Determine max value in time and budget available.
• Designed a solid foundation that can scale and grow.
• Developed and maintained documentation to client standards / provide feedback on standards where they can be improved.

Environment: Data Stage 7.5, UNIX, Windows 2000/NT, IBM UDB-DB2, DBArtisan, Star Team, Mercury Quality center, ControlM, Shell & PERL Scripting

Confidential

ETL Developer

Responsibilities:

• Prepared documentation including requirement specification.
• Installed and configured Power center Client and Server Tools.
• Creating Dimensions and Facts in the physical data model.
• Documented the metadata to capture from the sources
• Created Sessions and batches to extract the data.
• Involved in the creation of jobs using work flow manager to validate schedule run and monitor the jobs.
• Involved in designing the procedures for getting the data from all systems to Data Warehousing system.
• Performed production support activities.
• Handled CRs (Change Requests).
• Performed impact analysis during the system enhancements.
• Requirements Gathering from End Users.
• Prepared Design Document for DQD Implementation.
• Developed ETL mappings, Transformations and Loading using Informatica Power Center 6.1.
• Involved in Scheduling using the scheduling tool like AUTOSYS.
• Developed JIL (Job Information Language) Scripts in UNIX Environment.
• Extensively used ETL to load data from Relational Databases.
• Involved in Developing and testing all the Informatica mappings using Lookups and Update Strategy and other transformations.
• Developed mappings using different types of transformations like source qualifier, Stored procedure, expression, filter, update strategy, lookup, and sequence generator.
• Involved in Unit Testing.
• Used the Power center Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Assisted warehouse designer while designing the models.
• Created Unix Shell Scripts to automate the process.

Environment: Informatica Power center 6.1 & 7.0, Windows NT, Sybase, UNIX and PERL scripting, Autosys, Flat Files, DBArtisan JIL scripts .