SUMMARY:

• Over 7 + years of experience in Designing and Implementing BI applications within various industries such as Healthcare, Insurance and Banking.
• Highly proficient with SQL Server BI Stack (SSIS, SSAS and SSRS) within large and small Development/Production teams.
• Experienced with all phases of SDLC involving Systems Analysis, Design, Development, and Implementation.
• Excellent problem - solving skills with strong ability to efficiently implement Database Solutions to accomplish all critical Business Objectives.
• Proficient in Extracting, Transforming and Loading (ETL) Data from different type of Sources such as Excel, Oracle, and Flat Files using SQL Server Integration Services (SSIS) from OLTP to OLAP
• Experience in SQL Server DTS and SSIS (Integration Service) package Design, Constructing, and Deployment.
• Created complex SSIS Packages using appropriate control and Data Flow elements with SSIS Standards like Error Handling, Logging and working with Package config files.
• Experience in Interacting with Business Users to analyze the business process and transforming requirements into screens, performing ETL.
• Experience in generating on-demand and scheduled Reports for Business Analysis or Management Decisions using (SSRS).
• Created Ad-Hoc Reports as per client requirement and used Stored Procedures.
• Created weekly and Monthly Reports as per requirement using SSRS and Scheduled Reports to be delivered to User on-demand Basis or run on daily, weekly and monthly basis in SSRS report Manager.
• Worked on Power BI Desktop by extracting data from different sources, by writing queries according to business needs in query editor.
• Good experience on creating Power BI Dashboard from scratch and handling Workspaces, Apps and User Security in Power BI Service.
• Used Temporary Tables, Table variables and Common Table Expressions (CTE) for the better performance of the queries according to the requirement.
• Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Triggers

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, C, Java

Operating Systems: MS-DOS, Windows Server 2012/2008/2003/ XP, UNIX

RDBMS/ Databases / Database Tools: MS SQL Server 2014/2012/2008 R2/2005, MS Access, SQL Server Management Studio, SQL Server Data Tools, Business Intelligence Development Studio (BIDS), Visual Studio, SQL Profiler, Performance Monitor, DTS, Database

Data Warehouse Tools/Technologies: SSIS, SSRS, SSAS 2014/2012/2008 R2/2005

Data Modeling Tools: Power Designer, MS Visio, ERWIN

Reporting Tools: MS Reporting Server (SSRS), Excel Power View

Microsoft Technologies: SharePoint, VB.Net, ASP.NET, POWER BI

PROFESSIONAL EXPERIENCE:

Confidential, CINCINNATI, OH

Sr.ETL Developer

Responsibilities:

• Loading data from source (MYSQL) to destination using ssis.
• Wrote Stored Procedures to insert the data to the staging table using ssis from staging to production we moved through Stored Procedures.
• Created Triggers for the automatic event in the audit tables so that if any changes occur in the base table it automatically triggers in the audit table
• Worked on Incremental load to load the data from various sources to destination for the past 6 hour data to load in the target.
• Created packages by checking the destination tables if they are getting loaded or not into Datawarehouse.
• Deployed SSIS packages to SQL server agent for the automatic schedule of jobs.
• Created and Scheduled Jobs in SQL Server agent according to the business requirements.
• Created tables to pull the data from the Datawarehouse and load it to the destinations by applying different types of transformations.
• Documented the Data Lineage for the future for the business and to keep track of the packages and Jobs whether they are loading the data into the tables according to the scheduled job.
• Created Log tables to log the information of the package.
• Used Script task for the connection details of the database instead of writing it every time and it will notify if the records are updated correctly or not.

Environment: MySQL, SSMS (SQL Server Management studio), Microsoft Visual Studio 2017, Pervasive, SQL Server agent, Confluence, SVN, TFS.

Confidential, Charlotte, nc

ETL/BI Developer

Responsibilities:

• Loading data from source to target using SSIS which involves tasks, containers and transformations depends on requirement.
• Designed complex ETL strategies to pull data from different sources, like SQL server, and flat files and load it to the destination database using API files after using multiple transformations.
• Participated in agile and Retrospective ceremonies to discuss about the requirements.
• Creating batch files to run the packages to load the data and copying the files from local to server locations using Linux.
• Experienced in Configuring Batch Logging, Error Logging, event handlers and Connection Managers in SSIS
• Proficient in troubleshooting and fixing the QlikView and Qlik Sense dashboard issues
• Trained end users to develop and use QlikView and Qlik Sense applications.
• Strong knowledge in designing and developing QlikView and Qlik Sense dashboards by extracting data from different sources like Sales Force , SQL Server, Oracle, SAP , Flat Files, Excel files, XML Files.
• Created jobs and scheduled them using SQL server agent and involved in monitoring those jobs to make sure if they ran fine.
• Involved in working with Ops team and DBA’s in the time of deployment when working on Prod environments.
• Created SSRS reports using Pie-charts, bar graphs and tabular, matrix reports based on business requirements.
• Reports including Drill-down, drill-through using expressions to show the reports.
• Maintained the SSIS packages and SSRS reports using Git version control.
• Developed SQL queries using stored procedures, common table expressions (CTEs), temporary table to support SSRS reports
• Created database objects like Tables, DML, DDL, Views, Stored Procedures, Functions, Joins, and Indexes in T- SQL based upon the functional specifications
• Extensively worked on developing database objects like Stored Procedures, Views, Indexes, Triggers and Functions using T- SQL and performance tuning of SQL Queries.

Environment: SQL Server 2014, SQL Server Data Tools, Microsoft Visual Studio 2017, GIT, Oracle SQL developer 18c, Linux, Version One, SQL Server Agent, Tortoise, Power BI, MS Excel,Qlik Sense

Confidential, Cincinnati, OH

ETL / SQL BI Developer

Responsibilities:

• Involved in Technical discussions about business gathering requirements with Product Owner, Client Team.
• Analyzed Informatica Mapping and COBOL code which was the ETL framework for ODW to identify sources and transformations to re-build that in SQL server for the EDW.
• Developed the code in SQL Server using SSIS with different type of Transformations like Audit, Look-up, aggregate, Data conversion, Multi-cast.
• Participate in all phases of the SDLC to ensure and verify that the design meets defined business requirements
• Performed complex Data Analysis/Validation to ensure the accuracy and integrity of Data
• Responsible for understanding the complex SSIS packages and make understandable to the team
• Monitor for timely and accurate completion of Data Processes and scheduled Jobs
• Create batch files for automatic deployment of database objects and ETL packages while promoting to other environments.
• Responsible for understanding the complex SSIS packages and make understandable to the team
• Used SSIS tester automated tool to test packages, tasks and precedence constraints
• Create change requests using ServiceNow to promote newly developed database objects and ETL packages to production.
• Worked with Operations Team to create and schedule the jobs/workflows in UC4 to have the automated execution of the workflows
• Maintaining the SSIS packages In TFS for the version control.
• Collaborate with Database Administrator and Solutions Architect to determine strategy for Data warehouse design architecture and the backup/recovery of Databases and Data warehouse
• Performed Performance Optimization and Tuning on new and/or existing Data warehouse and/or ETL operations
• Worked with various versions in Tableau, Tableau Server, Tableau Public, Tableau Reader and Tableau Online
• Able to creatively stretch the capability of Tableau to customize and develop creatively stunning and dynamic visualizations
• Deep, technical knowledge of both Tableau Desktop and Tableau Server from an administrative and a consultative standpoint
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart
• Ensures adherence to Data Management/Data Governance Policies
• Create and maintain Documentation for existing architecture, and data lineage of the source and target.

Environment: SQL Server 2008, SQL Server 2012/2016, SQL Server Data Tools, Microsoft Visual Studio 2015, TFS, MS Office 2010, UC4, Service Now, JIRA, Informatica PowerCenter 8.6.1, Beyond compare, Excel SSMS, Tableau 9.0

Confidential, Dayton, OH

MSBI (SSIS & SSRS) Developer

Responsibilities:

• Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.
• Experienced in database design process and data modeling process.
• Analyzed the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.
• Designed SQL Server Database and Table Design with Schemas, Constraints and Views.
• Extracted data from various sources like Teradata, Facets, .CSV, Microsoft Excel and Text file from Client servers.
• Analyzed business requirements and implemented data mart solutions for data mining and reporting.
• Created SSIS packages which involved a variety of transformations such as Slowly Changing Dimension, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion before loading the data into Data Warehouse.
• Become a strategic partner for SiteMinder’s key groups and RDX partners, understanding their business and IT strategy
• Knowledge on RDX applications and ability to design, implement and enhance our systems.
• Transferred the files securely using FTP and exchange/share data.
• Created a report model on SSAS cubes.
• Designed the Data Model based on Star Schema and created the Tables and Indexes and developed the scripts to load the Datamart Tables.
• Identified the issues 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.
• Developed, Code Reviewed, fixed bugs, Tested and Deployed SSIS packages using SQL Server 2014 Business Intelligence Development Studio.
• Gathered Report Requirements and designed Reports, Matrix, Table Reports with Drilldowns, Map Reports, Dashboards, Gauge and Subscription reports.
• Also involved in migrating old SSRS reports to interactive dashboards in Power BI to deploy in Power BI service.
• Expert in creating Custom columns, Inserted Merged columns, filtering rows using Power BI.
• Used different kinds of visualizations like Line charts, Bar graphs, Scatter chart, Matrix table, Map, Card, Slicers.
• Also wrote DAX queries in power BI for performing calculations like Aggregations.
• Created detail reports using Drill through filters.
• Created Custom visualizations for business users to see their data in a way that best fits for their business.
• Strong knowledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.
• Ensured constraints and writing triggers/linked server scripts to apply the business rules. Performance Tuning, Backing Up & Restoring User Databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Deployed and Tested (UAT) Reports in Multiuser Environment.
• Part of the Agile/Scrum team and participated in Standup, grooming, planning and retrospective meetings.

Environment: T-SQL, MS SQL Server 2014, MS SQL Server Reporting Services 2015, MS SQL Server Integration Services 2015, SVN, TFS, Octopus, Power BI

Confidential, Pittsburgh, PA

Microsoft BI developer

Responsibilities:

• Actively participate in gathering of user requirement and system specification.
• Interacted with customers to analyze business needs. Provide software product design and - developed technical roadmap for the solution through the project lifecycle and beyond.
• Created different Parameterized Reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the number of records required
• Built SSRS project to generate reports with desired formats (Word, PDF, Excel, etc.) to present statistics information according to business requirements
• Created subscriptions to provide a daily basis Report.
• Involved in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports
• Migration of stored procedures and database objects between development and test environments
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Modified queries and stored procedures to improve the performance.

Environment: SQL Server 2005/2008/2010 , SQL Server Management Studio, Windows 2000/2003, SSIS & SSRS

Confidential

SQL Server Developer

Responsibilities:

• Developed, maintained and executed SQL queries and validated completeness, integrity, and accuracy of data.
• Designed, developed, and tested stored procedures, views and complex queries for the creation of Reports.
• Involved in Designing and developing ETL packages using Heterogonous Sources to Destination (SQL Server).
• Successfully created SSIS packages using Sequence Container, Data Flow, Execute SQL, Bulk Insert, Send Mail Task Etc.
• Used SQL Server Agent for job scheduling.
• Used advanced features of T-SQL in-order to design and tune T-SQL to interface with the database and other applications in the most efficient management.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, SQL Server Studio Management, Visual Studio, MS Excel, SQL Server Agent