Dec 2020 – May 2022 · 1 yr 5 mos

• The objective of this project was to interpret data, analyze results using statistical techniques and provide ongoing reports. Acquire data from various departments within the company and maintain databases. Prepare reports for management using business intelligence reporting tools. Work with management to prioritize business and information needs. Create data dashboards, graphs, and visualizations.
• Created and implemented complex Stored Procedures and Triggers, Functions, Indexes, Constraints, Tables, Views and Joins using T-SQL to provide definition, structure, maintain data efficiently for applications and to automate tasks.
• Reviewed data and classified the tables/measures functions by using multiple queries, views, and procedures.
• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction for varies projects. Prepared a claim data for risk adjustment by extracting, cleaning, and merging from different tables using SQL.
• Loading data from various sources like, flat files, MS Access, and Excel, to SQL Server database using SSIS package.
• Used SSIS to build high performance data integration solutions, including extraction, transformation, and load (ETL) packages.
• Using SSRS to deliver enterprise, Web-enabled reporting reports that draw content from a variety of data sources.
• Deployed SSRS Reports in SharePoint for web-based access for multiple end users.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for users using Row level security and User filters.
• Environment: MS SQL Server 2019, Query Analyzer, Enterprise Manager, SSIS 2019, SSRS 2019, Microsoft Excel, SQL Server Agent. Tableau 2018, Power BI, MS Access, Teradata.

Oct 2017 – Dec 2020 · 3 yrs 2 mos · North Carolina, United States

• Fidelity Bank is a financial services organization that is the leading retirement provider of financial services for the academic, research, medical and cultural industries. It was created as a stock life insurance company for the purpose of providing retirement income for professors through fixed premium guaranteed deferred annuity contracts.
• Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints, Stored Procedures and Queries to be used in the project.
• Developed SSIS packages to load the staging tables run jobs. Data sources included flat files, spreadsheet, Access, and other third-party sources.
• Created derived columns from the present columns for the given requirements.
• Did Transformation and data cleansing activities use various Control flow and data flow tasks in SSIS packages during data migration.
• Analyzed data by defining quality requirements, making recommendations for changes on the source system, working with users to correct historical data and by applying standard data cleansing in integration services flows using SQL Server.
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation and Aggregator Transformation.
• Designed and developed Data warehouse, star schemas, fact table, Dimension tables, Slowly Changing Dimension, Staging areas, Operational Data Store.
• Developed Source-To-Target Mapping for the Data Mart incorporating various Business Rules.
• Developing and Extending SSAS Cubes, Partitioning, Data Mining Models, Deploying and Processing SSAS objects, writing MDX queries.
• Environment: MS SQL Server 2017 and 2017, SSRS, SSIS, SSAS, MS SQ, C#, VB.NET, Erwin

Aug 2015 – Oct 2017 · 2 yrs 2 mos

• The goal behind the Market Risk System is important for banks to have a reliable two-year documented capital plan that demonstrates that they have sufficient capital to continue operating soundly during times of economic distress & to have a robust capital planning process that includes a sophisticated understanding of their unique potential risks.
• Responsible for updating and staging the dimensional databases as well as rebuild the Dimensions using SSIS.
• Used C# scripts in SSIS script task to run custom scripts in package flow.
• Involved in implementing package configuration in SSIS packages that allowed transferring packages from one environment to other.
• Worked with Business Analysts for gathering the requirements & implementing the tasks.
• Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system into data warehouse and then making data available in the cube.
• Configure TFS environment such that SQL Reporting and SharePoint interact with each other.
• Knowledge on maintaining Production Servers which are in remote location.
• Performed Unit Testing of ETL Programs to support QA on End-to-End testing.
• Collaborated with development team during all phases of the project to promote successful delivery of quality products to our customers.
• Identified and involved in creation of dimension, fact tables and designed the data warehouse STAR and
• SNOWFLAKE schema.
• Understand the significance and use of encryption and risk management for data protection.
• Involved in SDLC followed by Agile methodologies to produce high quality software model using N-Tier Architecture
• Designed and Implemented Tables, CTE, Views, Functions, Stored Procedures and Triggers in SQL Server 2015.
• Regression testing was performed after each new build of the application.
• Environment: SQL Server 2015, MS Excel 2003, SMS SQL Query Analyzer, SQL Profiler, SSIS, SSRS.

Jan 2012 – Sep 2015 · 3 yrs 8 mos

• Ananta Group is a marketing technology and Services Company that collects, analyzes, and parses customer and business information for clients and consists primarily of companies in the financial services, insurance, information services, direct marketing, media, retail, consumer packaged goods, technology, automotive, healthcare, travel and telecommunications industries, and the government sector.
• Developing T-SQL queries, triggers, functions, cursors, and stored procedures.
• Responsible for logical and physical design of SQL Server databases.
• Alter the schema for the required objects.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Created views to restrict access to data in a table for security.
• Expert in extracting data using SSIS from OLTP to OLAP.
• Performed Bulk data migration using DTS and SSIS from flat files.
• Designed and optimized all the SSIS packages.
• Created SSIS packages to Export data from text file to SQL Server Database.
• Designed and implemented stylish report layouts.
• Identified the Data Source and defining them to build the Data Source Views.
• Identified and defined the Datasets for report generation and included report parameters.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Implemented full and differential backups and created and managed DB objects.
• Make recommendations for File group Creation and Placement.
• Scheduling backups and automating weekend maintenance tasks.
• Created users and roles for login authentication and validating permissions.
• Administering MS- SQL Server, performing day-to-day tasks such as Database tuning by checking indexes.
• Upgraded SQL Server 2008R2 to SQL Server 2012.
• Assisted developers in tuning Stored Procedures, Triggers and Functions over performance issues.
• Environment: SQL Server 2012, T-SQL, DB Artisan, MS Reporting Services, Management Studio, Query Analyzer, Windows 2003/2000 Server, Oracle 9i