SUMMARY:

• 10+ years of total IT experience in Data Warehousing/Business Intelligence systems, data migration and data integration projects.
• Extensive exposure to financial and medical industries teamed with business requirements analysis, application design, data modeling, development, testing and documentation.
• 8+ years of Data Warehousing experience using Informatica, Power Center 8.x/7.x/6.2, Power Connect, Power Exchange and Power Analyzer.
• 4+ years of dimensional and relational data modeling experience using Star Schema/Snowflake modeling, fact and dimension tables, physical and logical data modeling, OLTP, and OLAP systems.
• 8 years of analysis, development and testing Business Intelligence Systems
• 3+ years of experience working with reporting tools like Business Objects, Cognos and Power Analyzer. Also experienced with ERP systems PeopleSoft, SAP - HR, Finance, Sales, Banking Modules.
• 9+ years of database experience using Oracle 11g/10g/9i/8i/8.x/7.x, DB2, Teradata VR5/VR4, MS SQL Server 2000/2005/2008 , MS Access 7.0/’97/2000.
• Extensive knowledge and practice with SDLC-Waterfall, RAD, Spiral Model, JAD and agile methods. Involved in Software Testing Life Cycle, manual testing and Black Box testing. Created test cases and test plans. Participated in integration, regression, performance and system testing.
• Developed POFs, Design and technical documents. Worked with technical and business teams to design and impose best practice methods to build a quality system with greater system/data leveragability. Developed ETL standards, naming conventions and developments standards to enable greater process traceability and accountability.
• Extensively used metadata to monitor and analysis systems parameters. Further used that information for optimization and trouble shooting.
• Big picture thinker with proven ability to make intelligent trade-offs between technical efficiency, product quality, reliability, effort levels and financial parameters to deliver optimal system solutions for the business.
• Strong technical design, architecture, and programming skills, along with a desire to provide technical mentoring and growth for individual contributors. Continually seeks out relevant and applicable new technologies.
• Significant customer interaction, including involvement in requirements gathering, product usability studies and presentation of product features. Also presented project vision to technical and non-technical audiences. Played significant role in helping choose technologies and software tool sets to support the business needs.
• Managed development teams, on-site and off-shore, and maintained project development metrics. Motivated and directed teams to ensure project deliverables within estimated time and effort limitations. Estimated man hours, work effort levels and resource distribution. Also involved in cross-functional efforts.
• Very strong communication skills including both oral and written proficiency. Self-starter and highly motivated.

TECHNICAL SKILLS:

ETL: Informatica Power Center 9.x/8.X/ 7.1/7.0/6.2.1/6.2/ (Repository Manager, Designer, Server manager, Work Flow Monitor, Work Flow Manager), Power Connect, Power Exchange, PowerAnalyzer, Datamart, ETL, Control M, Oracle 11,10g/9.x/8.x/7.x, UNIX Shell Scripting.

Microsoft SSIS: Pantaho, Data Cleansing/Profiling Trillium v7.5,Informatica Data Explorer.

BI & Reporting: Power Analyzer5.0,4.0,Business Objects XI 11.x,Crystal reports,Webi,Deski,Congos Series 7.0/6.6,, Power play, Transformer, Impromptu Web Reports (IWR), Power Play Enterprise Server. Oracle Discoverer 10g.

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling, ER Diagrams, Erwin 4.0/3.5.2/2. x, Oracle Designer 2000, OLAP, ROLAP, MOLAP, OLTP

Databases: Oracle 11g/10g/9i/8i/8.0/7.3, MS SQL Server, IBM DB2 UDB, DB2/400, Teradata V2R5/V2R4, Sybase 12.0/11.x, PL/SQL, Developer 2000

Job Scheduling & Other tools: CA Autosys, BMC Control M, Cron Tab, Informatica scheduler, Toad, Microsoft Word, Excel, Access

Environment: UNIX (Sun Solaris, HP-UX, AIX), Windows, IBM AS400

Others: XML, HTML, DHTML, C, VBScript, SQL, Clarabridge

PROFESSIONAL EXPERIENCE:

Confidential, MN

ETL Architect-Sr.Developer

Responsibilities:

• Data and system integration for new business entities.
• Data Migration from RB4 to RB5 Consumer portal and Client
• Set up standards and protocols for best practice ETL process and error management for efficient process control and data accountability.
• Designed and implemented data traceability process and process recovery process with minimal turnaround time.
• Collaborated with key business users and technical team to design, develop and implement customer-centric solutions.
• Interacted with upstream teams to design and develop the new system adaptation.
• Incorporated new technique into the existing process to make it more efficient, reduce its complexity, and make it easier to handle and break fix.
• Suggested improvements to the existing documentation templates for ETL process and scripts.
• Streamlined the workflows and sessions with respect to the available system resources and job priorities.

Environment: Pentaho PDI, MySQL, PL/SQL, SQL*Plus, TOAD,JSON, Linux, Gems scripting, Groovy scripting,Python.

Confidential, MN

Informatica ETL Architect-Developer

Responsibilities:

• Performed process analysis to evaluate the quality and resource consumption for existing process.
• Identified and analyzed issues and complex process areas and their impact levels on system failure. Designed backup and recovery plans to minimize the impact.
• Responsible for the design and execution of all phases of SDLC process for this interface project.
• Worked with the users and business analysts and Interface Leads
• Involved in the design and execution of all phases of SDLC process.
• Collaborated with key business users and technical team to design, develop and implement migrating and data relation translations solutions.
• Defined the ETL and process executing strategy.
• Developed data transformation for all ADP modules.
• Performed risk assessment and identified potential risks and issues. Report appropriately to managers. Took a Proactive approach to identify potential loop hole, bugs and weak process and data quality designs and code.
• Provided technical coaching to business functions and lower-level data analysts on moderately complex issues.

Environment: Informatica Power Center 9.x, Oracle 10g, PL/SQL, SQL*Plus, TOAD, SQL Developer, XML, Unix

Confidential, MN

Informatica ETL- Sr .Developer

Responsibilities:

• Responsible for business analysis and requirements collection
• Deign and developed Payroll and customers case management modules.
• Used Informatica and SSIS integration tool set to migrate data across systems.
• Used Kingsway Soft module to load data in to Microsoft CRM
• Extensively used stored procedures
• Performed extensive data analysis to archive high level of accuracy for all billing amounts and data.

Environment: Informatica Power Center 9.x,SQL Server, SSIS, PL/SQL, SQL*Plus, TOAD,SQL Developer, Kingsway Soft

Confidential, MN

Informatica ETL Architect-Developer

Responsibilities:

• Design and building new schemas using ERWIN.
• Designed ETL process to the upgrade and support additions functionality.
• Design and built ETL process, with multiple source system.
• Worked extensively with business user to align the data and relationship.
• Performed unit testing and support testing team to test complex part of the system integration.
• Worked through testing scenarios, release plans and deployment plans.

Environment: Informatica Power Center 9.x, Oracle 10g, PL/SQL, SQL*Plus, TOAD, SQL Developer,XML, Unix

Confidential, St.Paul, MN

Informatica ETL Architect-Developer

Responsibilities:

• Architect, design and build myService E-Business Service Suite application modules for Australia and New Zealand enterprise initiations.
• Developed POCs, Design and technical documents. Work with technical and business teams to design and impose best practice methods to build a quality system with greater system/data leveragability. Develop ETL standards, naming conventions and developments standards to enable greater process traceability and accountability.
• Production Support and enhancement of myService E-Business Service Suite Modules and providing the solutions to the users.
• Responsible for developing new interfaces, modifying workflows and reports, fixing issues and provide solutions for User requests and bugs.
• Extensive usage of Microsoft Technologies, Informatica tool sets, Reporting tools-Crystal, Database Administration and BI Admin Tool along with the UNIX shell scripting, UC4, Sql/PlSql code.
• Making test cases, testing custom extensions and making changes in the customization to suit the business needs for Service Contract.
• Working closely with off-shore teams of the project for pre and post development (business teams/Functional team). Providing immediate support to the customer or project team on ad hoc basic though mail or phone.

Environment: Informatica Power Center 8.x,Oracle 10g, SQL Server 2005, PL/SQL, SQL*Plus, TOAD,SQL Developer,XML, Unix,SFTP,Oracle Discoverer

Confidential, MN

Tech Lead-Developer

Responsibilities:

• Set up standards and protocols for best practice ETL process and error management for efficient process control and data accountability.
• Set up Informatica admin standard and protocols.
• Designed and implemented data traceability process and process recovery process with minimal turnaround time.
• Technical lead for Billing & Receipting system conversion project. In house billing system to an external vendor system (SBC).
• Extensively worked with cross function teams and business units.
• Actively involved in testing
• Designed and implemented data quality layers and process to control and improve data relations and quality.
• Worked with Informatica, SSIS, stored procs to create ETL and data flow logics.

Environment: Informatica Power Center 9.x,SQL Server 2008, SSIS, PL/SQL,T-SQL,, Windows 2008,SSRS.

Confidential, MN

Informatica ETL Lead-Developer

Responsibilities:

• Informatica upgrade/migration - installation and setup environments from Ver 8.6 to Ver 9.1.
• Installed and setup MetaData Manager and Reporting service environment.
• Set up standards and protocols for best practice ETL process and error management, for efficient process control and data accountability.
• Design and architected ETL process and data quality process for Profitable Revenue Optimization - Analytics project.
• Participated on MDM tool evaluation and scale effectiveness to the current business process and data requirements. Provided business with feedback reports and recommendations with vendor/tool selection.
• Analyzed existing ETL process to understand the driving factor and core action of high business value. Identified loop holes and designed fixes.
• Designed, built and test Informatica workflows, sessions, mappings. Helped testing team to create test cases for effective testing.
• Set up enterprise standards for ETP process, code and data quality/ accountably protocol for a controlled, effective and efficient ETL work environment.
• Scheduled, planed and managed the development and testing of ETL interfaces with a strong delivery focus.
• Performed risk assessment and identified potential risks and issues. Report appropriately to managers. Took a Proactive approach to identify potential loop hole, bugs and weak process and data quality designs and code.
• Provided technical coaching to business functions and lower-level data analysts on moderately complex issues.
• Developed documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Environment: Informatica Power Center 8.x, 9.x,SQL Server 2008, PL/SQL,T-SQL,TOAD,SQL,Fload,XML,, Windows 2008,Metadata Manager, Jasper Reporting.

Confidential, MN

Informatica ETL Architect-Developer

Responsibilities:

• Business analysis and requirements collection, interacted with the users and business analysts to gather requirements.
• Analyzed current ECC system to identify various data leverage point in the system and the data flow process.
• Did extensive data analysis to understand the system and the usability to address the current project scope with involved effort, accuracy and inter dependencies.
• Designed and developed integrated data flow system that leverage the legacy data system and a 3rd party vendor data system.
• Architected the data model to layer data for best insight without loosening granulate. Extensively worked with 3rd party tool set- Clarabridge.
• Lead the effort for detailed design, development and implementation of Informatica mappings, work flows and support procedures.
• Data modeled ECC metric framework and built a foundation data model and data set to help with existing reporting universes.
• Extensively worked with Teradata.
• Collaborated with key business users and technical team to design, develop and implement customer-centric solutions.
• Created and scheduled jobs according to the requirements.
• Developed documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Environment: Informatica Power Center 8.x, 9.x,Clarabridge, Oracle 10g,Teradata TeradataSQLassistant,PL/SQL,T-SQL,TOAD,SQL,Fload,Developer,XML, Unix,SFTP,Oracle Discoverer,Unix.

Confidential, MN

Informatica ETL Architect-Developer

Responsibilities:

• Analyzed the existing ETL process to understand the driving factor and core action of high business value.
• Interacted with various team to understand there requirement and priorities.
• Did extensive analysis of the whole control and data flow to understand the bottle necks and weak joint in the process stream.
• Designed and developed a throttling system address the monitoring and control of packages and work flows issued.
• Incorporated custom techniques to create a virtual dynamic allotment of resources based on priority and business vales.
• Extensively worked with JMS queues, XML and B2B tool set.
• Built ETL process using SSIS(packages) and Informatica(workflows).
• Developed stored procedures, advanced queries, triggers, views, and indexes by using SQL (Oracle) as per requirement.
• Created Jobs and scheduled jobs according to the requirements.
• Developed documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Environment: Informatica Power Center 8.x,Oracle 10g,PL/SQL,T-SQL, TOAD,SQL Developer,XML, Unix,SFTP,Oracle Discoverer,SUSE Linux Enterprise Server 10.

Confidential, Confidential, MN

Principal Data Analyst/Lead Informatica ETL Architect

Responsibilities:

• Build interface process for data acquisition from heterogeneous system to an existing downstream system.
• Coordinate and interact with appropriate teams on defects, changes, issues and enhancements that may impact development, data, workflow and/or functionality.
• Translate business requirements into technical requirements.
• Conduct extensive data analysis related to the business needs and confirm the accuracy of the data in terms of quality and functionality.
• Provide constant input into project plans.
• Interacted with upstream teams to design and develop the new system adaptation.
• Incorporated new technique into the existing process to make it more efficient, reduce its complexity, and make it easier to handle and break fix.
• Suggested improvements to the existing documentation templates for ETL process and scripts.
• Streamlined the workflows and sessions with respect to the available system resources and job priorities.
• Unit testing and assisted in building system plans to accurately test critical processes of the system.
• Documented all the developed interfaces, design and technical documents, and transformations, Mapplets, Mappings, Sessions and Workflows

Environment: Informatica Power Center 8.x,Oracle 10g, SQL Server 2005, PL/SQL, SQL*Plus, TOAD,SQL Developer,XML, Unix,SFTP,Oracle Discoverer

Confidential, MN

Principle Data Analyst/Lead Informatica ETL Architect

Responsibilities:

• Designed and implemented new data structures and process methods to support the new business requirements, which included process enhancements, data managements and performance tuning.
• Continuously reviewed/analyzed data loaded into the data warehouse for accuracy and provided solutions for enhancing data accuracy and data processing performance.
• Mapped the client-business realities to a mode-driven architecture, and then built a data integration solution that addresses the client data reporting needs.
• Managed, monitored and administered database and system performance, including optimization and tuning of data loads, extractions and recommending appropriate procedure, query or package changes and optimizations to ensure and improve system performance and reliability.
• Maintained data warehouse data dictionary, data modeling diagrams and report data definitions pertaining to the business application
• Supported the existing data warehouse business layer, star schemas and reports for business users using oracle reports.
• Worked with ETL developers and data analysts to identify design and implemented solutions for extraction and integration of data to and from data warehouses and data marts for the purposes of reporting, decision support and analysis.
• Work with BI team to develop a complete analytics solution for Financial Advisors from gathering requirements, prototyping, building universes and repositories, reports and dashboards, testing and deployment.
• Excellent analytical skills and the ability to integrate information from multiple sources to execute effectively and efficiently in a dynamic environment.
• Worked with the Data Warehouse and Decision Support teams to evaluate data sources, define business rules, design summary/aggregation structures for performance and ensure integrity and security of data and information usage.
• Performed audits, provided capacity planning requirements, and other data environment optimization technical recommendations as needed.
• Translated analytical needs for the enterprise and worked on designing, developing and sustaining the architecture of the enterprise data warehouse and data marts.
• Strong understanding of determining proficient execution plans.
• Strong knowledge of Data Warehousing methodologies and concepts, including and not limited to: star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Used a proactive approach in order to address problems and solutions.
• Experience working with Development, QA, and Production Teams.
• Complied with all applicable laws, rules and regulations, the company’s policies, and FDA regulations and compliance.
• Provided technical coaching to business functions and lower-level data analysts on moderately complex issues.
• Created process documents for the administration and troubleshooting of the reporting infrastructure
• Provided off hours on-call support to resolve production issues.
• Developed test scripts and testing plans to test data warehouse, data integrity, application and reports.
• Performed additional job duties as required.

Environment: Informatica Power Center 8.x,Oracle 10g/9i, SQL, PL/SQL, SQL*Plus, TOAD,SQL Developer,XML, Unix, SQL Server,SQL Query Analyzer, Power Exchange, Business Objects - Crystal, DESKi, WEBi reports.

Confidential, MN

Sr.Data Analyst/ Informatica ETL Lead/Architect

Responsibilities:

• Performed process analysis to evaluate the quality and resource consumption for existing process. Identified and analyzed issues and complex process areas and their impact levels on system failure. Designed backup and recovery plans to minimize the impact.
• Altered the enterprise data mart to support new functionalities and features initiated in the BI applications.
• Participated in the data modeling design for OLTP systems.
• Worked with business analysts and customers to understand the key business drivers behind data requests. Worked closely in collaborative efforts with team members in the Business Information, Strategic Data Services and other technology and business groups.
• Installed PowerCenter and created test and development environments to support future project initiations.
• Installed Power Exchange, Power Analyzer test and development environments
• Performed upgrading of the BI reports system from PowerAnalyzer 4.0 to PowerAnalyzer 5.0.
• Set up Power Center and Power Analyzer canned metadata reporting and also created custom metadata reporting to analyze and monitor the enterprise data warehouse and BI environments.
• Made design alteration and process clean up for the BI reporting system prior to migration to new environment and system
• Redefines ETL process quality standards and created document standards and templates.
• Did extensive performance tuning at various levels of the ETL process to optimize process time, cost and resources.
• Scheduled, planed and managed the development and testing of ETL interfaces with a strong delivery focus.
• Performed risk assessment and identified potential risks and issues. Report appropriately to higher manager.
• Written technical documentation for all undertaken projects, software upgrades and migrations.
• Presented complex technical design topics to a non-technical audience of managers/project sponsors.
• Manage a team to ensure it delivers the target objectives within time and effort hours limitations.
• Work closely and helped others members in a team-based environment.
• Estimated man-hours, work efforts and resources required for the ETL development tasks.
• Managed and distributed work efforts among the team members based on individual skills and expertise for optimal project productivity.
• Served as a mentor to less experienced developers.

Environment: Informatica Power Center 8.x,Oracle 10g/9i, SQL, PL/SQL, SQL*Plus, TOAD,SQL Developer, XML, Windows NT 4.0,, Scripting.IBM MVS,SQL Server, SQL Query Analyzer, TOAD Power Analyzer 5.0,4.0, Power Exchange 5.0,Informatica Data Explorer.

Confidential, MN

Sr. Software Engineer /Sr.Informatica ETL Architect

Responsibilities:

• Business analysis and requirements collection interacted with the users and business analysts to gather the requirements.
• Involved in the design and execution of all phases of SDLC process.
• Collaborated with key business users and technical team to design, develop and implement customer-centric solutions.
• Defined the ETL strategy for Data Warehouse population.
• Extensively worked with data modelers in designing of the data marts and DB schemas to optimal support ETL loads.
• Worked in coordination with the data molders to design and support OLAP (1st project), OLTP (2nd Project) system.
• Participated in design reviews to make recommendations on performance, architecture and fault tolerance throughout the project.
• Lead the effort for detailed design, development and implementation of Informatica mappings, work flows and support procedures.
• Assist with designing and writing scripts to prepare data to be loaded into a data warehouse.
• Used Informatica Tool set to map data from SAP modules. SS,MM Modules.
• Created reusable ETL components and maintenance of ETL mappings. Automated the ETL process through scheduling and exception routines.
• Implemented performance tuning, performance testing and optimization of existing processes.
• Improved user productivity by means of automating the data feeds.
• Performed repository administration tasks (creating repositories, users, assigning privileges, creating backups and recovery).
• Involved as architect and technical advisor for various other projects.
• Documented all the developed interfaces, transformations, Mapplets, Mappings, sessions and workflows.
• Extensively worked with testing teams to design and implement test cases, specifically for critical modules of the project. Also supported the testers for each process run through.
• Coordinated with reporting team to design and implement the reporting environment for best performance, analyzing factors like frequency, resultant data set, priority, response time, resource availability, server usage, etc.
• Designed, developed and tested POCs. Also presented to a wide variety of audiences, including development teams and partners within the business unit.
• Generated innovative and dynamic cost effective approaches and solutions to technology challenges. Received peer recognition for these achievements.

Environment: Informatica Power Center 8.x,7.1,Informatica Power Connect. Oracle 10g/9i, SQL, PL/SQL, GLOBAL TEMP Tables, SQL*Plus, TOAD,SQL Developer, XML, XML parsing, Windows NT 4.0,, Unix Shell Scripting. IBM AS400 - OS400-DB2, SQL Server, SQL Query Analyzer, Cognos, CA Autosys,SAP- SD,MM modules.

Confidential, NYC

Software Engineer / Informatica Developer

Responsibilities:

• Responsible for the design and execution of all phases of SDLC process for this interface project.
• Created interface workflows between various legacy systems.
• Involved in designing thearchitecture of data systems to support wide range of functional departments across the enterprise.
• Collaborate with architects and technical leads on design validation and decisions.
• Extensively worked on B2B Data Transformation model.
• Worked exclusively on PWC Tax Compliance modules. Developed interfaces for the existing database systems to the PWC modules-database. Also worked on validation and updating of the TAX Database.
• Extensively worked with Informatica 7.1.3, Oracle 10g, Sql Server, and Flat Files.
• Developed complex Mapping, sessions, workflows using Informatica Mapping Designer, Workflow Manager.
• Performed performance tuning, unit testing, and volume testing for data loads.
• Tuned ETL, SQL and L/SQL queries for optimal performance.
• Used Teradata SQL Assistant, Fast Export, Multiload, Fast Load, Bteq, and Tpump.
• Applied Teradata and Informatica Performance Tuning techniques to optimize.
• Coordinated with reporting teams to design and build BO Universe and reports.
• Involved in cleansing of data by using Trillium Quality and Discovery tools
• Used core concepts and widely practiced techniques for mapping design and fine tune the workflows for optimum performance.
• Coordinated with business users and DBA’s to develop the design and architecture of the database required for the data movement for the interface development.
• Created UNIX scripts to conditionally validate the session and performed required actions.
• Streamlined the workflows and sessions with respect to the available system resources and job priorities.
• Involved in automation of workflows using Control M.
• Worked on upgrading standards for naming convention used.
• Documented all the developed interfaces, transformations, Mapplets, Mappings, sessions and workflows.
• Acted as production support. Identified software bugs and solved complex problems independently.
• Developed modules for end-user on MS Access and MS Excel for validation purposes and minimal data manipulation and updating.
• Involved in knowledge transfer to FTE.

Environment: Informatica Power Center 7.1,Ascential, Control M,Oracle 10g/9i, SQL, PL/SQL, TOAD, MSSQL Server 2000, Erwin 4.0, Teradata V2R5, BTEQ, XML, Windows NT 4.0, Sun Solaris Unix, Business Objects - Crystal v10,Trillium v7.5