SUMMARY:

• Designed technical processes as a Technical Manager by using internal modeling and working with analytical teams to gather requirements and create specifications.
• Lead a team of 6 - 9 data integration team members to achieve success in design, development and deployment activities.
• Helping to formulate estimates and timelines for project activities and setting related goals.
• Managed all aspects of the SDLC process - requirement analysis, time estimates, functional specification, design, development, testing, packaging, and support/maintenance.
• Expertise in data integration solutions over a wide range of platforms and delivery methodologies.
• Proven ability in defining goals, coordinating teams and achieving results.

TECHNICAL SKILLS:

BI Tools: Tableau, Cognos

Databases: Teradata, Oracle, Netzilla, SQL Server, MySQL, DB2, Hadoop

Modeling Tools: ERWin, VISIO

ETL Tools: Informatica, Talend, BODS, DataStage, IBM Info Server, SSIS

Programming Languages: SQL, Java, Visual Basic, XML, HTML, R language

Website Analytics: Omniture Site Catalyst

Industry Experience: Retail, Healthcare, Insurance, Manufacturing, Education, Banking and Government

PROFESSIONAL EXPERIENCE:

Confidential

Senior BI/ETL Architect

Technologies: Teradata 14, Teradata BTEQ, Teradata RDM, Informatica 9, Tableau, and Windows.

• Provided leadership and direction to project team by understanding business processes, gathering requirements, identifying potential usability issues, managing scope, and ensuring that an appropriate level of application quality was maintained at all times.
• Architected and designed end to end process for ETL Process in Informatica and Teradata.
• Responsible for translating complex analytics into terms that business users can easily understand.
• Responsible for Assigning task and Prioritizing tasks for ETL and Semantic team.
• Provide direction to the developers when needed
• Enforcing project processes and policies.
• Participating in the weekly Technical Integration Working Group meetings
• Coordinated several different towers within Unilever for Capacity planning, User Access, Performance tuning, Scheduling and Releases.
• Extensive documentation on the design, development, implementation, daily loads and process flow of the workflow in Teradata.

Senior BI/ETL Architect

Technologies: Teradata 14, Microstrategy, Informatica 9.6.1, Visio 13, UNIX and Windows.

• Provided technical leadership to project team by design the ETL architecture, gathering requirements, design ETL process and workflows and managing scope.
• Acting as a technical mentor for developers.
• Manage a team of senior engineers and contractors to implement the key components of the Teradata HR system according to specifications
• Helping to formulate estimates and timelines for project activities and setting related goals
• Acting as a technical mentor for developers
• Introduced the use of advanced software development techniques such as Informatica Mapping design using VISIO, code reviews, and unit test plan and Integration test plan for development.
• Completing a weekly status report for the Client.
• Responsible for key architecture decisions
• Extensive documentation on the design, development, implementation, daily loads and process flow of the workflow in Informatica.

Senior BI/ETL Architect

Technologies:TD Cloud, Informatica Power Center, Informatica Power Exchange, Omniture, Teradata 14, AIX UNIX and Windows.

Role Description:

• Provided technical leadership and direction to project team by design the ETL architecture, gathering requirements, design ETL process and workflows and managing scope.
• Responsible for ETL design, Coding, Unit Test, Integration test, Workflow dependency from source to target for all the subject area.
• Provide leadership and mentoring to ETL Developers.
• Enforcing project processes and policies and Prioritizing tasks
• Created mappings, sessions and workflows for incremental load into staging tables and scheduled them to run daily.
• Investigate Data sources, Design System Solution; write specification for project coding and unit testing.
• Completing a weekly status report for the project manager
• Develop Semantic and Shell scripts for web data processing.

Senior BI/ETL Architect

Technologies:Informatica 9.1, Zycus, Teradata Multiload, Teradata 14 Database, Linux and Windows.

Role Description:

• Architected and designed end to end process automation for creating Zycus template using Informatica and Teradata
• Helping to formulate estimates and timelines for project activities and setting related goals
• Acting as a technical mentor for developers
• Manage a team of senior engineers and contractors to implement the key components of the product according to specifications
• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Involved in meetings with key stakeholders of the business and discussed on strategies and roadmaps for creating Zycus template.
• Involved in finalizing Teradata Database Architecture for Zycus template.
• Provided ETL specification documents and methods for tracking flow of data from source systems to target

Senior BI/ETL Architect

Technologies:TD Cloud, Microstrategy, Teradata 14, Teradata Multiload, Teradata BTEQ, Teradata 14 Database, Linux and Windows.

• Provided solutions and strategies in the areas of analytics and big data space.
• Responsible for translating complex analytics into terms that business users can easily understand.
• Analyzing Could requirements and designing and developing BTEQ and Multi-Load Scripts
• Mentoring and Leading Offshore TD Cloud Team.
• Providing ETL specification documents and methods for tracking flow of data from source systems to target

ETL Architect

Technologies: DataStage, Cognos, SQL Server 2005, Oracle 11g, UNIX and Windows

• Analyzed ETL requirements; designed and developed ETL jobs/mappings using DataStage for MDR
• Provided ETL specification documents and methods for tracking flow of data from source systems to target
• Developed jobs, sequences, and scripts to execute jobs in DataStage
• Created partitions in DataStage jobs and in the Oracle database as part of performance optimizations that were also applied on the indexes to ensure faster execution of queries from ad hoc reports

Manger of offshore and onsite testing team

Technologies:Teradata 12, SAS, Rational Quality Manager, SoapUI, Window

• Coordinated several different departments within WellPoint to define MSCP UI testing requirements
• Took responsibility of testing with SoapUI web service by giving input and checking for expected output
• Issues were raised during SIT on issue trackers; testing cycles continued until all issues were closed
• Tuned most problems using Teradata specific techniques
• Formulated a performance optimization strategy and presented strategy to management

ETL Architect

Technologies:eScholar, SQL Server 2005, SSIS, Cognos 8 and Windows

• Architected and designed ETL module using SQL Server Integration Service
• Configured eScholar Data warehouse tool and data profiling
• Developed SSIS packages which generated sources CSV files for eScholar Data warehouse
• Optimized SQL Server database for faster retrieval of reports
• Ensured ETL specification documents could be traced back successfully to the requirements defined by Iowa Department of Education.

ETL Lead

Technologies:DataStage 7.5, Cognos 8, SQL Server 2005, Oracle 10g, UNIX and Windows.

Role Description:

• Analyzed ETL requirements and developed ETL jobs/Mappings using DataStage 7.5
• Provided ETL specification documents and methods for tracking flow of data from source systems to target
• Ensured ETL specification documents could be traced back successfully to the requirements defined by Department of Education
• Developed jobs, sequences, and scripts to execute jobs in DataStage
• Created partitions in DataStage jobs and in the Oracle database as part of performance optimizing and applied partitions on the indexes to ensure faster running of queries from ad hoc reports

Confidential

ETL Lead

Technologies: IBM Information Server, SQL Server 2005, Oracle 10g, UNIX and Windows.

• Analyzed ETL requirements and develops ETL jobs/mappings using IBM Information Server
• Provided ETL specification documents and methods for tracking flow of data from source systems to target
• Developed jobs, sequences, and scripts in DataStage
• Took initiative to partition the jobs and target tables which resulted in faster loading of data into the target database

ETL Lead/Developer

Technologies:Oracle9i, Informatica 6.2, Microstrategy 7, UNIX and Windows

• Analyzed ETL requirements and develops ETL jobs/Mappings using Informatica 6.2
• Integrated the First Logic with Informatica 6.2 which is used for data cleansing and data profiling
• Provided ETL specification documents and methods for tracking flow of data from source systems to target
• Created new mappings using Informatica 6.2 and modified existing mappings, mapplets, and workflow based on new functional specifications to meet business requirements
• Took initiative to partition the jobs and target tables this resulted in faster loading of data into the target database
• Wrote batch scripts which took regular backup of workflow logs and session logs
• Upgraded Informatica 6.2 to Informatica 7.1.2

Confidential

ETL Lead/Developer

Technologies:Oracle9i, Informatica 6.2, Microstrategy 7, and Windows

• Designed the data model and development of mapping for initial data load and delta load using Informatica
• Converted Escrow and non-Escrow cycle Business logic to mappings
• Optimized the workflow using partitions in sessions

ETL Lead/Developer

Technologies:1032 Mainframe, Oracle 9i, Informatica and Windows

• Played key role in data profiling, design and implementation of a business-driven dimensional data warehouse model that is optimized to the reporting needs of several data sources
• GAP analysis in the existing disclosure system vs. 1032 mainframe
• Integrated BCRA rules to existing disclosure system
• Designed the data model and developed mapping for initial data load and delta load using Informatica
• Upgraded Informatica repository from 4.7 to 6.2
• Reviewed referential historical integrity of DW data, validated all mappings/sessions and optimized existing mapping of dimensional and fact tables
• Constructed test plans for mappings/sessions, batches, pre/post processing scripts and executables
• Tested mapping, sessions, batch pre/post processing scripts and executables

ETL Developer

Technologies:Oracle9i, Informatica 4.7 and Windows

• Created star-schema model that integrated and transformed data received from operational systems and the central Data Warehouse
• Designed Informatica mappings, sessions, batches, refresh strategies, procedures, and pre/post batch processing
• Reviewed and validated referential and historical integrity of DW data
• Designed and developed multidimensional cubes

Project Manager

Technologies:JAVA, PHP, MYSQL, Linux

• Website architectural design, content management, set up and maintenance of multiple replication servers, database design, administration and hot/cold system backups.

Developer

Technologies:Oracle 8i, JAVA

• Database Analysis, Design, Implementation, Administration and stored procedures
• Set up replication servers and OLAP services; developed stored procedures; designed and conducted hot/cold system backups

Confidential

Developer

Technologies:IBM ES9000, 3090, DB2, CICS JCL, Oracle

• Systems and database design, analysis, implementation and administration
• Maintenance and management of multiple Oracle applications and replication servers
• Planned storage requirements and application table spaces
• Ensured data recoverability by database synchronization and backup strategies
• Designed inventory tracking system and purchase activity management system
• Customized user level security features
• Designed hot/cold backup strategy
• Created individualized, user-specific menus based on privilege sets
• Customized user defined IBM Mainframe ISPF panels
• Designed end-user screens in CICS (IBM Mainframe)
• Created and optimized DB2 tables
• Created sub modules in Cobol