SUMMARY

• Around 15 years of IT experience mostly in Analysis, design, development, Testing and implementation of BI/DW projects.
• Significant work experience as an ETL Architect/BI Architect (5 - 6 yr.) and BI project Manager (4-5 yr.) with handling of team size of 30+ team member.
• Very good experience in Data Architect/Data Modeling of all DW/BI layer. (EDW, ODS, DATA MART) for Retail, Utility, Insurance, Manufacturing, Telecom and Finance domain.
• Around 8 yrs. of extensive experience in Architecting, design and development of Extraction, Transformation and Loading (ETL) process using IBM Infosphere DataStage 8.5/8.1, Ascential DataStage 7.5x (Administrator, Director, Manager, Designer) and Informatica Power Center 8.x/7.x/6.x.
• Experience in setting up real time Change Data Capture process using IBM Change Data Capture (CDC) 6.5/6.3.
• Significant experience in designing IBM Data Stage Parallel jobs and optimizing pipeline and partitioning parallelism by using parallel stages like DB2/UDB Enterprise, Funnel, Modify, Remove Duplicates, Sort, Lookup, Merge, Join etc., and using multiple configuration files. Experience in Connector Technology for various databases and applications like Teradata, SQL Server, Netezza etc.
• Significant experience in designing ETL process using Informatica 7.x/8.x using both PowerCenter as well as Power Mart. Good understanding on added functionality in Informatica 9.x.
• Good experience in design &development of Business Layer/Reporting Layer using Framework manager in Cognos 8.4.
• Good experience in design and development og BI Dashboard as well as BI reports (Charts, Cross tab, List) using Cognos 8.4.
• Experience in using IBM Balance Optimization to convert base Data Stage ETL job into ELT job to leverage Teradata load (TPT) process
• Experience in Teradata utilities in like Fast Load, Multi-Load and Fast Export, query tools SQL Assistant, Teradata SQL, Explain Plan.
• Experience in Designing end-to-end ETL framework and strategies to handle Re-startabality, Error handling, Data reconciliation, Batch processing and process automation
• Significant Experience in Full Software Development Life Cycle (SDLC) including requirement analysis, design, development, testing, implementation and project documentation.
• Exposure to IBM Information Analyzer and Metadata Workbench
• Strong understanding of the principles of Data Warehouse functions including the use of Fact Tables, Dimension Tables, Star Schema modeling, and Snowflake Schema modeling.
• Good experience in Data model design for entity relational model (ER Model) and dimensional relational data model using Erwin/Embarcadero.
• Extensive experience in Insurance, Retail, Manufacturing, Retail and Utility domain.
• Excellent experience in troubleshooting of DataStage jobs/ Informatica Mappings and addressing production issues like performance tuning and enhancements.
• Good experience in BI report development using BusinessObject 6.2
• Good experience in setup parallel and user defined Project specific Environmental Variables at Project level and using them as job parameters at job level.
• Experience in implementing ETL load across databases like Oracle 10g/9i, Teradata, Netezza across multiple operating platforms like UNIX, Windows
• Experience in Extracting data from Mainframe Flat files, Unix Flat Files and Complex Flat Files.
• Self-motivated, excellent grasping capability with strong technical and communicational skills.

PROFESSIONAL EXPERIENCE

Confidential, Chelmsford, MA

BI Architect/Tech Lead

Responsibilities:

• Design & Develop new BI Semantic layer ( Both Business as well as Reporting Layer) using Framework manager to support Dashboard requirement
• Assist remote development team to develop the complete BI dashboard along with 20+ BI report ( List, Crosstab, Chart)
• Design and developed 2 Informatica Mappings to build the relevant fact table
• Design and develop underlying Fact and Dimension tables to support dashboard requirements.
• Involved in architecting the solution for proposed BI dashboard including leveraging existing Framework model, database tables
• Collaborate with Business Analyst to confirm and consolidate all business requirements for BI Dashboard.
• Involved in creating technical documentation to facilitate better understanding of the process and in corporate changes as and when necessary.
• Build new namespaces; create 25+ model query subject, and relationship among these query subjects.
• Build query items inside the query subjects and standardized the query item to rename corresponding business name..

Confidential, Framingham, MA

ETL Architect

Responsibilities:

• Designing the ETL framework and its components, setting up the framework components to accommodate the business project.
• Designed and developed parallel jobs for extracting, cleaning, transforming, integrating and loading data into data warehouse database using DataStage Designer.
• Worked on IBM Infosphere CDC to capture changes, developed subscriptions to map the source and the target table to write the changed data into the file or the table using the direct connect.
• Closely coordinate with Data architect group to design Enterprise Data warehouse and Data Marts.
• Design and develop process control model to make entire ETL process re-startable with no manual intervention as well as to support scalability.
• Converted complex job designs to different job segments and executed through sequencer job for better performance and easy maintenance.
• Setting Environment variables, Parameters and creating Parameter sets to make the jobs more flexible for development as well as debugging.
• Enhanced the reusability of the jobs by making and deploying shared containers and multiple instances of the jobs.
• Involved in creating technical documentation to facilitate better understanding of the process and in corporate changes as and when necessary.

Confidential, La Palma, CA

DataStage Designer

Responsibilities:

• Setting up Change Data Capture (CDC) process for new Data Warehouse as part of the ETL framework.
• Design of CDC process to move source system data into Warehouse environment.
• Assist CDC development team to create CDC Subscription against each source system on real-time replication mode.
• Design ETL process in InfoSphere DataStage to load both staging as well as core warehouse layer.
• Involved in setting up of pre-build ETL design template for development in InfoSphere DataStage.
• Also involved in setting up of the change control process using ClearCase tool.
• Development and Unit test of complex DataStage job and subsequently optimized these jobs using IBM Balance Optimizer.
• Identify and develop re-usable components.

Confidential

ETL Architect/Data Analyst

Responsibilities:

• Understand existing schedule reports along with identification of corresponding data element.
• Design new ETL framework to setting up recovery and re-startability process, Error handling process and metadata loading process.
• Design & development of entire ETL process to move data from source till Data mart.
• Analyze legacy ETL process to trace the data element from source system to reports.
• Analyze the source system data to identify any potential gaps
• Logical & physical data model of new Billing data warehouse as well as data mart.
• Analysis of source system data, attributes and relationship among data elements.
• Define overall technical architecture for new billing data warehouse. i.e. Staging layer, ODS layer, EDW layer and finally Data Mart layer
• Coordination with concerned team to set up the connectivity and infrastructure at offshore location at Mumbai, India.
• Coordinate with resource manager for resource fulfillment and if required involved in screening & hiring process for project specific resource.

Confidential

ETL Architect/Data Architect/SPOC/DataStage Designer

Responsibilities:

• Designing ETL framework for new solution to cover metadata management, Error handling, Reconciliation and reject strategy
• Understand existing reporting solution and data elements.
• Understand the current EDW architecture.
• Design incremental load strategy to modify existing ETL process
• Design ETL to move data from source to staging area
• Identification of reference table needed for EDW
• Define and document the reference data requirement. ( Corporate Data Repository)
• Design of reference data structure to conform data across EDW
• Design & development of logical & physical data model (Erwin) of new re-engineering staging as well as ODS area in 3rd NF
• Analysis of source system data, attributes and relationship among data elements.
• Design revised ETL process to convert existing ETL process into Daily incremental
• Discuss and coordination with Business SMS to understand requirements and data.
• Participate in design discussion and review session with Client’ design team.
• Participated in server sizing discussion for ETL server
• Prepared tool evaluation document between SSIS 2005 & DataStage 8.0.1
• Monitoring of all BI related project with project deliverables, schedule, risks etc.
• Weekly status to BI management in term of status of all BI projects, new opportunity and, issues & concern of both client and team.
• Complete ownership of any new opportunity in this account including asking relevant questions to Client manager, collating all required artifacts, overall effort estimate and finally submission of the proposal/Sow
• Coordinating with Onsite project manager to facilitate all logistics for all onsite position.
• Coordinating with Resource team to fulfillment on all open position within the account.
• Coordinate with project lead and project manager to raise change request whenever applicable.
• Coordinating with Finance and billing team to raise invoice as per schedule
• Coordinating with network team to set up appropriate network connectivity at offshore location
• Resolving any issues/concern raised by Client manager
• Analysis of current ETL process developed by in-house team.
• Identify the dependencies across different subject area within EDW framework
• Design and modification of existing data stage jobs for better performance.
• Design test environment.
• Implemented ODBC connector across all data stage jobs.
• Coordinate with BI application manager to decide ETL work request priority within a release.
• Preparation of technical requirement document for any new work request.
• Coordinate with Business team to decide priority on business work request

Confidential, Chicago

Business System Analyst/Data Architect/ETL Designer

Responsibilities:

• Assessment to check the feasibility of these reports from EDW framework.
• Analysis of AS-IS data flow for all 13 reports
• Discuss and coordination with Business SMS to consolidation of requirements and understand the data.
• Identify the dependencies across different subject area within EDW framework
• Study of existing source system to understand current report generation process.
• Identification & analysis of data elements required generating 13 reports.
• Design data architecture to in corporate all specific data elements in EDW framework
• Design data integration layer to store and load data into EDW.
• Design semantics layer/physical layer to design reports in OBIEE.
• Provide solution in existing EDW framework to create these reports using EDW. This includes data model design as well as product hierarchy design.
• Preparation of technical requirement document & Gap analysis document
• Participate in design discussion and review session with Client’ solution architect team.
• Design and development of Informatica 8.1 mappings to load data across each integration layer
• Design the Informatics workflow/session for each layer including setting up dependencies.
• Integration of various interfaces (Unix, Informatics and Database) for each integration layer.
• Involved in Integration testing for each layer.

Confidential

Project Manager

Responsibilities:

• Prioritization of production tickets assigned to our team
• Monitoring of project on regular basis and task allocation to each team member and monitor their progress.
• Coordination with business domain SME to understand ticket detail and preparing action plan to close these tickets.
• Prepare knowledge transition plan & perform knowledge transition for any new release.
• Identify all recurring abends on regular basis and provide solution to prevent these abends.
• Regular monitoring of project efforts and schedule against the planned efforts and take appropriate action if it does not match.
• Involved in project status meeting with Client/Onsite Project manager on weekly basis
• Identify all possible risks in the project and monitor these risks on regular basis.
• Change control process for new changes with respect to base lined document/Code.
• Conduct team meeting on daily basis to identify any issues and escalate it if required.
• Ensured the smooth delivery of each production ticket as per schedule and made sure that these deliverables are compliance to QMS process.

Confidential

Technical Architect/Project Manager

Responsibilities:

• Design generalized solution to support multiple customers on Izoom store application.
• Involved in ETL process design to load data from flat files to Oracle staging tables.
• Development Informatica mapping to load both fact and dimension tables.
• Performed Gap analysis to identify the gaps between requirements and data model.
• Design file validation process, error strategy process and automation of input file handling process in UNIX.
• Assist Data Architect to formulate suitable partition strategy to develop ETL process in PL/SQL from Oracle staging tables to Oracle ADW tables.
• Preparation of high level and low level design document for Unix process as well as Informatica ETL process
• Regular monitoring of project efforts and schedule against the planned efforts and take appropriate action if it does not match.
• Involved in project status meeting with Client/Onsite Project manager on weekly basis
• Identify all possible risks in the project and monitor these risks on regular basis.
• Resolution of all project related issues on priority basis
• Monitoring of project on regular basis and task allocation to each team member and monitor their progress.
• Change control process for new changes with respect to base lined document/Code.
• Conduct team meeting on daily basis to identify any issues and escalate it if required.
• Ensured the smooth delivery of each project deliverable as per schedule and made sure that these deliverables are compliance to QMS process.

Confidential

Project Manager

Responsibilities:

• Understand the entire factory approach model and different aspect of it.
• Involved in detailed analysis of 35 technical specifications and prepare detailed query tracking sheet (QTS) for each technical specification.
• Analysis of these specifications and provide the solution to ELT team.
• Send these QTS to Gate leader and resolved it on priority basis
• Involved in efforts estimation required to develop and test all build components in the technical specification.
• Schedule a regular meeting with Gate bosses to provide answers to their queries on effort estimation
• Prepared Gate 1-3 work order for each technical specification.
• If more than 1 build components are to be developed within a technical specification then for each build component will have a separate work order
• Coordination with Onsite team and offshore team.
• Monitoring of project on regular basis and task allocation to each team member and monitor their progress.
• Conduct training on Data Stage to team.
• Assist team to prepare test plan, test cases, check list and work order as part of deliverables in Gate 4 process.
• Involved in Integration of various data stage components i.e. DataStage code and Unix shell script
• Participate in daily project status review meeting with senior management to identify/anticipate project related issues and plan appropriate action to resolve/mitigate them.
• Resolve all DataStage and database related technical queries of development Involved in offshore development setup
• Involved in review of data stage code and performance improvement of these code.