SUMMARY

• Having 8+ years of experience in IT SDLC process and Data analytics and data visualization.
• Good experience in usingDAX queriesfor different custom metrics & dimension creation.
• Experience in usingPower Queries (M)for building/updating existing datasets.
• Strong experience in writingSql queriesfor data set creation, data validation & POCs for new datasets.
• Proficiency wif Microsoft Excel, including Power Query, Power Pivot, connections to external data sources, REST APIs, pivot tables, charts, and slicers.
• Have extensive hands - on experience in Power BI, including but not limited to data set ingestion and transformation.
• Create different metrices using DAX queries, Power Queries (M).
• Do report development using teh most appropriate report templates for a given data set, build dashboards dat bring together key performance and operational data for an enterprise.
• Assist in teh creation of a secure framework for how data, reports, and dashboards are managed.
• Participate in teh creation of technical and functional guidance documentation and provide presentations and training for technical staff and power users
• Developed and implemented advanced analytics including customer segmentation, optimization, prescriptive analytics and machine learning algorithm & recommendation for pricing strategy, proactive retention, and serialization. Operate as a SME on consumer analytics for operational data (Marketing, Finance and Risk).
• Worked on response-based analytics on NPS and transactional surveys to see teh drift in NPS when a customer falls in teh intersection. Made recommendations on how to remove teh responder bias, increase response rate and improve NPS using SAS.
• Analyzed customer surveys and provided insight on customer profile, customer interaction, loan characteristics, credit journey and their financial behavior to improve Net Promoter Score (NPS) and established customer segmentation using SAS to aid NPS strategy.
• Partnered wif credit risk, marketing, finance, and business optimization teams to create a data lake dat will be used as a single repository for all analytics and modeling.
• Supported step-change improvements in credit performance by connecting drivers of future consumer credit trends to historical behavior, creating risk models, and testing hypotheses using rigorous monitoring and analysis.
• Document data requirements. Illustrate how data domains relate to each other using tools like source-target mappings, process-flow diagrams, data-flow diagrams, Customer Journeys, Pain points and workflow diagrams.
• Help build targeted insights to inform teh design and development of new customer experiences, as well as breakthrough technology and concepts designed to deliver on new go to market strategies.
• Managed Development, Maintenance, System configuration and Production Support for Underwriting tools and Long-term disability claims. Teh responsibilities include accountability for application health, business communications, business process optimization, SLA/OLA adherence, system upgrades/implementations and Applications Life Cycle Management.
• Ensured adherence to technology and business roadmaps, ensuring proper Disaster Recovery solutions in place.
• Worked on Data Modeling, Database Design, Normalization, SQL Query optimizations, Stored Procedures, Triggers, Functions and Views.
• Developed and executed ad hoc queries to extract data from supported systems and follow established procedures to validate queries/results in support of business requirements.
• Implemented large-scale data ecosystem including data management, governance and teh integration of structured and unstructured data to generate insights.
• Experience designing complex dashboards dat take advantage of all Tableau functions, including data blending, actions, parameters, and more
• Strong hands-on experience on Tableau and/ or MSBI stack (SSRS & SSAS multidimensional and Tabular, SSIS) Power BI
• Experience in developing and delivering Tableau training to other report developers and users
• Strong belief in teh art of dashboarding and following best practices while designing dashboards
• Experience developing materials for and facilitating training on basic or advanced Tableau data visualization design principals
• Experience in designing and developing business Intelligence and data analytical solutions to delivering insights to business through data
• Tableau BI reporting experience using Tableau Desktop, Tableau Server, and Tableau Reader creating worksheets, Graphs, Charts and dashboards
• Experience wif Cloudera Impala and/or Hive, MYSQL and creating Tableau dashboards connecting to Hadoop
• Database development in MySQL using Workbench 6.2 client

TECHNICAL SKILLS

BI & Reporting Tools: Power BI, Cognos,Tableau, Alteryx, QlikView,ETL

AWS Cloud Technologies: VPC, EC2, Auto Scaling, ELB, Security, DB Server (MySQL), EBS, S3, Route 53, CloudWatch, Cloud Formation, CloudTrail, IAM, Redshift

Operating Systems: Windows /XP/ UNIX/, MacOS / iOS/ Android

Languages: COBOL. C++, C#, iOS App Development, Android App Development, Java,T-SQL

Databases: ORACLE, SQL Server, DB2

Web Technologies: JavaScript, HTML, CSS, DOM, JQuery, XML, JSON, Rich Internet Application, Web Servers and Databases, PHP, Server Side Scripting, HTTPS, Web Security, Web Services, Semantic Web

Data Modeling Tool: ERWIN 3.5.2/4.0/4.1, Microsoft Visio.

PROFESSIONAL EXPERIENCE

Confidential, LOUISVILLE, KY

Sr Power BI/MSBI Consultant

Responsibilities:

• Develop and maintain Microsoft Power BI reports, dashboards, and advanced visualizations to meet business data analytics needs.
• Worked closely wif teh deployment team, business analysts, clients etc. to understand teh needs / requirements / issues to develop and maintain reports and visualizations.
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Published Power BI Reports in teh required originations and Made Power BI Dashboards available in Web clients and Mobile apps.
• Scheduled Automatic refresh and scheduling refresh in power BI service.
• Developed analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions.
• Drive teh design and build of data visualizations and analytics.
• Deliver on key projects and Data Visualization strategies dat directly support key business drivers.
• Experience wif Data Visualization libraries/tools/toolkits like Tableau, Vislt, ParaView, Protoviz, d3, Highcharts, Processing, etc
• Experience on working wif Power BI and Snowflake in Direct Query mode.
• Worked on all types of transformations dat are available in Power BI query editor and created stored procedures and SQL queries to pull data into PowerPivot model.
• Work wif teh team to maintain a secure framework for how data, reports, and dashboards are managed through adherence to standards and security guidelines
• Connecting to data sources importing data and transforming data for Business Intelligence.
• Able to implement Row level security on data and have an understanding of application security layer models in Power BI.
• Able to develop tabular and multidimensional models dat are compatible wif warehouse standards Adept in developing, publishing and scheduling Power BI reports as per teh business requirements
• Develop reports, dashboards & scorecards, data exploration, and visual analytics using existing and emerging technologies and tools.
• Design and implement intuitive and innovative dashboards and scorecards using technologies like Spotfire and Tableau.
• User & Design flows, experiences, and mockups wif product specs dat can be prototyped Contribute to high-level strategic decisions around report designs, Data visualization
• Develop complex interactive / dynamic dashboards wif data visualization tools like Tableau
• Developing visual reports dashboards and KPI scorecards using Power BI desktop.
• Meet teh client expectations of teh data visualization request provided in teh reports.
• Utilizes data visualization tools to make clear and concise visual representations of data.
• Create/manage Projects, Database Views, Data Sources and Data Connections using SSRS.
• Build, customize and publish interactive reports, data visualizations and dashboards using SSRS.
• Builds data transformations wif SSIS including importing data from files, moving data from one database platform to another; helps build star schema data marts.
• Able to creatively stretch teh capability of Tableau to customize and develop creatively stunning and dynamic data visualizations.
• Configured various performance metrics using AWS Cloudwatch & CloudTrial.
• Written various Lambda services for automating teh functionality on teh Cloud.Configured and monitored numerous MongoDB instances and replica sets
• Implementing on premise MMS monitoring and backup solution. Managing Mongo databases using MMS monitoring tool.
• Develop data mapping and design SSIS data loads wif new business data elements using EDI extracts from Black Knight MSP
• Installation of MongoDB on physical machines, Virtual machines as well as AWS
• Used Python Boto SDK for creating custom monitoring scripts to maintain tagging Standards for AWS resources
• Written Python scripts to automate jobs.
• Ability to develop ETL pipelines in and out of data warehouse using combination of Python and Snowflake’s SnowSQL
• Ability to write SQL queries against Snowflake.
• Ability to develop scripts (Unix, Python etc.) to do Extract, Load and Transform data
• Ability to provide production support for Data Warehouse issues such data load problems, transformation/translation problems etc.

Environment: Power BI, MS SQL Server 2016, SSIS/SSAS/SSRS, ETL, T-SQL, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Data Tools (SSDT), Agile/Scrum

Confidential, Timonium, MD

Sr Power BI/MSBI Consultant

Responsibilities:

• Processed, examined, and certified administrative receipts and disbursments
• Participate in all phases including Requirement Analysis, Design, and Coding, Testing, Production support and Documentation.
• Experience in connecting wif multiple data sources like SQL Server, Oracle and Excel from Power BI to build complex Datasets.
• Extensively worked on performing teh ETL Activities in Power Query.
• Extensively used transformations like Merge Queries, Append Queries, Pivoting teh Column, Un Pivoting Columns, Adding Custom Columns, Splitting teh Columns, Merging teh Columns etc.
• Extensive Experience in doing Data Modelling in Power Pivot Model.
• Extensively worked on Enhancing teh Data Model by Creating New Columns, New Measure and New Tables using DAX Expressions.
• Extensively used different Categories of DAX functions like Time Intelligence Function, Filter Functions, Date Functions, Logical Functions, Text Functions, Number and Statistical Functions for Creating New Information.
• Extensively worked in Power View for Presenting teh Data in Graphical Format using Different Visualizations in Power BI.
• Hands on Experience wif Visual level, Page level, Report level and Drill Through filters for filtering teh data in a Report.
• Good Experience in sorting teh Data in Visualizations, Grouping and Binning teh Data in Power BI.
• Extensive Experience in Creating APP Workspaces and adding teh Members to APP Workspace to Manage teh Content in Power BI Service.
• Experience in publishing teh Reports to Power BI Service and setting up teh necessary connections.
• Extensive Experience in Creating teh Dashboards using Multiple Reports.
• Worked on On-Premise Data Gateway to Refresh and Schedule Refresh teh Data in teh Dataset.
• Able to implement row level security on data and have an understanding of application security layer models in Power BI
• Experience in sharing theTabelu Reports and Dashboards wif End Users.
• Hands on Experience on writing SQL Queries as part of testing teh Data.
• Excellent Communication, Presentation, Interpersonal, Strong Troubleshooting and Organization Skills.
• Designed and developed Power BI graphical and visualization solutions wif business requirement documents and plans for creating interactive dashboards. multiple client accounts totaling over $75 million
• Train and coordinate a team of experienced in-house financial analysts.

Environment: SQL Server 2014, Oracle database, Pivotal cloud platform, TFS, Microsoft Visual Studio 2012, T-SQL, SSIS, SSRS, Power BI and DAX.

Confidential, Indianapolis, IN

MSBI Developer

Responsibilities:

• Involved in planning and designing data based on business requirement and provided documentation for further reference.
• Involved in installation and configuration of MS SQL Server 2005/2008.
• Experience in T-SQL skills in creating stored procedure, functions, views, triggers.
• Created SSIS packages wif different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded teh data into destination tables by performing different kinds of transformations.
• Modified teh existing stored procedures to get teh new functionality depending on teh client requirement.
• Creating tables wif cluster and non-clustered indexes on columns and created various database objects such as tables, indexes and views based on teh requirement.
• Created reports such as Parameterized, Cascading, Drill through/Drill down Reports, Charts and specialized inproducing Sub Reports using Relational data warehouse and OLAP Cubes.
• Created daily, weekly, monthly reports for various categories and Hierarchies based on business needs.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Created Company level inventory, sales reports from OLAP Cubes using MDX Script.
• Created Weekly, Daily level reports from lowest granular level (store) to highest (company) granular level wif lotsof metrics.
• Worked on teh performance of reports, created appropriate indexes on tables and modified teh code in existingstored procedures to get teh quick response on SharePoint site.
• Attended functional testing meetings user acceptance sessions and worked on teh feedbacks.
• Developed Sub Reports, Matrix Reports and Charts using SQL Server Reporting Services (SSRS).
• Managed and troubleshoot report server related issues.

Environment: MS SQL Server 2008/2012, Windows XP, T-SQL, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS) -2008, 2010, SQL Server Reporting services (SSRS), SQL Server Analysis Services (SSAS),Visual Studio, MS Excel, Flat File, SQL Profiler.

Confidential

SSIS/ SSRS/ SSAS Developer

Responsibilities:

• Involved in analysis of Report design requirements and actively participated and interacted wif Project Lead, Technical Manager and Lead Business Analyst to understand teh Business requirements.
• Migrated DTS packages from SQL Server 2008 to SQL Server 2012 as SSIS packages.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2008(SSAS).
• Excellent report creation skills using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) wif proficiency in using Report Designer as well as Report Builder.
• Created SQL Server Reports based on teh requirements using SSRS 2012.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Developed Complex Stored Procedures, Views and Temporary Tables as per teh requirement.
• Created complex reports which involve more number of groupings and multi-value parameters.
• Developed reports like Claim Statements, Fee Bills Transactions and some end user request reports on periodic basis.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Giving inputs to teh team.
• Created multiple reports wif drop down menu option having complex groupings wifin teh report.
• Designed, Build teh Dimensions, cubes wif star schema using SQL Server Analysis Services (SSAS).
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Handful experience in working wif teh new concept of Tablix Data Regions in teh Report Layout, Created a stack of stepped reports using teh Tablix.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Rendering teh reports to PDF formats as per teh requirement and printing all teh reports in a batch process for Monthly Statements.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Scheduling teh SSIS packages and Jobs.
• Worked very closely wif Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2007, IIS 6.0, MS SQL Server- 2012/2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel.

Confidential

SQL Developer

Responsibilities:

• Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Creating tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.
• Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Enhancing and deploying teh SSIS Packages from development server to production server.
• Wrote teh ETL scripts to load teh data into database from various source files.
• Experienced in error handling and troubleshooting teh scripts in failure to load teh data into database.
• Created SSIS Templates for developing SSIS Packages in such a way dat they can be dynamically deployed into Development, Testing and Production Environments.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created packages in SSIS wif custom error handling and worked wif different methods of logging in SSIS.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from teh Flat files on monthly and weekly basis.
• Expert in SSIS Deploying and Scheduling.
• Identified and Defined Key Performance Indicators in SSAS 2005/2008.
• Defined report layouts for formatting teh report design as per teh need.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services (SSRS).
• Generated Reports using Global Variables, Expressions and Functions for teh reports.
• Created reports and Dash boards using Microsoft Performance Point service.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send teh reports via email.
• In depth knowledge in SSRS for report generation to create various types of reports and also to develop different SSIS packages.
• Administrated teh created Reports by assigning permission to teh valid user for executing teh reports.

Environment: MS SQL Server 2008/2005, Windows XP, T-SQL, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting services (SSRS), SQL Server Analysis Services (SSAS),Visual Studio, MS Excel, Flat File, SQL Profiler.