Summary:

• 19 years of Business and Technical IT experience with Fortune 500 Companies, ISO 9001:2000 certified CMM SEI level 4 companies - having roles and responsibilities as Vice President Executive , Project Director Executive , Senior Consultant, Project Manager, Sr. Data Architect/Data Modeler ,Sr. System Analyst , Sr. Data Analyst Sr. Business Analyst with demonstrated leadership and technical skills having worked directly with the cross department Senior Management, Client's Business team , IT team or Offshore Onsite model in all projects either technical or non-technical receiving appreciations at various levels.
• Architecting, Designing and Overseeing the ongoing development and operations of an operational data store and enterprise data warehouse for Business Intelligence Projects in Waterfall and Agile SDLC Methodologies
• Expertise in Software Integration, OLAP and OLTP applications
• Expertise in Enterprise Architecture and TOGAF Architecture Framework. Knowledge of Zachman Framework.
• Expertise in Ralph Kimball and Bill Inmom Methodologies
• Expertise in Conceptual, Logical and Physical Data along with DBA modeling using ERWin Visio, and ER Studio
• Expertise in UML Modeling Class Diagrams, Use Case Diagrams, Sequence and Activity Diagrams. Proficient in writing Use Cases
• Expertise in Program/Project Management, Architecture, Data Warehousing, Data Movement and Integration ETL, EAI , Data Migrations, Data Architecture, Structured and Unstructured Data Management Big Data technologies , Data Quality, Metadata
• Improving and streamlining processes regarding data flow and data quality to improve data accuracy, viability and value for Business Intelligence Projects
• Collaborating with end users to identify needs and opportunities for improved data management and delivery for Business Intelligence Projects
• Improving and streamlining processes regarding data flow and data quality to improve data accuracy, viability and value for Business Intelligence Projects
• Overseeing the ongoing development and operations of a business intelligence architecture that enables fact-based decision making and ad hoc analysis and insight generation.
• Staying current with industry trends in Business Intelligence
• Advising and educating management on their relative importance and impact.
• Recommending and implementing strategies after analyzing current processes process optimization , systems and methodologies currently in place and recommending solutions for new cost-effective production, architectures and operational improvements, integrated information technology and human capital management to improve performance and enable clients to focus on increasing sales and profits.
• Ability to provide insightful and clear data for upper management to assess key performance indicator KPI to improve business health. Quantifying results applying and implementing statistical modeling predictive modeling with suggestions for process developments to reduce errors and improve business and organizational performance.
• Proficient in all aspects of BI and Information Management processes, technologies and architectures such as
• o BI delivery mechanisms: portals, thin/thick clients, email/mobile phone alerts, etc
• o BI tools such as report builders, ad-hoc queries, OLAP, dashboards, BAM business activity monitoring , data mining and predictive modeling
• o Dimensional data modeling principles star and snowflake schemas, de-normalized data structures, slowly changing dimensions, etc necessary to support
• o Physical data architecture options such as enterprise data warehouse, data federation, hub spoke architectures, independent data marts
• o Data integration tools and techniques such as ETL Extract Transform Load , CDC Change Data Capture
• o Relevant related areas such as data quality, master data management, metadata management, collaboration and business process management
• o Strong mathematical background in understanding Statistical Modeling, Risk Modeling Risk Analysis , Mathematical modeling Analytical Models or Numerical Models , Scientific Computing Research Analysis Market Analysis, Resource Analysis, Queue Models, R D being applicable to business domains

Skill matrix

Technical Skills:

Professional Experience

Confidential

Sr. Project Manager Business Intelligence

• Manage several Business Intelligence BI projects occurring concurrently. These projects require detailed project plans to map out the delivery timelines, complex mix of resources both on and off-shore, and multiple customers for approvals.
• Working in medium to large project teams, assisting with the definition of resources, responsibilities and project timelines
• Analyzing and designing solutions for Data Warehousing and Business Intelligence
• Conceptual, Logical and Physical Data along with DBA modeling
• Managing and mentoring mathematical Modeling, Business Intelligence and Data Warehousing teams
• Managing the design and extension of the Business Intelligence applications
• Managing the design and coding of Source Dependent Extracts, Source Independent Loads, and Post Load Processes from source to target systems
• Managing the design and implementation of user defined Dashboards and Reports
• Managing the validation and implementation of Business Intelligence solutions
• Reporting on the technical aspects of the project status to the 'C' level Executives, Directors and assorted Stakeholders
• Seeking out and championing new business and technology initiatives with Company stakeholders providing long term value
• Supervising and/or assisting the continuous enhancement and support of existing Data Warehousing and Business Intelligence solutions
• Consistent effort in exceeding customer service levels.
• Timely delivery of Business Intelligence and Business Intelligence Application solutions
• Testing Working in conjunction with the business users and development teams, responsible for the creation and execution of application test scripts, scenarios, and test plans that validate initial business requirements.
• Perform requirements change management, impact analysis and gap analysis
• Understanding Key Performance Measures and Indicators that drive company measurement, reporting and analytics across functions
• Understanding how these metrics and measures align and track against overall business strategies, goals and objectives.
• Provide leadership in developing standards, architectural governance, solution design patterns and IT best practices. Work with Business Analysts and Designer / Developers to create the right solution for each reporting need.
• Work with cross functional departments and the IT staff and gather / review business requirements, solution alternatives, and designs. Train, guide and mentor other IT staff in adapting standards, best practices to provide superior quality solutions for business requirements. Infuse architectural concepts like reusability, standards based, configuration driven, scalable and manageable solutions. Provide support to other IT staff in high priority issue resolution as needed.
• Involving Data Governance, Data Cleansing, Data Stewardship best practices and evolving them for organizational strategy
• Managing, understanding and documenting 'As-Is' and 'To-Be' for Business Intelligence processes. Designing logical and mathematical models
• Creating Business Rules to be functional mathematical for calculating risk like loan scoring, Basel Compliance II and Fair Lending Compliance
• Interviewing and documenting the Business Architecture and application Architecture
• Involved in Business process analysis, gathering and analyzing requirements, translating of business requirements , assisting in project scope determination and providing estimates of level of effort, assisting to manage multiple tasks and respond to tight deadlines in a fast-paced environment, mentoring the team for the project through excellent communication skills, giving trainings on projects business domain
• Conducted product evaluation, procurement and vendor due diligence process
• Trained in Cloudera/Hadoop and MPP Systems massively Parallel Processing using Informatica
• Conducting POC on Big Data and/or BI offerings using Microsoft SQL Server Parallel Data Warehouse/Hadoop

Environment: RSA Archer Suite, Optimal Blue, CompassPoint, ERWin 7.x, Oracle 10g, SQL Server 2005/2008, SSIS/SSRS, Visio, Excel, Project Insight, Microsoft SQL Server Parallel Data Warehouse

Confidential

Sr. Business Intelligence Data Architect

• Architected and Modeled STAR Scorecard Diagnostic Systems datamart for the reports
• Understanding and documenting 'As-Is' Architecture. Architecting 'To-Be' data warehousing considering OLAP/OLTP application data flow
• Modeled Enterprise, Conceptual, Logical and Physical Data Modeling for the STAR Scorecard
• Translating of business requirements into technical requirements by conducting the following data analysis like
• o Normalization First, Second and Third normal form and De-Normalization
• o Creating Data Partitioning and Analyzing data movement through SAS and creating ETL Design and
• Creating Data Dictionary and Data Mapping documentation using proper Corporate Naming Conventions
• Responsible for the development, care, and maintenance of data model Data Governance activities
• Analyzing data flow, existing SAS code and its reverse engineering to be utilized for ETL purpose
• Assists Business Unit Leader in developing tactical and strategic product, services and/or programs to support the business unit's goals of creating scorecard
• Worked closely with IT personnel and business partners to identify and maximize opportunities to use information and technology to improve program business processes.
• Review, analyze, and create detailed documentation of business systems and user needs, including workflow, program functions, and steps required to develop or modify reporting programs.
• Consult with IT personnel to determine business, functional and technical requirements for creating reporting applications.
• Coordinating the development of all approved versions of business and functional specifications for specified applications. Reviews use cases and other technical documents with IT project staff to ensure business requirements are adequately reflected in technical planning documents.
• Creating Data Governance, Data Cleansing, Data Stewardship best practices
• Analyzing the business unit's activities and trends and compare analyses against the service standards and best practices. Presents findings and works with the Business Unit Leader and other personnel to identify and implement strategies that will address tactical and strategic goals.

Environment: Embarcadero ER Studio 9.0, Visio Data Modeling Tool, SQL Server 2008, Oracle 10g, SAS 9.0

Confidential

Sr. Data Architect/Data Modeler

• Understanding and documenting 'As-Is' Architecture. Architecting 'To-Be' Real Time Active and Passive data warehousing using IBM Technology
• Understanding of several OLTP applications - Meter Data Management MDM , OpenWay DCE , CIS Customer Information System and their integration utilizing SOA Service Oriented Architecture constituting AMS Advanced Metering System for the implementation of Smart Grid Technology utilizing CIM Common Information Model Framework
• Elicit requirements using interviews, document analysis, requirements workshops, surveys, site visits, business process descriptions, use cases, scenarios, business analysis, task and workflow analysis.
• Critically evaluating information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests from the underlying true needs.
• Proactively communicating and collaborating with external and internal customers to analyze information needs and functional requirements and deliver the following artifacts as needed: Functional requirements Business Requirements Document , iii. Use Cases, report and Interface designs
• Utilizing experience in using enterprise-wide requirements definition and management systems and methodologies required.
• Work independently with users to define concepts and under direction of project managers
• Drive and challenge business units on their assumptions of how they will successfully execute their plans
• Strong analytical and product management skills required, including a thorough understanding of how to interpret customer business needs and translate them into application and operational requirements.
• Modeled Enterprise, Conceptual, Logical and Physical Data Modeling and implemented Meter Events Error Handling Project data mart for the Failure and Repair Maintenance reports
• Enhancing Utility Industry Data Model ADRM for the Enterprise Data Warehousing Perspective.
• Responsible for the development, care, and maintenance of data model Data Governance activities
• Utilized a fusion of Utility industry knowledge and analytics to provide executive management with the development of interactive business tools, and strategic analysis, vital for use in mission-critical decision-making
• Involving Data Governance, Data Cleansing, Data Stewardship best practices and evolving them for organizational strategy
• Mentoring and presenting for ETL Design, involving research and analysis for complex ETL processes and providing enriched Data Integration Solution.
• Presentations to 'C' level, Architect Groups and other groups

Environment: Data Architect, IBM Infostreams 1.0/2.0, IBM Smart Analytics, ERWin 7.x, Embarcadero ER Studio 9.0, SAS 9.0 , Toad/DB2 Client 9.1, DB2 9.1.7, Business Objects, Oracle 10g, Tivoli, Maximo, Windows 2005, Visio, Data Integrator 11.7.2

Confidential

Senior Consultant

Management Activities

• Data collection strategy
• Architected and implemented Automated traffic citation management systems datamart for the financial reports
• Statistical Modeling of AIS Adult Info System accident data a total number of 417,670 cases using SAS from 2005 to 2009 by creating initial dataset having drivers' records only and does not include passengers' information.
• Strategizing and implementing complete vendor and requirements gathering cycle.
• Business Process modeling and Conducted FIT and GAP analysis
• Defendant's Debt's Collections
• Serve as the liaison between vendor, business and technical domains
• Strategizing and implementing complete vendor and requirements gathering cycle.
• Strategizing and implementing Master Data Management MDM scope and Customer Data Integration CDI
• Business Process modeling -
• o Expected Loss Forecasting by performing Missing Data Analysis
• o Debt Score Card Analysis for identifying low, medium and high risk debtors
• Architected and implemented Debt Collections datamart- Data gathering from 12 applications using Oracle 9i/10g, SQL Server 2005, MS Access, DB2 mainframe file. Performing data extraction, data cleansing, modeled Star Schema for Financial reports in Oracle 9i/10g
• Statistical Modeling data analysis Financial analysis using SAS age, type of courts misdemeanor/felony/family, age group, male/female, debt ranges, payment schedules, collection calls using data from 1981 till today.
• Computerized Maintenance Management System CMMS or Enterprise Asset Management
• Business Process modeling for Dallas County Jail's, Dallas County Buildings, Laundry and Cooking facilities, Facility Management, Fleet Management, Supply and Purchase Department
• Collecting data from various departments for manual feeding and identifying systems for data requirements for data extraction
• Strategizing data transformation , conversion and loading to Oracle 10g for Famis application

Environment:

Oracle 9i/10g, SQL, PL/SQL, Toad 7.6, Erwin 7.1, SAS/Base, Stat, C , ASP.NET, SQL-2005, Novell, Clarity, Visio, MS Suite, Test Director, Daptiv

Confidential

Senior Data Architect/Modeler

Appraiser/Appraisal Management System Collateral Management System

Responsibilities:

• Researching Business Architecture, Technical Architecture Reverse Engineering current application and their data bases
• Creating Functional design spec to meet business requirement using UML RUP .
• Gathered Interfacing Data Touch Points Requirement , Data Retention Data Governance Requirements Historical data conversion and transfer
• Reverse Engineering Interact DB database , Datamart and DTS packages for data mapping and Financial/Management Reports for the EAI application
• Produced Data Map, Data Dictionary, Field Definitions, Database assessment and approach document, issues in existing database and report
• Data Migration Requirements, data mapping, roles and responsibility, Script writing for rolled deployment phases, testing
• Data warehousing Architecting and Implementation activities:
• Performing interviews JAD sessions and documenting Master Data Management MDM Customer Data Integration CDI
• Performing and documenting ETL process - Data scoping/Data abstraction from OLTP Server and other
• Performing Data cleansing , data validation, data profiling for the Data Staging environment
• Data warehousing architecture and data modeling
• Business Modeling for queue management using M/M/c mathematical Model for FIFO, recruitment modeling in relation to customers, geography and order generation
• Statistical Modeling using SAS package for Strategic workforce planning. This involved analyzing and forecasting the appraisers and reviewers needed based on geography to execute their business strategy

Environment:

Erwin 7.1, SAS/Base, Stat , Oracle 9i/10g, SQL, PL/SQL, SSIS, SSRS, Toad 7.6, C , ASP.NET, SQL2005, Lotus Notes, Clarity, Visio, MS Suite, Test Director

Confidential

Senior Data Architect/Modeler/ Analyst

The ODJFS Office of Ohio Health Plans is responsible for administering Ohio Medicaid.

Responsibilities:

• Reverse Engineering OJI by using T-SQL, technical documents, understanding the data flow, table/store procedures related to the given module of the OJI system.
• Analyzed and documented the business reporting requirements and architected the star schema dimensional model based on key dimensions and performance measures.
• Performing and documenting ETL process data and interface requirements, data mapping from interfaces and data base in the system boundary, data cleansing, data flow, data definition and dictionary
• Created the logical and physical data models Normalization 2NF/3NF for the data warehouse using Erwin.

Environment:

Erwin, Java Technology, AS400 Mainframes , COBOL, SQL Server, Toad , UNIX, Oracle 9i, Test Director, Rational XDE, ClearQuest, PVCS 6.0, Lotus Notes, Novell GroupWise, Visio 2002, MS Suite

Confidential

Sr. Data Architect/Modeler/ Analyst

The project at Anthem was related to Agent's and Policy Sales Management system

Responsibilities:

• Prepared the technical design and architecture and led a group of developers in the development of the system
• Analyzed the data sources extensively to determine availability of the required input data
• Established the Entities, Attributes and Relationships and created the Logical data model LDM Normalization 3NF and mapped the same to the Physical data model PDM

Environment:

Erwin, Java Technology, SQL Server, Oracle 9i, Windows NT, Lotus Notes

Confidential

Data Modeler/Data Analyst

Discarding the old applications and combining them with Path.net system an underwriting process system.

Responsibilities:

• Performing Scope Analysis for Data Cleansing and Interfacing application for the new Path.Net
• Involved in data modeling using Erwin for the OLTP and OLAP servers and conducted sign off's from related stakeholders
• Creating UML Diagrams and writing use cases

Environment:

.Net Technology, C , ASP, SQL-2000 , Visio, MS Suite, Datamart and data warehousing, Erwin,

Confidential

Sr. Data Modeler/Data Analyst

EBCBS developed services that addressed only or mostly the administrative aspects of claims processing by developing Administrative Services Only or ASO .

Responsibilities:

• Mathematical Modeling , Data analysis, curve generation for Insurance products and managing Offshore Onsite Communications
• Business process analysis and worked as a Data Modeler in analyzing the business data needs creating the logical and physical data models for the data warehouse.
• Designed and Developed the ETL process, using Informatica Power Center. Created Mappings, analyzing surrogate keys, candidate keys, inversion keys, primary keys and foreign keys . Implemented the keys using Erwin

Environment:

Oracle 9i, UNIX Korn Shell Scripts, Lotus Notes, Erwin