SUMMARY:

• IT Professional with solid experience in Banking, Insurance, Logistics and Telecom industries Identify product opportunities and manage projects from concept to market / in - house implementation Leverage multiple resources to drive issue resolution and product implementation with full knowledge of Software development Life Cycle.
• Presentations and training for large employee groups and non-technical business partners
• Able to manage multiple competing projects, priorities, stakeholders and geographically-dispersed teams
• Ensure business objectives are met and increase end-user efficiencies by delivering comprehensive, user-friendly products, on-time and with-in budget

ADVANCED SKILL SETS:

• Team Leadership & Management Data Warehouse / Data Mart Agile Scrum Master
• Dimensional Modeling Technical Presentations / Writing Requirements Analysis Business Intelligence Quality Management Systems Architectural Analyst
• Configuration / Product Administration Budget / Timeline Adherence Strategic Alignment

TECHNOLOGY EXPERTISE:

Agile Methodology: Scrum Master, Fact and Dimensions Tables using design toolsAb Initio (ETL) Parallelism Techniques, Component Folding, Parameter Definition Language (PDL) EME for Version Control, Impact Analysis and Dependency Analysis; Multi File Systems (MFS)

Requirements Analysis: Modelling with MS Visio and Erwin7.x.

ETL Tool: Ab Initio (GDE 3.x/ 2.14/1.13/1.12/1.11.9.1/1.8.27 ) Co>Operating System 3.x/ 2.14/2.12/ 2.11.7/2.5.7 ) with Repository (EME), Metadata Programming, Business Rule Editor (BRE).

Operating Systems: AIX, Sun Solaris UNIX, Windows NT 4.0, DOS 6.22, Windows 3.11, Windows 95, Windows 98, VMS.

Languages: C, C++, Korn Shell Scripting, Familiar with RDBMS - Oracle 8, SQL Server 6.5, Bteq Scripting, Fast Export.

Tools: / Packages SharePoint, Source Code Control System (SCCS), Control-M Job Scheduler, Mercury Quality Center, HP - ALM (Application Lifecycle Management)Visual Source Safe.

Database: Oracle 11i/10g/9i/8i, Teradata V2R5, MS-SQL Server 2000/7.0, DB2

Desktop tools: Microsoft Office, Microsoft Project, Microsoft Visio.

Training: In-depth, on-the-job-training Software Development Process, Requirement Engineering, System Design Overview, Testing & Debugging, Project Management, Quality Management Systems.

CAREER HISTORY:

Confidential, Westfield, OH

Project Manager / Information Security Architect

Responsibilities:

• As a Data Security Liaison, responsible for identifying / providing resolution on a regular basis for any Data Security related issues and communicating the same to Project Management and Teams involved.
• Responsible to Project planning updates including total resources allocation on projects.
• Coordinating discussion with Management and project teams involved related to issues and exceptions related to Data Security in ETL work stream on weekly basis.
• Responsible to Review / Approve ETL Functional / Technical Spec and actual process to see all PII / SPI are properly address per Data Security Policies and Exceptions and suggesting best practices for ETL processing and communicating same to Project Management Team also.
• Communicating up-to-date cross impact report to Management for any project requirement that might be affect other requirement / project from timeline or requirement modification basis.
• Involved with Data Analyst / Scientist teams for Data Classification for all tables in DB in Data Lake, Source Processing, Enterprise Subject Area (Enterprise Data Warehouse) and Reporting Marts.

Confidential, Columbus, OH

Financial Advisory

Responsibilities:

• Lead the team to study User requirement from the proposed documents by business users.
• Technical Lead for the team for development of various projects related to claims, policy and premiums.
• Analysing, Designing and Development in extending the data warehouse for new external sources.
• Developed functions for Data formatting and Data Cleansing for the files coming from External Systems (offline feeds).

Confidential, Columbus, OH

Project Manager, MIS AD Team Lead, System and Architectural Analyst

Responsibilities:

• Responsible for managing building new/modifying existing interfaces for requirements from Lines of Business (LOBs) in Financial Data Warehouse (FDW) environment.
• Gather business requirements from lines of business and source systems.
• Drive the architectural design, creating functional and technical design documents.
• Managed Application Development (AD) Team including onsite and offshore coordination.
• Managed resource allocation and tracking project progress through daily standup meetings in iterations.
• Provided estimates to management and business for projects costing (budgeting) and resourcing.
• Managed the project for MIS and SAP infrastructure upgrade in QA and Production Environment involving decommission of old severs and bring in new servers with SAN and security upgrade. Also, setting various activities like backup/ restore strategies, FTP/ sFTP, Access Management, Disaster Recovery, job scheduler configuration (Control-M/Autosys) etc.
• Worked on Star Schema and Snowflake modeling and Identify referential integrity between tables.
• Prepare and review mapping documents between sources to target table / downstream extracts.
• Prepare and review test plans, test script, test results and Wrapper scripts; assisted during multiple phases of test cycles.
• Maintained documentation and managed Enterprise Change Management (ECM/ITSM) for projects.
• Developed reconciliation strategies for data validation between pre-processed and post-processed data.

System Analyst Advisory - ETL Lead

Confidential

Responsibilities:

• Architected ETL process to process and managed the build team.
• Managed WAMU Decommission and merged into Confidential with least impacts to main design of application.
• Re-architected CGL reference load process by implementing deltas loads instead of refresh. This change removed code block of 3hours every night for reference refresh.
• Worked on Star Schema and Snowflake schema modelling for designing the solution for Confidential Rates and allocations of volume. Also involved in preparing functional & technical design specifications
• Designed and developed business intelligence (BI) solution to reconcile data for validation.

System Analyst

Confidential

Responsibilities:

• Designed and developed the ETL processes to process & load data into FDW from various source systems.
• Implemented a process for extracting periodically changes (delta) data from the sources system interfaces and loaded to the consolidated FDW.
• Built design for Extract Services Engine where data was extracted by reporting team through UI with all types of combinational filters.