Responsibilities:• Developed full life cycle software including defining requirements, prototyping, designing, coding, testing and maintaining software.• Created Logical & Physical Data Model on Relational (OLTP) on Star schema for Fact and Dimension tables using Erwin.• Performed GAP analysis to analyze the difference between the system capabilities and business requirements.• Developing SSIS packages to integrate them into Azure Data Factory V2.• Used Agile Method for daily scrum to discuss the project related information.• Prepared ETL technical Mapping Documents along with test cases for each Mapping for future developments to maintain Software Development Life Cycle (SDLC).• Involved in Data flow analysis, Data modeling, Physical database design, forms design and development, data conversion, performance analysis and tuning.• Created sampling specification, performed quality assurance, created multiple datasets to communicate with Medicare Advantage plans and analyzed Medicare plans response.• Created and maintained data model standards, including master data management (MDM) and Involved in extracting the data from various sources like Oracle, SQL, Teradata, and XML.• Designed the data marts using the Ralph Kimball's Dimensional Data Mart modeling methodology using Erwin.• Worked on Master data Management (MDM) Hub and interacted with multiple stakeholders.• Worked with medical claim data in the Oracle database for Inpatient/Outpatient data validation, trend and comparative analysis.• Design and implementation of an Azure data lake• Design and development of the data warehouse data ETL Jobs using azure data factory and azure databricks.• Proficient in developing Entity-Relationship diagrams, Star/Snow Flake Schema Designs, and expert in modeling Transactional Databases and Data Warehouse.• Worked on normalization techniques, normalized the data into 3rd Normal Form (3NF).

Responsibilities: • Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models.• Involved in data model reviews with internal data architect, business analysts, and business users with explanation of the data model to make sure it is in-line with business requirements.• Worked with delivery of Data & Analytics applications involving structured and un-structured data on Hadoop based platforms on AWSEMR.• Independently coded new programs and design Tables to load and test the program effectively for the given POC's using BigData/Hadoop.• Installation and Configuration of other Open Source Software like Pig, Hive, HBase, Flume and Sqoop• Translate business needs in to data models that integrate with the Enterprise DataModel.• Architecting and Modeling Enterprise Data Hub (EDH) cloud based solutions using AWS Redshift for Analytical platform and AWS Oracle RDS for Reference and Master Data. • Develop data models according to enterprise data management practices• Ensure the quality of data submitted to regulatory agencies by developing detailed metadata for submissions.• Worked for map reduce and query optimization for Hadoophive and HBase architecture• Extensively worked Data Governance , i.e. Metadata management, Master data Management, Data Quality, Data Security• Developed Spark/Scala, Python for regular expression (regex) project in the Hadoop/Hive environment with Linux/Windows for big data resources.

Responsibilities:• Responsible for Data Modeling, Data Integration, Data quality & Metadata management solution design and delivery for Enterprise EDW and Hadoop environment.• As a Modeler/Analyst implement MDM hub to provide clean, consistent data for a SOA implementation• Installation and Configuration of other Open Source Software like Pig, Hive, HBase, Flume and Sqoop.• Independently coded new programs and design Tables to load and test the program effectively for the given POC's using Big Data/Hadoop. • Develop ETL pipelines on AWS platform using Python and AWS services such as S3 Buckets, Lambda, API Gateway, SQS queues.• Worked with BTEQ to submit SQL statements, import and export data, and generate reports in Teradata. • Defined and deployed monitoring, metrics, and logging systems on AWS.• Full life cycle of Data Lake, Data Warehouse with Big data technologies like Hive, Hadoop. • Responsible for technical Data governance, enterprise wide Data modeling and Database design. • Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).• Designed both 3NF data models for ODS, OLTP systems and dimensional data models using Star and Snow flake Schemas. • Worked extensively on ER Studio for multiple Operations across Hartford in both OLAP and OLTP applications. • Involved in OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports using multi-dimensional models such as Star Schemas and Snowflake Schema. • Performed the Data Mapping, Data design (Data Modeling) to integrate the data across the multiple databases in to EDW.• Develop ETL pipelines on AWS platform using Python and AWS services such as S3 Buckets, Lambda, API Gateway, SQS queues.• Preparing new ERwin data model template for Postgres, Dynamo DB (NoSQL database) on cloud environment like Amazon Web Services (AWS).

Responsibilities• Used SQL extensively to query Databases• Sales data analysis and the maintenance of pricing tables that feed live website• Conducted data assessments of legacy data• Used Excel, Access and VBA in the development of robust and flexible reporting systems• Retrieved data from data warehouse and generated a series of meaningful business reports using SSRS and Cognos.• Deploying and maintaining production environment using AWS EC2 instances and Elastic Container Services with Docker• Monitoring resources and Applications using AWS Cloud Watch, including creating alarms to monitor metrics such as EBS, EC2, ELB, RDS, S3, SNS and configured notifications for the alarms generated based on events defined• Perform troubleshooting and monitoring of the Linux server on AWS.• Maintaining the user accounts (IAM), RDS, Route 53, SES and SNS services in AWS cloud• Validated and tested reports, then published the reports to the report server.• Performed and conducted complex custom analytics as needed by clients.• Designed and developed specific databases for collection, tracking and reporting of data.• Established, maintained and distributed daily, weekly and monthly reports• Created financial models using Excel Pivot Tables and formulas to develop best and worst case scenarios• Creation of user accounts, policies and roles on Amazon Web Services (AWS) using IAM• Data auditing, creating data reports & monitoring all data for accuracy• Data cleansing - checking for data redundancy, duplicates and reporting on all findings• Assisted in the development of Metrics to measure the business data cleansing progress• Performed and conducted complex custom analytics as needed by clients.Environment: Erwin9.0, AWS, Redshift, Oracle11g, Sql Server 2010, Teradata14, XML, OLTP, PL/Sql, Linux, UNIX, Mload, BTEQ, UNIX shell scripting

Responsibilities• Played an active and lead role in gathering, analyzing and documenting the Business Requirements, the business rules and technical requirements from the Business Group and the Technology Group.• Drafted enterprise security standards and guidelines• Performed and created procedures for system security audits• Assisted in the development of database access controls and separation of duties• Assisted in incident response and disaster recovery• Responsible for the documentation and execution of remediation plans• Performed periodic security review of privileged accounts• Performed a thorough analysis on the Sales Order Entry process to eliminate bottleneck• Captured As-Is Process, designed TO-BE Process and performed Gap Analysis• Gathered Requirements from different sources like Stakeholders, Existing Systems, and Subject Matter Experts by conducting Workshops, Interviews, Use Cases, Prototypes• Created Functional Requirement Specification documents - which include UML Use case diagrams, scenarios, activity, work Flow diagrams and data mapping. Process and Datamodelling with MS VISIO.• Worked with the DW, ETL teams to create Order entry systems Business Objects reports.• Worked in a cross functional team of Business Analysts, Architects and Developers to implement new features in various custom applications.• Developed and maintained various User Manuals and Application Documentation Manuals on Share Point tool.• Created Test Plans and Test Strategies to define the Objective and Approach of testing.• Used Quality Center to track and report system defects and bug fixes, wrote modification requests for the bugs in the application and helped developers to track and resolve the problems.•Environment: Erwin 8.0, MS Excel, MS Access, UNIX, T-Sql, MS Sql 2008, Excel, SSIS, SSRS, MS Visio.