SUMMARY

• Over 15 years of rich professional experience in data and information management (data governance, data quality, data and metadata management, MDM architure)
• Over 8 years of demonstrated Technical lead and management experience.
• Leading data architecture (data modeling and analysis), business intelligence (reporting, analytics, and data warehousing), and data integration (ESB EAI, ETL, EII) activities with a focus on Informatica’s data profiling (IDE).
• Strong verbal (presentation, facilitation, interviewing, influencing) and written (presentations, guidelines, specifications) communication skills
• Knowledgeable in Master Data Management (MDM) and Services Oriented Architecture (SOA) concepts and best practices (ITIL/ITSM)
• Practical use of a formal project life cycle (RUP) Rational Unified Process methodology. Experience with structured SDLC processes, cross - functional teams and Onsite-Offshore delivery and management.
• Experience in Ralph Kimball’s approach to design (Star Schema) and modeling principles. Strong Enterprise ODS experience with Manufacturing and Financial data warehouse environment
• Demonstrated focus on customer service, team development and on-time delivery
• Analyze document detailed functional requirements and business rules (use cases). Analyze document data requirements (from business needs perspective)
• Implementation & Adapting to Sarbanes Oxley (SOX) regulations procedures.
• Good understanding of Environmental Health related issues/software and proficient in Microsoft BI Integration and Analytic Services.
• Experience in system design, development, customization and maintenance of client server application projects and web development using ASP, IIS, VBScript, Visual Basic 5.0/6.0,Oracle 7.3.2. / 8.0, MS SQL Server 7.0. / Sybase 8.0.
• Hands on experience working in BI, (BO and OBIEE) XML, DTD, XSLT, Java, java script, application servers, web servers, Business Objects and workflow products.

TECHNICAL SKILLS

Software: Informatica PowerCenter 8, MetaData Manager, Autosys, SQL Server 2000/2005, Oracle 9i, Oracle 10G, DB2, Sybase 8.0, Erwin 4.1, Power Designer, Teradata, SQL Navigator, SQL debug, Quality Center, PL/SQL, Java, JSP, Kana Response eCRM, iFlow (Workflow), Visual Basic 7, xml, xslt, Crystal Reports 8.0, ASP, VB Scripts, Visual Interdev 6.0, MS FrontPage, Java, Java Script, IIS, MS Access, Developer2000, MTS, TOAD, CSS, Windows 95/98, Windows NT and UNIX, PERL

PROFESSIONAL EXPERIENCE

Sr. Integration Consultant

Confidential, San Francisco

Responsibilities:

• Innovating design and development process and approach.
• Data Governance, Data Integrity, MDM organization and ensuring availability of high quality data.
• Assist in process design and stewardship for ETL(Informatica) practice within the Commercial Operations Informatics Organization using Power Center and MetaData Manager
• Lead/Mentor Onsite-Offshore model for development, code review.
• Data profiling / root cause analysis and root cause analysis and streamlining end to end data flow.
• Identify business requirements (average to complex, operational, tactical and strategic) relating to business intelligence and develop a long-term strategy around the delivery options that balance cost of ownership with business needs.
• Evaluate alternative solutions and translate solutions into design, development and maintenance
• Assist in the identification, planning, implementation and support of ETL initiatives and meta-data management.
• Establish and maintain effective relationships and communication with business user community
• Work closely with application owners leveraging BI capabilities
• Maintain a solid knowledge of corporate and departmental information system strategies
• Leverage process, technology and best in class solutions

Technical Lead Consultant

Confidential

Responsibilities:

• Report to VP SoftwareEngineering on project progress and task management.
• Data governance, data quality, run-cycle, case management and support.
• Interpret business requirements into efficient code and communicate results to co-ordinating with Offshore development team in India and handled multiple tasks concurrently with competing deadlines.
• Lead Design/Development/Maintain ETL/BI environment using Informatica and Business objects interacting with Portfolio management tools.
• Analyzing, designing and developing new databases and enhancing existing capabilities using Case tools and manage BI development activities
• Create/Over see Technical specs, Unit test cases, Transition and Op-docs and work closely with business analysts, QA and data consumers
• Working with business analysts, technical managers, application and database development team members to understand the project requirements and provide solutions
• Hands on XML, XSLT for data transfer and presentation layers.
• Unix shell scripting, Perl programming, Autosys job scheduler, Quality Center, Clear Case tools, ETL Design, FTP, Data reporting and storage techniques, Database Solutions primarily in Informatica, SQLServer, Oracle and Sybase
• Prooven experience with performance tuning high volume Informatica mappings
• Participate in on-call support rotation

DW Architect Consultant

Confidential

Responsibilities:

• Designed and documented the ETL architecture including the workflow design and Oracle database staging tables design that will hold the data between mappings so that different statuses and error codes can be assigned and the messaging process can be replayed in case of any failure further down the message flow.
• Pluggable BI infrastructure and unfied business model using OBIEE development
• Extensively worked with XML generator and XML parsers to create MT950 swift messages and load Bond & Equities, Derivatives & Options, Swaps & Currency trades into different data warehouse tables and reporting systems.
• Created custom views in XML transformation and used advance mode pivoting.
• Used complex sql and analytical functions for derivative processing.
• Created procedures for SeeBeyond to call. Tables in Oracle that were periodically updated by SeeBeyond.
• Handson Cognos development
• Report Design and delivery experiences.
• Adhering to Agile process methodologies for Software development life cycle.
• Trained Business Analysts in XML, DTD, XML Schemas
• Fine tuned DTM Buffer size, DTM Buffer Block size, Line sequential buffer size and various cache sizes to optimize performance during processing big clobs rows ( 5-15 MB xml fields)

Data warehouse Consultant

Confidential

Responsibilities:

• Data Modeling (Star schema - dimension and fact tables) using ERwin.
• Implementation & Adapting to Sarbanes Oxley regulations procedures.
• Involved as a business analyst to engage and conduct business user interviews and stakeholder meetings at regular phases.
• Performance enhancements for existing informatica maps and Stored Procedures
• Provided leadership roles and acted as Mentor and provide technical solutions.
• Global and Local Index partitioning for tables of huge size.
• ETL was developed using Informatica 6.2 and PL/SQL procedures to transform and load the data.
• Hands on experience with Informatica 7.1, Unix Shell scripting, XML and DOM
• Extensive usage of advanced transformations in mappings.
• Team member for formulating procedural standards for coding and mapping guideline standardization.
• Unit/Error/Regression Testing and Configuration settings in Parameter files.
• Involved in performance tuning of various queries using explain plan utilities.
• Migrated mappings from Dev /Test to Production environment.
• Used Informatica Debugger.
• Unix scripting and job scheduling.

Environment: Informatica Power Center 6.2,, ERWin 3.5.2, Rational Clear Quest, Clarify, SQL Navigtor, Oracle 11i, Brio,Unix Solaris.

Data Conversions Specialist

Confidential, CA

Responsibility:

• User requirements gathering and responsible for Data Analysis, Data Conversion and Customization using Software development methodology of Rational Unified Process standards.
• Managed multiple Beta test clients for new product release and coordinated maintenance release.
• Provided client support on issue/service request from customers through ClientFirst System.
• Developed PL/SQL procedures to transform and load the data
• Involved in data testing and test plan creation.
• Developed critical reports using stored procedures and complex SQL.
• Developed Data Conversion Project Plans, Data mapping spreadsheets and Test Plans and maintain Issues log to communicate Client requirements and Conversion issues.
• Developed Stored Procedures, Conversion routines, Business rules and Data validation scripts.
• Designed and built SQL packages to extract data from two different source application. Extensively used DTS packages to extract data and schedule
• Demonstrated leadership qualities in handling clients independently for resolving conversion/Implementation issues.
• Acquired sound knowledge in Environmental Health Industry.

Environment: SQL Server, Sybase SQL Anywhere, MS Access, ISQL, SQL Debugger, Sybase Central, ASA SQLAnywhere, Oracle, Envision Suite of Products (Environmental health maintenance software). SQL Debug.

Pre/Post Sales Engineer

Confidential, CA

Responsibilities:

• Involved in assisting clients to find right solutions for their workflow needs.
• Help Sales to close on the transaction.
• Follow-up with Engineering team for solution implementation.
• Exposure to Java, Weblogic and Business Objects.
• Designed test case for all possible scenarios and to test the identified business rules.
• Working knowledge on workflow product Iflow, Java and web application servers.

Environment: Informatica Power Center 5.1.2,, ERWin 4.0,, PL/SQL, SQL*Plus,SQL*Loader, Oracle 9i, Business Objects, SQL Server, Java, J2EE, Weblogic, Unix Solaris.

Confidential

Asia Pacific data handling, sustain and reporting

Responsibility:

• Using Active Server Pages and Visual Basic developed knowledge sharing and decision-making reports and deployed in Compaq intranet services for MIS.
• Experiences in developing Global BI Solution for multiple regions.
• Developed utility tools like Frontlog Consolidation tool for sales forecasting. Designed Star schema for dimensional modeling
• Managing Asia Pacific data by integrating data from different systems. The process requires assimilation of data, analysis and develop consolidated databases. Designed and built Oracle SQL packages to extract data from source application.
• Developed PL/SQL scripts to Populate aggregate tables in Oracle
• Usage of OLAP tools and multi-dimensional database.
• Developed interactive messaging program in Java to allow exchange of messages between users. Made use of Java sockets.
• Effective usage of macro coding, Dynamicube, ASP, Crystal reports for reporting
• Using Oracle Data Control, IIS and Database grid in Visual basic developed user data entry module consisting visual basic documents
• Performing reporting, analysis, and data integrity exercises.

Environment: Visual Basic, ASP, IIS, SQL Server, Oracle, OLAP Server, Perforce, COM, Visual Interdev 6.0, Cashrush and Faxrush, Crystal Reports 7.0

Analyst Programmer

Confidential

Responsibilities:

• Actively involved in System Study, Client/Server Programming and involved in Testing Process Developed & Ported applications to be Web Enabled. Had very good exposure in various WEB Development tools. Developed sales order processing module and the utilities incorporated in the software were:E-mail, Dialer, Common access to MS Word and Excel using OLE automation
• Involved in re-engineering sample forms to the customer. Migrated from SqlForms 3.0, SQL Menus, References Forms in DOS to Forms 4.5(Developer 2000, 1.3 Ver), Menus and Libraries in Windows 95.

Environment: Designer2000, Developer2000, Oracle, SQL*Menu, SQL*Forms, Pro*C, PL/SQL, Unix, WindowsNT, SQL*ReportWriter, SQL*Plus, SQL Loader, Visual Basic