SUMMARY:

• Over 9+years of Experience in Microsoft SQL server and Business Intelligence Development (SSRS, SSIS, SSAS, SQL and Power BI ).
• Expertise experience in design, development and implementation of BI Solutions (ETL & Reporting & Analysis services) using SSIS, SSRS, SSAS, Microsoft SQL Server 2012/ 2008 R2/ 2008/2005, T - SQL, MDX, Power View, Power Pivot, Tableau.
• Analyze the source map documents and creating packages to move the data from source to destination.
• Creation of work flows with Data flow Task, Script Task, Execute Sql Task and Containers.
• Used Transformations like Derived Column, Conditional Split, Aggregates, Sort, Data Conversion, Merge join and Union all. Did error handling while moving the data.
• Implemented Performance Tuning at various levels.
• Created Configurations, Checkpoints and Breakpoints in packages for better reusability.
• Experience in Creating jobs and Scheduling SSIS Packages.
• Extensive Knowledge on creating Dashboards by using Reports and KPI’s.
• Created simple and complex reports by customizing look and feel by using various report models and pass the parameters according to business user’s request.
• As per requirements developed the reports in the form of Table, Matrix and Chart using SQL Server Reporting Services.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert
• Extensive experience on system analysis, design, development, testing and implementation of projects in Software Development Life Cycle (SDLC)
• Having knowledge in creating cubes and modifying measures and attributes, creating hierarchies and relationships in dimensions.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects
• Excellent T- SQL programming skills in writing complex queries to create and update database objects.
• Extensive knowledge in writing MDX query.
• Having good experience in Indexes, Joins, Views, Stored procedures, Functions, Constraints.
• Experience in creating PowerPivot data models and integrate them with SharePoint and automate refresh.
• Knowledge in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Robust MS Access and Excel skills with PowerPivot, PivotTable, Pivot Chart, Power View, VLookup functions and formulas.
• Experience in working with Agile and Sprint methodologies.
• Strong communication skills when working with stakeholders, developers, project managers, system implementers, and application end-users.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.

TECHNICAL SKILLS:

Relational Databases: SQL Server 2014/2012/2008 R 2/2008/2005/2000 , MS Access.

Tools: and Packages: SQL Server Management studio, SSIS, SSRS, SSAS, DTS, Microsoft Visual Source Safe, SQL Query Editor, MS-Office writer, Team Foundation Server(TFS),Office Writer

Languages: T-SQL, HTML, XML, SQL, C, VB.Net, ASP.Net

Operating Systems: Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS

Application Packages: MS Office, MS Outlook (Microsoft Office Suite)

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services(SSIS), SQL Server Analytical Services (SSAS), Power BI, Tableau

PROFESSIONAL EXPERIENCE:

Confidential, TX

SQL/SSIS/PowerBI Lead Developer

Responsibilities:

• Created dynamic and complex Power BI reports and dashboards as per the need.
• Independently handled the project and delivered the reports before SLA
• Designed SQL tables, views and stored procedures required for reporting.
• Extracted data from the source and loaded into tables using SSIS.
• Deployed the power BI reports to service, SharePoint and scheduled automatic data refresh.
• Implemented role level security and assigned the users as required this way we could restrict the data visibility.
• Created drill down and drill through report to go to details and child report within power bi based on hierarchy.
• Wrote complex DAX for calculated measures and columns.
• Used bookmarks feature which enables the ease to jump to respective report tabs with one click.
• Imported custom themes and page backgrounds for rich visual effects.
• Improved the performance of the reports by pushing most of the transformations within power BI to SQL.
• Created DAX measures to blank out visuals when no slicer is selected.
• Performed end to end testing on the reports and packages developed to ensure data quality is met.
• Actively participated in the weekly status meetings to get new requirements and talk on the status of current work in progress.

Environment: MS SQL Server 2012/2014, SSIS 2012/2014, Azure SQL server, Power BI, SharePoint.

Confidential, WI

SQL/SSIS/PowerBI Developer

Responsibilities:

• Created Power BI reports and dashboards as per the business requirement.
• Designed SQL tables and stored procedures required for reports and ETL needs.
• Actively involved in the monthly publishing cycle which involves creating tables and loading the data from multiple sources to SQL server destination using SSIS, refreshing the tabular models and creating the power pivot reports.
• Converted the existing Sap BO reports using SSIS packages to load the data into sql server.
• Created SQL jobs to schedule packages and stored procedures.
• Deployed the power BI reports to server and scheduled the automatic data refresh
• Modified the existing SQL views and created new views for various business needs
• Actively participated in the daily stand up meetings and bi weekly sprint planning sessions.

Environment: MS SQL Server 2012/2014, SSIS 2012/2014, SSAS, Power BI, DB2

Confidential, Phoenix, AZ

SQL/SSIS/SSRS/PowerBI Developer

Responsibilities:

• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created Tables, Stored procedures and defined functions. Modified SQL scripts for tuning and scheduling.
• Extensively used joins and common Table Expressions to simplify complex queries involving multiple tables
• Developed complex Stored Procedures and views to generate various Drill ­through reports, parameterized reports and linked reports using SSRS.
• Was responsible in redesigning existing ETL ‘s to SSIS packages
• Took end to end ownership of migrating the SSIS, SQL objects, DB roles, SSRS and Excel Reports from 2008 R2 to SQL 2014 .
• Expert in creating Power pivots, Power views and SSRS reports using Cubes (MDX) and SQL queries.
• Interactive data visualization products focused on business intelligence such as MICROSOFT Power BI.
• Developed confidential proprietary analytical tools and reports with Microsoft Excel, and Power Pivot, and Power Point.
• Experience with software development life cycle (SDLC), Agile, Scrum and Project Management Methodologies.
• Publishing Power BI reports from Power BI Desktop to Power BI service.
• Build Tabular, line charts, Graph charts visuals for Marketing KPI's metrics based on fields brought in and transform using Power Query functions and DAX calculated Measures.
• Generated reports utilizing SSRS and Excel with power pivots; deployed reports within SharePoint integrated mode.
• Created detailed dashboards utilizing Microsoft BI desktop to improve analysis and decision making with various sources Azure, Sql server, Excels.
• Managed reports/data sources, schedule report execution, and delivery.
• Managed team foundation server utilizing source control, check-in, and check-out.
• Captured the long running jobs and worked on fine tuning the store procedures and tables to improve the performance.

Environment: MS SQL Server 2008 R2/2014, SSIS 2008 R2/2012, SSRS 2008 R2/2012, Power BI, Redgate, Team Foundation Server

Confidential, Plano, TX

SQL /SSIS/SSAS/SSRS Developer

Responsibilities:

• Design and Build ETL (SSIS) to get data from different; with incremental loads
• Created reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description
• Developed a High-level dashboard using SSRS
• Designed and created Report templates, bar graphs and pie charts based on the financial data
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements
• Creating complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Optimized the performance of queries with modifications in T­SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Wrote stored procedures and User Defined scalar Functions (UDFs) to be used in the SSIS packages and S QL scripts .
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and super user reports using SSRS.
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies and defined Dimension Relationships.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, developing reports using MDX and SQL.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Build Tabular, line charts, Graph charts visuals for Marketing KPI's metrics based on fields brought in and transform using Power Query functions and DAX calculated Measures.
• Generated reports utilizing SSRS and Excel with power pivots; deployed reports within SharePoint integrated mode.
• Created detailed dashboards utilizing Tableau desktop to improve analysis and decision making.
• Created different P ower Pivot reports as per the client requirement.

Environment: MS SQL Server SSIS, SSAS, SSRS 2012, Power Pivot, Power BI, Tableau.

Confidential, Minneapolis, MN

SQL/SSIS/SSRS/Power Pivot Developer

Responsibilities:

• Responsible for designing database, creating tables, stored procedures, user defined functions and implementing joins, index using T-SQL.
• Responsible in monitoring and troubleshooting the production support and ensure that the SLA is met and no business impact.
• Responsible in creating power pivot reports as per the business requirement
• Designed dynamic SSIS Packages to transfer data crossing multiple platforms; validated data during transferring and archived data files for multiple DBMS.
• Designed SSIS packages to migrate the data from SQL Server to the staging area.
• Filtered bad data from the legacy system utilizing derived columns, lookups, fuzzy lookups, and conditional splits.
• Incorporated error redirection during ETL loads in SSIS Packages.
• Monitored and configured SSIS packages for dynamic execution; deployed packages to the testing environment.
• Generated various Drill-through Reports, Parameterized Reports, Matrix and Tabular Reports.
• Responsible for publishing and deploying the reports in Web Server and Report Server respectively.
• Optimizing the long running reports, packages and scripts.
• Responsible for deploying the objects (Scripts, packages, reports, web apps) into production environment on a weekly basis
• Monitoring the log shipping, mirroring and replication jobs.
• Responsible for handing over the support to US partners.
• Participated in Brown Bag session for Data visualization contest.
• Individually contributed in a SAVE project for automating a manual report and Saved $3930.24.
• Contributed in disk space clean up activity and saved 800 GB of SQL server space.

Environment: MS SQL Server 2008 R2, SSIS 2008 R2, SSRS 2008 R2, SharePoint.

Confidential, BatonRouge, LA.

SQL/SSIS/SSRS Developer

Responsibilities:

• Requirement gathering & analysis in Claims, Provider and Medical Management area while interacting with OSCs/Clients
• Responsible for review of the deliverable from offshore Claims, Provider and Medical Management area.
• Assist team to understand domain specific requirement in Claims, Provider and Medical Management area.
• Involved in Design and Development of SSIS Packages using various Control Flow and Data Flow items to Extract, Transform and Load the Data using SQL Server Integration Services (SSIS).
• Experienced in configuring with Error logging and Event handling to redirect error rows and fix the errors in SSIS Testing - unit testing & integration testing.
• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BULK INSERT etc and used configuration files and variables for production deployment.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2005) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types.
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Followed sprint methodology for the development activities with daily scrum calls and bi -weekly deployment schedule to ensure the everything was moving to production as per the timelines
• Scheduled reports to refresh and run on daily, weekly and monthly basis in the report manager.

Environment: MS SQL Server 2008 R2, SSIS 2008 R2, SSRS 2008 R2, Crystal Reports.

Confidential

SQL/SSAS/SSRS Developer

Responsibilities:

• Responsible for designing database, creating tables, stored procedures, user defined functions and implementing joins, index using T-SQL.
• Responsible in designing the database from OLTP to OLAP.
• Responsible in integrating the data from different sources through packages using SSIS, analyzing the data and creating cubes using SSAS.
• Responsible for designing reports using SSAS cube as a data source in SSRS.
• Generated various Drill-through Reports, Parameterized Reports, Matrix and Tabular Reports.
• Responsible for publishing and deploying the reports in Web Server and Report Server respectively.
• Involved in integrating the modules of the application.

Environment: MS SQL SERVER 2005, SSRS 2005, SSAS 2005.