SUMMARY:

• IT professional providing effective solutions for Data Warehousing and Business Intelligence - design and development; ETL process design, development and implementation.
• Experience in software development life cycle from design including database design through testing, quality assurance, deployment and maintenance.
• Excellent communication and interpersonal skills coupled with calculated and objective problem analysis skills.
• Proven ability to work in a team environment and highly capable of taking initiatives.

TECHNICAL SKILLS:

Platforms: Unix, Linux, Windows, Hadoop

Programming Languages: PL/SQL, UNIX Shell Scripting, Java, Hive QL, C, SQL.

Tools: Informatica Power Center 9.6/10.1 (Repository Manager, Designer, Workflow Monitor, Workflow Manager), SQL*Plus, TOAD, Oracle Enterprise Manager, SQL Developer, Data Pump, Data modeler, Oracle Data Integrator (ODI), Apache Hive

Database Systems: Oracle 12c/11g/10g, SQL Server 2008/2005.

Other: Oracle SOA, SQL*Loader, SVN, HP Quality center, HP UFT.

PROFESSIONAL EXPERIENCE:

Confidential, MD

Senior ETL Developer

• Designed, developed and implemented near real time Data Warehousing and Business intelligence systems
• ETL process design, development and implementation in support of census bureau operations including ongoing surveys and decennial census tests for 2020 census.
• Designed, developed and implemented Business Intelligence systems for monitoring cost and progress of census bureau survey operations.
• Designed ETL mapping, Workflow, Transformations and implemented scheduling for incremental loading of data from Source to Target Systems.
• Dimension modeling for star schema Data warehouse - analyzing source systems data, identifying and creating Fact and Dimension tables.
• Developed processes for ingesting data (XML, flat files, JSON) from source systems in near real time using Web services, Shell scripts, JAVA and PLSQL.
• Created Packages, Procedures and Functions to implement ETL processes.
• Automated ETL processes with Oracle DBMS Scheduler jobs, Unix Shell Scripts and Cron jobs.
• Created Detail and Aggregate tables for BI reporting via SAS portal.
• Performance tuning for Data Warehouse processing including SQL tuning, analysis of AWR reports for base lining and performance tuning of queries.
• Provided production support for daily Data Warehouse load including support for ETL and Business Intelligence systems, troubleshooting and fixing issues with OLAP cube builds, Materialized View refresh, Oracle Chain Jobs, UNIX cron jobs and SAS portal.
• Experience with Informatica Power Center tools - Designer, Workflow Monitor, Workflow Manager and Repository Manager

Confidential, Baltimore, MD

Senior Oracle Application Developer

• Developed and implemented API using PL/SQL.
• Created and implemented new Packages, Functions, Triggers and Procedures. Debugged existing program units
• Implemented new functionalities and provided support for Ellucian banner Student Information System.
• Developed custom oracle form using forms builder 10g to implement new functionalities. Modified existing 10g/11g forms.

Confidential, Annapolis, MD

Data Migration Analyst

• Defined, designed and implemented data extraction process for data migration.
• Code Extract, Transform and Load (ETL) processes for data extraction from legacy system
• Provided input in the development of mapping documents
• Evaluated tools and processes needed to implement data migration project
• Created Functions, Procedures and Triggers to automate the process of data reconciliation
• Provided technical and functional oversight of data reconciliation activities
• Created SQL and PL/SQL scripts to validate data requirements for data migration
• Ensured quality of data being migrated from legacy system met business requirements. Includes back end testing to verify data integrity and quality.
• Oversight of overall quality assurance of data migration, included business requirement definition and verification, quality assurance testing
• Performance tuning of complex SQL scripts
• Designed and implemented data loading and offloading using data pump
• Defined environment requirements, including test data, physical location, user access, change control, and training needs for validation testing.
• Implemented data replication using Materialized view.

Confidential, Annapolis, MD

Programmer/Analyst

• Performed requirement analysis, developed functional and technical specifications for new developments and modification to existing application.
• Created Packages, Stored Procedures, Functions, Libraries and database Triggers.
• Created new forms and enhancement to existing Oracle Forms 6i, 9i and 10g on Unix and Windows platforms
• Fixed bugs in existing application and implemented new functional requirements.
• Performed quality control, analyzed bugs in application codes and completed coding changes and testing.
• Provided technical advice, training and assistance to lower level programmers and/or peers.
• Responds to, identifies, researches, and resolves application or related system performance problems with internal and external customers.
• Created test data, performed quality control and testing for new programs and modifications to existing programs. Assisted in overall system tests or upgrades.
• Led or assisted in finding and solving simple to complex problems within software systems individually and as part of a team of other analysts.
• Member 7 man vendor selection team for new Policy Administration System to replace legacy system.
• Implemented presentation layers (GUI) using complex forms with libraries, menu, and various master-detail relationships.
• Extended functionality, developed, configured, and tested interfaces on custom application built on oracle platform.
• Designed and developed database objects; Tables, Views, Indexes, Sequences, and Materialized views.

Confidential, Annapolis, MD

Programmer/Analyst

• Performed requirement analysis, developed functional and technical specifications for new developments and modification to existing application.
• Created Packages, Stored Procedures, Functions, Libraries and database Triggers.
• Created new forms and enhancement to existing Oracle forms 6i, 9i and 10g on Unix and Windows platforms
• Fixed bugs in existing application and implemented new functional requirements.
• Performed quality control, analyzed bugs in application codes. Completed coding changes and testing.
• Created and maintained database objects.

Confidential

Support Analyst

• Provided technical support for application development on .Net platform with Oracle and SQL server backend
• Installed, configured and maintained various in house applications and database systems
• Created and maintained user access and privileges
• Provided support for application and database integration.
• Provided technical problem analysis and resolution of network and application issues.
• Provided Visual source safe user administration and support.
• Resolved network issues including resolution of issues relating to application performance