PROFESSIONAL SUMMARY:

• Solutions - driven Data Science Analyst/ Business Intelligence Developer with 5 years of experience in Data Science, Business Intelligence, Data Modeling, and Project management in the fast-moving agile environment.
• Hands on experience in Data Analytics, Business Intelligence, Data Governance, Data mining, Data validation, Predictive modeling, Data Lineage phases of the Data Lifecycle.
• Involved and excelled in all phases of Data Warehouse development, maintenance, and visualization.
• Well versed in machine learning algorithms Linear, logistic and time series, Linear discriminant analysis, decision trees, random forest algorithms.
• Good experience in IBM analytical (Cognos), modeling (Framework Manager), Data Governance (Information Governance Catalog) and ETL tools (DataStage) required for the Data warehouse development.
• Strong ability to query and maintain stored procedures in SQL for various RDBMS such as SSMS, Aginity workspace, DB2..
• Have good hands on experience in Ab initio.
• Self-motivated to take responsibility and contribute to be a productive team member. Strong team building, mentoring skills and excellent leadership capability.
• Good knowledge of the US healthcare industry, Banking, and Credit card sectors.
• Authorized to work in the United States for any employer.

SKILL:

• Health Care / Insurance Claim Analytics
• Credit Card Fraud Analytics (Banking)
• Data Analytics (Data Modeling, ETL)
• TSQL, IBM Cognos Framework Manager, data stage, SAS, SAS E-Miner, Ab-Initio, Information Analyzer, Jmp Pro, IBM Information Governance Catalog, SSMS, Aginity, Netezza, DB2.
• Tableau, Cognos Report/Analytics studio, SSRS, Visual Studio, Power BI, Qlik View, Oracle Hyperion Interactive studio
• R studio, SAS, Python
• Linear Regression, SVM, KNN, Na ve Bayes, Random Forest, SVM, Boosting, K-means Clustering

PROFESSIONAL EXPERIENCE:

Confidential, Ohio

Senior BI Report Developer

Responsibilities:

• Interacting with Business Stakeholders for gathering the requirements and managing the delivery, involving in entire data report development lifecycle.
• Converting/ Creating and validating SAP Crystal reports using IBM Cognos 11.1 and Tableau desktop.
• Assisting with monthly/quarterly legal - financial reporting.
• Creation and validation of ad-hoc reports during the production phase / data migration.
• Optimizing the performance of several monthly financial Cognos reports and dashboards, reducing the redundancy by interactive prompts, filters.
• Create, validate and maintain Audit reports for user security purpose.

Confidential, South Dakota

Data/Business Intelligence Modeler

Responsibilities:

• Analyze the raw data files using IBM Cognos Information Analyzer, which offers data quality assessment and helps in monitoring and defining the correlation between the fields.
• Analyze, define the data patterns, rules, and metrics according to IBM Information Governance Catalog and build a logical relational/ dimensional model using star schemas to define the source and target fields.
• After the ETL, Create, enhance and maintain IBM Cognos Framework Manager Relational and Dimensional Physical Models using a three-layer approach (Database/Foundation/Business) on Netezza 7.2.
• Effectively use reporting and data Visualizations to enhance the translation of data which includes creating Reports, dashboards, stories and data modules using IBM Cognos 11.0.
• Set the user security, Deploy / Publishing the packages, and Cognos reports from Dev to Prod.
• Assist in the development and implementation of various strategic initiatives around MetaData Management and Data Quality, ensuring proper configuration and change controls are implemented and followed.
• Involved in Security and Maintenance of Enterprise data model at the atomic and dimensional level for Business Intelligence purposes.
• Created customized Cognos templates/themes which are used by the power users to enhance/accelerate the report development.
• Working with Current and Historic transactions, payments, plastics, and Letters sent to the customer's Checking and Credit card data to find future trends and mitigating the risk.
• Involved in Creation, validation, and migration of BI report from Oracle Hyperion workspace to Cognos report studio.
• Developed almost 350 interactive reports on Netezza database using Cognos report/Analytics studio and validated with the Oracle database - Hyperion workspace reports.
• Created interactive prompt pages, conditions, and filters in Cognos reporting studio and dashboards to optimize, improve the report performance/ reducing the redundancy according to the reporting requirement.
• Provided power user to the qualified employees for the basic Cognos Query, Cognos report studio which helps them build many DIY reports and dashboards on the Netezza database using Cognos Analytics.
• Hands on experience in building simple and complex interactive active reports, drill through reports. Involved in all the phases of the data in developing a data warehouse and reporting.

Confidential, South Dakota

Data Science / Business Intelligence Analyst

Responsibilities:

• Querying on different databases related to structural and non-structural data and worked on its extraction using SQL and base SAS for the SQL server database.
• Work closely with the development team to provide support for database objects
• (stored/procedures/triggers/views) and performing code review.
• Identify and track current fraud trends by reviewing transaction and account patterns.
• Develop Ad-hoc reports, linked reports, dashboards, drill through, drill down reports and complex visualizations using SSRS, visual studio and Power BI.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multidimensional reports in SSRS.
• Converted SSRS reports to Power BI reports / created interactive dashboards.
• Used DAX and MDX for data analysis and visualization.
• Maintenance and creation of monthly financial reports using Power BI.
• Data cleaning and preprocessing for analyzing data patterns and content for correlation using JMP pro and R-Programming.
• Implementing Decision Trees after cleansing the data, using SAS E-Miner, to forecast the fraud trends.
• Worked closely with Client services, chargebacks, disputes, and other internal teams to mitigate risk and Customer Retention.

Confidential, South Dakota

Graduate Research Assistant (Tableau, SAS, R)

Responsibilities:

• Accurately interpreted data and created Tableau dashboards from SD agricultural data and critically investigated the areas to improve crop production.
• Involved in all the steps of the data lifecycle (cleansing, analyzing, modeling, Predicting and visualization) of the data from multiple data sources.
• Create user interactive dashboards and prompt pages and pivoting using Tableau, Qlik view, SSRS.
• Created machine learning algorithms for the ‘Heritage Healthcare’ by analyzing the previous 2 years of relevant data.
• Predictive modeling and web scraping using python Numpy/ pandas by working on different data formats such as JSON, XML, etc.
• Provided effective assistance to university graduate programs, on Facebook and LinkedIn projects.

Confidential

Database Analyst (SQL, Data Stage, Cognos)

Responsibilities:

• Used ETL DataStage developer for extracting, cleansing, transforming, integrating and loading data into the data warehouse using Netezza database.
• Implemented complex ETL strategies to implement data mart facts and dimension RDBMS tables.
• Created DataStage jobs staging transformer, aggregator, sort, join, merge, look up, surrogate key, column/row generator.
• Creating jobs for the new or existing modules in Ab Initio ETL tool, performing database tasks, in creating Staged and Trend Tables, views.
• Unit and Integrated testing of DataStage jobs as per the client requirement.
• Performance tuning of ETL and SQL scripts to reduce the loading times.
• Administer in providing security for all the IBM analytics products (Cognos) users with proper authentication and authorization.
• Testing using SQL queries and stored procedures to validate the ETL source-target mapping.

ETL - BI Developer

Confidential

Responsibilities:

• Cleanse the data using Ab-Initio Joins, look-up, sorts, filters, partitioning components.
• Providing Quality assurance testing of these modules by preparing test strategies using Teradata SQL, attend client review calls for each deliverable provided by the module signoff.
• Involved in creating views, stored procedures and custom SQL queries for data extraction and validation.
• Created Tableau dashboards for reporting purposes.
• Experience working with Unix Shell scripts and Unix commands to build Ab-Initio graphs.
• Connecting multiple data sources in tableau to implement working reports.
• Developed Tableau visualizations using crosstabs, Heatmaps, box and whisker charts, scatterplots, pie/ density charts, and dashboards.
• Creating jobs for the new or existing modules in Ab Initio ETL tool, performing database tasks, in creating Staged and Trend Tables, views.