Profile

• Hands-on and diverse technical consulting and Technical Architecture and development experience in financial, insurance, telecommunications, and healthcare industries.
• Serve in solution architecture and technical leadership roles, seamlessly and successfully bringing together mixes of technology in Data warehousing domain.
• Mentor and supervise staff in detailed analysis, design, and development of solutions to increase operational productivity and efficiency.
• Develop and maintain solid partnerships, consulting with all levels of clients and team members to facilitate open lines of communication.
• Keen ability to manage multiple projects and tasks simultaneously and effectively.
• Maintain high development standards of quality and attention to detail in researching and recommending solutions.
• Excellent organizational and communication skills coupled with exceptionally strong work ethic.

Technical Skills:

Experience

Confidential

Role: Senior Oracle ODI Consultant

• Analyzed the impact of migrating Confidential from Sybase to Oracle. Designed and implemented the migration for the application. Converted Confidential custom letter headers and batch processes from Sybase to Oracle.
• Performed data and impact Analysis and re-engineered legacy applications for the provision of new medical insurance product in Confidential.
• Re-engineered, tested and promoted the Business reports in PL/SQL, Perl and Oracle Report Builder.
• Designing and implemented the HBCI Health Based Coaching Incentive product in Confidential.
• Oracle 9i 10g , PL/SQL, Perl, Linux , Triggers, Oracle Reports builder, Confidential

Confidential

Role: Lead Solution Architect Data Analyst

• Responsible for coupling and converting of Confidential data processing products acquired by company. This involved Data Cleansing, Data Conversion and Data integration with data coming from about 70 data sources from different vendors. The cleansed was used to Rebuild existing Data Warehouse into Acxiom based data warehouses Abilitec Technology . Each database 7 data warehouses being merged was 1 to multiple terabyte.
• Data sources comprised of Mainframe, other databases from third party vendors.
• Teamed with client's implementations specialists designing common interface to company products to ensure uninterrupted transfer and proper functioning of existing solutions.
• Communicated and confirmed detailed requirements and created ETL flows.
• Rebuilt a solution in ODI and ensured existing Affinium Confidential applications function seamlessly.
• Tera-byte sized database s per client.
• Oracle 10G , Sql, PL/SQL, SqlLoader, Perl, Packages, Triggers, Pro C, Unica

Confidential

Solution Architect

• Gathered business requirements, designed and Implemented end-to-end Confidential and necessary data modeling using ETL/ELT tools.
• Consulted with client's Marketing Manager to manage expectations and defined , designed and implemented cross-sell models
• Implementation of end-to-end DWH/Data Mart and necessary data modeling using ETL/ELT tools.
• ODI was used to extract/transform data from flat files, Mainframe Data Sets.
• Used ODI to cleanse source data files and perform necessary data translation.
• Oversee project operations, including definition of requirements, development of functional specifications, documentation of design, and mentorship on development methodology and related procedures.
• Reengineered of OLTP solution, Customer Choice Suppression Data CCSD , and the data model, to enhance the compliance of Federal and client's opt out requirements.
• Designed, developed and tested many Unica campaign libraries for end users.
• The Unica campaign templates were built for each channel for both prospect and customer databases.
• The new campaign templates increased the campaign performance by implementing database remodeling and tuning and thus reduced its runtime from a week down to 10 minutes.
• Promoted reliability through design and implementation of scheduling the processes for batch files.
• Database sized approximately 4 TB, 800 MM records.
• Worked with datacenter network teams to manage data storage and archival.
• Solaris Unix, Oracle 10G , Sql, PL/SQL, Sql Loader, Perl, ODI, Packages, Triggers, Unica Affinium

Confidential

ETL Developer

• Built star schema and its related fact and dimension tables to house EDR data for OSI outsourcing solutions.
• Wrote ETL packages and tested for each dimension SCD1 SCD2 table and its corresponding data load for fact table.
• Developed Server side ETL PL/SQL components Stored Procedures, Functions Packages for implementing complex business logic for data loading into staging tables
• Wrote ETL packages and tested for data integrity for each dimension SCD1 SCD2 table and its corresponding data load for fact table.
• Defined and created SCM procedures via automated scripting for CVS repository.
• Designed and implemented self-tracking procedures for the update process restart, ensuring efficiency of ETL solution.
• Designed and implemented automatic scheduling of the processes for batch files.
• Database sized approximately 3 TB , 600 MM records
• Oracle 10G, Sql, PL/SQL, Sql Loader, Perl, Shell,Packages, Triggers

Confidential

Process Improvement Manager

• Served as process improvement manager established methodology for the company, supervising cross-functional teams PMO, PrM, PM, Subject matter experts .
• Managed 12 associates from different phases of SDLC to determine the best methodology for Acxiom solution/database developers, including SCM principles.
• Co-developed a application in VB.Net Ms Access, SQL Server to manage requirements gathering, design, Source Code Management and Component reusability.
• Established corporate standards and guidelines to facilitate timely delivery to customers

Confidential

Solution Developer Architect

• Designed and built customer recognition solution to facilitate fundraising campaigns.
• Consulted with and mentored customer's architect on grouping rules and designed and wrote functional specifications.
• The ETL solution was built in Acxiom transforms and PL/SQL/Sql Loader
• Facilitated and completed end-to-end ETL Worked with datacenter network teams to manage data storage and archival.
• 300 MM records

Confidential

Roles: Database Developer, DBA, Project Lead ,SME Solution Architect

• Designed and developed fraud management product for credit theft, focusing on effective identity verification.
• Trained team members on house holding and tracing products.
• Performed design and development of Hercules hive-enabled data grid storage system to store reference data with keying technology.
• Supported building of identity verification pilot in partnership with Identico system.
• Directed senior developers to create and implement demo for Congress that screened airline passengers.
• Managed project team converting Application Verification System AVS from Muscato ENGIN middleware messaging tool to in-house parsing and messaging and scheduling system, achieving cost savings on maintenance and upgrades.
• Maintained the Oracle transactional database sized 6 TB with 400 MM reference records. Created and maintained packages to post and retrieve transactions.
• Database sized 6 TB, 400 MM reference records.
• Evaluated and used ERD tools such as ERWIN and Ration Rose for development
• Wrote PL/SQL Scripts for Data Validation and Data posting reposting into the OLTP database.
• Developed Oracle Stored Procedures, Functions, and Packages using PL/SQL as per the Requirement/Design Documents.
• Extensively used PL/SQL tables, cursors and exception handling.
• Worked with datacenter network teams to manage data storage and archival.
• Tru64Unix,Linux,C/C ,STL,Shell,ProC, OCI, Oracle 9.x,PL/SQL,Perl, Packages

Confidential

Consultant

• Analyzed, designed, developed, and tested implementations for Virtuoso ll System for Alltel's client/server customer care and billing system.
• Prepared conceptual and functional design and testing procedures.
• Unix, C

Confidential

Consultant / Programmer Analyst

• Analyzed, designed, and developed Transfer Account Procedure Confidential for an OLTP Billing system.
• Designed, developed, and implemented Asset Data Engine to process telecommunication network data for WorldWin System.
• Performed design, configuration, and provisioning of network data for cable television using fiber optic technology in WorldWin System.
• Unix, C, Pro c, Oracle 7

Confidential

Instructor / System Engineer

• Delivered lectures on subjects such as Database design, SQA, Systems Analysis and Design, Oracle , Forms, Report writer
• Guided and managed the students' projects at various stages and graded them according to the merit.