SUMMARY

• Overall 8 years of experience for implementing BI solutions in Healthcare, Banking, Health insurance and P&C industries using MSBI Stack (SSIS, SSAS, SSRS, Power BI).
• Involved in all phases of SDLC from requirement gatherings through post deployment of application systems in large and small organizations using Agile methodology.
• Proficient in creating packages as part of ETL - extract data from heterogenous sources like: Excel, Flat file, OLEDB source and loading to SQL Server databases using SSIS ( 2016/2014/2012/2008/2005 ).
• Experienced in using various SSIS control flow items like: execute SQL task, Data Flow task, Send Mail Task, File system task, Bulk Insert Task, For-each Loop and Sequence Container.
• Experienced in debugging SSIS packages using checkpoints, breakpoints and error handling by configuring send mail task using event handlers.
• Proficient in logging teh runtime information into different log providers like: SQL Server, Text File using SSIS Logging to increase teh performance of SSIS packages.
• Experienced in transforming teh data as per business needs using different transformations like: Conditional split, Merge join, derived column, data conversion, Fuzzy lookup in SSIS.
• Experienced in performing incremental load of data into DW using SCD, Lookup.
• Strong experience in writing complex T- SQL queries and creating database objects like: tables, views stored Procedures, and Triggers.
• Experienced in performance tuning of long running SQL queries using SQL server built in tools like: SQL Server profiler, Execution plan and also by creating indexes.
• Strong Experience in designing diverse reports like: tabular, matrix, parameterized, drill through, ad-hoc, linked reports, chart and sub reports both for operational and regulatory needs using SSRS (2008/2012/2014/2016 ).
• Well experienced in deploying teh reports, managing teh reports in report server by creating folders, permissions and delivering teh reports in various formats using subscriptions.
• Proficient in optimizing teh performance of various SSRS reports by modifying stored procedures, creating cache reports and snapshots in report server.
• Enhanced teh functionality in data ware housing concepts (OLAP) Cube by creating KPI, Actions, Perspective and Hierarchies usingSQLServerAnalysis Services (SSAS) and Dimensional Modelling Techniques such as Star and Snowflake schema.
• Expertise in defining teh DB schema as part of data modelling to define teh entities and relationships, generating SQL scripts using Erwin Tool.
• Hands on experience in working with query editor (Power BI) to extra data from heterogenous sources, perform data cleansing and shaping and load them to teh data model region.
• Proficient in report designing with different visualizations like: tree maps, bar graph, pie, line chart and deploying and creating dashboards with automated refresh of reports using Power BI Tool
• Strong experience in story narration for business users by creating worksheets in Tableau using various objects like: calculated fields, actions, filters, parameters, groups, sets and hierarchies.
• Ability to work in tight schedules and efficient in time management and highly motivated team player with teh intensity of delivering high quality outputs within teh deadline.

TECHNICAL SKILLS

• MS SQL Server 2016/2014/2012/2008/2005
• MySQL
• Oracle 11g/10g
• SQL Server Management Studio(SSMS)
• SQL Server Integration Services(SSIS)
• SQL Server Reporting services (SSRS)
• SQL Server Analysis services(SSAS)
• MS office 2007/2010/2013 (MS Excel
• MS Visio)
• T-SQL
• MDX
• DAX
• PL/SQL
• C
• C++
• Java
• SQL Server BI Development studio (BIDS)
• C#
• .Net
• MS Visual Studio
• VB Scripts
• SQL Profiler
• Power BI
• Tableau
• MS Windows
• TFS
• Erwin
• GitHub
• TortoiseSVN
• MS Office Share Point Server.

PROFESSIONAL EXPERIENCE

Confidential, Richardson,TX

Sr. SQL/BI Developer (SSIS/SSRS/SSAS/Power BI)

Responsibilities:

• Responsible for requirement gathering, data modeling, designs and development, testing, and managing teh relationship between teh client and teh development team.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded teh data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS) 2016.
• Worked with data scrubbing and validation using SSIS transformations like: data conversion, derived column, split, merge join, multicast and fuzzy group.
• Implemented Power BI Power Query to extract data from external sources and modify teh data to generate teh reports
• While creating SSIS packages used various control flow elements like: execute SQL task, send mail task, for each container and used precedence constraints to define teh order of execution, created variables to store teh result set and later referenced by other SSIS components.
• Good working experience in Azure Logic apps, Service Bus, Document DB and SQL Database, Data warehouse.
• Responsible for creating environment variables and Project parameters to set up different environments and able to execute SSIS packages in different environments (Dev/Test/Production).
• Involved in troubleshooting teh SSIS packages by using SSIS logging to capture different events like: On pre/ post execute, On error during teh package execution.
• Responsible for Giving 24/7 production support on Call to handle issues on production environment.
• Utilized Power Query in Power BI to Pivot and Un-pivot teh data model for data cleansing and data massaging
• Developed periodic reports for teh statistical analysis of teh policy data using SSRS 2016 and involved in generating Chart reports, drill down reports, sub reports and cascading reports.
• Developed cache reports and snapshots, report parameters as part of improving performance of SSRS reports.
• Extensively used Triggers to implement business logic and for auditing changes to critical tables in teh database.
• Written Complex queries for creating database objects like: Stored procedures, Views, tables and Triggers using T-SQL.
• Proven Power BI development experience with desktop and pro versions. Familiarity with Direct Query functionality within Power BI
• Administered databases including backups/restores, performance monitoring, disk usage, and report gathering using T-SQL.
• Created custom C# and VB Scripts to rename teh files, to read data from teh file and to archive teh files.
• Published Power BI Desktop reports created in Report view to teh Power BI service & Report Server
• Involved in dimensional modelling by defining star and snowflake schema and responsible for creating SSAS cubes using existing fact and dimension tables for BI reports.
• Developed custom calculated columns and measures using DAX in Power BI to satisfy business user requirements.
• Ability to create scripts using Azure PowerShell during for automation and build process.
• Created TEMPeffective reports using visualizations such as Bar chart, Waterfall Chart, Pie Chart, and Tree map along with slicers and designed high interactive dashboards for business users.
• UtilizedPowerBIgateway services to keep dashboards and reports up to-date by automatic refreshing of data from on premise data sources.
• Performed data cleansing and shaping before loading data to data model region by using query editor in Power BI.

Environment: T-SQL, MS SQL Server 2016, SSIS, SSAS, SSRS, Report Builder TFS, Power BI, Erwin v8.0, Excel, MS Access,Azure,Oracle 11g/10g, Visual Studio, SQL Profiler, C#, Tortoise SVN.

Confidential, Houston,TX

Sr. SQL Server / Power BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Involved in working with Project Manager, business users to gather requirements and translate them into technical documents to facilitate BI reports and analytics.
• Responsible in creating teh SSIS packages for extracting teh data from heterogenous sources (Excel, Flat file, SQL server) and load them into multiple databases (Staging area, SQL Server, data warehouse) as a part of ETL process using ETL mapping document.
• Experience in publishing Power BI Desktop reports created in Report view to teh Power BI service & Report Server
• Applied several transformations like lookup, audit, derived column, data conversion, conditional split to perform data cleansing, data validation before loading data to Datawarehouse.
• Worked with various control flow and data flow elements like: execute SQL task, containers, file system Task, slowly changing dimension, fuzzy lookup, import/export column in SSIS 2014.
• In teh process of extracting and loading teh policy to data warehouse, implemented checkpoints, breakpoints and event handlers as teh part of debugging.
• Performed time series analysis using DAX expressions in Power BI.
• Designed dashboards utilizing Power BI with rich visuals such as charts, slicers, gauges, funnel, word cloud.
• Experienced in working with SCD transformation (Type-0/1/2) of SSIS for updating slowly changing dimensions in a data ware house to capture teh history of data.
• Responsible for Developing Dimensions, DSV’s (Data Source Views) and Multi-Dimensional Cubes, Perspectives and deploying them to production Environments for Processing.
• Worked with Excel add-in’s (Power Pivot, Power Query, Power View) to perform data analysis by integrating large volume of data from various sources (MS SQL, MS analysis services).
• Using T-SQL created database objects like: Tables, views, indexes and stored procedures for storing and as well as referencing teh data in database.
• Examined and troubleshoot report issues within SSRS and Power BI.
• Involved in solving real time issues with index fragmentation, DBCC checks, Query Tuning, Error and Event Handling.
• Secured teh reports using role based security in Power BI.
• Designed Business reports using SQL Server Reporting Services (SSRS) 2014 like: Tabular, Parameterized, chart reports and delivered them in different formats (Excel, Word, Pdf).
• Deployed SSRS reports to teh report manager and created linked reports, ad-hoc reports based on sudden requirement.
• Involved in creating different level of filters (report level, page level) on multiple reports and slicers for appropriate end user interaction using Power BI.
• Responsible for creating calculated columns and measures and applied transformations in edit Query section inPowerBI to clean teh data.

Environment: T-SQL, MS SQL Server 2014/2012, SQL Server Management Studio(SSMS), MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), SSAS, Excel, Power BI, SQL Server Profiler.

Confidential, Boston,MA

ETL/ Report Developer (SSIS/SSRS)

Responsibilities:

• Involved in data migration from different sources like: Flat file, excel, OLE DB to SQL server databases using SQL Server Integration Services (SSIS) 2012.
• Managed teh metadata associated with teh ETL processes used to populate teh data warehouse using SSIS packages, extensively worked on mappings, incremental data loading, and SSIS transformations.
• Used various SSIS transformations such as Conditional Split, Derived Column, data conversion, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading teh data into Datawarehouse.
• Worked on package configurations, logging, scheduling, error handling and variables while creating teh different packages.
• Scheduling SQL Server jobs on SSIS Packages along with data alerts to automate teh execution of teh packages at a particular time depending on requirements.
• Hands on Experience in Designing Multi-Dimensional Cubes with Star Schema using Fact and dimension tables in SQL server Analytical Services.
• Created Query Parameters and Report Parameters to control data returned by teh query and filter data at report level in SSRS.
• Scheduled teh SSRS reports to run on daily/weekly/monthly basis and email teh refreshed results to teh users in teh required format.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drilldown Reports and Charts usingSQL Server Reporting Services (SSRS) for business users.
• Involved in developing logical and physical data models and wrotecomplex SQLcode to access and manipulate data stored in relational databases.
• Optimized teh performance of queries by making some modifications to teh existing T-SQLqueries using execution plan and as well as creating clustered and non-clustered indexes.
• Responsible for creating database objects stored procedures, views, indexes, cursors using T-SQL.
• Enhanced teh old logical and physical database design to fit new business requirement, and implemented new design into SQL Server using ERWIN tool
• Involved in Normalization teh data by converting to 2NF,3NF by maintaining database integrity and eliminating data redundancy.

Environment: MS SQL Server 2012, SQL Server Integration services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis services(SSAS), T-SQL, Erwin 4.0, VB, Visual Studio, Ms Access, Windows.

Confidential, Louisville, Kentucky

SQL BI Developer (SSIS/SSRS/Tableau)

Responsibilities:

• Actively Involved in gathering and analyzing business requirements, work with technology team to recommend and implement best approaches to deliver business solutions.
• Responsible for designing SSIS Packages to validate, extract data from various data sources like flat files, Excel spread sheets and OLTP Databases into SQL Server 2012.
• Used Various Control flow tasks element’s like Execute SQL task, XML task, Bulk insert task, Profiling task and Containers etc., while designing SSIS packages.
• Used teh BCP to load teh large volumes of data from files into database tables.
• Extremely used complicated Data Flow Transformations like Lookup, Conditional Split, Derived Column, Merge, Merge Join, Multi cast, Data Conversion and Union all etc.
• Responsible for using Data profiling task of SSIS 2012, to identify data related issues(quality) in teh data source before loading into teh staging area.
• In SSIS, created variables to store teh result set, dynamic values and later referenced by other SSIS components using connection string.
• Designed pie chart reports, bar graph reports, and matrix reports using SSRS and formatted teh reports as per teh business requirement.
• Implemented action filters, parameters, calculated fields, sets, groups, data blending and hierarchies for preparing dashboards by using different visualizations in Tableau.
• Involved in creating Tableauscorecards, reports using Bar graphs, Pie charts, lines, Tree Maps, Histograms and Gantt charts using show me functionality.
• Responsible for Scheduling data refresh onTableauServer for weekly and monthly increments based on business change to ensure that teh views and dashboards were displaying teh changed data accurately.
• Involved in dealing with teh performance tuning by creating indexes on selective columns to speed up query processing and analysis in SQL Server Management Studio.
• Worked with RDBMS concepts for creating database objects such as tables, triggers, stored procedures and indexes using T-SQL.

Environment: MS SQL Server 2012/2008R2, MS SQL Server Management Studio (SSMS), MS SQL Server Analysis Services(SSAS), MS SQL Server Integration Services, MS SQL Server Reporting Services (SSRS), C#, ADO.NET, SQL Profiler, Query Analyzer, Excel, Tableau, MS Visio.

Confidential

SSIS/BI Developer (SSRS/SSAS)

Responsibilities:

• Created SSIS packages to integrate data from excel, flat file and SQL server and transformed as per business requirement and loaded data into SQL server, Flat files.
• Involved with team lead and business users to build ETL design specifications by understanding, gathering and documenting project requirements.
• Worked with various control flow and data flow elements like: execute SQL task, containers, file system Task, slowly changing dimension, fuzzy lookup, and import/export column.
• Written testcases as part of unit testing, to check teh functionality of each package before moving to teh testing environment.
• Involved in creating data alerts by using SQL server agent to check for any errors during teh package execution.
• Worked with sequence container to group teh related tasks and applied checkpoints on each container as part of error handling.
• According to Business requirement, created ad-hoc reports, bar graph, drill down reports and parameterized reports using SQL server Reporting Services(SSRS) 2008R2.
• Worked on querying data into datasets and creating on-demand reports using Report Builder in SSRS reports and send teh reports via email.
• Responsible for designing and delivering teh reports to end users in various formats like: Excel, Pdf, Csv.
• Involved in creating and configuring data source, data source views, OLAP cubes from facts and dimension tables for teh analysis of data from different locations and process teh data using SSAS 2008R2.
• Involved in Agile methodology, as a part of sprint meeting and scrum calls responsible for managing daily tasks, holding meetings and to resolve conflicts.
• Developed database objects like: tables, stored procedures, functions, triggers, views and built relationships for tables using primary key and foreign key.
• Responsible for using SQL Server profiler, Database tuning advisor to enhance teh performance of Stored procedures as well as to optimize slow running queries.

Environment: MS SQL Server 2008/2008R2, SSIS, SSRS, SSAS, BIDS, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS Excel, MS Access

Confidential

SQL BI Developer

Responsibilities:

• Involved in Installation and configuration of SQL Server 2008 and Migration of databases from SQL Server 2005 to SQL Server 2008.
• Experienced in using execute process task, execute SQL task, send mail task and Files system tasks in SSIS.
• Responsible in creating and deploying SSIS packages from OLTP and various sources to stage into data warehouse in order to perform merge join, aggregate, derived columns, fuzzy lookup and OLE DB command transformations.
• Inorder to record teh rows and error messages from package worked with data viewers, breakpoints in data flow tasks as part of debugging SSIS packages.
• Developed complex stored procedures and views to design various customized reports like: parameterized reports, linked reports, Drill-through reports and automated reports like: Tabular, Matrix using SSRS.
• Created a sustainable reporting practice and means of storing and sharing/ publishing teh information and reports using subscriptions in Report Server.
• Responsible for writing complex expressions as part of conditional formatting in SSRS.
• Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic
• Increased performance of long running T-SQL queries by tuning (Optimizing Indexes) using SQL Profiler.
• Responsible for performing PIVOT operations on tables to transpose teh columns and rows for getting view of data.
• Involved in Joining teh data from multiple tables using joins to develop SSRS reports based on embedded datasets.
• Involved in Reviewing requirements and defining data models using E-R diagrams with teh halp of MS Visio in conjunction with teh application development team.

Environment: SQL Server 2008/2005, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio, Tortoise SVN, MS Visio.