SUMMARY:

• ETL Data Architect offering 16+ years of success in Design, Analytical, Development, Architectural and Consulting projects to optimize productivity, maximize use of time and resources and achieve on - budget, on-time delivery.
• Ambitious self-starter who plans, prioritizes, manages, and completes tasks within fast-paced, deadline-driven situations.
• Strong data experience including but not limited to data analysis, data aggregation, data migration, data conversion, data architecture, data retention, data modeling and conditioning, data security (At rest and in transit - PII, PHI and FTI) for IRS & MARS E requirements.

KEY AREAS OF EXPERTISE:

• Project Planning & Estimation Impact & Requirement Analysis Test Strategy& Support
• Design & Development Implementation & Execution Performance Tuning
• Data Analysis & OLAP Data Management/Architecture Process Improvements & Automation
• Project Specifications Defect Management QA & QC
• Team Building & Training Prototypes & Use cases Data Modeling

CAREER HIGHLIGHTS:

• Strong analytical and technical skills portable to any ETL/DB platform.
• Strong ODS, ETL Architecture, Data Architecture and Project Management skills
• Solid experience in Data Migration and conversion, Data Quality Analysis, Data Modeling (Dimensional), Software Upgrades, Reporting & Analytics.
• Excellent business aptitude and skills transferable across a number of vertical markets.
• Major clients - State of Indiana, Wal-Mart Inc., Orange UK, AT&T U-Verse and WellPoint Inc.

TECHNICAL SUMMARY:

• Informatica Power Cente
•  IBM Data Stage & Quality Stage
• Pentaho • SSIS
• Cognos 10.2
• Oracle 11g
•  Teradata 15
•  PL/SQL
•  Unix Shell Scripts
•  MS Project
•  WinSCP
• WinCVS
• Erwin
• Oracle Forms & Reports
• MS Visio
• MS SQL Server
• SQL Developer/Toad

PROFESSIONAL SYNOPSIS:

Sr. ETL Data Architect 

Confidential

Responsibilities:

• Revise the existing Supply Chain ODS architecture more efficient for business reporting and operations
• Perform impact analysis at various levels such as data/business on data warehouse modules and responsible for designing/developing technical business rules.
• Improve performance and process efficiency by 50%

Sr. ETL Data Architect

Confidential

Responsibilities:

• Define data needs and requirements of existing and proposed systems and develop technical, structural and organization designs and specifications.
• Define appropriate Design patterns for the entire data warehouse operations, Application Dashboard Design and implementing strategic solutions and automation
• Define Dashboards and Cubes necessary for Executive decision making
• Played a vital role in ensuring seamless operational processes & automation and owned various subsystems such as Electronic Benefits Transfer, Division of Family Resources and Confidential.
• Collaborate with business, client and technical groups at all levels to define data requirements, evaluate data technology needs and formulate solutions.
• Perform impact analysis at various levels such as data/business on data warehouse modules and responsible for designing/developing technical business rules.
• Identify and explore the potential strategies for long-term planning implementation.
• Implement data verification and testing methods for the data warehouse modules and monitors completed application software system to ensure proper execution and performance.
• Improve/Tune performance of long running queries/Job modules.
• Provide technical and business guidance and feedback to other associates.
• Contribute by providing continuous value adds from our end to the clients and end users.
• Execute projects such as Application Conversion, Technology Upgrades and Platform Conversion etc.

Delivery Manager

Confidential

Responsibilities:

• Actively manage projects on a day to day basis to ensure that project outputs are being delivered on schedule, to budget and to the required quality.
• Manage the day-to-day operational and tactical aspects of multiple projects.
• Understanding the support process, Knowledge on SLA clauses, SLA Objective, Breaches etc.
• Demonstrated knowledge in Metrics that will be collected & published.
• Develop detailed resource plans and timelines for the project with identified milestones.
• Analyze profitability, revenue, margins, bill rates and utilization across projects.

Track Lead

Confidential

Responsibilities:

• Project Estimation, Project Planning, Project Tracking and Control for the CR/Defects.
• Direct and disseminate status of on-going assignments and / or projects to meet the goals and objectives of the project.

Technical Architect

Confidential

Responsibilities:

• Executed sophisticated Inventory Management System implementation project from start-up.
• Spearheaded ongoing changes on the IMS databases and played as a liaison between the offshore team and the clients.
• Optimized project efficiency by handling Change Requests/Enhancement Requests/Critical Defects originating from Application, Business and Quality Assurance team.

DB Analyst 

Confidential

Responsibilities:

• Executed DB Design and implementation for Business Process Management Online project.
• Met and/or exceeded client expectations in gathering technical/business requirements, impact analysis, reviewing the software components and further the project delivery.
• Identified and implemented numerous performance-tuning initiatives for reducing the data access time, which improved execution time in the system thereby significantly reducing costs for the customer.

Lead Programmer / Technical Architect

Confidential

Responsibilities:

• Specialized in System Design and Development, Data Migration, Performance Tuning and Pre/Post Implementation Support.
• Facilitated meetings for Business Requirements, Technical Requirements, Interface Agreements and High-Level Designs, Assisted application and business teams for each UR&D release and issue resolution as needed.
• Implemented and streamlined the process to monitor and resolve trouble tickets raised by Confidential clients and client partners thereby reduced the time and effort spent in tracking the tickets right from its assignment to its closure thereby increased the productivity.
• Certified by Confidential for commendable application support and system design.

Lead Programmer/Module Leader

Confidential

Responsibilities:

• Developed various claim processing user interface screens.
• Created numerous stored procedures for various health care claim handling processing and reports.
• Developed the extracts to be produced for the Smart Prospector reconciliation system.
• Migration of data from facets database to AFMS Database. (Conversion).
• Developed multiple applications involving health care claims reporting.