PROFILE SUMMARY:

• Around 5+ years of Extensive experience in the Architecture, Design, Development, Implementation and Support of complex Data engineering solutions for building Enterprise Data warehouses, Data Marts and Business Intelligence needs.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Architecture, Analysis, Design, Development and Implementation.
• Experience in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
• Hands on experience in Logical and Physical Database design & development, ORDBMS Concepts, Normalization and Data modeling using Erwin data model in relational databases such as SQL Server 2012/2014/2017 .
• Extensive experience in leading Business Intelligence/ ETL implementations using MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS).
• Proficient in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing in SQL Server 2012/ 2014/2017.
• Expert in Design and optimization of OLTP, OLAP tools and OLAP Cubes.
• Led design, development, implementation of reports, and also development and management of the BI reporting environment.
• Involved in ongoing support, design, and development of airline-based data warehouse, data marts and online OLAP analytical applications.
• Have extensive experience in building BI Products and Solution frameworks through Meta Data driven approaches.
• Developed U-SQL scripts for processing massive amounts of data in a very familiar environment which is mainly used for AZURE DATA LAKE ANALYTICS.
• Hands on experience on writing T-SQL Procedures, Functions, Views and Indexes.
• Hands on experience in writing MDX queries to work with cube data.
• Defined the custom data reader to read the data from flat files (Character data sets, delimited files, fixed text length) into Data Profiler and Data Cleanser.
• Strong Expertise in importing the Legacy Data Structures into Relational Data Structures and data mapping in the Relational database.
• Experienced in Developing, Deploying, Scheduling and Monitoring SQL workflows/sessions for ETL Purposes.
• Strong experience in handling Master Data (MDM), strong focus on the customer data.
• Very good Project management experience encompassing very aspects required for building Data & Information systems such as - Requirements gathering & Analysis, Stakeholder Analysis, Feasibility study, Effort and Cost Estimations, Project Planning, Risk
• Server/Database Migration or Upgrades - Migration of SQL 2012 databases to SQL 2014.
• Performance tuning of DTS/SSIS packages.
• Performance Tuning - Memory, CPU, I/O, Application, Hardware configuration (Different RAID levels) etc.
• Troubleshooting the long running queries and stored procedures to increase the performance by adding the index or by changing the query logic on need basis.
• Created SSIS jobs, which run on daily, weekly and monthly basis to update fields in reporting files.
• Identified and made recommendations for the appropriated data sources for the best solution to extract the data for the project being worked on.
• Proficient in handling parameterized reports in SSRS 2014.
• Experience in integrating the SSRS reports into web applications using Report viewer control.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Experience with optimizing cube using partitions and aggregations.
• Worked in Data modeling, creating star and snowflake schemas in SSAS.
• Experience in Excel pivot services and exposure to source safe, version controlling etc.
• Worked on SQL BI solution integration with Microsoft share point server.
• Played the role of Team Lead and On-Site coordinator and managed offshore associates.
• Experienced in creating build environment setup using TeamCity to deploy Web and batch applications.
• Proven organizational, time management and multi-tasking skills and ability to work independently while being a good team player who enjoys delivering high quality work.
• Experience on leading, mentoring teams and strictly adhering to SDLC/Agile processes.

TECHNICAL SKILLS:

Operating System: MS Windows 7,8,10, MS Windows Server 2012, UNIX, Linux

Languages: SQL, PL/SQL, T-SQL, C#, Visual Basic, C, C++

Database: Microsoft, Oracle, Teradata

Application Servers: Microsoft SQL Server 2012/2014/2017, Oracle 9G/10G/11G/12C/18C

Tools: SQL Server Integration Sevice (SSIS), Markit EDM, SQL Server Reporting Service, (SSRS), SQL Server Analytic Service (SSAS), Toad, IBM Datastage, Tableau, PowerBI, Crystal Reports

Scheduling Tools: Windows Scheduler, MS SQL Agent

Data Modeling Tools: Toad Data Modeler and SQL Developer Data Modeler.

Project/Process Management: Bugzilla, Ms Visual Source Safe, Tortoise SVN, TFS, Clear Case, and Clear

Quest Internet Tools: IIS, FTP, TCP/IP, SFTP, WinSCP

Testing Tools: HP ALM, QTP, Win Runner, Test Director

Portal: SharePoint Portal Server, Windows SharePoint Services

WORK EXPERIENCE:

Confidential, Boston, MA

SQL BI / Power BI Developer

Responsibilities:

• Involved in modifying the SSIS packages and optimizing the package to fetch better performance and results.
• Responsible for modifying the SSIS package based on the new requirement of customer.
• Responsible for creating the package configuration and loggings for better handling.
• SSIS- re-write the package to reduce the redundant SSIS package doing same task.
• Reduced the manual effort by the run team on a daily basis.
• Prepared a complete flow of the application, suggested and successfully implemented the changes
• Scheduling the application and other automation for sending reports and emails.
• Performance tuning of DTS/SSIS packages.
• Developed dashboards and ad-hoc reports using MS Power BI and SSRS for senior management team for analysis.
• Responsible for complete maintenance and delivery of scheduled releases.
• Performance Tuning - Memory, CPU, I/O, Application, Hardware configuration (Different RAID levels) etc.
• Troubleshooting the long running queries and stored procedures to increase the performance by adding the index or by changing the query logic on need basis.
• Analyzing the executing plan of SQL Server queries or stored procedures.
• Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Development and testing of new packages to ensure the data were extracted from database and presented for the project requirements and data validation.
• Created SSIS jobs, which run on daily, weekly and monthly basis to update fields in reporting files.
• Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Migrated existing Qlikview reports to POWER BI reports.
• Transformed and combined the data using Query Editor in the Power BI.
• Experience with optimizing cube using partitions and aggregations.
• Worked in Data modeling, creating star and snowflake schemas in SSAS.
• Developed User Interactive Sheets & Reports as per business needs in SSRS.
• Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports, Cascading Parameterized reports, sub-reports and linked reports using SSRS 2017 and integrated into the front end.
• Integrated the SSRS reports into web applications using Report viewer control.
• Integrate Salesforce with SQL Server 2017 and create Salesforce Pages using Apex.
• Salesforce Administration and Declarative changes, Triggers.

Environment: Microsoft SQL Server 2017, SQL Server Integration Services (SSIS), SSRS 2017, Power BI, Oracle 18c

Confidential, Exton, PA

SQL BI / Power BI Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Proficient in usage of SSIS Control Flow items (For Loop, executes package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Hands on experience working with SSIS for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Worked with a set of stakeholders to identify the data required to operate an area of the business. Define what it means to have complete and accurate data.
• Served as the internal expert for data definitions, data quality, and data lineage for your business unit.
• Used SSIS Component Data Profiling task to generate other types of reports (such as a Column Null Ratio report or a Column Pattern report.
• Used Data Profiling task in SSIS to validate data.
• Written TSQL Scripts for doing Data Analysis like to check Quality of Data, Integration validation issues, good experience in utilizing all TSQL windows Analytics functions.
• Applied Data profiling techniques to derive Candidate Key Profile, Column Length Distribution Profile, Column Null Ratio Profile, Column Pattern Profile, Column Statistics Profile, Etc.
• Worked on On-Premises Gateway to refresh the data sources/creating a live connection with Tabular SSAS.
• Implemented Role Based Security as part of security in Power Bi.
• Used Power BI Power Pivot to develop data analysis prototype, for advanced visualize reports.
• Created designs and process flow on to how standardize Power BI Dashboards to meet the requirements of the business.
• Designed and developed Power BI dashboards, Reports and published it on Power BI sites.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Wrote calculated columns, Measures query's in power bi desktop to show good data analysis techniques
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging
• Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure etc.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Modify the existing Claims Summary Report by removing two calculated measure from Claims Tabular Model.
• Create a new Audit Tracking column in claims Report by adding one new calculated measure from Claims Tabular Model.
• Mastered creating the OLAP cubes using various dimensions and creating SSAS projects.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Developed U-SQL scripts for processing massive amounts of data in a very familiar environment which is mainly used for AZURE DATA.
• Worked on creating Azure Data Factory for moving and transforming the data.
• Assisted with implementation/upgrade of AutoSys and JAWS, troubleshoot errors, and documentation/procedures.

Environment: MS SQL Server 2014/2016, TSQL, Tableau 10 Desktop, Tableau server Pl/SQL, Power BI, ASP.Net, Informatica, Power Center 9.6/10.0, Visual Studio 2017, Oracle 11g, SharePoint 2007/2010, SSAS, SSRS, SSIS, Informatica, Auto Sys Scheduler.

Confidential, Philadelphia, PA

SQLBI/ Power BI Data Analyst

Responsibilities:

• Subject Matter Expert (SME) for Power BI and worked on Microsoft Business Intelligence stack.
• Design the Data Model for the current solution to make it centralized for the other line of businesses.
• Created Power BI reports as Proof-of-concept (POC) for End users.
• Migrated Excel reports and Pyramid analytics reports to Power BI.
• Developed and maintained multiple Power BI dashboards/reports.
• Created Datasets using different data sources like Microsoft SQL Server, Microsoft Azure and Excel.
• Created Workspace and Apps in Power BI and giving access to end users to Apps.
• Configured Gateways in the Power BI service.
• Implemented Data security (Row level security) on Dataset and Reports in Power BI.
• Responsible for Scheduling jobs for weekly, daily data refresh on different Power BI reports.
• Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models.
• Designed a Power BI Data Model with multiple Fact Tables and Dimensions depending on the business requirements.
• Created Calculated Columns and Measures in Power BI depending on the requirement using DAX queries.
• Created complicated DAX measures in the Power BI reports as per the requirements of the Business Users.
• Generated Monthly, Yearly, Quarterly and Daily reports in Power BI.
• Worked on Power BI, Power Pivot and Power View to visualize reports.
• Understanding the existing data and create the required data models for the development.
• Created Databases, Data Mart Tables, Views, Stored Procedures, Triggers, Cluster/Non-Cluster Index, Unique/Check Constraints.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Designed SSIS packages to transfer the data from flat files, Access database and excel documents to the Staging Area in SQL Server 2016.
• Developed VB.NET and C# application to load data from multiple excel files.
• Developed master ETL packages for loading and migrating historical data from Legacy system into D/W.
• Using SQL Server Integration Services (SSIS) as an ETL Tool, the data has Extracted, Transformed and Loaded (ETL) from Excel and Flat file to MS SQL Server.
• Developed SSIS packages using looping, data formatting, check points, error handling, email notification etc.
• Create and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic.
• Developed complex reports with multiple datasets and sources in SSRS.
• Optimized SSRS reports with snapshots, caches, execution log views, embedded queries and stored procedures.
• Involved in Data scrubbing/Cleansing/validating/Translating, and scheduling SSIS packages.

Environment: MS SQL Server 2012, Visual Studio 2012, SSIS, SSRS, Power BI, SAP HANA, JIRA, Skype for Business, Agile Scrum, Web Services, T-SQL, MS Excel

Confidential

BI Data Analyst / Officer- IT/Systems

Responsibilities:

• Worked in all aspects of SDLC such as requirement analysis, design, development, testing, implementation, deployment & maintenance.
• Involved in modifying the SSIS components based on requirement.
• CADIS/SSIS Package creation, management and scheduling SSIS package and Cadis package.
• Responsible for creating the best practices to be followed in Logging and Configuring the SSIS package.
• Performance tuning of existing stored procedures.
• Used TeamCity tool for building various solutions developed.
• Creating and scheduling of MARKIT EDM ETL package.
• Create Data Porter, Data Inspector, Data Matcher and Data Constructor for Back office data management.
• Played the role of Team Lead and On-Site coordinator and managed offshore associates.
• Helped team to create, modify and optimize SQL queries and stored procedures.
• Prepared the High and Low Level Process Flow design for ETL process using MS Visio.
• Review of T-SQLs, SQL Server Execution Plans and SSIS Optimizations
• Guided the Development teams on using SSIS Components - Data Flow tasks, FTP, Merge, SCD, Script components etc.
• Involved in writing T-SQL queries, Stored Procedures and designing SQL Server Integration Packages.
• Designed Metadata Strategy, Data lineage, Data Quality and Profiling.
• Developed the strategies and alternatives for the Data issue resolution and the software required to perform Data Analysis Services.
• Configured Sql Server Reporting Services in SharePoint Server mode as well as Native mode
• Created different kinds of reports using SSRS (2012/2014) like Tabular, Matrix, Chart, Parameterized Reports, Sub reports and Drilldown Reports.
• Configured Sql Server Reporting Services in SharePoint Server mode as well as Native mode.
• Created Report Models and Adhoc Reporting using Report Builder 2.0
• Involved in training the end users in creating reports using Report Builder 2.0.
• Managed and Scheduled the SSRS Reports.
• Involved in Project Management activities reporting Risks and Mitigations, and Daily, Weekly & Bi-Weekly Status Reporting to respective Stakeholders

Environment: TSQL, Microsoft SQL Server 2012, SQL Server Integration Services (SSIS), MARKIT EDM, SQL Server Reporting Service (SSRS), MS Visio, SharePoint, Oracle 11g/12c

Confidential

Data Analyst

Responsibilities:

• Execute all assigned day-to-day activities related to bottler's confidential data support for deployments.
• Responsible for inbound customer interaction data verification and validation using established ETL (Extract, Transform, Load) data warehousing procedures and processing.
• Performed various specialized, critical administrative function for multiple technical departments.
• Perform detailed data mining, analysis and functional interpretation of Confidential Patient Data.
• Developed Microsoft Power BI audit reports to view and perform different analyses on different metrics.
• Assisted in the development of clinical reports and presentations
• Developed complex SQL queries, and perform execution validation for remediation and Analysis.
• Developed database triggers, cursors, procedures/functions and packages using PL/ SQL according to business requirement.
• Extensively worked on data mapping, validation, SQL loader and Bulk processing for loading data into Microsoft SQL database.
• Involved in SQL query tuning. Used Explain Plan, creation of new indexes to improve the performance of SQL statements
• Analyze day to day transactions and reporting to regulatory.
• Involved in developing scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
• Modified and optimized complex queries for data retrieval and modification
• Involved in the restructuring and fine tuning of the existing SQL Queries according to the new requirement.
• Monitor the scheduled jobs.
• Participate in the discussions in requirement and gathering.
• Coordinating with Client Team and business users for managing change during the UAT and the post implementation phase.
• Analyze the business requests and identify the impact components to be changed
• Implement several activities like action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented.
• Work efficiently to meet targets and developing a level of competency which helps to anticipate issues and solve them in advance

Environment: Microsoft SQL Server, Oracle 12C/11g, MS-Excel, Microsoft Power BI, SSRS, SSIS, Microsoft Visual Studio. Tableau.