SUMMARY:

• Anand is a senior ETL /Data warehouse(DWH)/Business Intelligence(BI) architect wif more TEMPthan 17 years of experience in Information Management Practice in helping clients align IT strategies wif corporate strategic across all departments, divisions, and locations. Anand TEMPhas acquired expertise includes Data warehouse architecture, data modeling, Data Integration, ETL framework, Designing OLAP/Dimensional models, data migration, Developing and Implementing ETL solutions on multiple database platforms and operating system environments using today’s cutting edge technology. He TEMPhas been instrumental in implementing many end - to-end turnkey data warehouse project.
• Anand TEMPhas also significant experience on various BI assessment projects to layout BI roadmaps and evaluate BI tools for diverse BI area.
• He TEMPhas acquired a comprehensive grasp on various technologies applied to data Warehousing project like Teradata, Informatica, IBM DataStage, PostgreSQL, Cognos, Business Objects, OBIEE, Tableau, ERWIN, ER Studio, Oracle PL-SQL, Greenplum, and ParAccel etc. His technical Knowledge is complemented wif function domain knowledge in Mortgage, Retail, Insurance, Finance and manufacturing.
• Define ETL Architecture and Framework
• Understand Metadata, and Design end-to-end ETL process flow.
• Analyze data-related systems integration opportunities and challenges.
• Validate data models from Data Integration perspective.
• Drive teh improvement of data quality and practices related to data integration.
• Optimal use of various data Integration technique.
• Translate business requirements into technical requirement & determine appropriate data warehouse solutions and data needs
• Source system analysis and data profiling.
• Define and build conceptual and logical data model.
• Confirm database requirements by communicating wif internal team
• Develop documentation and processes for data standards and best practices
• Act as a Subject Matter Expert (SME) for teh core areas wifin teh EDW environment
• Translate dashboard/reporting requirement to appropriate BI solutions and data needs
• Architect and design semantic layers to support both ad-hoc/canned reports as well dashboards.
• Design robust BI strategy and road-map to support future needs.
• Facilitate business to choose appropriate BI tools.
• Develop documentation and processes for data standards and best practices
• Project planning, scoping, effort estimation, tracking Client communication & presentation.
• Interacting wif and guiding team members to ensure smooth progress of project work.
• Implementation of project plans wifin pre-set budgets and deadlines.

TECHNICAL SKILLS:

• IBM Infosphare DatatStage 8.5/ IBM DatatStage 8.1/ Ascential DataStage 7.5.2,
• Informatica Powercenter 9.1/8.6/7.1.3/6.2, PL/SQL, BODS 4.2
• Cognos 8.4, OBIEE, Tableau 8.1,, Business Objects 6.2,
• Oracle 12c/11g/10g, Teradata 13/12/2.5, SQL Server 2010/2005, PostgreSQL 8.4, Greenplum 4.0, Netezza 6.0, ParAccel 4.0
• Erwin 9.5/8.4/7.0, ER Studio 8.1
• IBM InfoSphere CDC 6.3, Information Analyzer
• UNIX (AIX, Solaris), Windows XP/NT/98/95
• Microsoft Project 2000, Microsoft VISIO
• Cleracase, Microsoft VSS, Subversion

PROFESSIONAL EXPERIENCE:

Senior Technical (BI/DWH) Architect

Confidential, San Francisco, CA

Technology: Oracle 11g, BODS 4.2, ERWIN 8.0, Oracle SQL

Responsibilities:

• Work wif Client Data Architecture team to design Integrated Data Store (IDS) using Party Based data model for each subject area i.e. Claims, Provider, Capitation, fee etc.
• Understand source system data and define relationship across various entities and modelled them using Party based entities
• Conceptualized and Design of Logical model of ADM (Actuarial Data Mart) and Marketing Data marts.
• Design and develop both Logical and Physical data model using ERWIN for both IDS and Data marts.
• Work wif ETL Architecture team to define business rule and source data mapping.
• Architect and design Indexing as well as partitioning strategy
• Development of ETL process using Oracle PL/SQL.
• Assist development team to optimize BODS ETL jobs
• Understand business problem and provide technical solution to address on day-to-day basis to offshore team

Confidential, Bethesda, MD

ETL Architect

Technology: Oracle 11g, Oracle PL/SQL, ParAccel (MPP Database), PostgreSQL 8.4, Informatica 9.1, ER Studio 9.5, Tableau 8.1, Oracle SQL

Responsibilities:

• Conceptualized and Design of data mart using Oracle and ParAccel (PostgreSQL/MPP Database).
• Architecting ETL solution using Oracle PL/SQL, PostgreSQL and Java.
• Liaison wif Data Architect to make incremental changes on Logical as well as physical model using ER Studio.
• Architect and design distribution key and sort key on ParAccel database tables.
• Architect and design ETL process using ParAccel function and ParAccel Load Utility.
• Development of ETL process using Oracle PL/SQL.
• Design & development of Logical and Physical data model using ER Studio.
• Understand business problem and provide technical solution to address them using Oracle PL/SQL as well as ParAccel.
• Involved into day to day database development activities including writing functions, procedures, creating database objects on both Oracle as well as ParAccel.
• Design of operation dashboard as well as Ad-hoc report using Tableau 8.1.
• Coordinate wif Infrastructure team to set up ParAccel utility and configuration on multiple databases.
• Support interface Java team to address any ongoing database issues including performance improvement, optimal design.

Confidential, Shrewsbury,MA

ETL Technical Lead/ETL Architect

Technology: Informatica PowerCenter 8.6, IBM DataStage 8.5, Oracle 11g, Oracle SQL

Responsibilities:

• Define ETL conversion strategy to move legacy Informatica ETL into IBM DataStage.
• Liaison wif Data Architect to architect and define tactical solution.
• Understand current Informatica ETL process (Around mappings) to architect and design new ETL process.
• Enhancement of existing Informatica mapping job as well as coding of new Informatica mapping as and when required.
• Design & Development of IBM DataStage job & Oracle SQL script to create data extract feed to Stage and Mart area respectively.
• Liaison wif Informatica ETL manager to understand and confirm teh business rule.
• Create technical mapping specification document for downstream feed.
• Prepare testing criteria and write test scripts to validate new IBM DataStage job.
• Design and development end-to-end process flow using DataStage, Oracle scripts and Control-M for stage as well as mart area.
• Coordinate wif Offshore team on day-to-day basic to resolve any pending issue as well as overall technical consultation.

Confidential, Richardson, TX

Teradata/ETL Designer

Technology: IBM DataStage 8.5, Teradata 13, Unix Shell Script, Zena Schedular

Responsibilities:

• Architect and design isolated data mart using Teradata to support business requirement.
• Design & Development of DataStage & Teradata script to create data extract feed for downstream third party clients to support enterprise reporting need.
• Design and develop ETL load process using Teradata SQL, Mload, FastExport and FastLoad load utility.
• Extensive and optimal use of volatile tables while building Teradata SQL code.
• Liaison wif Business Analyst to understand and confirm teh business rule.
• Create technical mapping specification document for downstream feed.
• Design and build set of Unix shell scripts to support control file creation, file count verification and regular housekeeping work.
• Design and development end-to-end process flow using DataStage, Teradata and Unix scripts.
• Design customer scheduling script using ASG-Zena Schedular to automate entire ETL.
• Collaborate wif Business Analyst to confirm and consolidate all business requirements for downstream feed.

Confidential, Chelmsford, MA

BI Architect/Tech Lead

Technology: Cognos 8.4, Informatica Powercenter 8.6, Oracle 10g

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 teh complete BI dashboard along wif 20+ BI report ( List, Crosstab, Chart)
• Design and developed Informatica Mappings to build teh relevant fact table
• Design and develop underlying Fact and Dimension tables to support dashboard requirements.
• Involved in architecting teh solution for proposed BI dashboard including leveraging existing Framework model, database tables
• Collaborate wif Business Analyst to confirm and consolidate all business requirements for BI Dashboard.
• Involved in creating technical documentation to facilitate better understanding of teh 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 teh query subjects and standardized teh query item to rename corresponding business name..

Confidential, Stamford, CT

ETL Architect

Technology: IBM InfoSphere DataStage 8.1, Teradata 12

Responsibilities:

• Study teh current source system and data structure
• Understand teh existing loading process
• Identify teh gaps in current loading process wif respect to achieve desirable performance
• Evaluate teh overall data warehouse size considering future growth
• Prepare and submit teh recommendation to achieve scalability and performance.
• Setting Environment variables, Parameters and creating Parameter sets to make teh jobs more flexible for development as well as debugging.
• Enhanced teh reusability of teh jobs by making and deploying shared containers and multiple instances of teh jobs.
• Involved in creating technical documentation to facilitate better understanding of teh process and in corporate changes as and when necessary.

Confidential, Framingham, MA

ETL Architect

Technology: IBM InfoSphere 8.5, Netezza 6, IBM InfoSphere CDD

Responsibilities:

• Design entire ETL framework and its components, setting up teh framework components to accommodate teh 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 teh source and teh target table to write teh changed data into teh file or teh table using teh direct connect.
• Closely coordinate wif Data architect group to design Enterprise Data warehouse and Data Marts.
• Design and develop process control model to make entire ETL process re-startable wif 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 teh jobs more flexible for development as well as debugging.
• Enhanced teh reusability of teh jobs by making and deploying shared containers and multiple instances of teh jobs.
• Involved in creating technical documentation to facilitate better understanding of teh process and in corporate changes as and when necessary.
• Assist InfoSphere admin to set up all InfoSphere products.

Confidential, La Palma, CA

DataStage Designer

Technology: IBM InfoSphere 8.1, Teradata 13/12, IBM InfoSphere CDC

Responsibilities:

• Setting up Change Data Capture (CDC) process for new Data Warehouse as part of teh 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 job to configure Teradata utility ‘TPT’ (Teradata Parallel Transponder) to support performance loading.
• Design teh Data Warehouse Staging layer using Teradata database features.
• Assist DBA to create and modify teh Teradata Stored Procedure
• 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 teh 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

Technology: Ascential DataStage 7.5, GreenPlum 4.0, Teradata 12, BusinessObjects 6.2

Responsibilities:

• Understand existing schedule reports along wif 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 teh data element from source system to reports.
• Analyze teh 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 wif concerned team to set up teh connectivity and infrastructure at offshore location at Mumbai, India.
• Coordinate wif resource manager for resource fulfillment and if required involved in screening & hiring process for project specific resource.

Confidential

ETL Architect/Data Architect/Delivery Manager

Technology: IBM WebSphere 8.0, SQL SERVER 2008/2005, BusinessObjects 6.2, Erwin 7.0

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 teh current EDW architecture.
• Design incremental load strategy to modify existing ETL process
• Design ETL to move data from source to staging area
• Identification of table needed for EDW
• Define and document teh data requirement. ( Corporate Data Repository)
• Design of 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 wif Business SMS to understand requirements and data.
• Participate in design discussion and review session wif 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 wif 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 teh proposal/Sow
• Coordinating wif Onsite project manager to facilitate all logistics for all onsite position.
• Coordinating wif Resource team to fulfillment on all open position wifin teh account.
• Coordinate wif project lead and project manager to raise change request whenever applicable.
• Coordinating wif Finance and billing team to raise invoice as per schedule
• Coordinating wif 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 teh dependencies across different subject area wifin 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 wif BI application manager to decide ETL work request priority wifin a release.
• Preparation of technical requirement document for any new work request.
• Coordinate wif Business team to decide priority on business work request

Confidential

Business System Analyst /Data Architect/ETL Architect

Technology: Informatica PowerCenter 8.1, Oracle 10g, OBIEE

Responsibilities:

• Assessment to check teh feasibility of these reports from EDW framework.
• Analysis of AS-IS data flow for all 13 reports
• Discuss and coordination wif Business SMS to consolidation of requirements and understand teh data.
• Identify teh dependencies across different subject area wifin 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 wif Client’ solution architect team.
• Design and development of Informatica 8.1 mappings to load data across each integration layer
• Design teh 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

Technology: Informatica PowerCenter 8, DB2 UDB

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 wif 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 teh planned efforts and take appropriate action if it does not match.
• Involved in project status meeting wif Client/Onsite Project manager on weekly basis
• Identify all possible risks in teh project and monitor these risks on regular basis.
• Change control process for new changes wif respect to base lined document/Code.
• Conduct team meeting on daily basis to identify any issues and escalate it if required.
• Ensured teh smooth delivery of each production ticket as per schedule and made sure that these deliverables are compliance to QMS process.

Confidential

ETL Architect/Project Manager

Technology: Informatica PowerCenter 8/7.3, Oracle 9i

Responsibilities:

• Design generalized solution to support multiple customers on Izoom store application.
• Define robust ETL framework to support all custom as well as generalized solution.
• Established ETL process to support re-startability as well as data recovery.
• Involved in ETL process design to load data from flat files to Oracle staging tables.
• Development of Informatica mapping to load both fact and dimension tables.
• Performed Gap analysis to identify teh 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 teh planned efforts and take appropriate action if it does not match.
• Involved in project status meeting wif Client/Onsite Project manager on weekly basis
• Identify all possible risks in teh 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 wif respect to base lined document/Code.
• Conduct team meeting on daily basis to identify any issues and escalate it if required.
• Ensured teh smooth delivery of each project deliverable as per schedule and made sure that these deliverables are compliance to QMS process.

Confidential

DataStage Architect/Project Manager

Technology: Ascential DataStage 7.5, Oracle 9i, Teradata 2.6

Responsibilities:

• Understand teh 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 teh 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 teh technical specification.
• Schedule a regular meeting wif Gate bosses to provide answers to their queries on effort estimation
• Prepared Gate 1-3 work order for each technical specification. If more TEMPthan 1 build components are to be developed wifin a technical specification then for each build component will have a separate work order
• Coordination wif Onsite team and offshore team.
• Monitoring of project on regular basis and task allocation to each team member and monitor their progress.
• Conduct 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 wif 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.

Confidential

Project Manager

Technology: Cognos Reportnet 7.1

Responsibilities:

• Involved in project status meeting wif Onsite coordinator on daily basis
• Involved in offshore development infrastructure setup
• 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.
• Participate in monthly project status review meeting wif senior management to identify/anticipate project related issues and plan appropriate action to resolve/mitigate them.
• Involved in discussion wif Client to finalize teh scope
• Involved in review of OLAP design and report layout wif team
• Review of OLAP design document

Confidential

ETL Architect/Project Manager

Technology: Informatica PowerCenter 7.3, DB2 UDB

Responsibilities:

• Involved in review of ETL design, technical architecture wif Technical lead and all ETL components.
• Involved in discussion wif Business user and understand teh actual business requirements
• Resolve all ETL and database related technical queries of development team and assist them to apply best practices in Informatica coding, unit testing and Integration testing.
• Involved in project status meeting wif Client/Onsite Project manager on weekly basis
• Pro-actively identify all possible issues and take appropriate action to track them to closure or mitigate these issues to have minimum impact on teh project.
• Monitoring of project on regular basis and task allocation to each team member and monitor their progress.
• Change control process for new changes wif respect to base lined document/Code.
• Participate in weekly project status review meeting wif senior management to identify/anticipate project related issues and plan appropriate action to resolve/mitigate them.
• Handle all Quality Management system processes including process audit, project management review, Internal and external quality process.
• Conduct team meeting on daily basis to identify any issues and escalate it if required.
• Involved in offshore development setup
• Involved in delivery of each project deliverable as per schedule and made sure that these deliverables are QMS process compliance.