SUMMARY:

• Currently working in the Information Technology field with emphasis on Data Analysis/ Business Intelligence
• I have been working in the field of Analytics for the last six years. My experience is mostly in the health care domain, experience in Hospitality (Hotel/ Property management) domain, Logistics domain and Pharmaceuticals domain as well. Tools I have been using in regular basis are Microsoft Excel, Microsoft SQL server, Microsoft Power BI, Oracle SQL, Tableau professional, Teradata Studio, TOAD, SSIS, SSRS, MS Dynamics etc.

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

Power BI Developer

Responsibilities:

• I was responsible for leveraging the available data to oversee and manage the benefits and complexity research for new automation opportunities, working with Business Analyst and Product owner
• Worked with business stakeholders and product owner to build customized reports to measure automation values
• Measure the effectiveness of automation and create management reports, utilize data findings to educated key stakeholders on trends and strategic implication
• Attend meeting with development team and Business Analyst to discuss reporting opportunities for various projects
• Attend daily standups to discuss reporting updates on various projects
• Designed and developed data warehouses, ETL packages, multi - dimensional OLAP cubes, data mining models, performances dashboards and reports
• Written complex DAX functions in Power BI and Power Pivot like COUNT(), SUM(), RELATED(), LOOKUPVALUE(), RANX(),CALCULATE(),etc
• Migrated from Tableau and Cognos reporting to Power BI reporting
• Shared dashboards and reports from most places in the Power BI service: Favorites, Recent, Shared with me (if the owner allows it), My Workspace, or other workspaces based on Roles and Permission
• Worked on various types of DAX functions like Date and time functions, Time-intelligence functions, Filter functions, Information functions, Logical functions Math and Trig functions, Parent and Child functions, Statistical functions and text functions
• Used advanced calculations using Power BI Desktop Aggregate functions, Date functions, Logical functions, String functions and Table functions
• Experience in configuring security, Organizational Content Packs, data Gateways, refresh schedules for PowerBI service
• Performed Row level Security to limit access to certain group or individuals
• Connected Power BI to Azure SQL Database along with a key configuration before connecting Power BI to Azure
• Installation of Power BI desktop, version upgradation and patches installation in client computers
• Configured the "Firewall" settings at the Azure SQL Database server
• Performed Power BI administration tasks like configuration of governance policies, usage monitoring, provisions of licenses, capacities and organizational resources
• Use Azure SQL Database connector to connect to Azure SQL Database
• Select the appropriate Azure server and database to query the data
• Created workspace and apps to allow business users to view the developed reports
• Created Gateways to schedule automatic refresh and scheduling refresh in power bi service
• Created Power BI Apps, Content pack, Datasets, Dataflow
• Wrote calculated columns and measures
• Worked on various kinds of reports: Yearly, Quarterly, Monthly and Daily
• Extensively used joins and sub queries to simplify complex queries involving multiple tables
• Created reporting which includes data sources like Microsoft SQL, Dynamic365, Flat files (.CSV), Denodo databases (AWS), PL SQL, Cloud databases, etc.
• Created reports using charts, gauges, tables, matrix
• Created drill down reports, drill through report, etc
• Was responsible for providing view/ edit access to custom Power BI reports to users of various denominations
• Performed advanced Microsoft Excel functions like IF, COUNT, COUNTIF, COUNTIFS, PIVOT TABLE, VLOOKUP, MACROS VBA, etc
• Performed programming in M query while using Power Query ETL process
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
• Created data connection for Excel with Microsoft SQL so that new data will be automatically populated with user clicks data refresh button.
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Involved in reviewing complex SQL queries
• Performed Database testing using SQL queries
• Wrote Parameterized Queries for generating Tabular reports, Formatting report layout, creating reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and Datasets, calculating subtotals and grand totals for the reports using SSRS
• Build and extended the Databricks could system
• Created Drill through, drill down, Matrix and Sub reports, added report mapping functionality to the reports using SSRS, Power BI
• Designed Dimensional Modeling using SSAS cubes for End-User. Created Hierarchies, Aggregations, partitions, calculated members and KPIs in Dimensional Modeling
• Gathered business requirements for SAP reporting and functionality enhancements.
• Wrote functional specifications for SAP Sales and Distribution transactional data reporting enhancements
• Tested custom SAP transactions to ensure proper functionality.
• Created training documentation and provided training on standard and custom SAP transactions.
• Configured SAP to enhance functionality and reporting
• SSIS ETL packages created to move data from Oracle and bring it to Microsoft SQL studio Data Warehouse
• Used SSRS for reporting data from operational database

Confidential, Memphis, Tennessee

Power BI Developer

Responsibilities:

• Used PowerBI tool to perform previously Excel done reporting to save time and energy
• Written complex DAX functions in Power BI and Power Pivot like COUNT(), SUM(), RELATED(), LOOKUPVALUE(), RANX(),CALCULATE(),etc
• Worked on various types of DAX functions like Date and time functions, Time-intelligence functions, Filter functions, Information functions, Logical functions Math and Trig functions, Parent and Child functions, Statistical functions and text functions
• Created graphical dashboards and reports in PowerBI
• Performed Row level Security to limit access to certain group or individuals
• Experience in configuring security, Organizational Content Packs, data Gateways, refresh schedules for PowerBI service
• Installation of Power BI desktop, version upgradation and patches installation in client computers
• Configured the "Firewall" settings at the Azure SQL Database server
• Performed Power BI administration tasks like configuration of governance policies, usage monitoring, provisions of licenses, capacities and organizational resources
• Created reports from data sets like XPO, DDD, Payment, etc
• Performed programming in M query while using Power Query ETL process
• Getting familiar with the Payment history made by Pfizer to all the supporting vendors
• Reporting the date of the check mailed to vendors, the invoice number, the Purchase order made by the vendor, the name of the vendor, the name of the Claimant, Payment check number, Gross amount paid to the vendor, etc.
• Extensive study on drugs like Zoloft, Viagra, Lipitor and Dilantin; and the reaction on human body including side effects and dangers
• Using Microsoft SQL server studio to write inner join queries to tie many tables together for data reporting with convenience.
• Using T-SQL programming to write query where value is declared by user, in case when user want to check if any check money was split into more than one payment
• Created SQL tables in personal schema for research help. CREATE TABLE, DROP TABLE, TRUNCATE TABLE, INSERT, etc. SQL statements were used in daily basis
• Created Tables, Stored Procedures and extracted data using T-SQL for business users whenever required
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
• SQL Cursor, Stored procedures, Triggers were created and executed in time of need
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
• Used internet search engines to study the case studies and lawsuit information regarding cases filed against Pfizer
• Created weekly report on number of researches completed and information successfully found regarding the payment made by Pfizer to the vendors
• Created VBA programs to automate Excel reporting. Task included automatic creating directories in folder and workbooks with multiple custom named worksheets. Deleting Columns when required. Created user forms like command box, list box, etc to create visually user-friendly reporting
• Performed Data Mapping in excel and created user stories for the ETL logics
• Working with multidimensional OLAP cubes
• Creating data lineage, data taxonomy, data dictionary
• Performed ETL using Excel and Microsoft SQL server tools
• Preparation and cleaning of data (data profiling) using Talend data preparation tool, Microsoft Azure machine learning studio tool, Azure data lake and python programming
• Connected Power BI to Azure Cosmos, Cloud databases and other Azure sql data tools
• Build roadmap for Adobe Analytics product suites
• Designed approach and best practices and governance
• Identified areas where Adobe Analytics can be leveraged beyond capturing site analytics - mobile analytics, video analytics, social analytics
• Performed Adobe Analytics automation including campaign development, email templates, schemas design, forms, web pages, segmentation, import/ export workflows, etc
• Design and monitor construction of user-facing presentation tools, such as Microsoft SQL Server Reporting Services (SSRS) reports
• Designed Dimensional Modeling using SSAS cubes for End-User. Created Hierarchies, Aggregations, partitions, calculated members and KPIs in Dimensional Modeling

Confidential, Memphis, Tennessee

Power BI Developer

Responsibilities:

• Acted as liaison for each Vice President
• Manage research for the VP team
• Executed CHT(In house tool) changes and updated cases
• Performed research and made recommendations for changes to account structures, compile submissions and performed pre and post transition KPI validation
• Maintained communications on team email, assigned and distributed cases to VP teams
• Performed research on data using Excel
• Written complex DAX functions in Power BI and Power Pivot like COUNT(), SUM(), RELATED(), LOOKUPVALUE(), RANX(),CALCULATE(),etc
• Worked on various types of DAX functions like Date and time functions, Time-intelligence functions, Filter functions, Information functions, Logical functions Math and Trig functions, Parent and Child functions, Statistical functions and text functions
• Facilitated data migration from old ERP system to cloud based system
• Performed Row level Security to limit access to certain group or individuals
• In Excel Formulas and Statements used were COUNTIFF, SUM, IF and nested IFS, VLOOKUP, PIVOT TABLE, CONCATENATE, etc.
• Performed research on data using Python- Pandas and Numpy
• Cleaned data using Pandas statements like .isna(), fillna(), Strip/Trim data frame data, etc.
• Grouped data using Group by statements
• Merging two tables
• Sorting table with specific columns using sortvalues statement
• Performed exploratory data analysis using Pandas. Created plots using python- Bar plots, Histogram, Box plot, Area plot, Scatter plot, Pie plots
• Ran SQL queries in Teradata SQL Assistant, TOAD to find Global entity Id, Facility ID, EAN, etc. of FedEx customers to perform research
• Ran SQL joins of multiple tables to find quick solution to data lookup task for entire team
• Updated team OneNote regularly with updated research findings
• Used PowerBI tool to perform previously Excel done reporting to save time and energy
• Used DAX formulas in PowerBI like Related function, Calculate, etc
• Created graphical dashboards and reports in PowerBI
• Experience in configuring security, Organizational Content Packs, data Gateways, refresh schedules for PowerBI service.
• Connected to data source ServiceNow
• Extensively used Data Modeling, Data Analysis for OLTP and OLAP systems
• Reviewed the Conceptual EDW (Enterprise Data Warehouse) Data model with Business users, app development team and information architects to make sure all requirement are covered fully
• Performed Data modeling techniques like Dimensional data modeling, Star Schema modeling, Snow-flake modeling using tools like Erwin
• Designed and developed data marts by following Star Schema and Snowflake Schema Methodology
• Identified the Facts and Dimensional tables and established the grain of fact for dimensional models
• Created Multi-Way Aggregate Fact Tables as a specific summarization across dimensions of product, region and date
• Created Snowflake Schemas by normalizing the dimension tables as appropriate, and creating a sub dimension as a subset to the Customer(previous) dimension
• Created DFD (Data Flow Diagram) to show the input, outputs and how the input data gets converted to output data by a process or calculation
• Created ETL/Talend jobs both design and code to process data to target databases
• Created Talend jobs to load data into various Oracle tables. Utilized Oracle stored procedures and wrote few Java codes to capture global map variables and use them in the job
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.

Confidential, Plano, TX

Power BI Developer

Responsibilities:

• Used PowerBI tool to perform previously Excel done reporting to save time and energy
• Used DAX formulas in PowerBI like Related function, etc
• Created graphical dashboards and reports in PowerBI
• Written complex DAX functions in Power BI and Power Pivot like COUNT(), SUM(), RELATED(), LOOKUPVALUE(), RANX(),CALCULATE(),etc
• Performed Row level Security to limit access to certain group or individuals
• Worked on various types of DAX functions like Date and time functions, Time-intelligence functions, Filter functions, Information functions, Logical functions Math and Trig functions, Parent and Child functions, Statistical functions and text functions
• Experience in configuring security, Organizational Content Packs, data Gateways, refresh schedules for PowerBI service.
• Automated their previously manual reporting process for Transition of Care report for Behavioral health and Acute care patients using SQL, Dynamic365 and Excel
• Performed programming in M query while using Power Query ETL process
• Worked closely with Business owners to ensure comprehensive and clear understanding of requirements for successful reporting implementation.
• Research and evaluate alternative solutions and recommend the most efficient and cost effective solution
• Apply advanced technical training to informatics reporting standards and report activities
• Moved their Excel reporting process to Tableau reporting.
• Performed data mapping
• Help with creating data dictionary
• Ran daily Transition of Care reports
• Reported consistently on claims, provider data, member data, clinical data, CMS, HEDIS and pharmacy data
• Review data to study operational impacts on business and come up with actions needed to solve minor/major issues; elevate such issues, trends, areas for improvement and opportunities to management
• Ran reports in Excel using SQL with Business Objects Tool Tableau interference directly linking sources to core databases (ODS/EDW)
• Trend analysis using business objects tool Tableau
• Imported flat files .CSV into Microsoft SQL for reporting purpose
• Experience in configuring security, Organizational Content Packs, data Gateways, refresh schedules for PowerBI service.
• Performed advanced Microsoft Excel functions like IF, COUNT, COUNTIF, COUNTIFS, PIVOT TABLE, VLOOKUP, MACROS VBA, etc
• Created data connection for Excel with Microsoft SQL so that new data will be automatically populated with user clicks data refresh button.
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Involved in reviewing complex SQL queries
• Performed Database testing using SQL queries
• Running queries and extraction of data using Teradata Studio, TOAD
• Updating the latest versions of reports to team SharePoint so all team members have access
• Data Profiling using Talend Data Preparation tool and Alteryx software
• Good understanding of HIPPA compliance requirements and Performed QA on reporting so all our reporting is coming from reliable source and is HIPPA compliant
• Cloud technologies like AWS Redshift, Aurora, RDS Cloud databases
• Created S3 buckets in the AWS environment to store files, sometimes which are required to serve static content for a web application.
• Configured S3 buckets with various life cycle policies to archive the infrequently accessed data to storage classes based on requirement.
• Created EBS volumes for storing application files for use with EC2 instances whenever they are mounted to them.
• Performed supervised and unsupervised Machine learning with AWS including logistic regression, linear regression, classification, SVM, NLP etc.
• ERWin for data modeling
• Querying with Big Data (Scala, Spark, Hadoop, NoSQL databases- MongoDB and Apache Cassandra)

Environment: MS SQL Server, Microsoft Share Point, SAP

Confidential, Nashville, Tennessee

Power BI Developer

Responsibilities:

• Used PowerBI tool to perform previously Excel done reporting to save time and energy
• Written complex DAX functions in Power BI and Power Pivot like COUNT(), SUM(), RELATED(), LOOKUPVALUE(), RANX(),CALCULATE(),etc
• Worked on various types of DAX functions like Date and time functions, Time-intelligence functions, Filter functions, Information functions, Logical functions Math and Trig functions, Parent and Child functions, Statistical functions and text functions
• Created graphical dashboards and reports in PowerBI
• Experience in configuring security, Organizational Content Packs, data Gateways, refresh schedules for PowerBI service.
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
• Created and maintained SQL Scripts to perform back-end testing on the oracle database.
• Performed Database testing using SQL queries
• Performed reporting SSRS, SSIS
• Proficient in Microsoft Office as well as MS Access programming language and data
• Used MS Access to build forms and reports that are bound to relational data
• Created complex calculative fields in Tableau using functions available to meet the client requirements for different dashboards
• Created reports with graphical representation using Shapes to indicate the profit or loss percentage which helps user understand easily
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data
• Used Dual Axes, Reference lines, Trend lines to show their trends
• Build visualization using tableau advance features such as line/ Dual Axis/ histogram/ Combination chart/ Boxplot/ Area chart/ Heat Maps/ Tree maps
• Involved in Full Life Cycle Development of Reporting Projects, which included requirements gathering/ analysis, design, development, testing and production rollover
• Performed advanced Microsoft Excel functions like IF, COUNT, COUNTIF, COUNTIFS, PIVOT TABLE, VLOOKUP, MACROS VBA, etc.
• Performed data analytics with SAS
• Imported files from various formats like CSV, DAT, TXT using INFILE Statement and Proc Input
• Used Merge command to merge two tables with at least one common data column
• Used SET command to retrieve data from previous dataset
• Used Proc command for Sort, Print, Frequency, Mean, etc.
• Use Proc SQL statements to manipulate data using UPDATE, DELETE, INSERT
• Using Hive SQL to query and extract data for analysis purpose
• Data mining with querying and mining large datasets to discover transition patterns and examine data
• Created graphical dashboards and reports in MSBI

Environment: MS SQL Server, Oracle, Microsoft Team Foundation Server, MS PowerPoint, Blueprint, VBA and Rally

Confidential, Danville, PA

BI Developer

Responsibilities:

• Identified, analyzed, and documented defects, errors, and inconsistencies in the application using MS Excel
• Experienced in backend testing by executing SQL queries
• Performed data analytics in Python Language
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
• Created reports, Graphs, Tables and Summary analysis using SAS.
• Used SAS Import/Export Wizard plus SAS programming techniques to extract data from excel.
• Performed advanced Microsoft Excel functions like IF, COUNT, COUNTIF, COUNTIFS, PIVOT TABLE, VLOOKUP, MACROS, etc.
• Provided technical oversight and subject matter expertise to BI team on key initiatives
• Prepared user documentation for hands on training of end user community
• Conducted user interviews and reviewed existing reporting/ analytical solutions to understand the clients specific reporting needs
• Worked extensively on the life cycle management, in moving the reports from the environments of developing, testing and production
• Designed and developed PL/SQL stored procedures to increase the performance of system
• Created metrics, analytics, rules, goals for the corporate dashboards
• ETL (Extract Transfer Load) experience
• Performed complex queries and data mining methodologies to identify patterns and trends that are indicative of potential risks using traditional as well as predictive/ advanced analytic methodologies
• Set up Data warehousing/ Business Intelligence project
• Set up OLAP database
• Data warehouse schemas like star and snowflake design
• Creating Facts and Dimension tables
• Build visualization using tableau advance features such as Line/ Dual Axis/ histogram/ Combination chart/ Boxplot/ Area chart/ Heat Maps/ Tree maps in Tableau
• Involved in Full Life Cycle Development of Reporting Projects, which included requirements gathering/ analysis, design, development, testing and production rollover.

Environment: MS SQL Server, Oracle, Microsoft Team Foundation Server, Blueprint, SSRS and Rally

Confidential, Southlake, TX

Data Analyst/ BI Analyst

Responsibilities:

• Identifying new and existing bugs and wrote test cases.
• Manually tested the web application to ensure the flow of the application functionality
• Performed Black Box, Negative, Regression, and Integration & Security Tests Using manual testing techniques
• Performed XML validation and testing
• Performed backend testing to validate the data using SQL queries
• Performed negative and positive testing using SQL queries
• Performing UAT Regression Testing after each build during SDLC
• Setting up projects in Quality Center, writing test cases, executing them and performing bug tracking
• Documented bugs found out during the process of testing
• Testing Applications built with SOA by sending request and waiting for responses
• Executing test cases manually to verify the expected results
• Mentoring and building skills in more junior members of the QA team
• Set-up, co-ordinate & conduct system & UAT testing with Business Analysts and end-field users after the applications were all set
• Participated in weekly status report meetings
• Database querying in both OLTP and OLAP RDBMS systems

Environment: .Net, Windows, MS Office Suite

TECHNICAL SKILLS

Tools: Microsoft TFS, One Note, Quality Center RDBMS MS SQL Server, DB2, Microsoft Team Foundation Server, R Studio, Talend Data Preparation tool, SSRS, SAP, Databricks

Query Tools: SQL Server Management Studio, PL SQL developer, MS Access

Data Visualization: Tableau Desktop, Microsoft Excel, Python- Pandas, SAS, Power BI