SUMMARY:

• 9+ years of IT experience in Database Development, Administration, System Analysis, Design, Development, implementation, and support of MS SQL Server 2005/2008//2008 R2/2012.
• Extensive Experience in Data Modeling, ETL (Extract, Transform and Load), Database Design, Development and Reporting.
• Expert in developing T - SQL (DDL, DML) statements, Data Integrity (constraints), Rules and Validation issues.
• In-depth knowledge in ER Modeling and Dimensional Modeling (Star and Snowflake Schema) building Dimension and Fact tables
• Extensive experience with all phases of Software Development Life Cycle in different environments like Banking, Insurance, Engineering and Information Technology.
• Knowledge in Agile, Scrum, UML, Waterfall and Project Management Methodologies.OLTP Experience:
• Extensive experience with SQL Server in production and development environments and T-SQL in constructing tables, user defined functions, relational database models, triggers and data integrity.
• Supported and developed various Client Server applications by handling Database requests for various application development teams.
• Good knowledge in creating, modifying, using and debugging Stored Procedures, Views, Indexed Views.
• Experience in building Referential Integrity Constraints, Normalization and Data Modeling
• Experience in handling client static data or client data
• Excellentanalytical, communication and interpersonalskills.
• Performed Test and Deploy code across various SDLC Environments.
• Responsibilities also included creatingarchitecturediagrams, data flows and data models identifying the data to migrate by developing database models
• Involved in Maintenance, Bug Fixes, Job scheduling and Code Debugging.
• Implemented Change Data Capture on databases.
• Experience in working a variety ofanalyticalfunctions, RANK, DENSE RANK, LAG, LEAD, and PARTITION OVER
• Good knowledge of object-oriented paradigms for c#.Net to maintain and find functionality in MSBI
• Excellent communication,analyticalskillsand strong ability to perform as part of a team
• Good understanding of healthcare domain, HIPAA regulations and continuous communication with different stakeholders, clients like Medicare, Medicaid, CHIP
• Handle daily Service Now tickets raised by internal teams and issues withcustomerreports deployed in Production
• Good knowledge and exposure to Database Mirroring, Replication, Log shipping, backup and restore procedures and disaster recovery.BI (OLAP) Experience:
• Expertise in Business Intelligence Process for Data Integration and Migration services.
• Hands on experience in configuring and creating SSIS solutions for ETL.
• Experienced in normalizing databases for OLTP environments and de-normalizing tables for use in OLAP environments.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.
• Experience in using Microsoft .NET framework for SQL ServerIntegration Services (SSIS) packages for logging programmatically and managing, automating Control flow, Data flow and Events.
• Expertise in Power BI, Power BI Pro, Power BI Mobile.
• Expert in creating and developing Power BI Dashboards into rich look
• Experience in building Data Mart using Oracle SQL Developer to be consumed by MS Power BI reports and dashboards
• Expert knowledge and experience authoring, managing and deploying reporting solutions using SQL Server Reporting Services (SSRS).
• Experience in Troubleshooting Report Processing, Configuration of different problems, Subscription and Delivery.
• Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions.
• Design, Develop and Deploy Microsoft Power BI reports
• Developed Scorecards/Reports for the system using SSRS
• Experience in creating Multidimensional Cubes using SQL Server Analysis Services (SSAS).
• Experience in implementing KPI’s, Aggregation, Partitions, Perspectives, Hierarchies and Calculated Members using SSAS.

TECHNICAL SKILLS:

Data Warehousing & BI: SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS)

Reporting Tools: Power BI, SSRS 2012/2008/2005, Crystal Reports XI/X/9/8, Excel.

Database: MS SQL Server 2012/2008/2005, Oracle 10g/9i/8i, MYSQL, MS-ACCESS.

Programming: C, C++, Visual C++ 6.0, VB6.0, C#.Net, VB.Net, PL/SQL, TSQL, Java EE

IT Processes: Software Development Life Cycle (SDLC), Project Management

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Visio

Operating System: Windows Vista/NT/XP/98/95, Windows 2003/2000 Server, UNIX.

Application Servers: Microsoft IIS 6.0/5.0/4.0, Apache.

Web Technologies: HTML, XML, JavaScript, PHP, Shell Scripting, jQuery.

PROFESSIONAL EXPERIENCE:

Confidential, Glen Allen, VA

SQL BI Developer

Responsibilities:

• Actively involved in analyzing and working on the tickets based on the Severity level of the ticket
• Understand the Root cause of the issue and resolve the ticket by creating the DBA scripts for any data or configuration changes and Operations tickets to restage the files or run the jobs based on the resolution of the ticket.
• As part of permanent fix of the ticket develop the solution of the ticket and create the Pull request to merge the new changes in production
• Work on SSIS packages to develop solution for the ticket by creating new transformation and update the existing transformations based on the need
• Analyze the jobs to define the exact step of the job failure and root the exact SSIS package which is causing the issue
• As part of root cause analysis of the ticket, analyze the flow of complex SSIS packages and prepare the solution to fix the issue
• Coordinate within the team, Scrum team and business team accordingly to understand blockers during the process of resolving the ticket
• Work with the QA team to test the changes before deploying to production and complete the Integration and Staging testing before the changes are merged in production
• Setup the test environment in Development or Integration or staging for the QA team and share the inputs as needed to test the changes or run the jobs
• Participate in KT sessions as part of new client implementation or integrating a new solution into the project
• Analyze the complete flow of the job and fix the logic in all the required SSIS packages and make sure similar issue will not be repeated
• Understand the complete flow of the project to define the exact root cause of the issue and fix it at the earliest.

Environment: MS SQL Server 2012/2008R2, SQL Server Integration Services (SSIS), Agile, T-SQL, SQL Profiler, Bitbucket, SQL Developer 4.0.1.

Confidential, Bloomfield, CT

Sr. Power BI Developer

Responsibilities:

• Actively involved in gathering System Specification Requirements for the projects
• Developed Power BI model used for financial reporting of P & L and Headcount
• Enforced the Business Rules by creating multiple constraints like check constraints and triggers as well as automated to update the database statistics.
• Developingstored procedures,triggers, views,and adding/changing tables for data load and transformation, and data extraction.
• Eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Scheduled Automatic refresh and scheduling refresh in Power BI service.
• Wrote calculated columns, Measures query’s in Power BI desktop to show good data analysis techniques
• Work with the business managers, requesters and Client data management to analyze and perform the changes accordingly
• Designed and developed SSIS Packages to import and export data from MS Excel,SQLServerand Flat files.
• Used SQL Server Profilerto trace the slow running queries and tried toOptimizeSQLqueries for improved performance and availability.
• Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure
• Worked on the Hadoop solution to perform Data Masking for the Hadoop applications using Hive and Sqoop by implementing the logic in Python
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Expertise in writing complex DAX functions in Power BI and Power Pivot
• Created views as required by front end developer for easier implementation and wrote triggers on the associated tables to provide efficient data manipulation.
• Tested, Cleaned and Standardized Data to associate the business standards using Fuzzy /exact lookups using SSIS tasks.
• Implemented Error handling and utilized Event handlers for automated notifications using SSIS
• Investigate data quality issues and content exceptions.
• Using SQL Server Reporting Services (SSRS) generated periodic reports based on the statistical analysis of the data
• Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS in Visual Studio
• Designed Power BI data virtualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts
• Exported data in a variety of ways and across multiple visualization using Power BI.
• As part of Data Mining activity, provided the data for different test scenarios to PVS and QA testing teams
• Involved in developing backup/recovery strategies.
• Developed macros to produce the Data Profiling statistical graphs.
• Experience in creating multiple reports (SSRS) in Drill down mode using tables, financial tables, crosses tabs and charts
• Participate in defining metrics to measure the quality of the metadata and data.
• Participated in the application development process and code reviews of database objects.
• Documented MSSQLServerdatabase design, implementation and configuration.

Environment: Power BI, MS SQL Server 2012/2008R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), Agile, T-SQL, SQL Profiler, GIT, SQL Developer 4.0.1.

Confidential, Baltimore, MD

SQL BI Developer

Responsibilities:

• Interacted with technical team and Business users to perform analysis of business requirements and transformed them into technical requirements for ETL and Reporting needs
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
• Handle the tasks of providing technical leadership and guidance to team members
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults user defined data types and functions
• Worked on Deployment of packages into Production servers and managed scheduled SQL jobs
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Created number of standard reports and complex reports to analyze data using Slice & Dice and Drill Down, Drill through using SSRS.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Developed Power BI reports and dashboards from multiple data sources using data bending
• Involved in creating complicated packages with custom coding using c#.net in SSIS.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Responsible for Extraction, Transformation and Loading of data from multiple sources to Data warehouse using SSIS
• Lead team to validate agile change requests, revise plan bi-weekly and get client approval
• Developed generic ETL packages in SSIS for the User Maintained files which are loaded to Oracle data warehouse using file sources
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
• Experience in SQL joins, sub queries, tracing, indexing strategies and query/index tuning and performance tuning for better running of queries.

Environment: Power BI, MS SQL Server 2014/2012/2008 R2, MS SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Agile, C#.NET, T-SQL, SQL Profiler, XML, DB2, Subversion (SVN), MS Excel, SQL Developer 4.0.1.

Confidential

SQL BI Developer

Responsibilities:

• Prepares performance Dashboard, Jobs Failure stats, Data Volume check using SSRS, SSIS, SQL and Excel and gives PPT presentation near client for this on a daily basis.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements
• Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files.
• Create and manage Reports subscriptions and schedules SSRS reports
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Created SSIS packages to Extract, Transformation and Load (ETL) inventory and other sales data from Flat Files, Excel Files, Access, Mainframe DB2, Oracle etc.
• Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis
• Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Designed and built up high performance ETL packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Responsible for debug, performance checks and performed index tuning and query optimization
• Created database maintenance planner for the performance of SQL Server, which covers database integrity checks and re-indexing
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area

Environment: Power BI, MS SQL Server 2012/2008R2, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), Agile, MS SQL Server Analysis Services (SSAS), C#.NET, T SQL, SQL Profiler, XML, Team Foundation Server (TFS), SQL Developer.

Confidential

SQL BI Developer

Responsibilities:

• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.
• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.
• Developed large number of standard and customized reports using SSRS for data feeds and for Reports onserver.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created several reports using SSRS and MDS like parameterized report, drill through reports, linked and sub reports
• Actively participated and interacted with project manager and other team members to process the complex business logic and requirements of the project.
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by usingSQLProfiler andSQLAnalyzer.

Environment: Power BI, MS SQL Server 2012/2008R2, Agile, T SQL, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS Excel.