Experience

MOLINA HEALTHCARE INC

• United States
• Hospitals and Health Care
• 100 - 200 Employee

• Sr. SQL Server Developer

  • Mar 2022 - Present

  .Participated in project meetings, providing input to project plans, and providing status updates. .Assist the team in configuration of EDI projects. Responsible for collecting, organizing, interpreting, and analysing healthcare data from a wide range of existing data sources for key stakeholders. .Creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities. .Maintain detailed documentation and process flows of all data integration and EDI processes. Created new and existing processes are appropriately documented, including both technical and user documentation. .Create and Modify Processes and maps, according to the business. Performing the ETL operations to support the data loads and transformations for EDI Processes. Show less



TriWest Healthcare Alliance

• Hospitals and Health Care
• 700 & Above Employee

• Sr. SQL Server Developer

  • Apr 2021 - Feb 2022

  • Involved in analysing business requirements and understanding the functional workflow of information from source systems to destination systems. • Designed automated scripts in T-SQL and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity. • Created Efficient Stored Procedures, Triggers, and Functions, Indexes, Tables, Views, and other T-SQL scripts. • Responsible for Query optimization and Performance tuning. • Involved in Debugging Issues as a part of Production Support. • Performing Unix/ Linux command line to restart and fix server router which is detected by U2A (broker) monitoring script. • Worked to detect and resolve the defect in Perl script on Linux Red Hat platform by modifying and install zip, mailx functionality to send the batch job log files to email server. • Designed Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing. • Build efficient SSIS packages for processing fact and dimension tables with complex transforms. • Extract, Transform and Load source data into respective target tables to build the required Data Marts. • Created ETL process using SSIS to transfer data from heterogeneous data sources. • Worked on Deployment of packages into Production servers and managed scheduled SQL jobs. • Created a variety of reports using SSRS including matrix report, Parameter Report, Dashboard, Charts, Drill-down, Drill- through, Cascade parameterized Report, and Configured Report Server • Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages. • Experience in developing interactive data visualization reports, and dashboards using Power BI Desktop. • Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages. Show less



UnitedHealth Group

• Hospitals and Health Care
• 700 & Above Employee

• Sr. SQL/MSBI Developer

  • Mar 2020 - Mar 2021

  • Prepared detailed design documents and documented it clearly while detailing the purpose of the project, source and target database structures, list of batch jobs, sub jobs and their roles, Business rules and assumptions involved in the project. • Imported the data from flat files and were transformed and placed in DB2, Teradata Databases as they were the target databases. • Developed SQL scripts for data dump in the Database in SQL server, DB2, Teradata. • Worked on Azure/SQL on Premise Replication/ geo replication. • Deployed Azure/SQL databases and other SQL settings using PowerShell. • Continuous Integration through VSTS/TFS for tracking work items, code, build, deployment, and release processes. • Create technical design spec for changes, new features and/or enhancements of Azure SMDS Runners using OneNote, MS Word etc. Involved in maintaining Data consistency and Data Integrity using various constraints like Unique, Check, Primary Key and Default. • Extensive hands-on experience with SSIS to build huge packages which involves sourcing the data from a Tab Delimited Text Files, DB2, XML, Excel files and Flat Files and setting up the Variables and Parameters and mapping the obtained result sets to a Map Network Drive which uses the Merge Scripts. • Implemented Performance Tuning of T-SQL Statements effectively with SQL Profiler and Database Tuning Advisor. • Designed SSIS packages using various control flow task like Data Flow Task, For Each Loop, Execute SQL Task. Actively involved in deploying and scheduling packages. • Effectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages. • Worked with various Dataflow tasks like Character Map, Aggregate, ODE Command and Conditional Split while designing SSIS Packages. • Created Excel Reports, Power BI by connecting to various SQL server databases and improved the efficiency of these large reports. Show less



Charter Communications

• United States
• Telecommunications
• 700 & Above Employee

• MS SQL Server Developer/BI Developer

  • Oct 2018 - Feb 2020

  • Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages. • Involved in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert). • Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS. • Involved in error handling of SSIS packages by evaluating error logs. • Successfully extracted, transformed, and loaded data into data warehouse. • Created reports using SSRS from OLTP and OLAP data sources and deployed on report server. • Created tabular, matrix, chart, drill down reports, parametric reports, cascaded reports, dashboards, and score card reports (SSRS) according to the business requirement. • Designed, developed, and tested Qlik View scripts to import data. • Worked on creating proper star schema data model for dashboard. • Extensively used Custom Visuals from Power BI Custom Visuals Blog to meet the requirements. • Shared Power BI reports using Content Packs, Email Share. • Deployed and managed various Power BI reports in Power BI Service. Show less



Equifax

• United States
• Financial Services
• 700 & Above Employee

• MSBI / SSIS/SSRS Developer

  • Mar 2017 - Sep 2018

  • Requirement gathering and analysing data sources. Assisted in design and implementation of Database. • Experienced in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert. • Created and implemented complex SSIS package to migrate data from multiple data sources for data analysing, deploying and dynamic configuring of SSIS packages. • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities. • Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema. • Calculated measures and dimension members using multi-dimensional expression (MDX). • Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS. • Maintain and optimize the existing databases; monitor database performance and growth, performance tuning, generate reports according to the business requirements using SQL Server Reporting Service (SSRS) and populate data warehouse using SQL Server Integration Service (SSIS). • Designed, developed, and deployed SSRS reports that include parameterized reports, snapshot reports cached reports, drill down reports, drill through reports, linked reports, click-through reports, Sub-reports. • Created and Deployed reports to Report Manager and Troubleshooting for any error occur in execution • Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column, etc. • Deployed different SSIS packages on test and production servers. • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments. Show less



Citi Bank

• Financial Services
• 400 - 500 Employee

• SQL/BI Developer

  • Dec 2015 - Feb 2017

  • Documenting the requirement specification and framing the business logic for the ETL process • Creating database objects such as tables, views, stored procedures, Indexes and CTE etc. • Involved in entire product lifecycle development from the requirement gathering through developing and Implementing in the production. • Migrating SQL Server 2008 to SQL Server 2012. • Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, XML task and various transformations. • Worked on FTP and SFTP tasks in SSIS to transfer the data to the providers. • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments. • Configured SQL mail agent for sending automatic emails when SSIS packages fail or succeed. • Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers. • Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secure, and extensible. Show less



HSBC Bank

• Hyderabad, Telangana, India

• Business Intelligence Developer

  • May 2014 - Nov 2015

  • Perform all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and SQL Server T-SQL stored procedures within SQL Server 2008 environment. • Developed, monitored, and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database. Involved Automation of Back Office project and Migration of SQL. • Performed Full load & Incremental load with several Data flow tasks and Control Flow Tasks using SSIS. • Developed application for business to create Internal Rate of Return (IRR) reports for Private Equity using C#.net plugin for Excel, Excel and Access VBA and SQL Server. • Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails. • Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server. Maintained Batch logging, Error logging tables and handled errors using Event handlers. Show less