SUMMARY

• performing IT Professional having around 8 years of experience as MSBI Developer. Strong expertise in the analysis, design and development of Microsoft Business Intelligence ETL Applications. Highly accomplished in developing SSIS, SSRS, Power BI, Tabular and SQL Server applications that provide integrated solutions to various applications across the enterprise based on the underlying principles of EAI. Highly motivated and team - oriented with excellent problem solving, communication, and interpersonal skills.

TECHNICAL SKILLS:

MS BI: SSIS, SSRS, SSAS, Tabular Model.

Databases: SQL SERVER, DB2, Oracle.

Programming Languages: C, SQL, TSQL, Visual Basic.

Reporting BI Tools: Power BI, SSRS, Tableau.

Tools: SQL Server Management Studio, Teradata SQL Assistant, Toad.

Web Technologies: HTML, XML.

Operating Systems: Windows, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

MS BI SSIS/SSRS/SQL Developer + Power BI Developer/ Designer.

Responsibilities:

• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) process strategy to populate the data from various sources using SSIS.
• Developed ETL SSIS packages to load business retail data from various sources into data marts using Data Flow Task, Execute SQL Task, Lookups, Fuzzy Lookups, Conditional Split, Derived Column and Execute Package Task.
• Extensive experience in migrating data from various sources such as Excel, DB2, SQL Server, OLE DB and flat files to different destinations using SSIS.
• Modified various SSIS packages according to business requirements and created appropriate SQL jobs to provide clients with Daily and Weekly flat files.
• Written complex SQL statements using joins, sub queries and correlated sub queries and CTE.
• Developed complex programs in T-SQL, wrote Stored Procedures, Triggers, Views and Queries with best execution plan.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing and data manipulation.
• Worked on Enterprise Reporting Lifecycle. Created Ad-hoc reports, Monthly and Weekly reports.
• Built SSIS packages that load data in to staging tables overnight for heavy reports so that the users don't experience long waits for generating reports.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Created tabular, matrix, chart, drill down reports, parametric, cascaded reports, dashboards and score cards reports(SSRS) according to business requirements. Optimized SQL statements for customer summary reports.
• Having Experience on Microsoft Power BI.
• Built and published customized interactive dashboards utilizing Power BI.
• Created the data model by pulling the data from multiple sources and transform the raw data into business information by applying the transform rules.
• Experienced in Developing power BI Reports and Dashboards from multiple data sources using Data Blending.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Created new measures and new calculated columns for reports and dashboard analysis.
• Created data visualizations using various visual objects (Line chart, Bar chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals).
• Used different types of visualization Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements.
• Published reports and dashboards to the Power BI service through the Office 365 integration.
• Implemented dashboards and scorecards with power pivot for executive management for data insights as per business requirements, shared the dashboards among multiple users in the group.
• Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
• Review changes, manage documentation and stakeholder presentations.
• Adhere to best practices and standards in application development.
• Manage checkpoint meetings, demos, and daily communications with the client.

Environment: MS SQL Server 2008/2012/2016 , MS SQL Server Integration Services (SSIS) 2008R2/2012/2016, MS SQL Server Reporting Services (SSRS) 2008R2/2012/2016,MS SQL Server Management Studio 2008R2/2012/2016, Microsoft Visual Studio, Microsoft Power BI, Flat files.

Confidential

MS BI SSIS/SSRS/SSAS/SQL Developer + Reporting Developer/ Designer.

Responsibilities:

• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) process strategy to populate the data from various sources using SSIS.
• Developed ETL SSIS packages to load business retail data and from various sources into data marts using Data Flow Task, Execute SQL Task, Lookups, Fuzzy Lookups, Conditional Split, Derived Column and Execute Package Task.
• Extensive experience in migrating data from various sources such as Excel, DB2, SQL Server, OLE DB and flat files to different destinations using SSIS.
• Modified various SSIS packages according to business requirements and created appropriate SQL jobs to provide clients with Daily and Weekly flat files.
• Written complex SQL statements using joins, sub queries and correlated sub queries and CTE.
• Developed complex programs in T-SQL, wrote Stored Procedures, Triggers, Views and Queries with best execution plan.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing and data manipulation.
• Worked on Enterprise Reporting Lifecycle. Created Ad-hoc reports, Monthly and Weekly reports.
• Built SSIS packages that load data in to staging tables overnight for heavy reports so that the users don't experience long waits for generating reports.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Created tabular, matrix, chart, drill down reports, parametric, cascaded reports, dashboards and score cards reports(SSRS) according to business requirements. Optimized SQL statements for customer summary reports.
• Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up & Cyclic Grouping), List, crosstab etc. using Tableau.
• Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web.
• Developed various data connections from data source to Tableau Desktop for report and dashboard development.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Responsible for the creation and the maintenance of Analysis Services objects such as cubes, dimensions and MDX queries.
• Used MDX queries for pre-calculated measures.
• Well-versed in using multi-dimensional expression (MDX) queries, mathematical formulas, and user-defined functions for developing Reports from Multi-Dimensional OLAP Cubes.
• Designed aggregations and pre-calculations in SSAS.
• Involved in designing Partitions in Cubes to improve performance using SSAS.
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Used SQL Profiler for troubleshooting, monitoring and optimization of SQL Server components.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Having Experience on Microsoft Power BI.
• Built and published customized interactive dashboards utilizing Power BI.
• Created the data model by pulling the data from multiple sources and transform the raw data into business information by applying the transform rules.
• Experienced in Developing power BI Reports and Dashboards from multiple data sources using Data Blending.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Created new measures and new calculated columns for reports and dashboard analysis.
• Created data visualizations using various visual objects (Line chart, Bar chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals).
• Used different types of visualization Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements.
• Published reports and dashboards to the Power BI service through the Office 365 integration.
• Implemented dashboards and scorecards with power pivot for executive management for data insights as per business requirements, shared the dashboards among multiple users in the group.
• Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
• Review changes, manage documentation and stakeholder presentations.
• Adhere to best practices and standards in application development.
• Manage checkpoint meetings, demos, and daily communications with the client.

Environment: MS SQL Server 2008/2012, MS SQL Server Integration Services (SSIS) 2008R2/2012, MS SQL Server Reporting Services (SSRS) 2008R2/2012,MS SQL Server Management Studio 2008R2/2012, Microsoft Visual Studio, SSAS, Tableau, Microsoft Power BI, Flat files and DB2.

Confidential

Designer/Developer

Responsibilities:

• Preparation of High level and Low level designs from the requirements.
• Prepared technical design, tests (Unit/System) and supported user acceptance testing.
• Testing the system at Unit, Integration and System Test level. Preparation of Test Result Documents of the tested cases at Unit and Integration.
• Development of SAS JCL's to subset Flat, GDG and VSAM files using the selected accounts to pare down the volume of data.
• Development of automated process to improve the efficiency and avoid manual efforts in the process.
• Worked on complex IMS database files, DB2 tables and transformed the data successfully as per the requirements.
• Worked on complex sanitization logics to mask customer data on lower environments.
• Developed SAS and Eztrieve codes for pare downing the production data into smaller volume so that it can fit in the test environments.
• Developed many JCLS to stream line the batch process of pare downing more than 10,000 files. Developed COBOL programs to sanitize data.
• Performed requirements and impact analysis on integration interfaces.
• Coded the integration interface, and performed internal code review and unit and system testing of components.
• Provided performance testing, deployment support, issues/defects tracking, and resolution.
• Conducted peer reviews and offshore liaising.

Confidential

Support/Enhancement

Responsibilities:

• Performed Requirement analysis for building and supporting DCPS Statements application.
• Developed various automated process to improve the efficiency and also to avoid manual efforts involved in the process.
• Provided efficient solutions for enhancing the application to speed up the processing of Customer Statement Generation.
• Designed new jobs as per the requirement from the Customer and involved in scheduling the jobs in CA-7, Involved in BAU activities like Report generation and statistics.
• Extended support to various testing teams on their day- to- day functions and helped in the resolution of issues they face in UAT and SIT testing environments.
• Involved in monitoring of jobs in the Unix box through HP Command Center and Putty, Generated project metrics reports, Production issues report for incident management and worked on customers queries and identified the root cause of the issue.
• Coordinating with Onshore and clients regarding requirement gathering for enhancement activities and updated the customer on a weekly basis about the status of the project.