SUMMARY:

• Sixteen years of experience in Information Technology which includes designing, developing and deploying Data warehouse.
• Fourteen years of experience on Data Warehousing.
• Populated Data Warehouse for State Government, Healthcare, Insurance & Telecommunication organizations.
• Comprehensive knowledge in Extraction, Transformation & Loading (ETL) of data using heterogeneous sources and targets.
• Experience for Performance tuning of Informatica and tuning the SQL queries.
• Understood and analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all applications and systems.
• Proficient in working with Oracle, Sybase, Sql Server. Procedures, Functions, Cursors, triggers and Packages.
• Design Metadata Repository, Data Modelling (Logical and Physical).
• Informatica 10.x and Business Object 4.2 Administration.
• Experience with BI Tools like Cognos & Business Objects for Designing/Building/Managing Reports.
• Experienced in writing UNIX Shell scripts, Perl scripts.
• Mentoring developers for technologies.
• Manage and Support to team members.
• My personal strengths include ability to meet deadlines, problem solving, creativity, a strong work ethic and professionalism.
• Strength in communicating with the end - user understanding their needs and delivering effective solutions and have good exposure of working in team environment as well as independent.
• Plan and Manage the Design, Development, Test, Execution and Documentation for Team members.

TECHNICAL SKILLS:

• Data Warehouse ETL tool Informatica (Power Center & Power Mart 5.x/6.x/7.x/8.x/9.x/10.x).
• SAP Business Objects, WebI, Broadcast Agent and COGNOS for BI.
• Knowledge of Data modeling tool ERWin, SQL Developer Data Modeler and Power Designer.
• UML Designing tool MSVisio.
• Good Command over RDBMS Oracle7.x/8.x/9i/10g/11g/12c, MS SQL Server, Sybase, mySQL.
• Operating Systems Windows, Unix, Linux.
• Languages C, C++, PL/SQL, JAVA.
• Unix shell scripting and Perl programming.
• Enterprise Edition Java Servlet, JNDI.
• Technologies JSP, JavaScript, XML.
• Protocols TCP/IP, LDAP & SNMP.

PROFESSIONAL EXPERIENCE:

Confidential, Austin TX

Data Warehouse Architect

• Maintenance and Support for MBOW.
• Health and Human Services Informatica 10.x Server Administration.
• Health and Human Services Business Objects XI 4.2 Server Administration.
• Analyze new requirements for Changing Performance Measures for existing Performance Measures.
• Maintenance and updating Informatica ETL for MBOW and CMBHS Data Warehouse.
• Maintenance and updating Business Objects reports for MBOW.
• Maintaining and Supporting MBOW database programs and Unix Scripts.

Environment: Informatica 10.1.1, Business Objects 4.2, Oracle 11-12c, SQL Developer, Unix, Shell Scripts.

Confidential, Austin TX

Database Administrator

• Analysis, Design & Deployment of new OLTP functionality for CMBHS in Agile Methodology.
• Logical and Physical Data modelling.
• Populate Database deployment scripts.
• Database Administration activities.
• Analysis for designing new ODS system to provide MH data into MBOW data warehouse.
• Coaching developers for Datamodel and technologies for Development effort.

Environment: Oracle 11, SQL Developer, SQL Developer Data Modeler, Microsoft TFS.

Confidential, Austin TX

Data Warehouse Architect

• Maintenance and Support.
• Research and communication with Program customers.
• In corporate new changes and enhancements.
• Communicate fixes to Development team.

Environment: Unix server, Unix, Perl, Oracle 10g, Sybase 15.x, Rapid SQL, Informatica 9.x, Power Designer, Opcon/Cron.

Confidential

• Requirement gathering & analysis.
• Prepared project plan and documentation.
• Design database model & deployment. Created database deployment scripts.
• Developed Informatica mapping to combine MBOW, TWC, DARS and DADS data to populate employment data.
• Communications with DARS and TWC teams in regards to data.
• Designed and developed deployment scripts.
• Communication effort to team for the process Life Cycle.

Environment: Unix, Perl 5.x, Oracle 10g, Rapid SQL, Informatica 9.x, Power Designer, Opcon, MS Visio.

Confidential

• Maintenance and Support.
• Research and communication with Program customers.
• In corporate new changes and enhancements.
• Communicate fixes to Development team.
• Involved with HHSC EDW Data Governance Project and provided client information.

Environment: Unix server, Unix, Perl, Sybase 9.x-15.x, Rapid SQL, Informatica 9.x, Power Designer, Opcon/Cron.

Confidential

• Involved into migration from MDS 2.0 to MDS 3.0.
• Review and Analyze MDS 2.0 environment to identify the needs to create MDS 3.0 environment.
• Proposed a new extract flow for daily and monthly extract.
• Developed the specification documents, crosswalk document and new extract file structure for MDS 3.0.
• Designed new database for MDS 3.0.
• Developed new process for MDS 3.0 extract.
• Review, analyzed and provided solution to change required for existing dependent processes for other systems.
• Designed and developed deployment scripts.

Environment: Windows server, Perl scripts, Unix Shell Scripts, Oracle 10g, SQL Server, Rapid SQL 7, MS Visio, IBM VPN client.

Confidential

• Involved into full SDLC.
• Review Detailed High Level Design Documents and knowledge sharing sessions with the team.
• Understood Business Users requirements. Involved in Requirement Gathering for migration.
• Designed data models and implemented star and snowflake schemas using Erwin & Power Designer. Reverser engineering of Sybase model and forward logical and physical model for Oracle database.
• Migrated the data models required for the data warehouse using Erwin and transferred from Sybase to Oracle.
• Used Informatica as the ETL tool.
• Migration of Cognos catalog on sybase to BOXI universe on Oracle.
• Developed the solutions for ongoing enhancements using stored procedures, Informatica & BOXI.
• Testing for BOXI universe and reports with the customer.
• Maintained the existing system with monitoring and supporting weekly/monthly loads.
• HIPPA training with DADS.
• Developed & maintained in house fast paced projects as HCSSA load & CDR loads using Informatica.
• Designed and developed deployment scripts.
• Communication effort to team for the process Life Cycle.

Environment: Informatica Power Center 7-10, Oracle 9i-10g-12c, Sybase 12c, ERWIN 4, Cognos 6, BOXI 3.1, Power designer 12, Rapid SQL 7, MS Visio, Windows XP, UNIX, Shell scripts, Opcon.

Confidential

• Involved into full SDLC.
• Review Detailed High Level Design Documents and knowledge sharing sessions with the team.
• Involved in Requirement Gathering sessions with the business users.
• Involved in the Meta Data Specs creation.
• Test loads from SQL Server Operational Data Source into Oracle sample tables using Informatica Power Center 6.2.1.
• Unit testing of ETL Work.
• Cognos report team work with developers to support the user requirements.
• HIPPA training by DPW.

Environment: Informatica Power Center 6.2, Oracle 9i, SQL Server 2000, ERWIN 4, Cognos 6, MS Visio, Toad 6, Windows 2000 Server, UNIX.

Confidential,Schaumburg,IL

Sr. Consultant

• Involved into full SDLC.
• Involved to design Drafted schema and participated in Designing logical and physical data model using ERWIN.
• Test of workflows for - AMR 2 (Affiliate Metrics Report), which is a part of AADM.
• ETL Development of Product Ref Load and Daily Load to Oracle DB.
• Performance Tuning to improve your mapping performance to get efficient results in time.
• Business Object Universe, Business Objects Reports and Business Objects repository extensively used, and new universe were designed and developed to support the user requirements.
• Created complex views to overcome loops and contexts.
• WebI Reports were created and deployed.

Environment: Informatica Power Center 7.1, db2 UDB EEE 7.1, Oracle 9i, Business Object 6.5, ERWIN 4.1, Unix.

Confidential,Woburn,MA

Informatica Developer

• ETL using Informatica to load data from Flat file, MS SQL, Oracle to ORACLE
• Performed complex queries involving large data volumes.
• Modified the Informatica components, parameters, utilize data parallelism and thereby improve the overall performance to fine-tune the execution times.
• Tested all the business application rules and monitored sessions using Informatica Server Manager
• Developed and tested ETL applications for the warehouse application according to functional specifications using Informatica.

Environment: Informatica Power Mart 5.1, Oracle 8i, SQL Server, Erwin 4.0, Cognos