SUMMARY

• Over 5+ years of Experience in Business Intelligence applications design, development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS) and Data Transformation Services (DTS) with a demonstrated history of working experience in the health care and ecommerce industry.
• Expertise in analyzing, designing, and developing Business Intelligence (BI) database applications using MS SQL Server 2014/2012/2008 , SQL Server Integration, Reporting & Analysis Services.
• Experienced in creating Databases Tables, Stored Procedure, DDL/DML, Triggers, Views, User defined data types, Cursors, Indexes, Derived Tables and Common Table Expressions (CTEs) using T - SQL programming to facilitate efficient data manipulation and data consistency.
• Extensive experience in Tuning SQL queries & improving the performance of the Database.
• Experience in creating standard and ad-hoc report using SSRS and proficiency in creating different types of reports such as, Drill Down reports, Drill through, Sub reports, Parameterized reports, Cascaded reports and Dashboard such as Graph, Chart, Gauge and Map.
• Expertise in Data Extraction, Transforming and Loading (ETL) between different Systems using SQL tools (SSIS, DTS, Bulk Insert, and BCP).
• Good knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Expertise in design and development of Power BI graphical and visualization reports as per business requirement documents (BRD).
• Experience in Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Experience in developing reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements. Expert on creating multiple kind ofPowerBIReports and Dashboards using SDK.
• Experience in managing reports by using SSRS tools such as report management, report delivery and report security. Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Experience in creating jobs, Alerts, SQL Mail Agent, Database Mails and Scheduled DTS and SSIS Packages.
• Extensive analytical and problem-solving skills in designing, developing, and implementing innovative business process and providing system solutions using new approaches, technology and training.
• Experienced in interacting with business users/ partners/ Stakeholder to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable.
• Proven Power BI development experience with desktop and pro versions, familiarity with Direct/Power Query functionality within Power BI.
• Experience developing and supporting Microsoft BI and reporting capabilities (Power Pivot, Power BI, data mapping, Power View, and SSRS) &implementing enterprise software solutions.

TECHNICAL SKILLS

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

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

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

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

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

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

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, JSON, JavaScript, PHP, jQuery.

PROFESSIONAL EXPERIENCE

SQL POWER BI DEVELOPER

Confidential, COLUMBUS, OH

Responsibilities:

• Played key role in gathering requirements for better understanding of business rules to successfully implement the project design.
• Involved in developing Tableau Dashboards using both relational and Multidimensional data.
• Developed SSIS packages to handle both manual and incremental loads with proper partitions and schema variations.
• Involved in designing, developing and testing ETL strategy to populate the data from various source systems feeds using SSIS.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to SQL data warehouse, data mart, and process SSAS cubes to store data to OLAP systems.
• Extensively worked on SQL queries performance tuning for existing store procedures and automated procedure execution call through SSIS package.
• Worked on different issues that arise out of file formats like ‘Excel’, ‘PDF’, ‘Xml', 'Json' and ‘HTML’.
• Successfully deployed SSIS packages with defined security and scheduled jobs on SQL Agent to run the ETL on nightly basis for more than a Terabyte of Data.
• Experienced in developing a dynamic SSIS packages as per the ad-hoc request. Created generic SSIS packages involving files with c# as scripting language.
• Worked on complex store procedures to get the underlying data of each report as per the filtering criteria of the users.
• Performed data validations for all source to destination extracts and resolved reported issues.
• Involved in development of Microsoft Power BI dashboards, dashboard templates and data mapping.
• Developed SSIS packages to handle both manual and incremental loads with proper partitions and schema variations.
• Defined aggregations required and granularity available and required in DW.
• Developed calculations in Tableau dashboards for KPI’s. Implemented the calculations to aggregate physical measures.
• Involved in maintaining Tableau server and monitor the performance of Dashboards.
• Resolved the issues of Tableau daily refresh extracts in Tableau server.
• Developed Aggregations, advanced aggregations and also usage-based aggregation in order to improve the query time performance.
• Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision makers for strategic planning.

SQL ETL DEVELOPER

Confidential, DES MOINES, IA

Responsibilities:

• Involved in development of maintenance procedures and provided data integrity strategies using ETLtools.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Designed rich dashboards with Power BI and referred user stories to create compelling dashboards to deliver actionable insights.
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Generated the weekly, monthly, and quarterly reports by using SSRS, MDS.
• Identified and worked with Parameters for parameterized reports in SSRS.
• Proficiency in creating Ad-hoc Reports, Drill-Down, Drill-Through, Cascaded, Matrix, Sub-reports, Pie Chart Reports and Tabular Reports for different business domains depending on the specifications and requests.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Created trace inSQL profiler and used database engine tuning advisor for performance tuning on stored procedures and Scripts.
• DevelopedSQL validation scripts on data staging tables and data warehouse tables to validate the data Loads.

SQL BI DEVELOPER

Confidential

Responsibilities:

• Worked as a developer in creating complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
• Involved in gathering business requirement from business users and prepared BI technical specifications.
• Experienced in installation, upgrade and configuration of Microsoft SQL Server and databases
• Developed, executed, documented, and maintained appropriate BI procedures.
• Collaborated with network operations, application developers and DBAs to enhance end user experience.
• Made changes to the existing Power BI Dashboard on a regular basis as per requests from Business.
• Published Power BI Desktop reports created in Report view to the Power BI service.
• Responsible for Scheduling jobs for weekly, daily data refresh on different Power BI reports.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Power BI.
• Responsible for managing BI environment, which includes Data Model, Data Sources, ETL tools, target Data warehouse, Data marts, OLAP analysis of data marts, data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modelling, Snow-Flake Modelling, fact, and dimensions tables using MS Analysis Services.
• Develop standardized reports using SQL Server Reporting Services (SSRS)
• Scheduling Jobs and Alerting using SQL Server Agent.
• Used Performance Monitor and SQL Profiler to optimize queries.

SOFTWARE DEVELOPER

Confidential

Responsibilities:

• Complete analysis, requirement gathering and function design document creation.
• Collaborated with the application developers in data modeling and E-R design of the systems.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements
• Used DDL and DML commands for writing triggers, stored procedures and data manipulation.
• Involved in tuning system stored procedures for better performance.
• Involved in the Data modeling, Physical and Logical Design of Database
• Designed and developed SSIS packages for day to day data transfer between transactional systems (OLTP) to Data Warehouse with all required transformations applied.
• Implemented auditing and error handling for all the developed SSIS packages and existing SSIS packages.
• Developed complex SQL queries and store procedures to perform data transformations as per mapping documentation.
• Worked on audit, conditional split, data conversion, derived column, multicast, row count, script component, aggregate, sort, lookup, merge, merge join, union, union all transformations in designing data flow task and as per the required data flow.
• Configured ExchangeServerfor sending automatic mails to the respective people when a job failed or succeed.
• Worked with the application developers and provide necessarySQLScripts usingSQL.
• Responsible for the management of the database performance, backup, replication, capacity and security.
• Actively involved in project design reviews for better understanding of load rules and source templates.