Summary

Data Architect with 11.7 years of experience in data analysis, modeling, and data warehouse, design and development projects. Extensive experience as the interface with stakeholder and business units gathering business requirements while managing Design , Data Models, Logical and Physical Data modeling and ETL and reporting application implementation.

Data Modeling:

• Conceptual/Logical/Physical data modeling using ERWIN, Embarcadero Data Architect ER Studio
• Data Warehousing concepts including Star Schema and Snowflake Schema, Data marts, conformed dimensions and facts, OLTP,OLAP,ODS, ETL design and implementation
• Expert in Kimball and Bill Inmon methodologies
• Reverse engineer existing applications for enhancements
• Generate dimensional model from relational data model
• Metadata management

Data Profiling

• Analyze, understand, and document the flow of information between applications, databases, and third party vendor systems
• Data analysis approach, documentation and data remediation scope determination
• Data Standardization, Customer de-duplication and archival strategy design and implementation

Data Integration

• Detailed Data Mapping documentation using data dictionaries of source and target systems
• Intervene to resolve design and logical issues faced by technical teams
• Master data management process design and implementation

Data Analysis Data Quality

• Data flows diagrams, functional and mapping documentation
• Analyzes new requests for data and reporting
• Identify data discrepancies and advocate for data quality and integrity
• Assess informational needs, investigate, analyze data, draw conclusions, and make recommendations
• Analyze, understand, and document the flow of information between applications, databases, and third party vendor systems
• Prepare test plans, engage in all phases of testing

Data Migrations

• Data Migration strategy documentation, Project planning and Deliverable management
• Data reconciliation process design both for Financial data and Non-financial data
• Source to Target Data Mapping documentation and testing strategy
• Cutover planning, Go-Live preparation, Business and External Auditor Sign-Offs

Data Warehousing BI MicroStradegy

• Designing and maintaining SCD type 1,2,3
• Monitor development team, assign tasks, and verify workflows.
• ETL, Reconciliation and BI solutions for Enterprise Data Warehouse
• Consulting guidance for changes related to existing data warehouse and improvement areas
• Expertise in managing Data Warehouse Support and Maintenance portfolios and successful track record of setting up DW support process

Data Science/Big Data Analytics

• Leveraging an Enterprise Data Science EDS methodology, based on a hypotheses-driven assessment framework, used to translate business objective to predictive classification models to actionable enterprise operations leveraging traditional and big data process and storage assets.
• Defined framework for building big data enable ecosystem Hadoop, Cloud era, etc. .
• Define customer-centric use and business cases for big data to establish monetization of data strategy.

Business Development Strategies

• Specialized in customer relationship management, consistently demonstrating integrity while projecting a positive personal and professional image.
• Excels in business process improvement analyze, as well as data analyze to identify problem root cause and resolution requirements.
• Extremely reliable possessing a strong work ethic, willing and able to function in any role necessary to ensure project success.

Program/Project Management- Quality Management:

• Project Scope, Strategy Budget Analysis - Planning, Support Status tracking
• Team Building - Applications Analysis, Development and Implementation
• End to End Client management - Requirements control - Project Sign-Offs
• Extensive experience with Onsite-Offshore models - Agile and Waterfall methodologies
• Deep understanding of HP PPM tool, Microsoft Project, MS Excel and MS PowerPoint for tracking scope, schedule and cost of the project and providing timely update to key stakeholders
• Expertise in managing Data Warehouse Support and Maintenance portfolios and successful track record of setting up DW support process
• Managing cost, schedule scope and proven track record of delivering DWBI projects with best in breed quality solutions
• Deep understanding of project management methodologies like Waterfall, Agile, Scrum, and hybrid approaches
• Directed the strategic and tactical planning to successfully support critical data centric projects. Created program charter organizational structure and roles and responsibilities along with SDLC based on rational unified process for all subsidiary teams to follow.
• Full software application and business intelligence development lifecycle knowledge including Initiate, design, build user acceptance and implementation phases.

Technical Skills

Professional Experience

Confidential

Technical Lead

Responsibilities:

• Responsible for designing data validation framework for various assignments across domains.
• Designed a technical solution architecture and incremental project approach to introduce structured data storage and reporting to an internal reporting team.
• Worked with business and technology subject matter experts to define scope, create accurate and inclusive estimates, develop budgets and project plans, and produce high quality project charters and other planning documentation needed for funding approvals.
• Direct project activities, conduct reviews, manage risk, issues, and change control processes, and communicate status to senior executives within the development and business organizations.
• Managed and track project budgets, forecasts, and schedule to achieve project objectives and goals.
• Ensure that projects are in compliance with Project Management Methodology and Key Controls and that accurate and timely information is collected and reported regularly on project progress and financial status.
• Manage design processes around data flow from various Policy admin systems into Operational Data Store, Data warehouses and Data marts.
• Coordinated Data Systems Remediation, Data Cleansing activities and Error Handling.
• Post implementation support- Analysis of issues raised on daily basis and resolution to meet SLA with Level 2 support for data integration issues and SME for Production Support team with responsibility being day to day issue analysis, issue resolution, peer reviews, release preparation and performance monitoring and tuning.
• Lead various technical resources and team members to achieve project goals and deliver solutions following agile method of Project Management.
• Created documents and providing presentation of new processes for user training and business owner presentation.
• Analyzing data provided by multiple source systems.
• Drawing relationships among data elements and identifying inconsistencies.
• Designing multiple subject areas of the warehouse including positions, trades, and accounts reference data.
• Define and deliver data centric solutions including.
• Monitor performance of all Data Warehouse and reporting systems.
• Deliver 'best in breed' BI solutions by recommending tools, defining hardware and identifying optimal system configurations.
• Scoping, planning, and execution of a portfolio of IT projects utilizing standardized company Project Management Methodology.
• Managing cost, schedule, issues, risks, resource management, and status reporting and owning project management implementation, deliverables and results.
• Exercising a leadership role, ensuring the completion of projects within defined time-lines, budget controls and quality standards.
• Developing and managing the projects tasks and dependencies to ensure that development activities are consistent with established I.T. standards as well as those business objectives.
• Preparing management reports summarizing resource utilization as well as how project plans are performing against critical schedules and budgets.
• Leads/mentors less experienced staff on complex projects in area of expertise.
• Complete appropriate forms/discussions addressing performance and development goals for all employees assigned to each project to give effective, meaningful feedback.
• Demonstrated project management experience in the direction of multiple large or complex projects from beginning through execution. Demonstrated proficiency managing projects that typically have enterprise-wide implications as well as a highly technical complexity.
• Effective verbal and written communication skills for the purpose of providing and explaining project information and status to management, staff, and vendors.
• Running complex projects/programs from design and development to production.
• Managing multiple projects concurrently.
• Applying strong organizational, presentation, negotiation, and customer service skills.
• Reviewing, analyzing and evaluating processes and user needs for the system and negotiating deliverables and timelines with IT and business management.
• Consulting and advising team with regard to architecture approaches.
• Ensuring projects are completed by adhering to project management standards and architectural principles.
• Identifying and solving project issues, and employing appropriate escalation practices, as needed.
• Conveying a sense of urgency to all team members, business stakeholders and management.

Environment: Embarcadero ER Studio 9, Oracle 11g, Abinitio, Visio, Micro strategy 9.1, MS Excel, PowerPoint, Unix, MS Project, HP PPM,

Confidential

Lead Solution Design Analyst

Responsibilities:

• Performed data migration legacy system to target systems.
• Designed and managed the ETL process, including data mapping from source to target systems.
• Analyzed current Master data business processes and participate in designing future business processes.
• Developed prototype solutions to verify capabilities for new systems development, enhancement, and maintenance of MDM.
• Running complex projects/programs from design and development to production.
• Managing multiple projects concurrently.
• Applying strong organizational, presentation, negotiation, and customer service skills.
• Reviewing, analyzing and evaluating processes and user needs for the system and negotiating deliverables and timelines with IT and business management.
• Lead onshore offshore team in design development.
• Analyzing data provided by multiple source systems.
• Designing multiple subject areas of the warehouse including positions, trades, and accounts reference data.
• Managed Statements of Work, Project Plans, Change Orders and Project Estimates.
• Managed the program involving Data Conversions, Interfaces and Customer Data Integration.
• Functioned as a Single Point of Vendor Contact and delivered projects with high success rates.
• Coordinated the design and implementation of an Enterprise Data Warehouse.
• Developed approaches, methodologies, policies, and standards to govern master data
• Developed data owner and data steward strategies.
• Lead onshore offshore team in design development.
• Analyzed data provided by multiple source systems.
• Drawing relationships among data elements, identifying inconsistencies.
• Designed multiple subject areas of the warehouse including positions, trades, and accounts reference data.
• Monitored performance of all Data Warehouse and reporting systems.
• Preparing logical model.
• Physical model implementing with DBAs.
• Mapping Documents.
• Writing Functional and Technical Specifications.
• Design ETL Strategy.

Environment: Embarcadero ER Studio 9, Oracle 11g / 10g, Netezza, IBM Info sphere DataStage, Control-M, Visio, Business Objects

Confidential

Lead Business Analyst

Responsibilities:

• Project Lead and Client-site Coordinator for production support and development activities
• Performing Gap Analysis for designing future state application by analyzing current roles, applications and business processes.
• Extensive use of requirements tools to document Vision, Scope, Business Requirement, Business Rules, Business Events, Use Cases, User Interface, Non Functional Requirement, Implementation Plan, Test Plan, Test Case, User Acceptance Testing scripts and User Guides.
• Participated in monthly operation reviews for the customer and internal program reviews relative to Delivery Performance, Quality and Reliability.
• Provided ongoing project analysis, define mitigation strategy and plan as needed, communicated project status and identified and resolving project issues and constraints.
• Define roadmaps, project plans and steps to implement master data management architectures
• Enforce standard adherence of master data architectures for migration
• Responsible for design, development, and integration or testing of new or existing software features. Possesses significant skills and practice in software development, debugging, and testing techniques.

Confidential

Programmer Analyst

Responsibilities:

• Extensive application development, testing and Data Migration experience.
• Coordinated with teams at client site for System testing and User Acceptance testing.
• Widely used DB2 Database and created various data models using ER-Win.
• Participated in the implementation of Claims Data Warehouse for reporting.