SUMMARY:

• Around 8 years of experience in analyzing, designing, and developing client/server, Business Intelligence (BI) database applications, Requirement Elicitation, ETL, Data visualization, Analytics, Data Integration and related database Platforms in banking and Health Care sectors.
• Experienced in developing Statistical models to perform predictive data analysis using Python.
• Extensive theoretical and experimental knowledge on various supervised and unsupervised machine learning algorithms Regression, Classification, Decision trees, Neural Networks, and K - Means clustering techniques.
• Worked on several Python packages like NUMPY, SCIPY, PANDAS, MATPLOTLIB etc.
• Excellent skills in analytical analysis and proven ability to read and interpret different points of data.
• Experience in analyzing, designing and developing client/server, SAP Business Intelligence, Business Objects, Requirement Elicitation, ETL, Data visualization, Analytics, Data Integration, governance, and related database Platforms in banking and Health Care sectors.
• Proficient with Data Analysis, mapping source and target systems for data migration efforts and resolving issues relating to data migration.
• Experienced in ETL, data analysis with solid understanding of Business Requirements Gathering, Data warehousing, Business Intelligence, Data Mapping, governance, and Data Modeling.
• Experience in OLTP, OLAP, Slowly Changing Dimensions, Data Cleansing and Data Migration.
• Experienced in Data Modelling, ETL & Data Analysis experience using Dimensional Data Modelling and Relational Data Modelling, Star Schema/Snowflake Modelling, FACT & Dimensions tables, Physical & Logical Data Modelling.
• Experience in Database Programming SQL & PLSQL, MS Access, Oracle 12c/11g/10g/9i, XML, DB2 Teradata, Database Tuning and Query Optimization.
• Expertise in developing standard and re-usable mappings using various transformations like expression aggregator, joiner, source qualifier, lookup and router.
• Excellent understanding and working experience of industry standard methodologies like System Development Life Cycle (SDLC), as per Rational Unified Process (RUP), AGILE Methodologies.
• Expertise in analyzing and documenting business requirement documents (BRD) and functional requirement documents (FRD) along with Use Case Modeling and UML.

TECHNICAL SKILLS:

Programming and Scripting: Python, Scala, Spark, Hadoop, R, C, C++, Java Script, Java, SQL, HTML, PHP.

ETL and Analytical Tools: Tableau, SAP Business Intelligence, SAP Business Objects, Crystal Reports, and Xcelsius.

Machine Learning, Statistical Packages: Alteryx, MINITAB, and MATLAB R2017A.

Data Warehousing Tools: Amazon Web Services, SQL Server Enterprise Edition 2017(SSRS, SSMS, SSIS, SSDS), SQL Server 2012/2008/2000, Oracle 12c/10g/9i, and MS Access.

Others: Excel, Git, Pivot tables, VLOOKUP.

PROFESSIONAL EXPERIENCE:

Data Analyst / Scientist

Confidential, Warren, NJ

Responsibilities:

• Writing test cases in Python for statistical analysis and created predictive analysis reports in different domains.
• Created a Machine Learning model to predict the business that will be most successful in region wise.
• Performing data analysis and data modelling (feature scaling) using statistical and machine learning methodologies to advance unstructured data sets.
• Worked on optimization algorithms and model prototyping.
• Used Python libraries for optimization algorithms.
• Working on consensus algorithms using Python.
• Created interactive dashboards in tableau to assist end-user decision making.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Extensively worked Tableau Server and created report schedules, backups, and restoring backups into the repository.
• Involved in the design and development of user interfaces and customization of Reports using Tableau and designed cubes for data visualization, forecasting reports using historical data.
• Generated various presentable reports and documentation using report designer.
• Analyze data model, write business algorithms using stored procedures and queries, and perform proof of concepts for new data architecture.
• Created databases, tables, views & schemas. Performed users access authorization, defined locations, populated tables with data and performed unload/copy/replicate data from one database into another after detail analysis and design.
• Collected, reviewed and analyzed quarterly and annual financial asset data.
• Preparing Dashboards using calculations, parameters in Tableau Desktop and Server.
• Evaluated data profiling, quality, cleansing, integration and extraction tool.
• Created reports to show quality and quantitative trends to define key metrics.
• Verified new deployments and contributed to evolution of various tools to improve data quality.
• Worked with cloud based technology like Redshift, S3, AWS, EC2 Machine, etc. and extracting the data from the Oracle financials and the Redshift database.

Environment: Tableau, Python, Statistics, Machine Learning, Spark, Alteryx, Hadoop, Hive, HDFS, Minitab, Amazon Web Services, No SQL, PL/SQL, Excel.

Data Analyst

Confidential

Responsibilities:

• Provided assistance for defining of SAP roles and new business processes.
• Reviewed and maintained data structures in SAP modules.
• Extracted data from SAP BI using OLTP and OLAP connections to do modelling and designing in Universe level.
• Utilized SAP ETL toolset (Data Explorer, and Data Quality) to analyze legacy data for data profiling.
• Generated Xcelsius dashboards and reports using BEx, WEBI, DESKI, and Crystal and performed analysis for decision making.
• Performed modeled data extraction process from universe to Xcelsius to generate dashboards using QAAWS.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Generated Tableau ad-hoc reports using excel sheet, flat files, CSV files to.
• Generated tableau dashboards with combination charts for clear understanding.
• Monitored end - to - end workflow process to enter, create, or change the data.
• Conducted or performed data modeling exercises in support of subject areas and/or specific client needs for data, reports, or analyses, with a concern towards reuse of existing data elements, alignment with existing data assets and target enterprise data architecture.
• Tested various ETL transformation rules based on log files, data movement and with help of SQL.
• Involved with Business Unit for Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements. Executed SQL Queries to check the data table updates after test executions.
• Tested various ETL transformation rules based on log files, data movement and with help of SQL.
• Developed conceptual, logical, and physical Enterprise Data Model based on industry standards.
• Involved in preparing logical data models and conducted controlled brain-storming sessions with project focus groups.
• Involved in designing Context Flow Diagrams, Structure Chart and ER- diagrams and worked on database features and objects such as partitioning, change data capture, indexes, views, indexed views to develop optimal physical data mode.
• Designed the Logical Model into Dimensional Model using Star Schema and Snowflake Schema.
• Executed enterprise data governance strategies in line with the organization s strategic plan and objectives.
• Assessed data repositories for compliance with data governance policies and standards. Works with all areas of the organization to ensure data quality and integrity.
• Involved in the data profiling activities for the column assessment and natural key study.
• Developed complex SQL queries, and perform execution validation for remediation and Analysis.
• Used Normalization methods up to 3NF and De-normalization techniques for effective performance in OLTP systems.

Environment: SAP NetWeaver, SAP Business Intelligence, Business Objects, Crystal Reports, Xcelsius Dashboards, Rational Requisite Pro, MSOffice (Word, Excel and PowerPoint), MS Project, MS Access, MS Excel, CSV files, UML, Erwin, MS Visio, Oracle 11g, RDBMS, SQL Server 2008, ANSI SQL.

Data Analyst

Confidential

Responsibilities:

• Gathered business requirements through interviews, surveys, prototyping and observing from account managers and UI (User Interface) of the existing Broker Portal system.
• Delivered technical presentations to the team regarding projects and processfloe.
• Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modelling.
• Identified the objects and relationships between the Healthcare objects to develop a logical model in Erwin tool.
• Implemented Slowly Changing Dimensions Type2 and Type3 for accessing history of reference Healthcare data changes.
• Identified entities and attributes and developed conceptual, logical and physical models using Erwin.
• Used reverse engineering to create Graphical Representation (E-R diagram) and to connect to existing database.
• Writing Complex SQL queries in Teradata to pull the records with data issues reported by the users using complex joins, partitions, ordered analytical functions, aggregate functions etc.
• Defined and implemented Data Governance Management tools.
• Created and implemented the Data Governance framework that meets data objectives for the organization.
• Established and executed the Data Quality Governance Framework, which includes end-to-end process.
• Quality framework for assessing decisions that ensure the suitability of data for its intended purpose.
• Developed Healthcare data mapping documents between Legacy, Production, and User Interface Systems.
• Creating or modifying the T-SQL queries as per the business requirements.
• Designed and Developed Oracle database Tables, Views, Indexes with proper privileges and Maintained and updated the database by deleting and removing old data.
• Performed Backup operations on CRM system Daily, Weekly, Monthly basis and performing analysis.

Environment: Oracle 11g, ANSI SQL, Erwin, ODBC, RDBMS, SQL Server, Excel, Rational Rose, HTML, Agile methodology.