AKANSHA SINGH SISODIA

E: adwtd5@r.postjobfree.com M: 716-***-****

PROFILE SUMMARY

* ***** ** ** ********** focusing on Data Warehousing, Data Modeling, Data Integration, Data Migration, ETL process and Business Intelligence.

ETL development using Azure Data Factory.

SQL Server and NoSQL databases.

Azure services including Azure Data Lake Storage, Azure Databricks, Azure Cosmos DB, Azure HDInsight, and Azure Synapse Analytics

DevOps and CI/CD using Azure DevOps and Liquibase

Package Software: Expertise in Informatica ETL and reporting tools. Proficient in Data Warehousing SDLC and architecture of ETL, reporting and BI tools.

Experience in all aspects of analytics/data warehousing solutions (Database, Data modeling, Data mapping, ETL development, Data migration and Reporting solutions) I have been keying in delivering innovative database/data warehousing solutions to the Finance Industries.

Strong understanding of Data Modeling (Relational, Dimensional, Star and Snowflake Schema), data analysis, implementations of data warehousing using Windows.

Developed mappings in Informatica to load the data from various sources into the data warehouse different transformations like Source Qualifier, Expression, Lookup, Aggregate, Update Strategy and Joiner.

Experience in developing stored procedures, functions, Views and Triggers, Complex queries using SQL Server, TSQL and Oracle PL/SQL

Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.

SDLC: 6 years of IT experience in system analysis, design, coding and testing. Extensive experience in the Data Warehousing implementations, Data Migration and ETL for Finance Domain.

Databases: 6 years of experience using Oracle 10g, MS SQL Server 2014, Sybase, SQL, PL/SQL, SQL*Plus, SQL*Loader, TOAD.

Data Modeling: 6 years of Dimensional Data Modeling experience using Star/Snowflake Modeling, Data marts, OLAP, Fact & Dimensions tables, Physical & Logical data modeling.

ETL: 6 years of Data Warehousing experience using Informatica PowerCenter 8.6.

Business Intelligence: Experience in Data Visualization using Tableau Desktop and Tableau Server.

Superior communication skills, strong decision making and organizational skills along with outstanding analytical and problem-solving skills to undertake challenging jobs. Able to work well independently and in a team by helping to troubleshoot technology and business-related problems.

TECHNICAL SKILLS:

Business Intelligence: Tableau Desktop, Tableau Server, Power BI

Databases: MS SQL Server 2014/12/08, Oracle 11g/10g, Sybase

ETL Tools: Power Mart 6.2/5.1/4.7 (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager) Tableau Prep, SQL*Plus, SQL*Loader, TOAD

Languages: SQL, PL/SQL, Python, C++, C#, JAVA, and R

Testing/Other Tools: TFS, HP Quality Center, Jira, Adaptavist and Kanban Board

Cloud: Azure

PROFESSIONAL EXPERIENCE

Employer: Surgalign

May2022– current

Title: Senior Database Engineer

Responsibilities:

Designed and implemented a real-time data processing system using Azure Event Hubs and Azure Stream Analytics to collect and analyze data from multiple sources.

Developed ETL pipelines using Azure Data Factory to extract data from various sources, transform the data, and load it into Azure Data Lake.

Designed and implemented data models for data warehousing using Azure Synapse Analytics.

Developed custom data processing solutions using Azure Databricks and Apache Spark.

Created custom data visualizations using Power BI to provide insights into business performance.

Designed and implemented a data warehousing solution using SQL Server Integration Services and SQL Server Analysis Services.

Developed ETL pipelines to extract data from various sources, transform the data, and load it into the data warehouse.

Developed custom data visualizations using Tableau to provide insights into business performance.

Employer: Accenture

Nov 2016 – Sep 2019

Title: Senior Application Development

Responsibilities:

Working with business users and Business Analyst for requirements gathering and analysis.

Designing and customizing data models for data warehouse supporting data from multiple sources on real time.

Design and develop SQL functions for Business Intelligence application under direction of the Application architect and project manager for analyzing the new source data set and data providers as part of new sources Data Acquisition process.

Extracted data from different flat files, MS Excel, MS Access and transformed the data based on user requirement using Informatica Power Center and loaded data into target by scheduling the sessions.

Worked on Informatica Power Center 8.6 tool – Source Analyzer, Data Warehousing designer, Mapping & Mapplet Designer and Transformation Designer. Developed Informatica mappings and tuned mappings for better performance.

Created reusable mapplets and Transformations.

Created sequential batches for sessions.

Developed PL/SQL procedures/packages which returns dataset that will be used as source data to load the data into Oracle.

Stored reformatted data from relational, flat file, XML files using Informatica.

Analyze the new data sets data and certify for its data quality, accuracy, interpreting data using statistical techniques, also performing analytics using Python, Tableau, and other Business Intelligence tools.

Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.

Written SQL Scripts and PL/SQL Scripts to extract data from database and for testing purposes.

Executing test scripts to verify actual results against expected results by using Power Connect for source validation and target validations.

Test system BI solution components using Microsoft SQL Server, Informatica, Tableau, Power BI to provide Business Intelligence and data analytics solutions.

Environment: Tableau 2020.3/2019.1/2018.2, Power BI, Informatica, SQL Server, Oracle, Python.

Employer: Capgemini

Jul 2014 – Oct 2016

Title: Senior Application Development

Responsibilities:

Involved in the analysis of the user requirements and identifying the sources.

Created technical specification documents based on the requirements by using S2T Documents.

Involved in the preparation of High-level design documents and Low-level design documents.

Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.

Prepared ETL standards, naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.

Designed and developed Informatica’s Mappings and Sessions based on business user requirements and business rules to load data from source flat files and tables to target tables.

Worked on various kinds of transformations like Expression, Aggregator, Stored Procedure, Java, Lookup, Filter, Joiner, Rank, Router and Update Strategy.

Developed reusable Mapplets and Transformations.

Used debugger to debug mappings to gain troubleshooting information about data and error conditions.

Involved in monitoring the workflows and in optimizing the load times.

Involved in writing procedures, functions in PL/SQL.

Worked with SQL*Loader tool to load the bulk data into Database.

Prepared test Scenarios and Test cases in HP Quality Center and involved in unit testing of mappings, system testing and user acceptance testing.

Environment: Informatica power center, SQL Server, Data Integration, Data Analysis

Employer: IGATE global solutions Feb 2014 – Jun 2014

Responsibilities:

Classroom training provided by IGATE on Core java, advance java, spring framework.

Created website AIRLINE reservation as part of training.

Worked on internal projects such as Peoplesoft to manage human resources.

EDUCATION

Master’s degree in computer science, National University, CA, USA. Sep 2020 – Sep 2021

Bachelor of Engineering in Electronics and Communication, India. Oct 2009 – Jun 2013

Contact this candidate