SUMMARY

• 9 plus years of Experience with all phases of the Software Development Life Cycle (SDLC) including analysis, Resource Planning, Code Development, testing, implementing and maintenance.
• Over 9 Years of professional experience in Database development and Data Analysis design of OLTP and OLAP systems.
• Highly effective Data Scientist/Data Analyst with over 6 years of experience in Data Analysis, Data Mining, Data Acquisition, Data Validation, Predictive Modeling, Data Visualization, Web Scraping, Testing.
• Proficient in Statistical Programming Languages like R and Python including Big Data Technologies like Hadoop, Hive.
• Extensively used GCP Cloud tools such as Big Query, Dataflow, Dataproc, Data Fusion, Cloud Functions etc.
• Knowledge of both Private and Public Cloud Computing service market, models, offering types, and architecture concepts.
• Experience on AWS Redshift Confidential Database to support large scale data storage and analysis, and also performed actions on large database migrations.
• Assisted in designing and management of PostgreSQL database schemas and tables.
• Experience with NoSQL databases (Apache Cassandra) and NoSQL support in PostgreSQL.
• Experience in developing Spark applications using Spark - SQL in Databricks for data extraction, transformation, and aggregation from multiple file formats for Analyzing & transforming the data to uncover insights into the customer usage patterns.
• Good Experience in building data pipeline using Delta Lake on Google Cloud Storage and pull data from Databricks and BigQuery to visualize in Looker.
• Collaborating with Scatter Plot - Smart Data Compression. Data Load Editor Walk-through. Creating Drilldown Master Item Dimension. Data Preparation Capabilities with Qlik Sense.
• Performing daily base Data Analysis, System Analysis, Business Requirement Gathering and Data Warehousing concept.
• Extensively used Microsoft office like Excel, PowerPoint, and Word documents to validate data, document requirements and present the content to the management/Team.
• Good noledge and experience on advanced analytics tools such as Mega HOPEX, QlikView, Qlik Sense, Tableau.
• Good Knowledge on cloud-based databases, specifically AWS technologies such as RDS, S3, EMR, EC2, IAM roles and policies.
• Excellent noledge of classic data integration technologies including ETL/ELT, data replication/CDC, message-oriented data movement, API design, and access as well as emerging data ingestion and integration technologies like stream data integration, CEP, and data virtualization (HOPEX Tool).
• Good Knowledge on Power BI, Python, R, Hadoop, Spark, Kafka, Rally, Java, C++, C#, Linux, UNIX, UNIX tools including object-oriented design.
• Used Webex teams’ space to collaborate with the teams and with Management.
• Good experience on Root Cause with defining the problem, collecting the data, identifying the possible and root causes, evaluate solutions and solve the problem.
• Good Experience on understanding and analyzing Structured and Non-structured data.
• Good Knowledge and experience in architecture of data marts, fact tables, dimension tables, data views within data marts/data warehouses, and data models like star schemas and snowflake schemas are examples of advanced data warehousing and data mining principles.
• Extensively Worked on Mega HOPEX Tool to digitize the data for Enterprise Architecture.
• Has good experience in reading Architecture Artifacts (Tech07, CBID’s in VISIO and InfoPath) and MVP Template.
• Trained team members in modeling technical architecture data (Application Environment, IT Infrastructure, Application System models) in HOPEX.
• Trained other team members in modeling data of Application Environment.
• Good Experience at architecture and design such as architecture, design patterns, reliability, and scaling.
• Created a number of User Guides and published on EA portal.
• Worked in HOPEX Tool to load architecture data using modeling methodology. Created hundreds of Application Environment models (Application Interface diagram) along with its NFR (Non - Functional Requirements) and ATA (Application Technical Architecture).
• Has good experience in IT Infrastructure of an application and modeled data in HOPEX, which can display data for an application's IT server, clients, upstream and downstream (partner applications), communication channels, networks, application technical architecture, etc.
• Created an Application System Structure Diagram, which is a component of ASE Models, while working on the HOPEX Application System Environment (ASE) to visualize the data of Product Group, Product Line, and Product.
• SPOC for Smart IT Connect Tickets raised by Architects, Product teams and Business Customers and, managed the tickets, assigned them to the team members as needed and completed/closed the tickets within the standard time.
• Worked on Data Cleaning to eliminate bad data like retired and worked on adding related data in accordance with the needs of the customers to the Applications.
• Worked on the HOPEX Advance Query (ERQL Queries), which would aid in the correction of data pertaining to partner applications, position type, interactions, exchange contracts, contents, and technologies.
• Extensively used APM (Application Portfolio Management) QlikView Dashboard to identify changes/anomalies in data.
• Good experience in data integration, modeling, data visualization, data cleaning to maintain data quality in the repository which were directly relevant to data engineering.
• Had good experience in using MVP Templates, Application Analysis Interface Templates, Import/ Bulk Load Templates to fix the data of Applications in to HOPEX Application Environment (AE) Model.
• Familiar in using Share Point (SP) Site.
• Extensive experience in data migration techniques using SQL* Loader, Import/Export
• Ran a number of Application Interface Integrity Report, Offline Reports, Capability Reports of HOPEX Models.
• Conducted UAT for technology upgrades. Used/updated test plans for the Technology Architecture (TA), tested various HOPEX Tool versions, collaborated with other workstreams and Development teams and completed a successful UAT.
• Extensively used EAMS (Enterprise Architecture Management System) web tool for training architects
• Facilitated FSAC ( Confidential Software Architects Conference) presentations and recorded the sessions.
• Took the lead role in Rally (Project management tool) and ran weekly status meetings and to track each phase of the development iterations and releases. Strong teamwork and collaboration skills, with track record of leading or working with Architecture teams. Good experience of using TO Compass to analyze work of Team.
• Defining the Technical Architecture modeling and Architecture content management in the Mega HOPEX and WEB, by maintaining new Meta classes per the process and defining the queries and reports.
• Supported in preparation of Technology Roadmap and having good noledge on Big Data and its concepts.
• Expertise in data modeling principles/methods including conceptual, logical & physical Data Models.
• Ability to quickly learn and adapt modeling methods from case studies or other proven approaches
• Ability to clearly communicate complex technical ideas, regardless of the technical capacity of the audience
• Strong inter-personal skills and ability to work as part of a team.
• Skilled in visualizing, manipulating, and analyzing large datasets and TEMPhas ability of designing and developing effective reports. Proficient with MS Office Applicants, Excel (Pivot Table, Lookups, Index, Match, dashboards, etc.)
• Experience in developing rich interactive Tableau reports and Dashboards using various visualizations like Chart-Box (Drill Down, Drill Up& Cyclic Grouping), Heat Maps, Tree Maps.
• Bubble Charts, Reference Lines, Dual Axes, Line diagrams, Bar Graphs, Geographic Visualizations (Detailed and filled in maps), etc.
• Skilled in Power BI and visualization of the results using Tableau to import, analyze and create various filters and parameters for reports from various data sources such as SQL Server.
• Proficient in Data Analysis, System Analysis, Business Requirement Gathering and Data Warehousing concept.
• Experience transforming large, complex, unstructured data into denormalized star or snowflake schemas
• Strong analytical skills with the ability to collect, organize, analyses and disseminate significant amounts of information with attention to detail and accuracy.
• Knowledge in Data Engineering, Business Analysis, Advanced Analytics, Data Analysis.

TECHNICAL SKILLS

• Python & R for Data Science
• HIVE
• Big Data and Spark for Data Analytics and Data Engineering.
• Cron and Autosys Scheduling
• Unix Shell Scripting
• Oracle SQL
• PL/SQL TERADATA
• HDFS
• NoSQL
• PostgreSQL and Greenplum
• ERWIN
• Jupyter Notebooks
• Visual Studio Code
• GIT and Groove Automation
• Kubernetes
• TFS
• Power BI/ Tableau/Cognos/SSRS.
• Maven 3.0
• Google cloud
• Azure
• Docker
• Kubernetes
• CI/CD
• PCF
• ANT
• GRADLE

PROFESSIONAL EXPERIENCE

Sr. Data Engineer/Analyst

Confidential - Dearborn, MI

Responsibilities:

• Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow diagrams.
• Actively working on GCP Cloud tools such as Big Query, Dataflow, Dataproc, Data Fusion, Cloud Functions etc.
• Collaborating with Scatter Plot - Smart Data Compression. Data Load Editor Walk-through. Creating Drilldown Master Item Dimension. Data Preparation Capabilities with Qlik Sense.
• Performing daily base Data Analysis, System Analysis, Business Requirement Gathering and Data Warehousing concept.
• Working on Database development and Data Analysis design of OLTP and OLAP systems.
• Working on AWS Redshift Confidential Database to support large scale data storage and analysis, and also performed actions on large database migrations.
• Configured Jenkins to handle application deployment on Cloud (AWS) and to integrate with Git Hub version
• Extract Transform and load data from source systems to Azure date storage Service using combination of Azure date factory, T-SQL, Spark SQL and Azure Databrics.
• The database interactions.
• Collaborating with other team members in designing and management of PostgreSQL database schemas and tables.
• Control created the Azure Functions using JAVA that receives the inputs from the service calls and performs
• Collaborating with Scatter Plot - Smart Data Compression. Data Load Editor Walk-through. Creating Drilldown Master Item Dimension. Data Preparation Capabilities with Qlik Sense.
• Performing daily base Data Analysis, System Analysis, Business Requirement Gathering and Data Warehousing concept.
• Involving in sessions with business, project manager, Business Analyst, and other key people to understand the Business Needs and propose a solution from a Warehouse standpoint.
• Collaborating with other teams in designing the architecture of the organization at the enterprise level and thorough understanding and hands on experience of Software Development life cycle from Ideation to Implementation.
• Actively working on building data pipeline using Delta Lake on Google Cloud Storage, and pull data from Databricks and BigQuery to visualize in Looker.
• Significant number of tasks performing to collect data, organize, analyses and disseminate significant amounts of information with attention to detail and accuracy.
• Working on Data Visualization & Reporting tools such as Tableau, Power BI, Qlik Sense, QlikView.
• Supporting Data Engineering, Business Analysis, Advanced Analytics, Data Analysis.
• Excel, PowerPoint, and Word documents from Microsoft Office has been utilized extensively to validate data, establish requirements, and present content to management and team members.
• Collaborated with the teams and management using the Webex teams' environment.
• Significant Work on the Mega HOPEX Tool to digitize the data for Enterprise Architecture.
• Possessed solid reading skills for the MVP Template and Tech07, CBID, and InfoPath artifacts
• Trained team members to model data relevant to technology architecture using HOPEX (Application Environment, IT Infrastructure, and Application System Models). Trained other team members on Application Environment data modeling.
• Instructed, trained, and monitored other team members on Application Environment data modeling.
• Excellent understanding of emerging data intake and integration technologies including stream data integration, CEP, and data virtualization as well as traditional data ingestion and integration technologies like ETL/ELT, data replication/CDC, message-oriented data movement, and API design and access (HOPEX Tool).
• Experience in developing Spark applications using Spark-SQL in Databricks for data extraction, transformation, and aggregation from multiple file formats for Analyzing & transforming the data to uncover insights into the customer usage patterns.
• Involved in creating CI/CD Pipelines and Datasets using TFS and groove automation to load the data onto data warehouse and documented Logical, Physical, relational, and dimensional Data Models, designed the Data Marts in dimensional Data Modeling using star and Snowflake Schemas.
• Worked on HOPEX Tool to visualize the data of Solution Architect and created hundreds of Application Environment models along with its NFR (Non - Functional Requirements) and ATA (Application Technical Architecture).
• Extensive experience in data migration techniques using SQL* Loader, Import/Export
• Having experience on HOPEX IT Infrastructure Models, which can display data from a solution architecture for an application's IT server, clients, upstream and downstream (partner applications), communication channels, networks, application technical architecture, etc.
• Created an Application System Structure Diagram, which is a component of ASE Models, while working on the HOPEX Application System Environment (ASE) to visualize the data of Product Group, Product Line, and Product.
• Worked on Data Cleaning to Support IT and Smart IT Connect Tickets, which fixed to eliminate bad data like retired and worked on adding related data in accordance with the needs of the customers to the Applications.
• Ran Reports on Application Interface Integrity Report, Offline Reports, Capability Reports of HOPEX Models.
• Worked on the HOPEX Advance Query, which would aid in the correction of data pertaining to partner applications, position types, interactions, exchange contracts, contents, and technologies.
• Contributed on developing test plans for the Technology Architecture (TA), tested various HOPEX Tool versions, and completed a successful UAT.
• Good experience in data integration, modeling, data visualization, data cleaning to maintain data quality in the repository which were directly relevant to data engineering.
• Created and revised a number of HOPEX Modeling user guides that were published on the Enterprise Architecture (EA) Portal.
• Used Forward Engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Conducted Design reviews with Business Analysts, Database Administrators and Content Developers to validate the models.
• Done Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks.
• Manage HOPEX administration and configuration activities such as User profile and access management, Repository object management, and administration.
• Proposed new features in HOPEX Tool to enhance the capabilities and to make more user-friendly tool to Modelers, customers and as well as for trainees. And those features were approved to build.
• Created and maintained the Data Model Repository as per company standards.
• Worked with the Application Development team to implement appropriate data strategies.
• Good experience working with popular data discovery, analytics, and BI software tools like PowerBI, QlikView, Tableau, etc.,
• FSAC ( Confidential Software Architects Conference) lectures were facilitated and recorded the sessions.
• Played a major role in Rally Board (Agile). Had good experience in creating and maintaining Features, User Stories, Tasks with Release, Iteration, Plan Estimation.
• Played a major in role in maintaining, supporting, and monitoring User Stories of my Team with velocity, capabilities for each Iteration.
• Having good TOCompass experience would help a team examine and improve their work pattern within the organization.
• Completed training of Rally 101,102,103 and 104.

Environment: C, C++, Rally, APM, Java, Core Java, Mega HOPEX, Provision, SQL, PL/SQL, QlikView, Tableau, ArchiMate, ASP.Net, C# .Net.SQL Server Management Studio, Microsoft Office (PowerPoint, Excel, Word)

Sr. Data Analyst/Engineer

Confidential, Southfield, MI

Responsibilities:

• Involved in sessions with business, project manager, Business Analyst, and other key people to understand the Business Needs and propose a solution from a Warehouse standpoint.
• Standard in designing the architecture of the organization at the enterprise level and thorough understanding and hands on experience of Software Development life cycle from Ideation to Implementation.
• Implemented various AWS services such as AWS EC2 instance, SQS, Kinesis and S3 bucket and configured security groups for accessibility from on premise environments
• Managed IAM security policies, Roles and keypairs for multiple instances such a Windows and Linux.
• Worked on implementing AWS NAT gateways and NAT instances with spread instances.
• Built CI/CD pipelines for end-to-end data processing using groove automation
• Designed the ER diagrams, logical model (relationship, cardinality, attributes, and candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle and Teradata as per business requirements using ER Studio.
• Implemented metadata standards, data governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modeling.
• Worked with SME's and other stakeholders to determine the Requirements to identify Entities and Attributes to build Conceptual, Logical and Physical Data Models and designed an Industry standard Data Model specific to the company with group insurance offerings, translated the Business Requirements into detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
• Responsible for Analyzing report requirements and developing the reports by writing Teradata SQL Queries and using MS Excel, Power Point and UNIX.
• Designed Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Created a high-level industry standard, generalized Data Model to convert it into Logical and Physical Model at later stages of the project using ER-Studio.
• Developed Stored Procedures, Functions & Packages to implement the logic at the server end on Oracle and Performed Application/ SQL Tuning using Explain Plan, SQL Tracing & TKPROF. Also, used Materialized View for the Reporting Requirement.
• Developed numerous Teradata SQL Queries by creating SET or MULTISET Tables, Views, Volatile Tables, using Inner and Outer Joins, Using Date Function, String Function and Advanced techniques like RANK and ROW NUMBER functions.
• Traced and catalogue data processes, transformation logic and manual adjustments to identify data governance issues.
• Involved in extensive DATA validation using SQL queries and back-end testing and generated DDL statements for the creation of new ER/studio objects like table, views, indexes, packages, and stored procedures.
• Conducted design walk through sessions with Business Intelligence team to ensure that Reporting Requirements are met for the Business and developed Data Mapping, Data Governance, and Transformation and Cleansing Rules for the Master Data Management Architecture involving OLTP, ODS.
• Collaborated with ETL, BI and DBA teams while working on, SQL Server, Teradata to Analyze and provide solutions to Data issues and other challenges while implementing the OLAP model.
• Performed dimensional Modeling on OLAP system using Ralph Kimball methodologies and Extracted data from Oracle 11g and upload to Teradata tables using Teradata utilities FASTLOAD & Multiload.
• Generated ad-hoc reports using Crystal Reports 9 and Prepared Analytical and Status Reports and Updated the project plan as required.
• Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic and create and deploy reports using SSRS.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

Environment: ER-Studio, Python, Teradata, Netezza, Oracle 12c, Cognos, MS Office (Word, Excel and PowerPoint), SQL Server, MS Project, MS FrontPage, MS Access, EDI, UML, MS Visio, Oracle Designer, SQL Server, Oracle SQL developer, Crystal Reports, SSRS, SSIS and Tableau.

Sr. Data Engineer/Analyst

Confidential

Responsibilities:

• Worked with team of data scientists, machine learning engineers, software engineers and QA engineers.
• Performed data collection, preprocessing, feature engineering, data visualization and analysis.
• Build automation of data collection and preprocessing and built models to address business problems.
• Supported preparation of technology roadmap.
• Worked on Matillion ETL with the Enterprise IT team to maintain and develop data integration solutions to support our Analytics platform.
• Migrated and Transform Data from Different Sources and provided production support for existing products that include
• Worked extensively SSIS, SQL Server, Stored Procedures, data marts, Matillion, AWS, and Snowflakes.
• Engaged with lines of business, users, and analysts to explore and prototype opportunities and used cases exploiting data and the application of cognitive and machine learning technologies.
• Designed, developed, test and support Cognitive Microservices to operationalize and productize deployment of resulting models and cognitive solutions.
• Worked with Business users to no the Business Requirements and Gathered the entire detail Requirements from Business for reporting.
• Implemented logical and physical data modeling with techniques using Erwin in Data Mart and Used Reverse Engineering approach to redefine entities, relationships, and attributes in the data model as per new specifications in Erwin after analyzing the database systems currently in use Performed Dimensional Modeling on OLAP system using Ralph Kimball methodologies and performed gap Analysis.
• Used ERWIN column property editor to create and named physical properties, ERWIN index editor to create, named, sort and cluster for performance tuning for physical design, ERWIN physical object editor and table property editor to create named physical objects for physical design and ERWIN synchronization dialog to sync physical objects with the target environment.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database using Oracle and involved in the creation, maintenance of Data Warehouse and repositories containing Metadata.
• Designed the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Created data governance and privacy policies specifying contract implementation and Linked data lineage to data quality and business glossary work within the overall data governance program.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model and Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information Conducted design reviews with Business Analysts, Enterprise Data architect and solution lead to create proof of concept for the reports and involved in Business process modeling using UML through Rational Rose and maintained Metadata, version controlling of the Data Model.
• Created source to target Mapping Documents for renal and immune disease Data Mart with all the upstream sources.
• Wrote SQL scripts for creating tables, Sequences, Triggers, views, and materialized views and wrote SQL scripts for Loading Data from staging area to target tables and involved heavily in writing complex SQL queries to pull the required information from Database using Teradata SQL Assistance.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Did performance Analysis and Created partitions, indexes, and Aggregate tables where necessary and broken down the hierarchies from the dimensions to create the roll up dimensions

Environment: Informatica, MS Visio, C, C++, Java, Core Java, SQL, PL/SQL, QlikView, Tableau, ASP.Net, C# .Net, Power BI.

Data Engineer

Confidential

Responsibilities:

• Supervised training and developmental of software engineering staff and other resources.
• Analysis reports prototypes from the Business Analysts belonging to different Business units; Participated in requirements sessions involving the discussion of various reporting needs.
• Provided support to other developers in accurately mapping source attributes into the Teradata Financial Services Logical Data Model (FSLDM) and in interpreting business requirements Reverse Engineering the existing Data Marts and Identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for reports.
• Conduct Design discussions and meetings to come out with the appropriate Data Warehouse at the lowest level of grain for each of the Dimensions involved.
• Designed a STAR Schema for sales Data Involving shared dimensions (Conformed) for other subject areas using Erwin Data Modeler.
• Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for new enhancements of reports.
• Created ETL Jobs and Custom Transfer Components to move data from Oracle Source Systems to SQL Server using SSIS, Designed and created data extracts, supporting SSRS, POWER BI, Tableau, or other visualization tools reporting applications.
• Performed dimensional Modeling on OLAP system and created and maintained Logical Data Model (LDM) for the project and includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Involved in loading of data into Teradata from legacy systems and flat files using complex MultiLoad scripts and FastLoad scripts.
• Assigned work to software engineering personnel and evaluated and managed their performance.
• Supported to recruit engineering personnel, technical staffing, and project team's formation.
• Supervised reporting responsibilities for independent software contractors, software engineers and outsourcing partners.
• Ensure that software engineering personnel are properly trained to perform all job functions and that project and software related tools are used appropriately.

Environment: Windows-XP/2000/NT/98/95, MS-DOS, C, C++, Java, Core Java, SQL, PL/SQL, ASP.Net, C# .Net