SUMMARY:

• SQL development professional with strong verbal and written communication skills and solid analytical skills for writing relational database solutions for businesses. A self - starter who can work independently with 9+ years of experience.
• Expert in creating and developing Power BI Dashboards into rich look and configuring data gateways to have automatic refresh of the dataset.
• Highly experienced in designing SSIS packages to import and transform data between databases and external data sources using various transformations.
• Experience in configuration and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager
• Experience in Ad-hoc reports, data driven subscription reports by using Report Builder.
• Working knowledge in SQL Server Analysis Services (OLAP).
• Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies.
• Good knowledge on OOPS, SOLID Principles Object creational design patterns.
• Very good experience in Entity Framework, LINQ to SQL.
• Experience in MS- SQL Server Development and Administration including Design and implementation of Distributed or Replicated Databases, planning or implementing backup or recovery strategies, and Performance tuning.
• Expertise in creating reports from importing, Direct Query and Live data from several data sources.
• Good at developing and implementing reporting and data solutions, including custom user interfaces. In-depth understanding of all stages of software development life cycle (SDLC).
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction. Provide database coding to support business applications using Sybase T- SQL.
• Expertise in installing, maintaining and troubleshooting the Personal and On-Premise Gateway
• Import data from different data source to create Power BI reports and dashboards
• Involved in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions.
• Worked on end to end project in Azure Environment by pulling the source data from SQL Server and storing the data in Azure SQL Server using Blob Storage and creating reports using Power BI Desktop.
• Expertise in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split column, Date & Time Column, etc.
• Created different reports in Power BI Desktop and publish to Power BI online.
• Strong knowledge in SQL Server and SSIS, SSAS, SSRS experience in data visualizations and report development with Power BI.
• Worked on Power BI desktop and power BI service to publish the reports.
• Involved in writing Complex SQL queries, stored procedures and Triggers accessed SQL SERVER Management Studio (SSMS).
• Worked with developing events and delegates in implementing Multi-threaded application.
• Experience in Creating Reports using SQL Server Reporting Services (SSRS).
• Effective team player and excellent communication skills with insight to determine priorities, schedule work and meet critical deadlines.
• Excellent verbal and written communication skills, analytical and inter personnel skills.
• Possess great communication skills, both written and verbal and be a team player, will adapt to shifting priorities.

AREAS OF EXPERIENCE:

RDBMS: Quality Assurance Web Services and APIs, SQL, T-SQL, PL/SQL SQL Server, SSIS & SSRS SAS, R and Python

ETL: Informatica Probability, Inference & Modeling Data Analysis

PROFESSIONAL EXPERIENCE:

Confidential, AUSTIN, TX

Sr. SQL Developer

Responsibilities:

• Development and Integration of new Reporting Templates using SQL Server Reporting Services (SSRS) and MS - SQL 2017 for Researchers.
• Revision and Improvement of existing Reports based on Research requirements.
• Development of Stored procedures to run in the background for data population.
• Work as Data analyst, by interacting with the researchers and gathering requirement for Claims data Discovery.
• Expertise in creating applications and LCP Letters using XML, SQL configuration and JASON.
• Participate in the deployment of updates and configuration changes to SQL Server.
• Monitor scheduled jobs to ensure process stability.
• Write and revise documentation for system configuration & standard operating procedures.
• Develop Ad-hoc reports through SQL Server Reporting Services (SSRS) and Maintain existing reports within our SSRS environment.
• Develop and execute extraction and load scripts (SSIS).
• Worked on ICD-9 codes and DRG.
• Develop/maintain automate reporting and client email delivery through SSIS.
• Advanced knowledge of T-SQL (stored procedures, functions, triggers).
• Design and development processes across the entire data warehouse ETL framework.
• Worked on Claims, Members, Providers, Medicaid and Medicare Data.
• Able to write, optimize and debug queries and stored procedures. Relational Database and SQL Language.
• Design and development of SSRS reports and Dashboards including data set ingestion and transformation, Modeling, Data Analysis Expressions (DAX) using the appropriate report templates
• Development of data models, technical and functional documentation with business partners.
• Demonstrate and promote reporting best practices and use of data visualizations to empower data driven decision making.
• Provide governance around the SSRS platform architecture and operations.
• Design and develop SSRS reports, dashboards, apps, DAX scripts.
• Manage concurrent projects and independently prioritizes multiple requests to meet the organizational goals.
• Monitor a wide range of technical problems and make decisions and provide recommendations to the team
• Participate in the deployment of updates and configuration changes to SQL Server.
• Worked on Claims, Members, Providers, Medicaid and Medicare Data. Write and revise documentation for system configuration & standard operating procedures.

Confidential, Chicago, IL

SQL/SSRS Developer

Responsibilities:

• Modified Store Procedure and formulated basic coding and scripting to be utilized for reports.
• Used Joins and Sub-queries for complex queries that involved multiple table from different databases and identified relationship among them.
• Analyzed data models, data relationships, and dependencies for greatest optimization.
• Provided tech team support for data warehouse.
• Identified issue and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.
• Responsible for data cleansing operation for data warehouse in staging environment and identified issue and fix them before entering data in a Data Warehouse.
• Modified the existing SSIS package to meet the changes in user's' requirements.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Created various SSIS packages and ETL processes based on the business requirement.
• Responsible for extracting data from various source system like Excel, CSV file, Flat File, SQL server, Banner based on the requirement.
• Extensively worked on developing database objects like Stored Procedures, Views, Indexes, Triggers and Functions using T- SQL and performance tuning of SQL Queries.
• Created SSIS package to load data from staging environment to data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, and Slowly Changing Dimension.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the Database on Daily basis using SQL Server Agent.
• Modified the existing SSIS package to meet the changes in user's' requirements.
• Created and maintained various SSRS report for the business users.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2015 Reporting Services (SSRS).
• Created various kind of SSRS reports such as parameterized report, sub report, Drill Down report, and Drill Through report for the business users.
• Designed and developed stored procedures that accept parameters, queries, views, User-defined function, and CTE's necessary to support SSRS reports.
• Created subscription in SSRS to deliver reports to a PDF or excel format.
• Create team specific agile process flow in JIRA to move tasks from one activity to another.

Environment: MS SQL Server 2014/17, T- SQL, SSRS, SSIS, SSAS, Windows server 2012R2, Visual Studio 2015, SVN, JIRA, C#/VB.NET, Windows 7/10.

Confidential, Atlanta, GA

SQL Developer

Responsibilities :

• Expert in preparing performance Dashboard, Job Failure stats, Data Volume check using SSRS, SSIS, and SQL.
• Create reports in Power BI utilizing the SSAS Tabular via Analysis connector as Data Source.
• Project Specific Activities:
• Understanding the business requirement and functional specification of the client module with Business Executives & Analysts.
• Created SSIS Packages/projects to move data from source to destination programmatic by using Visual Studio 2014 and developed ETL packages to extract and transform data from data sources like MS Access
• Involved in Data Scrubbing and Data Cleansing using MDS, DQS.
• Gathered statistics and analyzed tables and Indexes for performance tuning.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for DBMS.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
• Designed, developed, debugged Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
• Created various visualizations such as Stacked Charts, Pie Charts, Donut Chart cards according to business requirements. Worked on RLS to constrain the user access to the row level data.
• Involved in creating MDX, DAX, Cubes and Tabular models using SQL Analysis Services (SSAS).
• Design and write elastic queries to access data across database and Migrate an existing SQL Server Database to use Azure Database.
• Responsible for the Performance tuning of the SQL Commands with the use of SQL Profiler and Database Engine Tuning Wizard.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Familiar with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER Functions.
• Provided ongoing support and configuration for JIRA projects, workflow, screens, fields, permissions and other administrative tasks.

Environment: MS SQL Server 2014, SQL Server Integration Services 2014 ( SSIS), SQL Server Analysis Services 2014 (SSAS), SQL Server Reporting Services ( SSRS),MDX, DAX,T- SQL, Shell Scripts, Microsoft Visual Studio 2014, JIRA, MDS, DQS, Power BI Desktop, Power Query, TFS, Tableau, Azure, MS Access, ETL, Excel.

Confidential, Indianapolis, IN

Sr. SQL Developer/ Power BI

Responsibilities :

• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house by using BIDS.
• Improved the performance of SSIS packages by enabling Parallelism in the Control and Data Flows, usage of synchronous transformations.
• Experience in creating master and child packages, using package configurations (SQL Server) and SSIS logging.
• Created the ETL (SSIS) packages and ETL procedures scheduled them for Jobs.
• Modifying scripts to handle automated Loading/Extraction and Transformation (ETL) of data using (SSIS).
• Created complex Stored Procedures, Triggers, Tables, Views and SQL Joins and other statements to maintained referential integrity and implemented complex business logic.
• Performance tuning: improved slow running SQL scripts with getting rid of nested cursors. Missing indexes has been added. Unused indexes have been removed to improve tables update performance.
• Designed Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Created various database objects such as tables, indexes and views based on the requirement.
• Participate in creating data conversion and migration strategy, conversion design and conversion development documents. Participate in Data Modeling Sessions.
• Hosted SSIS knowledge transfer, data quality issue meetings with the client on a weekly/biweekly basis.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Developed data reconciliation SQL queries to validate the overall data migration. Prepared data reconciliation reports for conversion team/business. Maintained ETL functional specifications, test plans and data for data conversions. Automated the data reconciliation process to minimize the developer involvement in validating production migrations.
• Provisioned VMs with SQL Server on cloud utilizing Microsoft Azure and setting up communication with the help of endpoints.
• Documentation of Business Rules, Data Mapping Spreadsheet, Meeting Minutes, Key decisions from the client, SSIS introduction material to the client.
• Generated Custom ETL scripts using SSIS 2008 and unit test SSIS load processes for performance check.

Environment: MS SQL Server 2010/2012/2016 , SSIS, SSRS, T- SQL, Vector SQL, Visual Studio 2010/2012, C#, SQL Server Profiler, Dashboard, Power BI, SQL Server Management Studio, Team Foundation Server (TFS), SQL Server Business Intelligence Development Studio (BIDS), DbVizualizer, Action Database.

Confidential, Overland Park, KS

MS SQL Server Developer/SSIS/SSRS/SSAS

Responsibilities:

• Gathered functional requirements and Business requirements and written the technical specifications for building the Global Enterprise Data warehouse.
• Worked closely with end users in designing and creating the Global Enterprise Data warehouse.
• Implemented member properties, virtual dimension, dimension custom rollups, write back, action and drill through.
• High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill - through, Drill-down, Crosstab Reports and Sub-Reports using RDL.
• Developed a multi-dimensional database (MDDB) and OLAP cube using SQL Server 2008 that stored and maintained the data.
• Implemented MS Analysis Services setup, tuning, cube partitioning, and dimension designing including hierarchical and slowly changing dimensions.
• Managed Up gradation of DTS packages to SSIS packages.
• Involved in the complete data warehouse development life cycle and solely responsible for the design, development and maintenance of 8 cubes.
• Implemented transactional replication among different servers.
• Provided technical guidance and support to end-users by developing documentations required.
• Performed application and database code production pushes, following production release procedures.
• Performed production SQL release final verification procedure to production.
• Documented all database changes and follow and enforce change and release management processes.
• Audited and enforced database security, code and procedural standards