PROFILE:

I am result - oriented Lead, Architect, Data Systems Specialist, Sr. Consultant and Lead Data Analyst/Business Analyst with over 20 years of Data Lake/Big Data, Data Warehouse(EDW), Cloud Computing, Operation Data store(ODS), Business Intelligence, Data Conversion, e-commerce, GUI and ERP Full life Cycle Implementation, strong Agile Scrum and SDLC experience, Record of successful performance, innovation and results in high-pressure environment working on various projects simultaneously.

PROFESSIONAL SUMMARY:

• Experience in lead the projects, coordinated across multiple teams and drive projects to completion
• Played major role as Architect/ Lead in Data Lake, Data Warehouse/Migration and BI Projects
• Lead the design sessions and worked with business and/or IT staff to define application, ETL/reporting requirements, build business Applications, Transaction/ intelligence reports for large user communities
• Experience in working with Data Architecture and Data Modeling based on Solution Architecture and Requirements.
• Experience in providing the Data Architecture based on various Source and Target data systems in Datalake (Big data) and Teradata/DB2/Oracle Environments
• Experience in providing the Data Model/Data Mapping/Data Profiling tasks on multiple projects
• Proficiency in Business Data requirements and converting them into conceptual, logical data models
• Experienced in Data Analysis, Design, Development, Implementation, Configuration, Administration, Trouble shooting, Migrations and Supporting of Data Analytics, OLAP and OLTP Systems
• Worked closely with Application/Data Business Owners and Business users to get the requirements and provided multiple clear choices to the business on possible solutions
• Provided Technical, Functional subject matter expertise to the Development teams and QA -provided technical guidance to junior team members and code walk-throughs
• Worked on Project Management tasks such as Project /Resource estimations, Change Management and Project Implementations.
• Worked with Off shore teams such as AMS team on Project Transition and Operational Tasks.
• Prepared Fact and dimension matrix and data mapping documents and Proficiency in ETL architecture
• Strong knowledge and experience in Dimensional Data modeling (Star/Snowflake) and Relational modeling using Erwin and Power Designer.
• IGC (IBM Governance Catalog)-used IGC for Data Governance and Data Mapping.
• Strong experience in Informatica Power Center, Proficient in using Informatica workflow manager, workflow monitor and Create, schedule and control workflows, tasks, and sessions
• Extensively used Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, and Informatica Server Manager
• Experience with Data Profiling and Data cleanse tasks on various source legacy systems
• Experience in developing strategies for Extraction, Transformation and Loading (ETL) using Informatica, SSIS, Data glance tools
• Expert in Various Reporting Tools BO, Crystal Reports, SSRS, PB reports, Oracle Reports 6i
• Experience in Business Objects(BO) Full Client, Supervisor, Designer, Broadcast Agent Publisher, Info View, Web Intelligence Explorer and Web Intelligence Reporter
• Experience in Database Programming creating Database Table and view definitions, Sequences, Synonyms, Procedures, Cursors, Packages, functions, triggers, Jobs and DB links
• Expertise in DBA tasks database backup and Recovery, database optimization, users, roles, groups creation moving code changes to Dev, Test and PROD environments using MS SQL server and Sybase
• Experience in writing and Modifying Unix Shell scripts
• Expert in Business Analysis, Design and Development of Data Systems/Client/Server and Web applications
• Application development experience using .NET, ASP, VB 6,Power Builder 10, XML and Oracle Forms 6i, Reports 6i with Databases Oracle 11g, 10g,9i,7, Sybase ASE 11, MS SQL Server and Shell Scripting
• Expertise in the entire QA Life Cycle Process, which includes design and development of Test Methodology, Test Strategy, Test Scenarios, Test Plans and Test Cases
• Expertise in Monitoring Scheduled ETL workflows, BO reports, SQL server and Oracle Job’s
• Managed daily Scrum, Analysis/ design, Demo, Weekly Prioritization, Project Estimations, Test Drive with Business, and lessons learned Meetings
• Experience in preparing Project status reports, Project estimations and Project scheduling
• My Core Competencies are Leadership * Team Player * Strong Communicator * Technical Skills * Domain Knowledge * Time Management * Analytical Problem Solver

TECHNICAL/FUNCTIONAL EXPERTISE

Databases: Big Data/ Data Lake, Hive, HBase, Teradata, DB2, Oracle 11g, 10g,9.x, MS SQL Server 2008/2005/2003 , Sybase 11 and Essbase

ETL: Talend 7.1, DataStage 11.5, Informatica Power Center 8.6/7.1,6.2,5.2, SSIS and Data Glance

BI/Reporting: Business Objects XI R3/R2, Crystal Reports XI,9, SSRS, Oracle Reports 6i and PB Reports

Languages: Scala/Spark, Pig, HQL,SQL, PL/SQL,T SQL C, COBOL, VB Script, Java Script, XML and Shell Scripts

GUI /Web: DOT net 2.0, ASP.NET, VB.NET, C#, Visual Basic 6.0, PowerBuilder 10, 9, 7, Oracle Forms 6i and MS InfoPath 2007

Database Tools: Hue, Teradata SQL Assistant, Toad 9.x, Oracle SQL developer, MS SQL Server Management Studio 8.x

Modeling: Erwin, Power Designer

Test Tools: Quality Center, WinRunner and Test Director

O/S: UNIX, Windows XP, 2000, NT and DOS

Version Control: Borland Star Team 2005, Visual SourceSafe 6.0 and Clercase

Req.Management: Borland Caliber RM

Tools: JIRA, Zena, Remedy, Team Track, FTP, Git hub, Jenkins, Putty and IGC (IBM Governance Catalog)

Content M tool: MS SharePoint Server 2007 ( MOSS), Quicker

PM Tools: JIRA, MS Project, MS Office,2003

ERP Module: Work Management, Sales, Purchasing, Material Management, Inventory, Quality Management, Controlled Documents, Engineering Change Financial Accounting, Budgeting and Action Tracking

EDW & BI: Insurance/Healthcare, Transportation, Energy and Banking domains

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Data-Application Architect / Data Systems Specialist

Responsibilities:

• Worked as Data/Application architect on various Gov projects on Medicaid and Medicare data
• Knowledge and expertise on solution/data architecture and data Modeling.
• Worked on various data flow/process flow diagrams and Design documents.
• Worked on Technical spec and Data Mapping documents for Extraction and TL process for GPD, FSD and above mentioned projects in ODS & EDW.
• Worked on data specifications and elicited business requirements to data requirements
• Created Data maps / Data Profiling in MS access and Excels to assist ETL teams for development and Quality assurance teams for Test Plan /cases creation.
• IGC (IBM Governance Catalog)-used IGC for Data Governance and Data Mapping.
• Worked on Data Models (Logical and Physical) and Data traceability documents.
• Extensively used Erwin for Conceptual, logical and physical data model creation in EDW and Bigdata
• Erwin is used for forward and reverse engineering of the database/tables
• Worked on Talend for ETL using files (XML/Json etc) and databases for the data transmissions.
• Participated and Facilitated JAD & requirement gathering sessions & Worked on Prototyping of different projects and on PPP phases of the projects
• Worked on Agile/scrum methods and extensively using Jira tool on Epic & Stories and Tasks
• Worked on Data Analysis and Gap Analysis/Impact Analysis study by reverse engineering and Estimation process for Rating Engine PPP & other projects.
• Worked on SQL and HQL for data Analysis as per the Business requirements for all the projects.
• Worked on Feasibility study on 2R’s project on current state Teradata/DB2 to future state of Architecture Data lake environment.
• Worked on Project Management tasks such as Project /Resource estimations, Change Management and Project Implementations.
• Attended Daily Scrum calls for FSD / 2r’s and other project.
• Worked with Off shore teams such as AMS team on Project Transition and Operational Tasks
• Worked on CRS and SRS documents for NGEN and GOV(MOM’s, IL/NM Medicaid etc) projects.
• Created data traceability matrices/Semantic Design documents for Claims and areas.
• Worked on customization of IBM HPDM model 8.5 to Confidential business requirements
• Involved in performing analysis and reporting to support process improvement and to improve efficiency of medical and pharmacy claims
• Worked on various Data Environments (Datalake /ODS / EDW) projects in Data Analysis/Design, Data Molding, Data Mapping, and Data Profiling.
• Conducted working sessions and walk trough of requirements with both development and quality assurance teams and Trained many Jr. Analyst’s in last 5 years.
• Lead the team of analysts and effectively worked towards requirements delivery to development

Environment: Bigdata/Data Lake, Hive, Pig, Scala/Spark, Talend 7.1, Teradata 13.10, DB2 10.1, HQL, Oracle, SQL, SQL Server, Zena 3.1 Datastage 8.5/11.5, Jira, IGC (IBM Governance Catalog) and Erwin

Confidential

Data-Application Architect/ Lead Data Analyst

Responsibilities:

• Worked on Source data analysis, gap analysis, recommendations, Logical, Physical data models and ETL Mapping design specs.
• Involved in Complete end to end ETL process from various data marts and databases in to EDW
• Worked as SME to identify and prepare the FACT /Dimensions matrix and data mapping documents
• Extensively involved in data profiling, data Integration and data cleansing processes
• Extensively used Workflow Manager and Workflow Monitor tools on day to day activities
• Extensively used Informatica client tools like Source Analyzer, Target designer, Mapping designer, Mapplet designer and Transformation Developer
• Created various Mappings, Mappelets, Sessions, Workflows and Work lets
• Responsible for Complete ETL design and development of POS application which is complete file system and move the data to SQL server F & B database using SSIS
• Created Replication process for CSPMI Source databases Remedy and WIMS using MS SQL Server
• Responsible for BO Universe Designing, Hierarchy Building for Data Analysis and applied conditions/filters in Business Objects.
• Worked on BO Designer Functionalities like Derived Tables, Linked Universes, Aggregate Aware, Index aware, Contexts, Aliases, complex joins, LOV’s and Cascading Prompts
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies by applying contexts and alias tables to remove cyclic dependencies.
• Scheduled and Monitored reports using Central Management Console and Info view.
• Implemented Trigger files in report schedules to control reports based on data loads
• Prepared design and development of Test Methodology, Test Strategy, Scenarios, Plans and Cases
• Involved in Preparing Test and Implementation documents for ITII F & B and CSPMI applications
• Managed daily Scrum, Analysis/ design, Demo, Weekly Prioritization, Project Estimations, Test Drive with Business, and lessons learned Meetings
• Prepared Change Management and ORR documents and involved in getting the Approvals
• Coordinate /Prepared Test, Implantation(pre/post/cut over) and Hr/Hr matrix documents
• Coordinated with other Testing/application teams for V to V severs transfers and left and shift servers
• Involved in Interface/ FTP/ETL setup changes and verified and UAT for moved servers

Environment: Informatica 8.6, SSIS, Business Objects Enterprise XI3.1, Crystal Reports, WebI 3.2, Deski, Oracle 11g, MS SQL server 2008, SQL server BI Studio, DB2, Visio, Erwin 4.1,Quality Center, XP, Unix.

Confidential, IA

Sr. Consultant / Application Lead

Responsibilities:

• Participated in the full lifecycle of BI development including business function analysis, design, and architecture documents.
• Responsible for Design of Conceptual and Physical data model using Erwin tool.
• Involved in defining the complete data warehouse architecture (ODS, Data Marts, EDW).
• Designed ETL architecture and prepared reporting architecture, proto type models for Confidential Reporting.
• Played major role as Application lead in the Complete Data Conversion/Migration Process for Confidential
• Worked with SME to identify and prepare the FACT /Dimensions matrix and data mapping documents in various subject areas in EDW and Confidential
• Interact with Confidential Functional leads and existing Site Application Business owners to identify the field to field mapping and Transformation rules and to prepare the ETL mapping design specifications
• Extensively involved in data profiling, data Integration and data cleansing activities
• Extensively used Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, and Informatica Server Manager
• Created mappings with Stored Procedure Transformations to build business rules to load data.
• Involved with upgrading Informatica Power Center from 6.x to 7.x including mappings, sessions, Worklets and database accessibility.
• Responsible for Source data validation and data scrub and data cleanse using PL SQL scripts
• Created decoding process to move the data from MS SQL server to Oracle
• Developed/Deployed various SSIS packages for Full and delta loads from Confidential source system to NMAS data mart.
• Converted the SQL Server Database data to Oracle region using SSIS packages.
• Responsible for Analyze, Design and coding the interface programs
• Conduct code walk-thru of systems solutions to ensure design quality and consistency, as well as cross- to the business requirements
• Modifying the Unix Shell scripts based on the business requirements
• Designed Universes by defining joins, cardinality between tables, linked the existing Universes in Business Objects XI R3
• Built advance visual dashboards to analyze from summary level to detailed report.
• Manages daily Scrum, Weekly Prioritization, Project Estimations and lessons learned Meetings
• Prepared Change Management and ORR documents and participated in review process
• Prepared Confidential /EDW Project Technical cut over, Pre/Post Hr/Hr cut over plan and process
• Coordinate for all Source database schemas refreshes to Con1, Con4 regions
• Manage in Review workshops, V & V review and SIT for Mock loads and Final loads
• Manage/ Participate in resolving Post Implementation issues from Command center
• Manage / Participate the complete Data center move project for BI projects and WM application
• Prepared Test and Implementation Plan documents, Test Cases, UAT and co- coordinated their execution for Confidential and Data Center move Project for WM and AT applications.
• Worked with Quality center for Defect Tracking, Test cases and Test Scripts

Environment: Informatica Power Center 8.6, 7.1, 6.x, SSIS, Business Objectes XIR3, R2, Crystal Reports, Oracle 11g, 10g, Sybase, SQL Server 2008, XML, PL SQL/SQL, TOAD, Erwin 4.1,Remey, Quality Center, Borland Star Team, Control M, Windows XP and UNIX