SUMMARY

• A dedicated IT Professional with 8+ years of experience in using RDBMS, Database Development, Business Intelligence tools such as SSIS, Tableau, and SSRS ina fast - paced environment.
• Experience with handling large volumes of data with the proficiency to perform in a fast-paced Agileenvironment.Skilled inSQL,Power BI, Excel, Python, and other technologies. Knowledge of machine learning algorithms and quantitative data analysis.
• Expertise and vast knowledge in Enterprise Data Warehousing including Data Modeling, Data Architecture, Data Integration (ETL/ELT),Business Intelligence, Data Discovery.
• Good understanding and hands-on experience in setting up and maintaining NoSQL Databases like Cassandra and HBase.
• Hands-on in error handling and debugging coding issues and troubleshooting of production defects, on-call support for Business users for production issues.
• Knowledge of various reporting objects like Facts, Attributes, Hierarchies, Transformations, Filters, Prompts, Sets, and groups in Tableau.
• Experience in Design, Development, and implementation of the enterprise-wide architecture for structured and unstructured data providing architecture and consulting services to Business Intelligence initiatives and data-driven business applications.
• Excellent analytical, communication, organizational, interpersonal, critical thinking, and problem-solving skills that are talented with conflict management and change management.
• Collaborated with Project Managers in developing Concept Proposals, Project Scope Statements, Project Management Plan, Project Charter, Risk Management Plan, and Work Breakdown Structure (WBS).
• Extensively used JIRA for managing Epics, User stories and contributed to Scrum Ceremonies like Release Planning, Backlog Grooming, Sprint Planning, Daily stand-ups, Sprint Reviews, and Retrospective.
• Strong in conceptualizing and communicating enterprise data architecture frameworks for global enterprises for the interoperation of data warehouses, middleware, and web applications.
• Experience in using various packages in R and python-like ggplot2, caret, Rweka, gmodels, NLP, Reshape2, rjson, dplyr,tidyverse, pandas, NumPy, Seaborn, SciPy, Matplotlib, sci-kit-learn, Beautiful Soup.
• Experienced in Dimensional Data Modeling experience using Data modeling, Relational Data modeling, ER/Studio, Erwin, and Sybase Power Designer, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Conceptual, Physical &Logical data modeling.
• Experienced in handling all the domain and technical interaction with application users, analyzing client business processes, documenting business requirements.
• Possess strong analytical and problem-solving skills and have a quick learning curve. Committed team player and capable of working on tight project delivery schedules and deadlines.
• Experienced in writing Design Documents, System Administration Documents, Test Plans & Test Scenarios/Test Cases, and documentation of test results.

TECHNICAL SKILLS

Programming Language: Python, R, VBScript, GitHub, Microsoft Office, Linux OS, Google Analytics, VBA, SharePoint, Hive QL.

Tools: Tableau,Power BI,QlikView, Gephi, Advanced Excel (VBA, V-lookup, Macros, Solver), JIRA, TFS.

Statistical Techniques: Hypothesis Testing &p-value significance, Heteroscedasticity test, Multicollinearity test, Endogeneity, ANOVA.

Big Data Technologies: Sqoop, Hive, Impala, Pig, Flume, and Spark.

DataModelling: Sybase Power Designer / IBM Data Architect

ML Algorithms: Linear, Logistic Regression, KNN, PCA, Decision Trees, Support Vector Machines, Clustering techniques,Ensemble methods.

BI & Reporting tools: Business Objects, Cognos, SSRS, Crystal Reports, Tableau Desktop, Datorama

MS-Office Package: Microsoft Office (Windows, Word, Excel, PowerPoint, Visio, Project).

Databases: RDBMS (MS SQL, MySQL, Microsoft Access), Big Data Hadoop Infrastructure (Sqoop, Hive QL).

PROFESSIONAL EXPERIENCE

Confidential, Dallas,TX

Data Analyst/BI Developer

Responsibilities:

• Created Logical & Physical Data Modeling on Relational (OLTP), Dimensional Data Modeling (OLAP) on Star schema for Fact & Dimension tables using Erwin.
• Gathered business requirements, working closely with business users, project leaders, and developers. Analyzed the business requirements and designed Conceptual and Logical Data Models.
• Prepared ETL technical Mapping Documents along with test cases for each Mapping for future developments to maintain SDLC.
• Implemented and followed Agile development methodology within the cross-functional team and acted as a liaison between the business user group and the technical team.
• Facilitated the automation process for the reports - which are required to run on a monthly and weekly basis using python script.
• Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
• Integrated BI assets into customer relationship management (CRM) tasks, improving service personnel's available intelligence.
• Plan, design, and build the overall automated test strategy for extraction, transformation, and loading of data across multiple product platforms for business intelligence.
• Designed and developed various analytical reports from multiple data sources by blending data in a single worksheet in Tableau Desktop and created Tree Map, Heat maps, and background maps.
• Developed Data Mapping, Data Governance, Transformation, and Cleansing rules for the Master Data Management Architecture involving OLTP and OLAP.
• Extensive practical knowledge in importing data for use in reporting software (Tableau) graphs, and flowcharts.
• Employed time series techniques & data visualizations (Tableau) to track KPIs impacting sales and production, to depict timely growth, reduced maintenance and operations cost by 6.8%
• Designed, optimized, and executed complex SQL queries, used analysis and visualization tools such as SQL, Excel, and Tableau analyzed data and drew accurate and reliable conclusions, provided insights to upper management.
• Used HANA design studio to build information models that offered analytical and calculation views as well as column-based tables, presented the results of data analysis to management and team.
• Performed analysis on implementing Spark using Scale and wrote spark sample programs using PySpark.
• Created UDF to calculate the pending payment for the given residential or small business customer's quotation data and used it in Pig and Hive Scripts.
• Worked on Data Discovery for the collection and evaluation of data from various sources to understand trends and patterns in the data.
• Worked on Machine learning algorithms like logistic regression, Decision trees, Support Vector Machine, and Random forest to achieve the best accuracy for the propensity model.
• Extensive working experience in RStudio packages and Python libraries like Scikit-Learn to improve the model accuracy from 65% to 86%.
• Strong practical experience in various Python libraries like Pandas, One dimensional NumPy, and Two dimensional NumPy.
• Developed and maintained stored procedures. Implemented changes to database design including tables and views.
• Worked on creating filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.

Environment: Oracle, Teradata, HANA, MDM, XML, PL/SQL,Tableau, RStudio, Python, PIG, Hive

Confidential, Center Valley, Pennsylvania

Data Analyst/BI Developer

Responsibilities:

• Worked with Business users during requirements gathering and prepared Conceptual, Logical, and Physical Data Models.
• Planned and defined system requirements to Use Case, Use Case Scenario, and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Built and maintained Power BI dataset and data flows to consolidate disparate data from multiple sources to support self-service report authoring and seamless data insights.
• Developed functionalities like Role Level Security (RLS) with Power BI desktop, assigned and validated in Power BI Service to ensure visualization data security for the enterprise.
• Creating advanced reports for various business users using the Dimensional data sources that include OLAP data sources and Dimensionally Modeled Relational (DMR) data sources.
• Wrote business requirements for capturing and storing information from those systems into Subrogation Information Management and Technology Data Warehouse
• Conduct Design discussions and meetings to come out with the appropriate Data Warehouse at the lowest level of grain for each of the dimensions involved.
• Created Entity Relationship Diagrams (ERD), Functional diagrams, Data flow diagrams and enforce referential integrity constraints.
• Designed a STAR schema for sales data involving shared dimensions (Conformed) for other subject areas using Erwin Data Modeler.
• Created and maintained the Logical Data Model (LDM) for the project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Developed rule sets for data cleansing and actively participated in data cleansing and anomaly resolution of the legacy application.
• Defined facts, dimensions, and designed the data marts using Ralph Kimball's Dimensional Data Mart modeling methodology using Erwin.
• Involved in Data profiling and performed Data Analysis based on the requirements, which helped in catching many Sourcing Issues upfront.
• Developed Data mapping, Transformation, and Cleansing rules for Data Management involving OLTP and OLAP.
• Responsible for data governance rules and standards to maintain the consistency of the business element names in the different data layers.

Environment: PL/SQL, Erwin8.5, MS SQL 2008, Python, OLTP, OLAP, ODBC, Transact-SQL, TOAD, Teradata SQL Assistant, Power BI

Confidential, Dallas,TX

Data Analyst/BI Developer

Responsibilities:

• Work with users to identify the most appropriate source of record required to define the asset data for financing.
• Developed new scripts for gathering network and storage inventory data and make Splunk ingest data.
• Imported the customer data into Python using Pandas libraries and performed various data analyses - found patterns in data which helped in key decisions for the company.
• Highly immersive Data Science program involving Data Manipulation & Visualization, Web Scraping, Python programming, SQL, Unix Commands, and Databases.
• Implementation and delivery of business intelligence solutions to develop and deploy ETL, analytical, reporting, and scorecard/dashboards using SSIS and Tableau.
• Created subscriptions for business users and automated the process to send reports in different formats such as PDF, PNG using TABCMD.
• Worked with advanced analysis such as Data Blending, Joins, Table Calculations, Action filters, Custom hierarchies, Parameters, LOD calculations.
• Created Batch scripts to call third party REST APIs (Qualys) and utilized response in Tableau Desktop to create reports and dashboards.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Exported the data required information to RDBMS using Sqoop to make the data available for the claims processing team to assist in processing a claim based on the data.
• Created Teradata SQL scripts using OLAP functions like RANK to improve the query performance while pulling the data from large tables.
• Worked on MongoDB database concepts such as locking, transactions, indexes, sharding, replication, schema design, etc.
• Created Hive queries that helped market analysts spot emerging trends by comparing fresh data with EDW reference tables and historical metrics.

Environment: SQL/Server, Oracle 9i, MS-Office, Teradata, ER Studio, XML, Hive, Flume, Sqoop, Python, Tableau, Mongo DB, SSIS, Access DB, SSIS, Batch Scripting

Confidential, Framingham, MA

Business Intelligence Developer

Responsibilities:

• Served as the primary reporting resource and was responsible for system analysis, design, support, maintenance, specifications documentation, change control, and versioning of all reporting components.
• Designing, implementing, and maintaining database objects.
• Developing, testing, integrating, and deploying ETL routines using ETL tools and external programming, as necessary.
• Involved in requirement gathering meetings to understand requirements and future usage for the reports and documented them.
• Worked on SQL Server development including writing T-SQL Queries and creating SQL Server objects like Stored Procedures, User-defined Functions, Views, Triggers, implementing T-SQL relational database models, and data integrity.
• Served as the primary reporting resource and was responsible and focused on system support, maintenance, analysis, design, specifications documentation, maintenance of report documentation, change control, and versioning of all reporting components used to build and manage and perform multi-system reporting.
• Created Tableau scorecards, KPI's, dashboards using stack bars, bar graphs, scattered plots, Gantt charts using show functionality and publishing them to tableau server for executive decision making.
• Developed story-telling dashboards and published them on to Tableau Server which allowed end-users to understand the data on the fly with the usage of quick filters.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD, and MTD type of analysis.
• Scheduled data refresh on Tableau Server for daily, weekly, and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately, performed performance tuning of the dashboard, and created Tableau functional design documents.
• Worked with testing team to understand test cases and created processes (using stored procedures and SSIS packages) to automate ETL.
• Supported Extract, Transfer, Load (ETL) efforts using Integration Services tools. Created, configured, modified, and tuned SSIS packages.
• Created custom packages to load slowly changing dimension tables (for Type 2 and Type3 loads).
• Used configuration manager in SSIS to dynamically move packages between environments, performed error handling for SSIS packages.

Environment: MS SQL server 2014, Visual Studio 2015/2017, T-SQL, SSIS, MS Excel, Tableau Desktop, Tableau Server, All Scripts, Epic Systems, JIRA, TFS.

Confidential

Business Intelligence Developer

Responsibilities:

• Built complex Power BI reports and dashboards to report KPI, and business operations for the organization.
• Built and maintained Power BI dataset and data flows to consolidate disparate data from multiple sources to support self-service report authoring and seamless data insights.
• Developed functionalities like Role Level Security (RLS) with Power BI desktop, assigned and validated in Power BI Service to ensure visualization data security for the enterprise.
• Lead efforts to design key performance indicators and metrics that facilitated reporting and analysis of client data.
• Developed and maintained customized Extract-Transform-Load (ETL) processes using SSIS to refresh the organization's data mart and data warehouse.
• Wrote complex measures using DAX to support reporting and analytics.
• Cleansed, structured, and standardized the dataset in addition to creating relationships and hierarchies to support consistency in analytics and visualizations.
• Participated in development of SSIS packages and testing before deployment to Production.
• As part of a team, created data models (entity-relationship models) and implemented physical database designs for client applications.
• Created T-SQL Queries, CTEs, and views to implement medium to complex business logic for reporting and analysis purposes.

Environment: Power BI, SSIS, MS SQL server 2014, Visual Studio 2015, T-SQL, MS Excel, DAX.

Confidential

Business Intelligence Developer

Responsibilities:

• Extensively used SQL server reporting services to generate reports every week for a particular sales type in each period.
• Involved in scheduling reports to run weekly, quarterly, monthly based on the data to be reviewed by the manager.
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables of the hub.
• Wrote T-SQL queries, created dynamic Stored Procedures by using input values.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard, and SQL Query Analyzer in MS SQL Server 2008.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration, and Disaster Recovery.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables and calculations from different databases.
• Experienced in utilizing common table expressions (CTE), analytic, aggregate, merge, and ranking functions to build T-SQL objects.
• Extensively used BCP and BULK INSERT to import and export data from flat files, Excel, and MS Access to MS SQL Server databases by performing various kinds of transformations.
• Used Error handling and Error logging techniques to capture data in SSIS in various ETL solutions.
• Responsible for creating & scheduling SQL Agent Jobs to schedule SSIS packages and monitoring the status of the scheduled jobs.

Environment: MS SQL server 2008 R2,Visual Studio 2012, T-SQL, SSIS, MS Excel, MS Access DB, TFS.