SUMMARY:

• A systems professional with over sixteen years of experience in database design, development, data modeling, data extraction, data cleansing and loading.
• Masters of Science in Information technology, with extensive experience in projects related to Health Care Services and Financial Services industries.

TECHNICAL SKILLS:

OPERATING SYSTEMS: Windows 98/2000/NT/XP/7, UNIX, Novell Netware

DBMS/RDBMS: Oracle 8i/9i/10g/11g, Microsoft SQL Server, UNIX, Sybase 15, PostGreSQL, Netezza

DATA WAREHOUSE TOOLS: Informatica, Sunopsis, Business Objects

LANGUAGES/TOOLS: SQL, PL/SQL, Oracle Application Express (APEX), C & C++, Access, Visual Basic, ColdFusion, InfoMaker, Crystal Reports, MS Office Suites, Erwin, Microsoft Visio, HTML, PHP, MySQL, Photoshop, Dreamweaver, Flash, Fireworks, GroupWise, Lotus Notes, MS Outlook, Microsoft Project.

PROFESSIONAL EXPERIENCE:

Confidential

Senior ETL Developer

Responsibilities:

Developing Informatica mappings and performing the transformation of data from multiple SQL Server and Oracle source databases into XML output files and sending the XML files via Connect:Direct to several external agencies for their use. Creating XML schema (XSDs) to define and validate structure of XML files. Creating parameter files, staging tables and control tables to manage the process of Informatica components. Setting schedules for running Informatica Sessions and Batch processes automatically. Creating Analysis document, Design document, Source - to-Target mapping spreadsheets and Unit Test document on assigned project. Creating, updating and maintaining technical documentations. Updating the status of project work assignments and attending weekly status meetings.

Environment: Informatica PowerCenter 9.6, Microsoft SQL Server, Oracle 11g

Confidential

Senior Associate

Responsibilities:

Develop Informatica mappings for the Genesys Telecommunications Laboratories, Confidential . to capture the changed records from Soundbite Oracle database into Netezza target database which is used for delivering cloud-based proactive collections, payments, and mobile marketing applications and customer service solutions. Unit Test, performance test and system test before deploying to production environment. Create, update and maintained ETL technical documentations.

Maintain Sybase ETL scripts. Write new stored procedures. Apply changes to the current stored procedures based on new requirements. Perform daily production support work. Participate in weekly job support enhancement and other related duties and responsibilities.

Environment: Informatica PowerCenter 9.5, Oracle 11g, Netezza, Sybase15.5

Confidential, Arlington, VA

Senior ETL Developer

Responsibilities:

Developed Informatica mappings for the U.S. Department of Housing and Urban Development’s (HUD) - to assist in collecting HUDStat related performance measures to support their business needs. Developed standard and re-usable Informatica mappings and mapplets using various transformations. PostGreSQL and Oracle Databases are used for source and target. Created, updated and maintained ETL technical documentations. Assisted in installation and configuration of Informatica PoweCenter Services and Clients. Assisted in set up Informatica environments; created users, groups, privileges, roles and permissions. Performed weekly Informatica backups. Coordinate resource activities with other IT staff.

Environment: Windows XP, Informatica PowerCenter 9.1/Adminstrator 9, Oracle 10g, PostGreSQL, PL/SQL Developer

Confidential, Owings Mills, MD

ETL Developer/Data Architect-Modeler

Responsibilities:

Developed Informatica mappings for the Centers for Medicare and Medicaid Services (CMS) - for the tracking and monitoring of activities, milestones and results from the implementation of the Affordable Care Act Performance Dashboard. Developed, validated, and communicated data modeling solutions. Ensured solution designs address performance requirements and availability, integrity, and security challenges as well as business functional requirements. Developed, maintained, and enforced data architecture-related standards. Analyzed business processes in order to develop appropriate data strategy. Worked on relational data models such as conceptual, logical and physical data models, dimensional data models, data dictionary, and metadata.

Environment: Windows XP, Erwin, PowerDesigner, Informatica PowerCenter 9.0.1, Oracle 10g, PL/SQL Developer.

Confidential, Washington, DC

Applications systems Analyst/programmer

Responsibilities:

Developed, tested and implemented Extraction Transformation Load (ETL) to perform the transformation and population of data from multiple sources for the Walter Reed Armed Forces Health Surveillance Center to provide the timely, useful, and reliable information needed to optimize the health, fitness, and performance of the Entire Army community. Provided up-to-date and historical data on diseases, medical events and longitudinal data on personnel deployments. Wrote Oracle PL/SQL stored procedures and functions. Automated load processes using UNIX shell scripting and crone jobs. Maintained and enhanced existing data extraction, cleansing, transformation, and loading processes to improve efficiency. Created Analysis, Design, Source-to-Target spreadsheets and Unit Test documents on assigned project. Created, updated and maintained technical documentations. Updated the status of projects and work assignments. Performed administrative tasks such as code migration and repository backups. Provided technical support to other analysts and developers.

Environment: UNIX, Windows XP, Informatica PowerCenter 7.1 & 8.1, Oracle 10g, TOAD 8.

Confidential, Rockville, MD

Etl engineer

Responsibilities:

Developed Informatica mappings for the Centers for Medicare and Medicaid Services (CMS) - Medicare Ombudsman Data System (MODS) to manage aggregate beneficiary inquiry, complaint, grievance and appeal data from the various source systems. Developed standard and re-usable Informatica mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup and filter. Created, updated and maintained ETL technical documentation. Coordinated resource activities with other IT staff in the development of new inputs. Ensured that the project data needs are met throughout the entire course of the project. Worked with the project Data Architect, QA and DBA. Provided on-going support of existing warehouse as well as continually reevaluating current processes and techniques for increased efficiency and maintainability.

Environment: UNIX, Windows XP, Informatica PowerCenter 7.1.3, Oracle 9i, TOAD 8.

Confidential, Washington DC

Etl engineer

Responsibilities:

Analyzed voter states data before processing; Developed and implemented Sunopsis mappings for voter states; designed and developed ETL processes using Sunopsis, Linux and MySQL. Schedule to run Sessions and Batches process and document the ETL processes.

Environment: Sunopsis, MySQL, Linux

Confidential, Washington DC

Database analyst

Responsibilities:

Managed firm’s data applications by gathering information and analyzing requirements. Designed appropriate solution and implementing by using VB/Access. Carried out application testing, modifications, determining functional specifications and translating user requirements into complete functional applications and deployment of complete system for the user community.

Environment: visual basic 6.0, Microsoft access

Confidential, Silver Spring MD etl developer/Data analyst

Responsibilities:

Developed and implemented Informatica mappings for migration of the legacy Sybase Membership & Claim systems to new Oracle systems to support the Mid-Atlantic Data Warehouse and Operational Data Store (ODS). Used Informatica Designer tools to design the source definition, target definition and transformations to build mappings. Used Source Analyzer and Warehouse Designer tools to import various sources and target database schemas, and the mapping designer to map source into the target Oracle database. Used Transformation Developer to create the joiner, filters, router, Expression and aggregation transformations that are used in mappings. Used Mapping Designer to create Mappings. Validated the Mappings, Generated and Loaded the Data and Automated Informatica process using shell scripting & crone jobs. Performed source system analysis and Data modeling. Produced Business Objects reports from time to time for clients. Performed analysis on assigned project related to database management as needed.

Environment: Oracle 8i, Sybase, Informatica PowerCenter 5.1, Erwin 4.1, UNIX, TOAD

Confidential, Rockville, MD

Database Technician

Responsibilities:

Worked on the timely retrieval and dissemination of medical data to support internal and external business needs, developed systems to perform data analysis functions, produced reports and profiles that are generated for management trending purposes, designed new database using query, forms, reports, macros and SQL. Assisted department staff in the use of existing and new systems as needed.

Environment: Microsoft Access, Microsoft Excel, InfoMaker