SUMMARY

• An experienced, enthusiastic, professional on Data Analyst whois engaged by working with visionary people and brands. I welcome fresh challenges and have an aptitude to assimilate new knowledge readily adapting to rapidly changing business needs.Experienced in supporting leading brandswith the focus on exceeding expectations for customer serviceand going above and beyond the call of duty. I am attentive to detail with a “can do” approach ensuring tasks are completed to a high standard, objectives, targets and deadlines are met.I am self - motivated and am able to work well on own initiative as well as enjoy working as part of a team.
• Seeking a challenging position within a fast paced environment that enables me to add value and strengthen my development skills.
• I have experience in web development, database management, programmingand team management; supporting a vast international client base working towards ever changing business needs and deadlines.

TECHNICAL SKILLS:

Databases: Oracle 9i & 10g, MySQL, DB2 & MS Access,Teradata, MS SQL Server 2008/2005/2000

Database tools: Ab Initio GDE 1.15,SQL developer, TOAD,Teradata SQL Assitant,IDQ

Application Software: R, Tableau, Crystal Reports, BI.

Job Function: Data Analysis, Data validation, Data Profiling, Business Analysis, System Analysis and Design.

OS/Environment: HP Unix, DOS, Windows XP/Vista, Windows 7.

PROFESSIONAL EXPERIENCE

Data Analyst/Programmer Analyst

Confidential - Columbus, OH

Responsibilities:

• Analyzed customer data to generate insights using data mining techniques in Teradata (SQL), R programming.
• Extracted and filtered data from big database Teradata using SQL to use for data analysis.
• Visualized online shopper transactional data using ggplot2 plotting techniques in R.
• Automated generation of key metric reports to monitor internet sales performance using CSS, HTML and RMD.
• Analyzed online shopper behavior with respect to demographics and insurance risk.
• Analyzed auto insurance coverages to optimize revenue generation on Nationwide’s website.
• Designed and executed A/B testing to improve the performance of online auto quoting system. As a result, the Bodily Injury downgrade rates of shoppers decreased from 21% to 2.4%.
• Provided Consulting for cross-functional Nationwide.com strategic team and for ad-hoc requests from other departments - Internet Optimization, Product and Pricing.
• Documentation delivery and sign off for each of Automation Script.
• Worked with DA Prod team to make the scripts run as per the schedule.
• Verified the Waterfall numbers between manual run and the automation results for the change control documents.
• Involved in the creation of change control document(Every script needs to get approval from the change control team before moving into production).

Environment: Windows XP, UNIX, Teradata, Ab Initio 2.14/2.15, SQL Assistant, Crystal Reports, MS Excel, MS Power Point

Data Analyst

Confidential - Columbus, OH

Responsibilities:

• As a member of DA prod team, worked on developing unix shell scripts to automate sql scripts.
• Tested the code in prep env and validated the results.
• Submitted the change order to deploy code into production once the sign off is received from DA owners.
• Scheduled processes using the control M scheduler and automated the email delivery to DA owners.
• Worked with EPC team to resolve issues with change orders and control M scheduling issues.
• Involved in submitting quotes to run adhoc requests as well as one time changes. Worked with CCUnix team for Incident Resolution.
• Involved in working with business users to gather the requirements and writing SQL code using Teradata.
• Migrated the code from PROD env to PREP env for enhancements in production code and worked on various issues involved in sql coding.
• Performed various data pulls from Teradata One View Data warehouse using SQL Assistant.
• Performed data validations before submitting the change order to deploy the code to prod.
• Coded using TERADATA SQL. Wrote unix scripts to validate, format and execute the SQL’s on unix environment.
• Monitoring the existing code performance and to change the code for better performance.
• Implemented data quality checks on teradata tables using specific dataquality rules(null,domain,value variance) with in-house developed data quality monitoring tool.
• Generated DQ score cards as per business requirements.
• Used sql assistant to query the database objects to validate the data quality.
• Performed data profiling to discover data quality issues using Informatica Data Quality Analyst.
• Created column level profiling using the live data and appropriate filters.
• Profiled source data using IDQ tool, understand source system data representation, formats & data gaps.
• Created Exception handling process and worked on the best practices and standards for exception handling routines.
• Contributed and maintained a library of reusable test plans for future projects/enhancements.
• Performed profiling at UAT and Post Production stages.
• Designed and developed Adhoc reports as per business analyst, operation analyst, project manager data request.

Environment: Teradata SQL Assistant, UNIX, IDQ, Tableau, Microsoft Office

Data Analyst

Confidential, Chicago, IL

Responsibilities:

• Work with users to identify the most appropriate source of record and profile the data required for sales and service.
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Involved in defining the business/transformation rules applied for ICP data.
• Define the list codes and code conversions between the source systems and the data mart.
• Worked with internal architects and, assisting in the development of current and target state data architectures
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines
• Assigned tasks among development team, monitored and tracked progress of project following Agile methodology.
• Responsible for defining the functional requirement documents for each source to target interface.
• Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling.
• Evaluated data profiling, cleansing, integration and extraction tools(e.g. Informatica)

Environment: SQL/Server, Oracle 9i, MS-Office, Agile,Teradata, Informatica, ER Studio, XML, Business Objects

Business Data Analyst

Confidential

Responsibilities:

• Acted as primary liaison between the client departments and the Information systems IT department to perform analysis, review, and estimation of client requests, prepared and reviewed requirements and client documentation for Personal Lines Property and Casualty business.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational RequisitePro.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams and Business Process Modeling.
• Reviewed Development Plans, Quality Assurance Test Plans and User Documentation to ensure correct interpretation of original specifications.
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Matrix
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.

Environment: Microsoft Office, Oracle 9i, Rational Clear Case, XML, MS Visio and Manual Testing

Quality Analyst

Confidential

Responsibilities:

• Automated the manual scripts used for regression testing using QTP (Quick Test Professional) and VBScript for PeopleSoft application.
• Worked extensively in functional areas like PeopleSoft Finance, Supply Chain and Inventory modules.
• Extensive use of QC (Quality Centre) for defect logging, tracking, debugging.
• Plans, researches, organize, analyze and complete special projects within specific department/division or facility as a whole.
• Participates in documentation processes, obtaining, compiling, maintaining and issuing necessary records, reports, data or lists, ensuring accuracy of content and correct distribution.
• Develops and implements plans to meet Children's Hospital goals.
• Promotes teamwork by building a team environment and fostering cross functional collaboration.
• Maintains strict confidentiality of employee and company information.
• Attends relevant training courses on policy and compliance.
• Performs additional duties, as assigned.

Environment: SQL/Server, Oracle10&11g,MS-Office,Embarcadero,Netezza,Terradata, Enterprise Architect, Informatica, Data Mining, ER Studio, Agile, XML, Informatica, OBIEE