SUMMARY:

• Over 10 years of IT experience in Healthcare, Telecommunication, and Financial IT environments as a Data Analyst, ETL Developer, Application and Production Support Specialist.
• Perform data analysis and develop for Enterprise Data Warehouse & ETL/Informatica projects.
• Contribute to the analysis of data requirements and development of logical data models and standards ETL development/mappings and SOA workflows.

TECHNICAL SKILLS:

Database: Oracle 9i/10i, DB2, SQL Server 06/08, SQL/SQL Plus 8.0, ETL, OBIEE Hyperion, Teradata, Sybase, AS/400, Netezza Business Object/Table

Mainframe: IBM Mainframe 3090, DOS/ JCL/ MVS/ JES2/ VTAM/TSO/CICS/OS,

Application Servers: Web Sphere, BEA Web Logic

Application Tools & Packages: Hummingbird V7.0, Exceed, Vantive 4.0, Crystal Reports, PVCS Tracker/NSS Clarify, JBuilder, Silver Stream/LNP GUI, Quest/TOAD, MS Access/MS Office, SQL 05/08 Quality Assurance, Remedy 4.0/ ICOMS/ACP Oracle Siebel CRM/BRM

Operating Systems: HP - UX, Sun Solaris 8, Windows XP/2000-NT/98/95, Microsoft Server 00

Shell Scripting: Shell scripting, DOS batch scripting, Java scripting

Network Utilities: FTP, X-Start, X-Session, TCP/IP, PC Anywhere, ACE Server/Remote, and Wireless Application Lifecycle

Languages: C# .Net, C++

PROFESSIONAL EXPERIENCE:

Confidential

ETL Informatica-TeamLead

Responsibilities:

• Development Lead for a BI project using Informatica / PL-SQL / AUTOSYS / Oracle Lead the Development support team at offshore through the SDLC process and ensure that the milestones are met. Communicate with stakeholders in case of delays or SLA breaches
• Resolve bugs within defined service levels Manage and own application Bugs and incident life cycle, and drive those to permanent resolutions, implement preventive measures to avoid repetitive issues. Resolve complex bugs with long term fixes following BI best practices and collaborate with BI team for solution review of complex bugs and incident resolution
• Follow up with requirements, data modeling and testing teams for the SDLC process Provide weekly status reports and ensure completion of tasks assigned Manage and own code deployment and release process Support release of BI deliverables into all lower and production environments and support issues encountered due to production change Responsible for continued system improvements to help reduce development costs
• Act as a backup for support engineer for events like vacations and unforeseen leaves Perform custom, ad-hoc data analysis and reporting based on stakeholder requests within SLA Support weekly and monthly customer report processing Conduct regular presentations to team/stakeholders.

Confidential

BI Reporting Analyst Team Lead

• Provide data driven analysis of business functions to stake holders/executive leadership and help implement improvements in focus, efficiency, accuracy, and effectiveness of their processes
• Develop functional requirements to meet evolving business needs of project managers, project controllers, resource managers and business unit management; design/develop/test enhancements to the reporting environment in conjunction with IT
• Report into the Global Operations function and provide business analysis and support across multiple corporate functions that include Business Unit Reviews, Account Plans, and company dashboards
• Create, modify and publish reports based on various stakeholders’ requests utilizing SAP Business Objects/ Tableau/Teradata/SQL/Excell
• Agile sessions with Stakeholders include senior leadership, project managers, resource managers and operations lead
• Lead continual improvement and support of the business intelligence environment which provides project and professional services reporting across multiple organizations and groups in using projects to manage their environment
• Reporting Lead for project data, focused on views by Client, Industry, Service Line and key offerings for various time frames and region Data mining/validation working managing
• Develop user training and communications along with providing first level user support as needed also providing managing onshore/offshore jr analyst

Confidential

Sr. BI Consultant & ETL Developer

• Responsible for client facing engagements; participated in business meetings and project planning sessions with project managers, architects, business analysts and business intelligence team members to analyze business requirements and outline the proposed IT solutions, making sure we meet all business requirements to define clients requirements; also define data model in Erwin
• Responsible for developing the masking code for CVS/Caremark, data analysis/mapping following the required business requirements to meet CVS/Caremark business objectives. Created low level design documentation. Tools used in the project were Informatica Design Powercenter 9.0, Informatica MDM/ILM Micro Strategy, and SQL Toad.
• Defined transformation for data source to target mappings and developed the components to support the mapping transformation.
• Worked with QA/testing to help validate and define test cases. FDA CFR 21 part 11, and GAMP Ensured the testing requirements were being met and helped with code defects. Participated in project planning meetings with project managers, developers and team members to analyze business/data masking requirements and outlined the proposed IT solution.
• Coordinate work with offshore group.
• Validated data via Toad/SQL Server 2008 and utilized Informatics for ETL processes. Met business requirements and adhered to IT policies throughout design, development and testing and incorporated architectural standards into application design specifications to move data to production.
• Effectively liaised with other members of the department and company to assist other members of the department with tasks as needed. Ability to successfully handle multiple projects and timelines. Ability to complete projects and other tasks on time with little or no supervision.
• Performed complex data modeling, mapping session, workflow creation, repository administration coding, testing and debugging, and created new code standards/mappings also validations in Informatica 9.0 also Performed complex data modeling, mapping session, workflow creation, repository administration coding, testing and debugging, and created new code standards in Informatica 9.5
• Responsible for development of full cycle in ETL/Informatica PowerCenter analysis data/code also mapping requirements in EDW environment, creating high and low level designs on ETL Mappings also Informatica workflows.

Confidential

Sr. ETL Developer/Informatica

• Responsible for development and maintenance of database systems: Oracle PL/SQL, SQL SSIS Server T/SQL. Experienced with performance tuning ETL Informatica 9.0 in Enterprise Data Warehouse (EDW) environment.
• Optimized complex SQL queries performed complex data modeling, mapping session, workflow creation, repository administration coding, testing and debugging, and created new standards for billing.
• Extracted, cleansed, transformed, loaded and maintained data. Ensured compliance with business requirements best practices and performed code review.
• Validated data via Toad/SQL SSIS Server 2008 and utilized Informatica for ETL processes. Met business requirements and adhered to IT policies throughout design, development and testing and incorporated architectural standards into application design specifications to move data to production.
• Informatica Master Data Management Business process design for managing Master Data throughout the lifecycle, including data quality, metadata and workflow technologies; Implementation experience on the following technologies OBIEE metadata for reporting dashboard.
• Upgraded all billing codes with the code subscriptions and standardization of the code types being supported on the data warehouse.
• Worked closely with QA for test cases created to ensure proposed data migration and implementation strategy met mapping business objectives

Confidential

Senior Business/Data Analyst

• Gathered business requirements and formulated logical JAGs of business requirements.
• Identified improvement opportunities to streamline and automate processes and functions.
• Developed and enhanced current reports via TOAD SQL and PL/SQL, as well as SQL Developer, Teradata
• Supported full project life cycle activities. Determined needs from internal client, vendor projects and reporting plans.
• Informatica Master Data Management Business process design for managing Master Data throughout the lifecycle, including data quality, metadata and workflow technologies; Implementation experience on following technologies OBIEE metadata for mobility dash board.
• Developed and controlled all changes via SharePoint.
• Established specifications for enhancing interim reporting capabilities until OBIEE/Dashboard reporting platform was complete. Used Oracle 10 databases and OBIEE for report and dashboard creation.
• Worked with Development/EDW teams to develop OBIEE prototype reporting tools. Helped the group understand the current CRM/BRM/ICOMS tables as well as the data interactions with Oracle Siebel CRM/BRM.
• Mapped data using (ETL) Informatica Powercenter.
• Analyzed marketplace, industry, company, technology trends and best practices, as well as vendor products and services.
• Performed development and maintenance including creating free-form SQL reports specifically for reporting.
• Provided feedback and technical guidance to Project Managers on issues of critical importance to achieving business objectives.
• Established and maintained relationships with hardware and systems integration for the purpose of influencing development standards.