OBJECTIVE:

Seeking a full - time 2019 job opportunity with excellent skills in system and data analysis, design, development, ETL(Talend),data modeling (MS Visio,oracle data modeler), data cleansing/scrubbing (Maestro,Tableau Prep),reporting (Tableau, Cognos,Power BI) and support using a range of databases like Oracle database 10g/11g, SQL, T-SQL, MS SQL for over a period of around 5 years.

TECHNICAL SKILLS:

TABASES: Post Gres sql, Oracle 10g/11g, MySQL 5.6, T-SQL, SQL Server 2008

LANGUAGES: SQL, R

TOOLS: Talend Studio(ETL),Project Maestro, TableauPrep, TOAD 8.5, SQL-Developer, SQL*Plus, SQL*Loader, Import and Export, Microsoft suite (Excel, Access), MySQL Workbench, Tableau, Cognos, Power BI

DATA MODELING TOOLS: Erwin, MS Visio, Oracle Data Modeler, Lucid Chart

OPERATING SYSTEMS: Windows, Unix, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta GA

IT Analyst/Data Engineer and Modeler

Responsibilities:

• I nvolved in reporting requests (ad-hoc and scheduled) from key systems like Ceridian (Payroll system), HGC (Compliance system), bullhorn (ATS system) as per the business requirements.
• Performed data analysis whether related to spotting some issues or studying the trend to facilitate in strategic decision making.
• Worked on Oracle Data Modeler/MS Visio for mapping both user-defined and default data types and creating Database Design (Physical and logical) for CAP(Consultant assignment portal -Onboarding portal), ODS etc.
• Being an SME of multiple systems, act as a first level reviewer/testing data for testing certain features, workflows as needed. Completion of user stories in an agile software development environment.
• Acted as a liaison between client/user and the development team walking through few requirements by preparing artifacts (technical/business rules, mapping documents etc.) which will ease the development process across multiple systems.
• Analyzes the ETL code to extract data mapping details and upload to metadata management tool to establish data lineage traceability.
• Employs techniques to create data and reporting requirements (artifacts).
• Engages in data profiling activities to identify any data quality issues.
• Worked in all phases of the life cycle including analysis, design, development, testing, deployment, post-production support/maintenance, documentation and end-user .
• Acted as a data steward for ODS (Operational Data Store) worked on maintaining a repository for users, static data and updated views accordingly in ODS and syncing up across different applications.
• Involved in developing talend (ETL) job for all the static services in projects as part of the drop-down list of values.
• Involved in key migration activity of integrating and migrating multiple sources of data into one system (extensive use of sql and ETL).
• General knowledge and involvement in building of Master ODS(operational data store), Data Governance, and/or Enterprise Information Management.
• Mastered the ability to design and deploy rich graphic visualizations using drill down and drop down menu option and parameters using Tableau.
• Worked Closely with business users. Interacted with ETL developers, Project Managers and members of the QA and development teams.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

Environment: Oracle 11i, SSMS 2008, Talend(ETL), Toad, Oracle Data Modeler, MS Visio, Tableau, Tableau Prep,Cognos. Payroll System Reporting Environment, Windows, Linux, Tableau, salesforce, Agile/Scrum methodology.

Confidential, Atlanta GA

SQL Developer and Data Analyst

Responsibilities:

• Expertise in configuring the instance in eThority tool as per the Configuration Acceptance document approved by Business Analyst and Activation Manager. Experience in Configuring the CORE Instance that involves data files like Employee, Leave of Absence & Payroll with single feed and multiple feeds, single control group or multiple control group at the same time preparing Instance Verification document for all the CORE instances that describes the detailed information about the instance.
• Experience in Configuring the IRS Instance that involves data files like Benefit Plans, Dependent Benefit Plans, Employee Benefit plans, Non-Employee Demographic files with single and multiple feeds depending upon the different version of Specification files produced by client for their individual instances.
• Experience in modifying the instance and purging (i.e. clearing the data from the database) the data required by the specific client to get the clean validation pass for the files submitted.
• Ability to analyze the data by performing extract, transform & load function mentioned by clients to process and get the accurate feedback that includes cause of warnings & failures. Ability to explain the cause for the loss of records when the data moves from import table to Transformation table.
• Ability to analyze the problems occurring with the clients data by verifying the contents of the file to make it work and provide accurate feedback by providing the exact cause of the problem along with its fix. Ability to analyze data in the database (SSRS i.e. SQL Server Management Studio) by running SQL queries & troubleshoot the issues related with the clients data.
• Experience in performing Regression testing i.e. finding the loopholes or bug in the tool by building up the test data as per the test cases which is then sent to the development team to develop a patch for that in order to fix the issue. Experience working with large amounts of data: facts, figures, and number crunching. Ability to see through the data and analyze it to find conclusions.
• Use computational tools such as R, SQL, programming languages and other tools on a daily basis to produce algorithms used for analysis, forecasting, and reporting.
• Experience in mentoring the new joiners about the project and them about how to perform data analysis, extract transform & Load function using ETL tool, identify the discarded or duplicate records from the client data and the reason for the same, how to follow up with Activation managers and Business analyst for the issues in Configuration acceptance document, Core/IRS Specification document and resolving the same.

Environment: T-SQL, SSMS 2008, Toad, Oracle 11i, PL/SQL Developer,eThority, R programming language, UNIX, Shell Scripts, Windows, Linux, Power BI, Tableau.