SUMMARY:

• Domain knowledge in Financial, Health - Care, Manufacturing, Insurance and Life Science sectors.
• Ability to translate business requirements into technical requirements.
• Ability to write complex SQL queries in Oracle, Teradata and SQL server.
• Performance tuning of SQLs using explain plans, indexing and collecting statistics.
• Utilized AWS for creating of EC2 instances, S3 for data storage and managing accesses in Confidential .
• Utilized Python, Flask, Bootstrap, HTML5 and CSS for Interactive Web Page creation in Confidential .
• Utilized Microsoft Azure with Jupyter Notebooks to run PySpark and Databricks code at Confidential .
• Facilitated the requirement gathering, grooming and retrospective meetings in Sprints in the Agile world.
• Ability to write shell scripts in UNIX and work with Vi editors and Cron for job scheduling.
• Analyzed user requirements, designed the code, tested and wrote user documents as a part of SDLC.
• Ability to support Client-Server applications and it’s development.
• Utilized the process improvement knowledge for cost saving and quality maintenance using Poke Yoke, Six Sigma and Kaizen.
• Ability to model data warehouse by Conceptual, Physical and Logical Data modeling techniques with Erwin.
• Created data dictionaries, control and flow diagrams, tables, views, DDLs, DMLs, ETL Specification documents and Source to Target mapping documents.
• Extensive experience with Tableau client for creation of Tableau Sheets, Dashboards and Story boards with development of complex visualizations helping business decisions to derive cost and budgets for future.
• Utilized Tableau Server for dashboard report publishing and distribution.
• Co-ordination with upstream and downstream systems and teams for production job run statuses.
• Ability to identify, bucket and secure the Non Public Information (NPI) data to avoid data breaches.
• Facilitated and participated in end-to-end project executions.
• Ability to write User manuals, Low and High Level Design document, Functional and Technical documents.
• Experience with Configuration Management activities
• Ability to deliver error free, efficient, high quality and first time right code.

TECHNOLOGY STACK:

OS/Environment: DOS, UNIX, Windows NT, Windows XP, Windows 7

RDBMS: Oracle SQL 8i to 10g, Teradata 13.0 to 15, MS-Access, SQL Server, DB2

Reporting: MS Excel, Business Objects, Tableau Desktop and Tableau Server 9x, Cognos

Languages: SQL, PL/SQL, UNIX Shell Scripting, Python, HTML 5, CSS, Bootstrap, Flask, Splunk,SAS

Data Modeling: Logical, Physical, Fact and Dimension tables, Erwin

Cloud Technologies: AWS and Microsoft Azure

Data Warehousing: Erwin, Informatica Powercenter 9.1/8.6/7.1.2 , Data Stage

File Manipulations: Textpad, Editplus, Notepad++, Wordpad, UltraEdit, UNIX Vi Editor

Version Control: RCS, CVS, PVCS, SharePoint, GITHub, WIKI, VersionOne, Visual SourceSafe.

Tools: Toad, PL SQL Developer, Teradata SQL Assistant, SQL Developer, Pycharm, Putty

File Transfer: WS-FTP, Filezilla, UltraEdit

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Senior Data Analyst

Responsibilities:

• Data Analysis using Teradata SQL Assistant, UNIX shell scripting, data modeling in Erwin and reporting in Tableau.
• Facilitated business meetings to lock down the functional/non-functional requirements from the BA/Product owner.
• Validated the Consumer Marketing Datamart utilizing data models and existing table relations.
• Utilized complex SQL queries in Teradata for deduping, integrity checks, and validating data redundancies.
• Created the ETL specifications document, designed conceptual and physical data model and Source to Target map
• Created Teradata tables with consolidated data from various heterogeneous sources so that the data is at one place and which can be utilized later for reporting purposes to study customer patterns.
• Optimized Teradata queries for performance using Explain plan, Statistics gathering and indexing.
• Utilized Excel and Tableau to create analytical dashboards for Sales, Web Visits, Leads, Phone and Email Marketing related parameters for the leadership team along with trend and location analysis using maps.
• Developed Tableau reports for activities like Sales, Purchases, Appraisals, Services, Credit and Vehicle transfers.
• Published these dashboards on the Tableau Server, granted access and scheduled them to run Daily.
• Rewrote new stored procedures for handling customer Offline (Store visit) to Online (Online activity) linking.
• Updated of the daily tracker and issue logs as part of the BAU activities.
• Utilized the Metadata documentation to acquire knowledge about the Customer Data Mart and it’s data model
• Trained the developers on Peer to Peer Code Reviews, Unit and Integration Testing and debugging
• Utilized Salford systems TreeNet tool for model building and predictive market analysis.
• Utilized Microsoft Azure for storing huge files in datalakes and manipulating them as per business requirements with tools like DataBricks/Pyspark in Jupyter Notebooks
• Team building activities included facilitating daily standups, stakeholder meets, analytics daily catchup meetings etc.

Confidential, Richmond, VA

Senior Data Analyst

Responsibilities:

• Data Analysis with Teradata SQL Assistant, Oracle SQL Developer, UNIX shell scripting, data modeling in Erwin, reporting in Tableau and data pattern searching in Splunk.
• Facilitated business meetings to work on the functional/non-functional requirements from BAs/Product Managers.
• Teamed up with upstream and downstream businesses and technical SMEs for efficient handshake of requirements.
• Utilized complex SQL queries in Teradata for checking data redundancies and designed UNIX shell scripts to tackle them automatically and by using Cron schedulers.
• Designed ETL specification documents that included links to the detailed external documents.
• ETL spec documents had examples of logical dimensional model, the physical database model, the source-to-target map, and the data profiling
• Teamed with the development team to ensure data is current with fields of interest and which can be utilized for complex data analysis.
• Created logical and physical data models for traversing proper data access paths for efficient future design.
• Created Oracle and Teradata tables with consolidated data from various heterogeneous sources so that the data is at one place and which can be utilized later for reporting purposes to study customer patterns.
• Created credit limit validation applications using Python, Bootstrap, CSS, HTML3 and Flask.
• Created performance optimization scripts for inefficient queries using various Teradata optimization strategies.
• Utilized SPLUNK for pattern searching of operational subject area by deriving valuable info from the machine logs.
• Utilized UNIX for directory and file manipulations and shell scripts for executable jobs.
• Utilized Excel and Tableau to create analytical dashboards and help the leadership team with trend analysis and location analysis using Tableau maps.
• Published these dashboards on the Tableau Server and scheduled them to run Daily.
• Projected cost saving initiatives by utilizing the Six Sigma, Poka Yoke and Kaizen knowledge for data quality.
• Updated the daily tracker and issue logs for the production jobs as additional responsibilities.
• Reported and escalated forecasted issues to management and maintained comprehensive project documentation
• Trained the team in Code Reviews and Unit and Integration Testing and debugging
• Worked on creating EC2 instances, S3 data storage buckets and access rights management in AWS for Teradata to Redshift migration.

Confidential, Bridge Water, NJ

Data Warehousing Analyst/Architect

Responsibilities:

• Involved in full capacity as Data Warehousing Analyst for the new Sanofi Cognizant NAAMS engagement
• Performed GAP analysis, feasibility analysis to validate the data requirements against existing attributes in the target database.
• Wrote complex SQL queries against the DW to check data integrity, data consistency and overall data management
• Trained the team in Code Reviews and Unit and Integration Testing and debugging
• Created ETL specification documents and included links to the detailed external documents
• ETL specification documents had examples of logical dimensional model, the physical database model, the source-to-target map, and the data profiling
• Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Sequence Generator, and Update Strategy with heterogeneous data sources.
• Defined target load order plan and constraint based loading for loading data correctly into different target tables.
• Designed and created data quality baseline flow diagram, which includes error handling and test plan flow data.
• Performed source system analysis to identify the source data that needs to be moved into the target tables.
• Developed project communication deliverables like roadmap, project plan and product backlog for future releases.
• Performed the data mapping exercise from source system to target data attributes.
• Conducted workflow, process diagram and gap analysis to derive requirements for existing systems enhancements.
• Involved in providing solutions to the business problems, scope of work identification and deliver best code quality.
• Liaison between business analysts and technical team during development and testing phase
• Developed Tableau reports for pattern analysis of source data from the business to create first time right error free reports using reference lines, annotations, tableau actions and embedded URLs of partner companies.
• Published the Tableau reports and scheduled them on the Tableau Server with relevant accesses to the relevant teams. Encouraged the leadership teams to subscribe to them on daily basis.
• Involved in identifying data quality issues for further analysis and resolving root cause issue for data failure.
• Prepared flow diagrams, swim lanes and technical specifications using Microsoft Word and Visio.
• Implemented process improvements utilizing quality assurance knowledge of Poka Yoke and Kaizen.
• Teambuilding sessions with team members on the enhancement opportunities and cost saving initiatives.

Confidential, Richmond, VA

Senior Data Analyst

Responsibilities:

• Facilitated business meetings with BSAs and stakeholders to work on functional/non-functional requirements.
• Developed UNIX shell scripts for batch process and utilized Teradata and Oracle SQL for data storage and querying.
• Developed and utilized MLoad, Fload, TPump and Fast Export Teradata tools both in ETL and UNIX scripts for flat files
• Extracted data from production DB (Oracle) and created financial reports using oracle SQL, PL/SQL, Teradata, and BTEQ.
• Performed Impact Analysis on existing data for the new requirements and study dependencies and impediments
• Optimized high volume tables by various join indexes, secondary indexes, join strategies and hash distribution methods
• Utilized Performance Monitor tool, Teradata View Point to monitor query performance
• Performed Data validations based on transformations, lineage and extraction.
• Designed BTEQ Scripts to access data from Teradata source system and to generate Reports using MS-EXCEL for weekly.
• Created several Multiload / Fastload scripts to load the staging/target tables.
• Analyzed and researched the data issues by creating Tableau dashboards for checking the trends and to advise leadership for corrective actions based on the trend study.
• Collaborated with various upstream and downstream teams including the business, BSAs, other development teams and technical SME teams for getting and confirming requirements which will further help in analysis.
• Executed SQL queries utilizing TOAD to retrieve data from multiple tables and to check database values
• Wrote DDL scripts to create tables, views and indexes in the Data Warehouse.
• Created different types of Indexes, Joins, Spaces etc. for optimum performance.
• Wrote SQL queries to ensure data consistency and integrity by filtering corrupt data and implemented DB Triggers.
• Designed Shell Scripts for automation and utilized Cron for scheduling those UNIX scripts on Production servers.
• Analyzed corporate database information to resolve data accuracy and integrity problems
• Performed gap analysis to identify the system nuances and to check compatibility of the existing system.

Confidential, Richmond, VA

ETL Data Analyst/Architect

Responsibilities:

• Data Analyst handling the ClearCourse/GroupVA module analysis.
• Facilitated business meetings to work on functional and non-functional requirements from the BA/Product Manager.
• Loaded data in the data warehouse using Informatica, queried using Teradata and reported on it using Tableau.
• SME for Network Strategy Projects for ClearCourse product using SQL queries and modeling using Erwin.
• Reported Weekly project updates to the client for discussing risks and mitigation plans.
• Facilitated stakeholder meetings for retention ideas or initiatives for the customers who are probable to attrite soon based on the pattern analysis from the Tableau reports.
• Performed Predictive market analysis and alerted the leadership team well before hand the risks/advantages involved in signing new contracts, consolidating or setting up new centers based on the trends seen on the Tableau.
• Teamed with the business and code development teams to ensure data is current with fields of interest and which can be utilized for complex data analysis
• Created tables with consolidated data from various heterogeneous sources so that the data is at one place and which can be utilized later for reporting purposes to study customer patterns and behavior.

Confidential, Richmond, VA

ETL Developer

Responsibilities:

• Maintained the production log, analysis, abend history and data loads solving production load failures
• Validated data inconsistencies/accuracy/integrity and tuning of loads for better efficiency.
• Worked on ETL Mapping design using Informatica and utilized heterogeneous data sources as databases.
• Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Sequence Generator, and Update Strategy.
• Wrote complex queries in SQL to guarantee the accurate loading of the data.
• Interacted with the business users and providing them presentable quality data as a part of WMS data requests
• Configuration and Change management activities were performed.

Confidential

Software Developer

Responsibilities:

• Requirement gathering and analysis.
• Coded using SQL loaders, SQL and Unix shell scripting
• Used reporting tools like MS Excel using Pivot tables and Charts
• Created user tables and queried them using Oracle SQL
• Applied process improvements utilizing Kaizen, TPM, Six Sigma, Lean, TQM, MOST, Poka Yoke
• Configuration Management utilized the Visual Source Safe tool.