Candidates About

 

Nic A

·         Highly skilled competent Data Analyst with 7+ years' industry experience in data analysis, data collection, validation, extraction, modeling, mining systems for data management, capturing, delivery and quality while supporting analysis and reporting in the areas of finance, Heath and telecom industries.

·         Strong working knowledge in Oracle, Asp.net, C#, SQL, PL/SQL, TSQL, SQL Server, MongoDB, DB2, Flat Files, MS Access.

·         Good knowledge of Hadoop bigdata and related technologies like Pig, Hive, Map Reduce. 

·         Monitored data entry, data auditing and creating data reports of all the data for more accuracy.

·         Expert in writing and optimizing SQL queries in creating aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters, views, stored procedures, triggers, jobs, and functions and work with both OLTP and OLAP database types.

·         Expertise in T-SQL in creating and using Views, User Defined Functions, Indexes, Stored procedures involving joins, sub-queries from multiple tables and established relationships between the tables using primary and foreign key constraints.

·         Experience with Implementing, configure and administer SQL server databases and experience working with Microsoft Server tools like SSAS, SSIS and in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS).

·         Expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.

·         Proficient in design and development of Dashboards and reports utilizing Visualizations tools like Power BI, D3.js, Tableau and experience working with Advanced Excel like Macros, VLOOKUP, Pivot Tables, with google analytics, SAS.

·         Good understanding of various Machine learning algorithms like Regression, Classification, Association, Clustering, Ensemble Methods and implementation in languages like python and R.

·         Experience with Data Warehousing mechanisms, including the use of Extract, Transform and Load (ETL) tools and creation of data marts using Pentaho Data integration tool and its components like spoon.

·         Well versed with Software Development Life Cycle (SDLC) methodologies like SCRUM, Waterfall and Agile.

·         Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization, Business Process Analysis, Dimensional Data modeling, FACT and dimensions tables, physical and logical data modeling.

·         Hands on experience in publishing various kinds of interactive data visualizations, dashboards, and workbooks from Tableau Desktop to Tableau Servers.

·         Experience in preparing Functional Requirement Document, High Level Design and Test Cases. 
Expertise in statistical modeling and analysis on study data by utilizing appropriate statistical methods. 

 

Data Analyst

BNP Paribas 

Oklahoma City, OK                                                                                           Feb 2017 to Present

 

Responsibilities: 

·         Wrote several Teradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.

·         Developed Python programs for manipulating the data reading from various Teradata and convert them as one CSV Files.

·         Performing statistical data analysis and data visualization using Python and R.

·         Worked on creating filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

·         Created data models in Splunk using pivot tables by analyzing vast amount of data and extracting key information to suit various business requirements.

·         Created new scripts for Splunk scripted input for collecting CPU, system and OS data. 

·         Interacting with other data scientists and architected custom solutions for data visualization using tools like tableau, Packages in R and R-Shiny.

·         Implemented data refreshes on Tableau Server for biweekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

·         Maintenance of large data sets, combining data from various sources by Excel, SAS Grid, Enterprise, Access and SQL queries.

·         Analyzed Data Set with SAS programming, R and Excel.

·         Publish Interactive dashboards and schedule auto-data refreshes.

·         Experience in performing Tableau administering by using tableau admin commands.

·         Created Hive queries that helped market analysts spot emerging trends by comparing incremental data with Teradata reference tables and historical metrics.

·         Responsible for creating Hive tables, loading the structured data resulted from Map Reduce jobs into the tables and writing hive queries to further analyze the logs to identify issues and behavioral patterns.

·         Developed normalized Logical and Physical database models for designing an OLTP application. 

·         Knowledgeable in AWS Environment for loading data files from on prim to Redshift cluster.

·         Performed SQL Testing on AWS Redshift databases.

·         Developed Teradata SQL scripts using OLAP functions like rank and rank () Over to improve the query performance while pulling the data from large tables.

·         Involved in running Map Reduce jobs for processing millions of records.

·         Written complex SQL queries using joins and OLAP functions like CSUM, Count and Rank etc. 

·         Involved in extensive routine operational reporting, hoc reporting, and data manipulation to produce routine metrics and dashboards for management.

·         Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau. 

·         Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

·         Experienced in migrating Hive QL into Impala to minimize query response time.

·         Responsible for Data Modeling as per our requirement in HBase and for managing and scheduling Jobs on a Hadoop cluster using Oozie jobs.

·         Worked on Spark SQL and Data frames for faster execution of Hive queries using Spark Sql Context.

·         Design and development of ETL processes using Informatica ETL tool for dimension and fact file creation. 

·         Develop and automate solutions for a new billing and membership Enterprise data Warehouse including ETL routines, tables, maps, materialized views, and stored procedures incorporating Informatica and Oracle PL/SQL toolsets.

·         Created UDFs to calculate the pending payment for the given residential or small business customer's quotation data and used in Pig and Hive Scripts.

·         Experienced in moving data from Hive tables into HBase for real time analytics on Hive tables. 

·         Handled importing of data from various data sources, performed transformations using Hive. (External tables, partitioning) 

Environment: SQL/Server, Oracle 9i, MS-Office, Teradata, Informatica, ER Studio, XML, Hive, HDFS, Flume, R connector, Python, R, Tableau 9.2

 

Data Analyst

IBM Watson Health 

Cleveland, OH                                                                                                            June 2014 to Dec 2015

 
Responsibilities

·        
Developed workflows for complete end to end ETL process starting with getting data into HDFS, validating and applying business logic, storing clean data in hive external tables, exporting data from hive to RDBMS sources for reporting and escalating and data quality issues.

·         Responsible for loading the data coming from different source using Sqoop.

·         Ownership in handling the post production issues. 

·         Expertise in handling health care files like PGF, HL7, 837 and claims.

·         Involved in probabilistic patient matching in production. 

·         Maintaining superior communication with the clients and modifying the production code based on their business need. 

·         Developed MapReduce programs in Pig to create the relationship between the data present in the Hadoop cluster.

·         Developed various Big Data workflows using Oozie.

·         Developed workflows to cleanse and transform raw data into useful information to load it to a Kafka Queue to be loaded into HDFS and noSQL database.

·         Developed MapReduce Programs in Ruby to map the data to the production environment. 

·         Responsible for importing and exporting data into HDFS and Hive.

·         Involved in quality assurance of the data mapped into production. 

·         Involved in code walk through, reviewing, testing and bug fixing.

·         Have good exposure to GIT, Jenkins, JIRA. 
 
Environment: Hadoop, MapReduce, HDFS, Sqoop, flume, kafka, Hive, Pig, HBase Eclipse, DBeaver, Datagrip, SQL Developer, intellij, GiT, SVN, JIRA, Unix

 

Data Analyst

Barclays 

Wilmington, DE                                                                                  March 2012 to March 2014

 

Responsibilities 

·         Experience with the development and testing teams about the ETL processes involved in the project.

·         Worked on Requirement Analysis, Data Analysis and Gap Analysis of various source systems sitting and coming from multi systems. Responsible for BI Data Quality.

·         Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices. 

·         Prepared Business Requirement Documentation and Functional Documentation. 

·         Primarily responsible for coordinating between project sponsor and stake holders. 

·         Conducted JAD sessions to allow different stakeholders such as editorials, designers, etc., 

·         Performed Business Process mapping for new requirements. 

·         Designed reports in Access, Excel using advanced functions not limited to vlookup, pivot tables, formulas.

·         Use SQL, PL/SQL to validate the Data going in to the Data Ware House.

·         Creating complex data analysis queries to troubleshoot issues reported by users.

·         Evaluates data mining request requirements and help develop the queries for the requests. 

·         Participated in sessions with management, SME, vendors, users and other stakeholders for open and pending issues Involved in reviewing/analyzing Business Requirement Documents/Functional specifications/use cases.

·         Worked with Business Analysts, developers while reviewing the Business Requirement Documents and when there are enhancements in the applications.

·         Defined data requirements and elements used in XML transactions.

·         Developed Test Cases for Deployment Verification, ETL Data Validation and Report testing.

·         Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.

·         Peer reviewed test cases developed by QA team members and advice/point/discuss possible complex scenarios and make sure requirements are completely covered.

·         Formulating various post production data quality and error handling SQL scripts.

·         Prepare Use case models based on Business Requirements documentation gathered through 
Analyzing Business requirement specifications and identifying the source data and transformations that needs to be applied in the process of moving data to target database.

·         Independently designed and developed project document templates based on SDLC methodology.

·         Exported Requirements, test plans and test cases to QC 9.2.

·         Created Traceability Matrix to ensure that all requirements are covered in test cases.

·         Prepared Kickoff meeting PowerPoint and gave presentation on testing activities for each cycle of testing and for different releases.

·         Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application. Expert in writing Complex SQL/PLSQL Scripts in querying Teradata and Oracle.

·         Conducted Defect meetings on daily bases to track defects status with functional leads and to speed up resolution process at end of each cycle.

·         Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting Test cases, Test Scripts in Quality Center 9.2

·         Created defects, manage defect reports and defect status in ClearQuest tool.

·         Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation. 
 
Environment: Informatica Power Center 8.6(Repository Manger, Designer, Server Manager), Oracle 10g, MS SQL, HP Quality Center 9.2, Requirement traceability Matrix (RTM), XML, Assistant, Teradata V2R6, Teradata SQL Assistant, IBM DB2, SSAS, SAS/Stat, SAS/Graph, SAS/ODS, SAS/SQL, SAS/Connect, SAS/Access, IBM Rational ClearQuest 7.0, TOAD, Business Objects, MS Excel, MS Project.

 

Data Analyst/Business Analyst

Caresourse 

Columbus, OH                                                                                                March 2010 to January 2012

 

Responsibilities

 

·         Involved in Business and data analysis during requirements gathering.

·         Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.

·         Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.

·         Defined data requirements and elements used in XML transactions.

·         Reviewed and recommended database modifications.

·         Generated and reviewed reports to analyze data using different excel formats.

·         Documented requirements for numerous adhoc reporting efforts.

·         Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.

·         Designed developed and implemented 2 professionally finished systems for tracking IT requests, and providing a data repository about reports. Documented all system functionality.

·         Participated in testing of procedures and data, utilizing PL/SQL, to ensure integrity and quality of detain data warehouse.

·         Metrics reporting, data mining and trends in helpdesk environment using Access.

·         Identify and report on various computer problems within the company to upper management.

·         Report on trends that come up as to identify changes or trouble within the systems using Access and Crystal Reports.

·         Guide, train and support teammates in testing processes, procedures, analysis and quality control of data, utilizing past experiences and training in Oracle, SQL, Unix and relational databases.

·         Maintained Excel workbooks, such as development of pivot tables, exporting data from external SQL databases, producing reports and updating spreadsheet information.

·         Created cases for settlement claims analysts by printing documents from a website that maintains information, regarding settlement claim data, compiled documents and updated settlement claim data into database system.

·         Created Excel pivot tables, which showed a table of users that, have not performed scanning of journal voucher documents. Users could find documents by double-clicking on his/her name within the pivot table.

·         Load new or modified data into back-end Oracle database.

·         Optimizing/Tuning several complex SQL queries for better performance and efficiency.

·         Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.

·         Worked on issues with migration from development to testing.

·         Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.

·         Tested analytical reports using Analysis Studio. 
 
Environment: Informatica Power Center (Power Center Designer, workflow manager, workflow monitor), SQL *Loader, T-SQL, Oracle, SQL Server 2000, Erwin, Windows 2000, TOAD