PROFESSIONAL SUMMARY:

• Senior Solution and Enterprise Architect with over 20 years IT experience, who understands all components of Architecture (Business, IS - Data/App and Technology domains) with core competence in Data and Solution Architecture.
• Togaf 9 Certfied Architect with experience in various architecture frameworks and project methodologies such as Togaf, Dodaf, Zachman, COBIT, ITIL, Agile, Scrum and Waterfall methodologies.
• Subject Matter Expert in Healthcare, Retail, SCM (Supply Chain Management) and WMS (Warehouse Management Systems).
• Extensive knowledge in Big Data applications in Hadoop framework using Greenplum Database and various ETL tools such as Hive, Pig and Sqoop.
• Built resilient applications using model-based techniques for design-time architecture specification and analysis accompanied by corresponding run-time support.
• Experience in architecting, leading and implementing content management and portals, e-Commerce, SOA, BPM, SSO, EPM, BPC, BW/BI Integration architecture across wide range of technologies.
• Experience working with solution delivery, application development, infrastructure management, SaaS & PaaS models, security teams and managing large Infrastructure related deployments with Microsoft, IBM, Linux, Sun & HP platforms.
• Subject matter expert on various Enterprise Architecture practices that include, Gap analysis for Domain architecture, creating a complete architecture plan with transition architecture points to achieve target architecture (to-be) from baseline adhering to governance and change management practices.
• Experience includes working on multi-platform installations in the roles of Lead Architect, Solution Architect, Enterprise Architect, ERP/CRM Administrator, Sr. Data/ETL Architect, Data scientist, Tech-Lead, and Sr. Programmer/Analyst.
• In-depth knowledge of ETL applications and tools gained by working as ETL developer and ETL architect. Hands on experience on various ETL tools such as Informatica, Datastage, SSIS and DM Express.
• Expertise includes working knowledge of different data modeling tools along with best practices of MDM in line with industry related standards such as HIPAA for health care, Retek/RDW for retail and EDI for data feeds.
• Extensively used various software and Business Intelligence tools while working on projects related to various domains such as Retail, Health, Insurance, Finance and Manufacturing.
• Excellent in interpersonal, communication and writing skills and is capable to work well in team or individual environments.
• References from current and previous work experiences upon request.

TECHNICAL EXPERTISE:

Architecture Expertise: EA, TOGAF, Dodaf, SOA, Zachman, Archimate 2.0

Project Methodologies: Agile, Waterfall, Scrum, Rup, JAD, ITIL, CobIT, PMP

Database Expertise: MDM, Data Models, Data Marts, Data Mining, HDFS(Hadoop Distributed File Systems), ETL (Informatica, Data stage), 3NF (Third Normal Form), ODI, OLAP, ROLAP, MOLAP, HOLAP, AMDD (Agile Model Driven Dev)

Operating System: UNIX, LINUX, MVS, OS/390, DOS/VSE, Windows 95/98/NT/2000/XP/7, MS DOS

Hardware: IBM ES 9000, Honeywell Bull Mainframe, IBM-3090, IBM ES-9000, Pentium PCs, DELL Laptops

Languages: C, C++, JAVA, .Net, PL/SQL, T-SQL, UNIX Shell Scripting, Perl, COBOL, JCL, XML, UML

Tools: & Utilities Cloudera(Hadoop), Pig, Hive, Sparx 12.0, E/R Studio, ERwin 9.X, SAS, Outlooksoft 4.0/4.2, SAP BPC 7.0/10, Retek, Micro Strategy, Quality Center, TSO, ISPF, VSAM, QMF, SPUFI, MS Office, Visio

DBMS: SQL Server 7.0/2005/08/12/14 , Oracle 10g/9.i/8.x/7.x, IMS-DB, DB2, MS Access

PROFESSIONAL EXPERIENCE:

Sr. IT Architecture Analyst

Confidential, MN

Responsibilities:

• Working as a Senior Solution Architect/Enterprise Architect in Community and State department that has its focus on new business opportunities.
• Created numerous SSDs(Solution Summary Documents) and SODs(Solution Outline Documents) for various projects.
• Solutions were either created as part of a RFP to bid for various state and federal projects or as part of process that would implement any such solutions after successful bidding.
• Often involved in Gap analysis by identifying current state architecture and future target state architecture with intermediate transition architectures.
• Extensively used SPARX Enterprise architecture tool to create various architecture diagrams, solution diagrams, data flow diagrams, process flow diagrams adhering to Archimate 2.0 standards.
• Extensive work on Provider and Claims subject area to improve data quality of Providers.
• Created a solution that would be implemented in phases to improve Provider data quality in phases. Initial phase would be used as a pilot and its success metrics would be analyzed to implement future phases.
• Switched roles as Data Architect, ETL Architect while working on data related projects.
• Successfully lead and implemented data projects which involved extracting and sending medical and lab data to outside vendors who would run analytics and rate/rank our partners.
• Day to day work involves interacting with Business Architects, Managers of Business Analysts, Tech-Leads apart from guiding/mentoring developers to ensure implementation of solution is on right path.
• Weekly reporting to directors and VP of C&S team giving a status update of the work done during week with emphasis on pain points and road blocks.
• Engaged in extensive data profiling and data mining to create solutions that would refrain from using band aid fixes and give a long term solution.
• Actively participating in ARB meetings to make sure standards of C&S Architecture are met by all of us as a team.
• Mentoring architecture team on Togaf and Archimate 2.0

Environment: Archimate 2.0, SPARX 9.0, Erwin 9.x, SQL Server 2012, Sybase IQ/15.4, Oracle 11i, Datastage7.5, 8x, SSIS, SSAS, SSRS, MS-Office Suite, Visio, MSP.

Confidential, Albany, NY

Sr. Solutions Architect/Data Scientist

Responsibilities:

• Worked as a Sr. Solutions architect providing solutions in all domains of architecture such as Business, Information Systems (Data/App) and Technical architecture.
• Actively participated in weekly architecture review meetings and presented various designs related to data models that were being modified and implemented.
• Regular interaction with senior management that includes VP - Corporate Analytics, Director - Data Management Director - Business Intelligence (Stats) and Director - Actuarial.
• Saved millions of dollars by stream lining applications run for Government related programs such as Medicare, Medicaid and HEDIS by reducing number of rejections in claims that were rejected due to frequent processing and submission errors.
• Worked as Data Scientist with SAS team to create HEDIS measurements programs that would be shared with employers to improve quality of health for their employees.
• Worked extensively on various Government related projects such as Medicare, Medicaid, All Payer Database (housing Clinical and EMR data), child welfare etc.
• Worked extensively to rebuild semantic data layer over EDW by merging tables that had duplicate information.
• RFPs covered in detail all the modules/deliverables along with cost estimation considering software costs, resource allocations within the organization and from external suppliers.
• Managed team of 8 ETL developers and presided over their work as a Team Lead cum Solutions Architect.
• Participated in discussions related to laying down guidelines for ETL load processes and Error handling.
• Enforced strict Governance and Stewardship rules by ensuring all standards were met such as across the domains of architectures such as business, Information Systems (Data and application) and technology.
• Built an end to end solution for All Payer Database by designing a solution architecture that was built on Java and Tibco applications for front end and service layer and on SSIS/Informatica for data extraction, transformation and load.

Environment: Java, Core Java, Tibco, Informatica Power Center 9.X, Oracle 11g, SQL Server 2012, Erwin 8.X, Ms-Office Suite, Visio, MSP, SAS, Clarity, Powerbuilder.

Confidential, Southfield, MI

Sr. Solutions Architect

Responsibilities:

• Worked as a Sr. Solutions Architect on a development project.
• Performed fit-gap-analysis to reach target architecture from baseline architecture and identified transition architecture points.
• Designing solutions related to financial changes that would be implemented as part of new contract terms that will be laid out in 2014.
• Involved in design discussions of various teams attending weekly scrum meetings.
• Data modelling for BI and BPC needs. Creation of dimensions and facts that would be used in building OLAP cubes for SAP.
• Built a process of sales consolidation that starts with dealers (over 150) submitting their Trial Balance as a CSV file. This file will then be loaded into BPC (MIS application) using a customised Import package, on a monthly basis.
• Reports like same store comp sales, quarterly targets and goals, success metrics on these goals, P&L are generated from the BPC system.
• Slicing and dicing of data to roll up for summarized data that would be used to do comp sales for dealers across North America.
• Attending daily scrum meetings to meet the dead lines and switch roles as tech-lead to mentor full time employees who would take over the application for maintenance.

Environment: JAVA, Data stage, Oracle SOA, TOGAF, ERWIN 9.2, Model Manager, Oracle 11i, MS-Visio, SAP BPC, SQL Developer, MS Office

Confidential, Detroit, MI

Lead Architect

Responsibilities:

• Performed as Data and Solutions architect for various federal government mandate programs such as RMRA (Revenue Management Risk Adjustment), E2E (HIX) End to End Health Information Exchange and PPQ(Product, Pricing Quote).
• Worked extensively on Operational and transactional data requirements for BI which would run reports to measure success of these mandates/programs.
• Lead a team of data architects in Business Intelligence Center (BIC) on an Enterprise Data gaps project aimed at building one true source of data.
• Work involved extensive data profiling to determine quality of existing data and classifying them into various categories based on the quality.
• Responsible for ensuring data used by various Data marts and Data warehouses have confirmed data. Diagnosed the faults with Source Data, eventually leading to business process reengineering initiatives to address the root causes of bad data and improve data quality over time.
• Lead a team of Informatica developers and trained them on IDE (Informatica Data Explorer) to ensure data profiling results were captured in a readable fashion for end users.
• Trained Data Modelers Erwin Model manager to help them use MM as version control tool for models and also as a metadata repository tool that could be used to query at the actual entity/attribute levels.

Environment: ERWIN 7.3, Oracle 11i, Informatica Power Center, MS-Visio, SQL Developer, MS Office

Confidential, Ann Arbor, MI

Data Architect/Data Lead

Responsibilities:

• Worked as a Sr. Data Architect for various state Governments to manage their Medicare and Healthcare information abiding by HIPAA rules and regulations.
• Worked on various RFPs in order to win projects from different State Governments to build and maintain their MMIS and other public health projects.
• RFPs were submitted with various options that would include selling only Analytics tool (Advantage), building and maintaining DW and Data Mart layers along with tool, integrating existing DW with our tool.
• Managed team of Data Analysts and PL/SQL developers who would work on databases designed by me.
• Updated and maintained logical and physical data models for Operational Data Stores (ODS/Staging), Integration Layer (DW layer) and publishing (Analytics) layer.
• Redesigned applications that were written in PL/SQL and enhanced their performance by bringing down time of execution to 10% of their original times.
• Involved in discussions with front end BO developers and guiding them by suggesting methods to extract data from the models.
• Designed and built 3NF data models apart from maintaining high quality of data, integrity, and reduced redundancy.
• Supported projects related to 3 different states by maintaining their claims and clinical data.
• Staying up to date with latest enhancements related to ICD 10 codes. Modifying data models to be
• ICD 10 compliant.
• Worked extensively on Oracle Enterprise Manager (OEM) for monitoring database activities, and running production jobs.
• Chained various programs and created an automated process to run the jobs there by reducing manual intervention to negligible levels.
• Guiding ETL developers and data analysts to improve code and processes that were used for extracting and building data components of Data warehouse.

Environment: ERWIN 7.2 and 7.3, Oracle 11i, Datastage, MS-Visio, SQL Developer, MS Office

Confidential, Owings Mills, MD

Data Architect/Data Lead

Responsibilities:

• Working as a Sr. Data Architect for various Portal related projects such as Employer, Member, Provider and Primary Care Medical Health (PCMH) Portal which deal with different Health Insurance related information. Concurrently working on various HIPAA and Federal Government regulated Medicare Projects.
• Information is secured at various levels depending on roles of members that access this data from within CareFirst and from outside Employer groups locations.
• Conducted and participated in JAD sessions with the Project managers, Technical Delivery Managers and Development teams to gather, analyze and provide data related information for various projects.
• Analyze the Business information requirements and research the OLTP source systems to identify the measures, dimensions and facts required for the reports.
• Worked with Model Manager and multiple data marts, involving multiple Subject Areas simultaneously, domains and Naming Standards.
• Designed and developed the Data Mapping documents, DDL Scripts, data dictionary and Meta data of the models and maintained them.
• Coordinated with DBA on data base build and table normalizations and de-normalizations
• Developed triggers, stored procedures, functions and packages using cursors and ref cursor concepts associated with the project using Pl/SQL
• Generated Solution Application Package (SAP) technical documentation for individual processes and data models.
• Identified and streamlined complex queries which were causing iterations and effecting database and system performance
• Coordinated in database changes needed for the front end development team, explained and guided them on the database architecture and objects for effectively accessing the database.
• Maintain change log and history tables for each data model and solved the production issues by debugging the code.
• Guided Informatica ETL developers by providing data mapping documents and helping them out with various data related issues.

Environment: ERWIN 7.2 and 7.3, Oracle 11i, MS-Visio, SQL Developer, MS Office

Confidential, Lansing, MI

Data Architect/Data Lead

Responsibilities:

• Worked for Medical Center of Excellence team in Accident Fund under tight deadlines and successfully delivered all the components of project in time.
• Involved in building logical and physical data models for the project that were later handed over to DBA team to build Schemas and databases.
• Created EDW data models for Q2 enhancements after creating a detailed Roadmap that involved various steps of Data warehouse architecture.
• Worked on MCE (Medical Center for Excellence) project to rate Workers comp providers by processing over 2 million medical bills which had clinical data.
• Created data models for existing databases using Reverse Engineering techniques and suggested various modifications that helped build cleaner 3NF data marts for EDW.
• Created Numerous Star Schema data marts for BO reporting that captured success metrics of the project both prospective and retrospective.
• Designed models that helped create numerous ETL jobs using DM Express to extract data from various sources and load target tables.
• Heavily involved in data cleansing activities and ran several processes to de-dupe data thus improving data quality in project. This was done by running some of the ETL jobs created using DM Express.
• Created a detailed data dictionary for the project by following best practices of Data Warehousing and enforced strict data governance by identifying SMEs as Data stewards.
• Worked in conjunction with Systems Architect and Web Admins to identify proper data elements and position the data on right servers.

Environment: Oracle 10g/9i, Erwin Data Modeler 7.3, AMDD, Toad, ODI, Embarcadero Rapid SQL, SQL Server 2005, Visual Studio 2008, DM Express, BO Universe One, Windows XP, TIDAL.

Confidential, Ann Arbor, MI

Sr. Programmer Analyst/Architect - Business Intelligence

Responsibilities:

• Heavily involved in supporting vendor management group that would sell our sales data to various vendors such as Equifax, Bookscan etc.,
• Worked closely with Accounting & Planning groups by giving projections of sales using Outlook soft (SAP BPC) and other financial application tools.
• Actively participated in different roles such as Data Architect, Team-Lead and also as a Sr. Programmer analyst by extensively using Informatica to import and export data between Oracle DB on Unix from/to DB2 on Mainframe.
• Involved in creating multi-dimensional OLAP cubes to support OutlookSoft 4.2 applications used for FPA (Financial Planning and Analysis).
• Wrote DTS packages to update dimension processing for Outlooksoft based on new requirements related to E-commerce and Concept store set up.
• Fine-tuned Complex SQLs to build all cubes required for processing Outlooksoft/BPC data over the weekend so that rolled up numbers could be ready by Monday morning for higher management.
• Created black berry flash sales reports for the top management with sales data up to previous day’s close of business for all stores on East and West Coast.
• Participated in various seminars as guest speaker for Outlooksoft showing how we used this tool to other retailers who were not involved in selling books. Helped SAP tutors by giving them case studies to teach their students in BPC course during its launch.
• Involved in design/development/test and implementation phases of building E-commerce sales reporting module on Informatica, by creating numerous work/temp tables that would consolidate data at intermediate levels, when Borders launched its website borders.com, moving away from Amazon.
• Maintained OutlookSoft applications until I was laid off before company filed for bankruptcy.

Environment: UNIX, MVS, Windows XP, Oracle 9i/11g.Toad, DB2, SQL Server 2008, Outlooksoft 4.0/4.2, SAP BPC 5.0, Erwin 7.2, E/R Studio, BO XI, Case Studio 2.0, TSO/ISPF, DB2, Cntl-M, FTP, Windows XP, MQ Series.

Confidential, Clinton Twsp, MI

Sr. Programmer Analyst

Responsibilities:

• Worked as an independent consultant for IBM thru Keane services at Nissan. Performed in various roles such as Programmer, Team-Lead for ODC in India, Junior level DBA and data architect.
• Designed and maintained databases for Vehicle Order System (VOS) a prestigious project at Nissan that would keep track of the service of its 10,000 plus employees to check their eligibility to lease company cars at highly subsidized prices.
• Closely interacted with different groups working on SAP, Mainframe, Client-Server in order to complete this project that had numerous front end.

Environment: SAP MM, Oracle 7.i, Cognos reporting, DB2 V5R2, Toad, Informatica, MS SQL Server, UNIX, MVS, TSO/ISPF, QMF.