SUMMARY

• Above 6+ years of professional experience as Data Analyst worked with large datasets of Structured and Unstructured data, Data Acquisition, Data Validation, Predictive modeling, Data Visualization. Experienced in using R, Python, Tableau, Hadoop and Power BI for data integration, data cleaning, data masking, data visualization, risk analysis and predictive analytics.
• Experience on large scale data processing platforms using Big Data.
• Participated actively in all phases of SDLC including Requirement Gathering, Designing Data Models, Development, Testing, Go live and Post Go Live Support.
• Experience with various databases like Oracle, SQL Server, Teradata and DB2.
• Strong Experience with SQL server design and development.
• Strong experience in Data Analysis, Data Profiling, Data Cleansing & Quality, Data Migration, Data Integration using SSIS, SSAS and Python
• Used DAX formulas and language in Power BI and SSAS.
• Experienced with AWS, EC2, Redshift to push data to cloud.
• Extensive experience in Stored Procedures, Triggers, Functions, Cursors, Views, Materialize Views and Analytical Functions.
• Good experience in SSIS packages to load the data from Text File to staging server and then from staging server to Data warehouse .
• Involved in SSIS packages to extract data from different sources like SQL server 2008, MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS .
• Created SQL queries to validate Data transformation and ETL Loading.
• Experience in metadata clean - up and processing at regular intervals for better quality of data .
• Good knowledge on Pivot Table reports in Microsoft Excel.
• Good understanding of Relational Database Design, OLAP concepts and methodologies.
• Excellent knowledge on Hadoop Architecture and ecosystems such as HDFS, Name
• Node, Data Node, YARN, Map Reduce, Spark, HBase, Hive, Pig.

TECHNICAL SKILLS:

Languages: R, Python, C, MATLAB, Java.

Software Packages: NumPy, Pandas, TensorFlow, Matplotlib, ggplot2, skit-learn

ETL Tools: Oracle Warehouse Builder (OWB), Informatica, SAS, SSIS

Reporting Tools: SSRS, Cognos, QlikView, Business Objects, Tableau, Power BI.

Operating Systems: Windows NT 4.0, Windows 98/2000/XP, Windows 7, 8, 10, UNIX

Databases: ORACLE, SQL Server, T-SQL, My SQL, MS Access, AWS-EC2, Redshift, DB2 and Teradata

Tools: & Utilities MS Office, MS Visio, TOAD, SQL Profiler, Hadoop.

Cloud: AWS, Azure, Redshift

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

DDM Data Analyst (SQL, SQL server, Teradata, DDM)

Responsibilities:

• Effectively used SQL Server in managing data, tables, jobs, SP and functions.
• Worked on extraction and transformations on PHI/PII data securely.
• Have done encryptions and decryptions for the PHI/PII data.
• Processed data in Tera Data .
• Designed and Developed data models in Power BI for enterprise solutions.
• Worked with AWS Redshift pushing data to cloud and making data available enterprise wide.
• Quickly jumped on to the requirements and delivered work times within the stipulated time
• Plans, leads, designs, coordinates, analyzes and directs BI project(s).
• SQL Server Integration Services (SSIS) and SQL Server T-SQL stored procedures within
• SQL Server 2016 environment.
• Responsible for modeling and implementing a Data Masking to server the data needs of biologists.
• Responsible for writing queries in T-SQL, implementing views and stored procedures to support the various BI report requirements.
• Have strong knowledge on healthcare domain.
• Used Normalization and Denormalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints
• Used advanced Microsoft Excel functions such as pivot tables and VLOOKUP to analyze the data.
• Various statistical tests performed for clear understanding to DB owners.
• Complete support to all regions (Test/Model/System/Regression/Production).
• Actively involved in Analysis, Development, and Unit testing of the data.
• As a Data Management Professional at Enterprise Level worked with wide variety of tools like SSIS, DTS, SSRS, SSAS, Tableau, AWS Redshift, and Python.
• Have knowledge on Big Data Hadoop, hive, Spark .
• Developed ETL pipelines in Python.
• Used Python for some Data Analysis .

Confidential, Akron, OH

Data Analyst (Python, R, SQL, Big Data, Tableau)

Responsibilities:

• Designed an Industry standard data Model specific to the company with group insurance offerings, Translated the business requirements into detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
• Determine customer satisfaction and help enhance customer experience using NLP.
• Work on Text Analytics, Naive Bayes, Sentiment analysis, creating word clouds and retrieving data from Twitter and other social networking platforms using Python, Tableau, R and power BI.
• A team member of Analytical Group and assisted in designing and development of statistical models for the end clients. Coordinated with end users for designing and implementation of e - commerce analytics solutions as per project proposals.
• Conducted market research on property insurance trends; developed and designed sampling methodologies and analyzed the survey data for pricing and availability of clients' products. Investigated product feasibility by performing analyses that include market sizing, competitive analysis and positioning using Python, R and Power BI.
• Successfully optimized codes in Python to solve a variety of purposes in data mining and machine learning in Python.
• Facilitated stakeholder meetings and sprint reviews to drive project completion.
• Project experience in Data mining, segmentation analysis, business forecasting and association rule mining using Large Data Sets with Machine Learning.
• Have used Bigdata with Scala to expand traditional data sets with social media data, browser logs as well as text analytics and sensor data to get a more complete picture of customers.
• Involved in Data governance and Data Security across Enterprise level.
• Worked with AWS Redshift pushing data to cloud and making data available enterprise wide.
• Worked on End to End Data Warehouse SQL server design and development solution for Complex Claim Integration Project.
• Efficiently used ETL in various stages of Data Warehousing.
• Design data ingestion and integration process using SQOOP, Shell Scripts & Pig, with Hive.
• Performing Mapreduce jobs in Hadoop and implemented Spark analysis using
• Python. Develop data collection/consolidation pipelines for capturing all Claim and Vendor data using Flume/Sqoop and land data in HDFS.
• Designed and Developed Table Work Sheets and Dashboards in Tableau.
• Efficiently trained Report Users to use Tableau to create their Dashboards from pre-defined Work Sheets.

Confidential -Powell, OH

Data Analyst

Responsibilities:

• Responsible for the study of SQL Queries, Analysis enhancements and documentation of the system.
• Used R, Python and SQL to manipulate data and develop and validate quantitative models.
• Performed Analysis and Interpretation of the reports on various findings using R, Python, SSAS, Tableau and SQL.
• Efficiently Migrated packages from DTS to SSIS.
• Responsible for Developing, Monitoring and Deploying SSIS packages.
• Implemented Batch Logging, Error Logging for the SSIS packages.
• Parameterized Reports and Report Models using SQL Server Reporting Services (SSRS) based on client requirement.
• Developed data models in Power BI for enterprise solutions.
• Designed a Work Sheets and Dash Boards in Tableau.
• Have exposure to AWS, EC2, RedShift.
• Used Normalization and De - Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints
• Used advanced Microsoft Excel functions such as pivot tables and VLOOKUP to analyze the data .
• Developed some data pipelines using Python for new line of business.
• Various statistical tests performed for clear understanding to the client.
• Implemented procedures for extracting Excel sheet data into the mainframe environment by connecting to the Oracle database using SQL.
• Complete support to all regions (Test/Model/System/Regression/Production).
• Actively involved in Analysis, Development, and Unit testing of the data.

Confidential

SQL developer/Data Analyst

Responsibilities:

• Responsible for the study of SAS Code, SQL Queries, Analysis enhancements and documentation of the system.
• Used Python, R, SAS, and SQL to manipulate data, and develop and validate quantitative models.
• Brainstorming sessions and propose hypothesis, approaches, and techniques.
• Analyzed data collected in stores (JCL jobs, stored - procedures, and queries) and provided reports to the Business team by storing the data in excel/SPSS/SAS file.
• Performed Analysis and Interpretation of the reports on various findings.
• Responsible for production support Abend Resolution and other production support activities and comparing the seasonal trends based on the data by Excel.
• Used Tableau for creating dashboards.
• Used advanced Microsoft Excel functions such as pivot tables and VLOOKUP to analyze the data .
• Successfully implemented migration of client's requirement application from Test/DSS/Model regions to production.
• Prepared SQL scripts for Oracle and Teradata servers for analysis and modeling.
• Provided complete assistance of the trends of the financial time series data .
• Various statistical tests performed for clear understanding to the client.
• Implemented procedures for extracting Excel sheet data into the mainframe environment by connecting to the database using SQL.
• Complete support to all regions (Test/Model/System/Regression/Production).
• Actively involved in Analysis, Development, and Unit testing of the data.