SUMMARY:

• An experienced and highly motivated IT professional, with 9+ years of experience in analysis, architecture, design, development, testing and support of Business Intelligence products and services like Microsoft Azure Cloud Computing (Azure ADF, Azure Data Storage, Azure SQL, Azure Data Lake, Data Bricks), MSBI (SSIS, SSRS), SQL SERVER, Data Visualization tools like Power BI Desktop, Power BI Service.
• Proficient in SQL Server and T - SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Strong SQL Server Developer Skills including writing stored procedures, user defined functions, common table expressions (CTE) views, Triggers to facilitate efficient data manipulation and data integrity.
• Hands on experience in Azure Cloud Services (PaaS & IaaS), Azure Data Factory (ADF), SQL Azure, Azure Data Lake.
• Experience on Migrating SQL database to Azure data Lake, Azure data lake Analytics, Azure SQL Database, Data Bricks and Azure SQL Data warehouse and Controlling and granting database access and Migrating On premise databases to Azure Data lake store using Azure Data factory.
• Expert in creating Source to Target Mappings.
• Expert in Data Profiling and analysis in a DW environment on Oracle/MS SQL Server
• Expertise in Joins and sub-Queries to simplify complex queries involving multiple tables.
• Strong experience in migrating databases from SQL Server 2008 to SQL Server 2018
• Highly proficient in SSIS with experience to design high level ETL architecture, creating and fine tuning ETL workflows.
• Actively involved in day-to- day ETL progress monitoring, pipeline deployments and validations.
• Good understanding of business requirements, Warehouse schemas and mapping rules for the implementation of simple to complex ETL designs.
• Expert in implementing various business rules for Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous Systems using Azure Data Factory (ADF) and SQL Server Integration Services (SSIS).
• Strong SQL, developing database queries in-depth Knowledge of MS SQL Server and Stored Procedures
• Designed and developed care coordination management Analytical dashboard with various measures, KPIs and
• Custom Visuals metrics in Power BI.
• Expertise in integrating data using SSIS OLE DB connection from heterogeneous SOR’s (Excel, CSV, Oracle, flat file, Access, Text Format Data).
• Experience in maintaining Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Experienced in DTS, SSIS packages creation and scheduling them
• Experience in installation, upgrades, patches, service packs, database migrations and maintenance of SQL Server 2000/ 2005/20 /2016/2018 databases in windows environment.
• Good Experience and knowledge in creating and managing user permissions, logins and setting up security according to business standards.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance
• Understanding of Solaris & Red Hat Linux Server, Windows operating systems.
• Experience in creating Jobs, Alerts, SQL Mail Agent and schedule DTS Packages.
• Experience in assessment, remediation of SQL Servers on governance controls for IT Audits.
• Experience in encrypting the database backup & restoring it using T-SQL in SQL Server 2014
• Handled automating process for proactive monitoring of Database servers.
• Experienced in planning and implementing MS SQL Server Security and database permissions.
• Expert in creating varieties of Reports using SSRS 2016/2008/2005 like drill down, cross tab, matrix style layouts, parameterized reports, performance issues handling, Sub Reports, Ad-hoc Reporting framework design.
• Utilized Star Schema & Snow Flake Schema for architecture and Row Level Security for Access control.
• Extensive experience in Power BI Service Administration, publish & share in Workspace & Apps, scheduling reports, refreshing datasets.
• Expert in performance tuning of Stored Procedures and Queries by using Execution Plan and Database Tuning Advisor.
• Proven ability to deliver productivity and quality improvements through well-managed, on-time projects and can work independently as well as team member.

TECHNICAL SKILLS:

Languages: TSQL, My SQL, VB, XML, C, C++, HTML, .Net tools

Data Warehouse Tools: SQL Profiler, SSIS, SSRS, SSMS, Business Intelligence Development Studio, SQL Server Data Tools

Database: MS Access, MS SQL Server 2000/2005/2008/2008 R 2/2012/2014/2016/2018

Tools: /Utility: SQL Server Management Studio(SSMS), Database Tuning Advisor, Analysis Manager, SQL Profiler, Team Explorer, IDERA, Red gate

Other Tools: MS Office, Visio, Ms Excel, SQL Search 2, SQL Compare 11, SQL Prompt 6, SQL Source Control, TFS, Git, Bamboo, Bitbucket, Octopus, Sharepoint, Tableau Reporting

Reporting Tools: Excel, SQL Server Reporting Services 2005, 2008,2012

Operating System: Windows XP/ 2003/2008/10

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Sr. SQL BI Developer

Responsibilities:

• Strong analytical skills to solve and model complex business requirements.
• Understanding of ETL Best Practices/Methodologies, relational structures, dimensional data modeling, structured query language (SQL) skills, data warehouse, and reporting techniques.
• Ability to efficiently write, tune, debug T-SQL code.
• ETL/SSIS development skills.
• Gather and analyze the business requirements and then translate them to technical specifications.
• Connecting to the required data sources (Tables in SQL Server and Excel files in Share Point)
• Preparing / cleaning the data by doing required data transformations, applying business logics to the data
• Integrating the data from different sources, creating a data model and use joins where required
• Designing and developing dashboard and dashboard functionalities as per the requirement
• Developed dashboard functionalities using parameters, DAX functions, Power Query, Power Pivot, Power View, etc.
• Developed all required visualizations (Charts and Tables)
• Data modelling in power bi to create a Star Schema with Facts and Dimension table
• Executing Unit testing on the data showing in dashboard visuals v/s raw data files
• Implementing row-level security on data along with an understanding of application security layer models
• Publish report to the Power BI Server premium in required workspace and schedule the data refresh
• Using ADF Copy activity moved the files from various sources to cloud data warehouse server.
• Worked on several Azure storage system like BLOB and Data Lake (ADL) .
• Recreated existing application logic and functionality in the Azure Data Lake, Data Factory, SQL
• Ingested data into one or more Azure services - (Azure Storage, Azure SQL, Azure Data Warehouse) and processed the data in Azure Databricks
• Ability to efficiently setup error logging and reporting to support the team.
• Ability to collaborate on a team with infrastructure, application development, and business analyst resources, and clearly communicate solutions to both technical and non-technical team members.
• Ability to support identification of data (e.g., numbers / facts / figures) to enhance messaging and support research (organize data, develop charts, tables, etc.).
• Critical thinking and analytical skills; ability to take loosely formed ideas, coordinate and evolve them.
• Ability to work with and empower others on a collaborative basis to ensure success of unit team.
• Highly organized, structured and self-directed.
• Ability to effectively exchange information, in verbal or written form, by sharing ideas, reporting facts and other information, responding to questions, and employing active listening techniques.
• Strong written and oral communication skills.
• Demonstrated knowledge of Microsoft suite with an emphasis on PPT, Excel, Word, and Project.
• Work on T-SQL Programming, stored procedures, views setup and management of linked servers in SQL-Server databases.

Environment: SQL Server, MS Visual Studio, TFS Source Control, Git, Bitbucket

Confidential, Richmond, Va

Sr. SQL BI Developer

Responsibilities:

• Will collaborate with various team members and operations department to develop internal and external reporting tools and gather and analyze requirements using industry best practices.
• Daily duties include: Describe, develop, design and create operational, financial, and analytic reports using SSRS(SQL Server Reporting Services) tool;
• Analyze existing SSRS reports and stored procedures to redirect sourcing for existing reports to a new reporting data structure and migrate SSRS reports into MicroStrategy environment;
• Build financial risk adjustment reports specific to Medicare Risk Adjustment as per CMS guidelines.
• Create SQL queries and other database objects to perform data analysis tasks;
• Provide support to other technical staff and clients related to system issues and reporting;
• Provide support, including testing, for product development and support staff in the development of enhanced tools for Verisk’s proprietary systems;
• Assist in new client system implementations, including data transfer and user administration;
• Validate data integrity of client data;
• Assist in staff on the use of proprietary systems;
• Utilize SQL Server (SSMS/SSIS), Reporting Services tools, and MicroStrategy tools for the creation and maintenance of relational database design and analytic reports.
• Develop the SQL Server Integration Services (SSIS) packages to transform data in MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations
• Analyze the requirement and design the report templates using SQL Server Reporting Services (SSRS).
• Build database queries and test cases for the testing team to test the reports
• Optimize SQL Server 2016 stored procedures for enhanced performance and robustness
• Develop SQL Scriptsto dynamically manipulate data and generate well-formatted reports based on user requirements
• Developed complex stored procedure using T-SQL to generate.
• Schedule and monitor Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Provide consultation on effective and efficient reporting strategies for end users
• Test, modify and/or debug internally developed reports and stored procedures
• Work with the Configuration Management team to create & manage physical Objects
• Address data performance and data consistency problems
• Work on T-SQL Programming, stored procedures, views setup and management of linked servers in SQL-Server databases.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations

Environment: SQL Server 2005/2008, 2012, 2016, MS Visual Studio 2016, TFS Source Control

Confidential, Richmond, Va

SQL Server Developer.

Responsibilities:

• Create reports for Estimated Receivables in Revenue Stream
• Use logic to calculate Estimated receivables with SQL Server Management Studio
• Analyze the requirement and design the report templates using SQL Server Reporting Services (SSRS).
• Build database queries and test cases for the testing team to test the reports
• Optimize SQL Server 2008 stored procedures for enhanced performance and robustness
• Develop SQL Scriptsto dynamically manipulate data and generate well-formatted reports based on user requirements
• Developed complex stored procedure using T-SQL to generate.
• Schedule and monitor Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Provide consultation on effective and efficient reporting strategies for end users
• Test, modify and/or debug internally developed reports and stored procedures
• Work with the Configuration Management team to create & manage physical Objects
• Address data performance and data consistency problems
• Work on T-SQL Programming, stored procedures, views setup and management of linked servers in SQL-Server databases.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations

Environment: SQL Server 2005/2008/2012, MS Visual Studio 2005/2008/2012, TFS Source Control

Confidential, Scranton, PA

SQL Server/BI Developer (SSIS/SSRS)

Responsibilities:

• Responsible to identify and translate business requirements for the Enterprise Data Warehouse
• Into logical and physical data models.
• Designing and developing SQL Server 2008 Database, Tables, Indexes, Stored procedures,
• Views, Triggers.
• Written complex SQL queries using joins, sub queries and correlated sub queries.
• Created T-SQL Triggers and Stored Procedures to retrieve updated and deleted data from
• Different servers from different locations
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages to load the Sales Data with Excel, CSV, and other flat files as sources.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using
• Packages to import/export data feeds to/from data warehouse and client systems.
• Designed, developed Monthly and Yearly reports for Accounting purpose to calculate revenue and sales analysis using SQL Reporting Services.
• Created and maintained a Point of Sales system to track all the sales generated from various customers across the globe into one single warehouse system.
• Gathered Business rules and implemented functional and technical specifications.
• Pivoted a data base architecture to create an EBook Sales processing system.
• Utilized Data management skills and Analytical skill to create balancing methodologies to tally profit and Loss between Data warehouse and Accounting General ledgers.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Generated reports according to business requirements using reporting services 2008.
• Involved in creating report models and applying row level security filters for report model.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance
• Point Server and published them Via Microsoft Office Share point Server (MOSS).
• Developed a High level dashboard using SSRS 2008.
• Transformed data from various data sources using Flat file, Excel, ADO .net and OLE DB connection by creating various SSIS Packages.
• Created packages in SSIS Designer using Control Flow Tasks and Data Flow Transformations to implement Business Rules.
• Creating the Mappings using Data Flow Transformations such as the Sort, Derived Column, Conditional Split, SCD, Pivot and Lookup etc.
• Using Control Flow, elements like Containers, Execute SQL Task, Execute Package Task, File System Task and Send Mail Task etc.
• Scheduling and Monitoring the ETL packages for Daily load in SQL Server Job Agent.
• Debugging and Validating the Data flows and Control Flows
• To Develop Exception Handling process for each SSIS Package.
• Implemented Performance Tuning at various levels.
• Design and development of database scripts and procedures.
• Implemented checkpoint configuration, package configuration in packages for better reusability.
• Created manual test cases for SSIS testing.
• Created several SQL scripts in order to have required check constraints, Indexes, and Views as per existing Business Rules. Also Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup &
• Recovery, user and application table management, upgrades, creating databases/file groups/Files/transaction logs.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup,
• Restoration and Disaster Recovery for the data
• Actively participated in User Acceptance Testing and Debugging of the system.

Environment: SQL Server 2008, SSIS, SSRS, SSAS,T-SQL, MS-Excel, Windows server 2003, SQL Profiler, Red gate dependency tracker, Tidal, SQL Compare, ultra-edit, IDERA diagnostic management tool.