Aalap M

SQL/ETL Developer at PopHealthCare
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Fort Mitchell, Kentucky, United States, US
Languages
  • English Native or bilingual proficiency
  • French Elementary proficiency
  • Hindi Native or bilingual proficiency
  • Gujarati Native or bilingual proficiency
  • Marathi Native or bilingual proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Android Development
    -
  • OCPJP
    -

Experience

  • PopHealthCare
    • United States
    • Hospitals and Health Care
    • 200 - 300 Employee
    • SQL/ETL Developer
      • Jun 2021 - Present

      · Develop Complex Stored Procedures, Views, and Temporary Tables as per the requirement. · Create and maintain documents like Documentation Roadmap, DATA Models, ETL Execution Plan, Configuration Management Procedures, and Project Plan. · Responsible for database Development, Dataflow, Integration and Data Modeling. · Design and develop various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages. · Perform SSIS Development and support, developed ETL solutions for integrating data from multiple sources like Flat Files (delimited, fixed width), Excel, SQL Server, Raw File, and DB2 into the central OLTP database. · Deploy and monitor SSIS packages for Dynamic ETL flow to validate, extract, transform and load data. · Migrate data from different sources (text-based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS). · Involved Automation of ETL processes and jobs to reduce manual intervention. · Created complex T-SQL Queries, Stored Procedures, Functions, Indexes, CTE’s, Views, Joins and Triggers. · Write complex T-SQL queries and stored procedures for the building reports in SSRS. · Write and debug T-SQL Queries, SSRS Reports, SSIS Packages and Stored Procedures. Show less

  • CareSource
    • United States
    • Insurance
    • 700 & Above Employee
    • ETL Developer
      • Dec 2020 - Jun 2021

      · Develop complex T-SQL Queries, Stored Procedures, Functions, Indexes, CTE’s, Views, Joins and Triggers. · Responsible for providing 24x7 Production support, Database and Log Backups & restoration, Backup strategies and scheduling Backups. · Performed data extraction and manipulation over large relational datasets using SQL, Python, and other analytical tools. · Involved in Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables. · Used Excel Pivot tables to manipulate data to perform data analysis. · Involved in Testing and Debugging Stored Procedures and functions, database tuning. · Deployed SSIS packages and Reports to Production Servers. · Created SSIS packages and used Analysis Services processing task to update the cube with current data. · Developed reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS. · Used SSRS reports with parameters from Performance Point Services deployed in SharePoint 2013. Show less

  • Fifth Third Bank
    • United States
    • Financial Services
    • 700 & Above Employee
    • ETL Developer
      • Jun 2019 - Dec 2020

      · Actively involved in administrative tasks, code reviews, troubleshooting problems and migrating to different environment processes. · Extensively involved in coding and unit testing of different integration based on the technical design specifications. · Experience working on given requirement, Implementing code review comments, design changes and documenting. · Created the insert, select, stored procedures, update for Source and target Tables. · Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS. · Performed Unit Testing and implement error handling as per defined standards. · Written SQL statements for database management · Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications. · Created SQL Server Integration Service packages (SSIS) and used it to Extract, Transform and Load (ETL) into Database tables. Show less

  • Baanyan Software Services, Inc.
    • United States
    • IT Services and IT Consulting
    • 100 - 200 Employee
    • Tableau developer
      • May 2019 - May 2019

      · Created and deployed SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations. · Fine \tuned SQL Queries for maximum efficiency and performance. · Designed and implemented data warehouse architecture for corporate circulation Datawarehouse. Subsequent data marts, extracts and reports were sourced from the architecture of conformed facts and dimensions · Created Drill-down and Sub-Report using SSRS. Monitored the performance of the reports. · Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently. · Generated context filters and data source filters while handling huge volume of data. · Built dashboards for measures with forecast, trend line and reference lines. · Published Workbooks by creating user filters so that only appropriate teams can view it. Show less

  • Qualcomm
    • United States
    • Telecommunications
    • 700 & Above Employee
    • Plsql Developer
      • Sep 2013 - Dec 2014

       Involved in gathering user requirements and documenting the Technical specification analysis based on functional needs.  Involved in query optimization and developing ER models as per the requirements.  Handling large size databases which involve migration of data from Oracle to SQL.  Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE.  Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.  Developed PL/SQL triggers and master tables for automatic creation of primary keys.  Created PL/SQL stored procedures, functions and packages.  Dealt with the third party vendor (4Sight) for resolving issues, finding software related bugs and gave recommendations to resolve it.  Worked with different business users in setting up data marts based on their Analysis/Reporting needs.  Developed SQL scripts /libraries for various data loads and validation for both OLTP and OLAP systems.  Created complex Stored Procedures, Triggers and User Defined Functions to support the front-end applications.  Created and altered Databases, Tables, Views, Indexes and Constraints with business rules using T-SQL across all SDLC environments. Show less

Education

  • New Jersey Institute of Technology
    Master's degree, Computer Science
    2016 - 2018
  • Shah And Anchor
    Bachelor's degree, Computer Engineering
    2011 - 2016

Community

You need to have a working account to view this content. Click here to join now