SUMMARY:

• Experienced and dedicated professional with over 12 years of IT experience playing various roles as Solution Architect, Big Data Architect, ETL Architect, Data Analyst, Business Analyst, Project Lead in various assignments covering all phases of Development, Testing, Maintenance, Implementation & Support.
• Experience in Data warehousing (DWH) projects including Data Quality, Data Governance, Data Profiling with hands on full BI Lifecycle (SDLC) Starting from Analysis, Development to Implementation, Support and Training.
• Experience in solution and designing Big Data projects - familiar with Cloudera and Horton works Big data components.
• Experience in ETL tools like Informatica,Talend, Datastage and reporting tools like Cognos, OBIEE, Tableau, Business Objects in Data Migration ETL, Business Intelligence, Reporting, Analytics, Predictive Analytics and software development including Client-Server based application
• Extensive experience in Business Intelligence & Data warehousing solutions for different industry verticals such as Health care, Banking, Insurance and Telecom,
• Worked with major customers directly with Confidential, Confidential, New Hampshire, North Dakota & Florida state government healthcare Medicaid projects. Confidential & Experian as BFSI projects, Scope Knowledge (Quattro) as Ecommerce project.
• Strong experience in interacting effectively with business stakeholders and technical teams at all levels of the organization.
• Analytical problem solver and critical thinker, innovative and creative, cooperative, results oriented, on-going learner, hands-on, self-motivated, multi-task oriented.
• Actively involving in pre-sales activity along with vertical and service line teams to win the new business
• Giving cost effective architecture solutions and design for the new proposals on BIDW technology
• Working closely with presales team to arrive on the project estimates, resource ram up plan, Cost estimates and etc.
• Involving in the SOW preparation along with pre sales team on signing the new contract deals.
• Participating in customer workshops, high level scoping, system study and recommendations

TECHNICAL SKILLS:

Big Data Tools/Environment: Hadoop, Hive, PIG, HBase, INFA HParser, MarkLogic Cloudera, Hortonworks, Amazon Cloud(EMR)

ETL Tools: Informatica Power Center, DataStage, Talend, Pentaho, Teradata Utilities, ODI and OWB

Business Intelligence: Cognos, Business Objects, Tableau, & OBIEE.

Data: Informatica & DataStage Data Quality & Data profiling

Database/Modeling: Netezza, Teradata, MS SQL,Oracle 11g/10g/9i,Erwin & MS Visio

Front end tools: Toad, PL/SQL Developer, Nexus, Aginity and Teradata Bteq

PROFESSIONAL EXPERIENCE:

Confidential, California,USA

BI & BIGDATA Solution Architect

• Designed the data model to support Provider related quality metrics, Modality utilization report, Finance summary report, Mammography related quality metrics, Stroke TAT,RAD TAT and etc.
• Designed the Data integration end to end for the sources Clarity(EPIC), CMS,MIDAS,HCAPS and etc.
• Assuming ownership on the end to end project deliverables, providing cost effective solutions proposing value add models to achieve organization wise benefits apart from project deliverables.
• Designed Hadoop Cloudera setup in Amazon Web Services (AWS) as 10 nodes cluster.
• Interacted directly with business, data designers and gathered functional requirements. Led the efforts in architecting scalable Big Data solutions.
• Leading the efforts in architecting scalable BigData/ETL solutions.
• Designed & Implemented HParser based solution(Informatica Big Data Setup) to process the complete unstructured data and convert in to XML files
• Designed and Implemented MarkLogic (NoSQL based solution) to process the xml files and get the required structured data as output
• In addition, proactively engages in providing coaching and mentoring to individuals and teams for Big Data practices, continuous process improvement and customer satisfaction initiatives.
• Develops strategies for data acquisitions, archive recovery, and implementation of a database.
• Working with various project teams and understand their business requirements and generate deliverables (data models, data dictionary, source analysis, source to target mappings).
• Designed complete end to end Analytical Data warehouse solution for the healthcare payer industry by adhering Data warehouse principles, incorporating best practices and Value adds.
• Designed and Implemented end to end ETL Foundation Layer, including consolidating the source, deriving the data in to stage, loading to Dimensions, Fact and Aggregate Facts to support above report and dashboard requirement.
• Preparing technical design for data quality, BI & ETL solution such as ETL foundation layer as reference pattern for end to end implementation, Data Integration approach, Error handling, Audit and Balance Control, Recycle process, Restartability and cleanup mechanism.
• Designed the ETL to integrate with MDM to derive the golden records specific to Patient, Provider and Employee domain.
• Performed extensive data profiling exercise to understand the different types of source data and define the relationship for data integration as per the reporting needs.
• Proposed and executed value-add models to achieve organization wise benefits apart from project deliverables.
• Performing various prototypes as per the project teams need and sharing the valuable inputs and suggestions based on the requirement.

Environment: MS SQL, Clarity, Oracle, Informatica, Informatica MDM, MicroStrategy, Business Objects, Erwin, MS Visio,AWS and Cloudera Big data stack.

Confidential

DWBI & Big Data Solution Architect

• Working directly with business, data designers and gathering functional requirements.
• Working closely with IT and business owners to identify right strategic opportunities to improve the business and organization goals with the help of latest and available technology.
• Leading the Data Integration and Warehousing architecture, design, and implementation efforts for large scale, enterprise Data Warehouse and BI solutions and programs within Healthcare Provider.
• Established document guidelines and standards for data architecture; design, direct, and execute changes to existing and new data models for data marts and data staging, maintain documentation
• Extensively involved in preparing source to target mappings, developing Logical Data Model(LDM),Physical data model(PDM),High level and Low level design documents & Solution Architecture docs.
• Collaborating with team members and educate them on data modelling and profiling aspect, helping on designing relational and dimensional model for ware house and data marts.
• Working with Upstream application owners and architects proactively to address any data related issues and design required solution for data acquisition need by business and customers.
• Extensive experience working with Healthcare Payer data from a data profiling, analysis, and modeling perspective, with a solid understanding of the relevant Healthcare business processes.
• Community Health Care & Evidence Based Treatment Program Implementation using Mark Logic, Apache Hadoop echo systems, Tableau reporting platform
• Developed and designed integration architecture to ensure seamless integration between the modules MEMBERS, PROVIDERS, CLAIMS, PBM, application systems and the Legacy and Contemporary application systems.
• As per healthcare industry standards developing strategies for data acquisitions, archive recovery, and implementation of a database to adhere with healthcare compliance.
• Gathering Business requirement and performed tool evaluation for multiple Data Quality tools
• Designing Complex Dashboards, Analytical Reports, Monthly current and historical snapshot using Tableau, Business objects and Cognos. Also designing appropriate Views to provide access to business users.
• Designing reusable components to fit in to Data integration to save cost and efforts effectively.
• Developing a Reference Architecture for the existing system and future development system.
• As part of EDRC (Enterprise Design Review Committee) team review various teams proposed solution and provide valuable technical feedback and suggestions and providing the sign off.
• Analysing the data to reveal the ways to improve business for customer.
• Conducting studies gathers and analyses data from various databases and sources, develops reports/visualization, providing appropriate recommendations.
• Designed data model in order to achieve appropriate Analytical reports related to members and non-members behavioural pattern.
• Provide reporting and analysis to assist in improving EDW-BI solution delivery
• Established document guidelines and standards for data architecture; design, direct, and execute changes to existing and new data models for data marts and data staging, maintain documentation.
• Drive Risk assessment, and Applications Repository Management initiatives.
• Working with various BI teams and ensure that PHI compliance systems are developed across the organization.

Environment: Netezza, Oracle, IBM Infosphere, IBM DataStage, Tableau, Business Objects, Erwin,Nexus,Aginity,SQL DBX.

Confidential

BI & Big Data Solution Architect

• Coordination on creating the requirements analysis, the platform selection, design of the technical architecture, design of the application design and development, testing, and deployment of the proposed solution.
• Working directly with business, data designers and gathering functional requirements.
• Assuming ownership on the end to end project deliverables, providing cost effective solutions proposing value add models to achieve organization wise benefits apart from project deliverables.
• Cluster administration, configuration management, monitoring, debugging, and performance tuning for the Cloudera based Hadoop Systems
• Performed BigData POC’s on business requirements/scenarios from projects to check whether the proposed design would work on processing unstructured data.
• Responsible for managing the full life-cycle of a Hadoop solution.
• Managed to perform detailed analysis of business problems and technical environments and use this in designing the solution
• Gathering Business requirement and performed tool evaluation for multiple Data Quality tools
• Preparing technical design for data quality, BI & ETL solution,
• As per PCI (Payment Card Industry) standards developing strategies for data acquisitions, archive recovery, and implementation of a database to adhere with PCI compliance.
• Working with various BI teams and ensure that PCI compliance systems are developed across the organization
• As part of ARB (Architecture Review Board) team review various teams proposed solution and provide valuable technical feedback and suggestions and providing the sign off.
• Performing various prototypes as per the project teams need and sharing the valuable inputs and suggestions based on the requirement.

Environment: AWS,Cloudera,Oracle,OracleSuite,ODI,OWB,OBIEE,APEX,BIPublisher,Toad,PL/SQLDeveloper.

Confidential

BIG Data Architect

• Working on all stages of New Product Development from rapid prototyping of research ideas / concepts to designing and developing highly scalable offering to meet customer needs
• Designed Hadoop Cloudera setup in Amazon Web Services (AWS) as 10 nodes cluster.
• Designed EMR setup (Elastic Map Reduce - AWS in built functionality) to execute the Hadoop programs.
• Interacted directly with business, data designers and gathered functional requirements. Led the efforts in architecting scalable Big Data solutions.
• Analysing the data to reveal the ways to improve business for customer.
• Conducting studies gathers and analyses data from various databases and sources, develops reports/visualization, providing appropriate recommendations.
• Designed data model in order to achieve appropriate Analytical reports related to members and non-members behavioural pattern.
• Developed efficient Dataware housing solution in AWS(Amazon Web Services) by extracting data from different OLTP systems
• User and Access management by using AWS IAM policies
• Creating reports and dashboards, Security Setup (groups, object and data level)
• In addition, proactively engages in providing coaching and mentoring to individuals and teams for Big Data practices, continuous process improvement and customer satisfaction initiatives
• Performing statistical programming develops and maintains databases and provides consultation and technical assistance.
• Define & Communicate business objectives like reduce TCO, Licenses cost, centralized Security Architecture, eliminate data redundancy and process duplication.

Environment: AWS, Coludera, HBase, Hive, Oozie, Pig, Sqoop, Spark, Zookeeper

Confidential

BI Solution Architect

• Had overall responsible for data integration architecture, handled complex system interfaces & ETL from requirements analysis through solution design and implementation.
• Work thru comprehensive data warehouse analysis, design, develop & test experience, with full life cycle knowledge of data warehouse methodologies and data modelling experience.
• Analysing business requirements and generate deliverables (data models, data dictionary, source analysis, source to target maps).
• Provided technical assistance to designers and developers during development, testing and deployments both at offshore and onshore.
• In addition, proactively engages in providing coaching and mentoring to individuals and teams for Project Management best practices, continuous process improvement and customer satisfaction initiatives.
• Adding to this helped customer to build PCI based BI solution in the fast track manner and helped to achieve the PCI certification as a first time in their history.
• Proposed and executed value add models to achieve organization wise benefits apart from project deliverables.

Environment: Oracle, Oracle Suite, ODI, OWB, OBIEE, APEX,BI Publisher,Toad & PL/SQL Developer.

Confidential

Data Architect

• Understanding the customer’s business requirements, business processes and system functionality to develop the data design and maintain the source of data.
• Designs database, data models, ETL processes, data warehouse applications and business intelligence (BI) reports through the use of best practices and tools.
• Develops strategies for data acquisitions, archive recovery, and implementation of a database.
• Delivers high quality (DA) related outcomes including ETL processes, data warehouse designs and data system enhancements in accordance with existing standards and guidelines.
• Resolves routine (DA) related issues with business analysts and technology teams by providing advice on data warehousing methods and approaches.
• Analysis (DA) related business needs, works with project staff to make decisions and recommendations on the future of (DA) developments
• Responsible for developing and maintaining a formal description of the data and data structures including data definitions, data models (Conceptual, Logical and Physical Data Model, data dictionaries, data flow diagrams).
• Provides the means of system integration by understanding the source and target data and build the data mapping.
• High-level data architecture documentation, which illustrates the source and destination.
• Evaluating new techniques for enhanced functionality.
• Provided DW/ETL Architecture expertise with an understanding between projects and Operation teams. Provided simple solutions for complex requirements.
• Extensively worked with data modelling tool to design/create conceptual, logical, and physical data models.
• Leading the design and support the deployment of the DW/BI Architecture, including - Data repositories, tools and archiving strategy and capacity planning.

Environment: Teradata,Informatica,Oracle,UNIX,Nexus,Toad,PL/SQLDeveloper,Business Objects,Qlikview,Cognos.

Confidential, North Dakota, New Hampshire & Florida

ETL Architect

• Planning, prioritizing and assigning the activities to team members and tracking of the progress
• Assessing risk, issues, and dependencies on weekly basis and reporting it to client organization and ACS leadership
• Responsible to interact with the business analyst team, US Client managers, architecture team, DBA & etc to gather/understand the business requirements.
• Create and adjust project plan for implementing and deploying complete GHS solution for Medicaid programs
• Provided Architectural Road Map, direction and work packets for ETL needs.
• Created detail ETL Standards documents for Design, Development, Release Management and Production Support.
• Design Detail ETL spec for offshore development and ensured Quality ETL Deliverables.
• Created detail ETL Migration Processes for Informatica, Database, Scheduling, O/S and H/W teams.
• Design and Develop Reusable Common objects shared across various Repositories.
• Automated, Redesigned and tuned several ETL Process for optimal utilization of Time and resources.
• Trouble Shoot, Tune and Maintain complex ETL Mappings.
• Design and develop and Implement detail layout of ETL testing plan procedures.
• Design Audit Balance and Control (ABC) for ETL process.
• Provide estimations for ETL deliverables and oversee the progress for quality ETL Deliverables.
• Created several Repository Mappings and Queries facilitating rapid analysis, trouble shooting, code verification and deployment.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Identify and assess business needs, anticipate future data requirements and implement solutions within the data warehouse.
• Reengineered ETL jobs and Processes to bring down the load times by more than 70%.
• Install, Upgrade, Configure and Maintain Informatica Power Centre.
• Maintain Informatica Code via Versioning and also thru Harvest.
• Responsible for designing ETL Process for integrating various source systems.
• Coordinate and Implement Various Releases for the CIM.
• Work Closely with Infrastructure team for Hardware capacity Planning.
• Trouble Shoot, Tune and Maintain Informatica Repositories
• Through understanding of enterprise data warehouses using Kimball methodologies.
• Widely used Database objects like Views, Synonyms, Triggers and Global Links for reducing the load on ETL tools.
• Tuning the ETL for Terabyte loads for Optimum Performance, Dependencies and Batch Design.
• Generated and published Meta data reports for the data model ETL and Reporting for the business users.
• Extensively used Mapplets and Reusable Transformations and Shortcuts.
• Created Data Profiling for the source mappings for trapping the data related issues.
• Responsible for Maintaining the Development, Test and Production Repositories.
• Maintain the Project Releases for various global regions.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Extensively used Designer (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer) for creating Sources, Targets, Mappings, Reusable Transformations and Mapplets.
• Used Filters, Routers, Lookups (Connected and Unconnected), Expressions, Update Strategy, Union Transformation, Aggregator and Sorter Transformations.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Migrated mappings, sessions, and common objects from development to test and to production.

Environment: Informatica,Oracle,UNIX,Nexus,Toad,PL/SQLDeveloper,Business Objects.