Objective: To fill a position in which I can use my natural abilities, knowledge, and acquired skills to effectively serve my employer, its customers and employees.

Professional Experience:

• Sr.Data Analyst, IT Analysis : Jan 2011 –Present

Confidential,Columbus,OH

• Perform data profiling on huge sets of data by querying the databases using Teradata SQL assistant and Teradata warehouse miner to see common trends in data and develop an understanding on the nature of data.
• Attend business user requirements sessions to gather requirements and develop overall business knowledge to help analyze huge set of data more efficiently.
• Work as a data analyst/data modeler in projects as needed and work closely with Data architects/SME’s to make logical decisions around building new attributes, documenting transformation rules for the same.
• Conduct design walk through to help ETL team understand the source, staging and target transformations.
• Work very closely with the Information delivery (Microstratgey Team) team to help them have a better understanding of the design of the new/GAP attributes and help them create reports based on the user requirements.
• Develop strong understanding of ETL flows, staging and source system data nature.
• Work closely with QA team to support issues reported during UAT/System testing before the project is released in production.
• Work as a data modeler.
• IT Summer Intern: June 2010-Dec 2010

Confidential,Infrastructure team.

• Image processing in Teradata: As part of my IT internship with Nationwide Insurance, single handedly carried a project to learn to process image (BLOB) in Teradata and retrieve it using java servlet on Apache Tomcat Server 5.5
• Jobs learned at IT internship:
• Learned Teradata SQL and using Teradata SQL assistant tool to query huge set of Insurance related data..
• Teradata BTEQ
• Hyperion Administration.
• Microstrategy project testing.
• Working with Informatica to create mappings, generate workflows and subsequent troubleshooting.
• Graduate Associate: Fall 2009-Spring 2010

Math GA, Tutoring services, Academic Advancement Center
Confidential,
Lab Assistant: Summer 2009
Computer Lab, Academic Advancement Center

• Confidential,
• Graduate Teaching Assistant August 2007 –June 2009

Confidential,
Education:

• Master of Communications Technology and Policy Master of Science

Applied Mathematics with Computer Science

• Post Graduate Diploma (GPA – 3.8/4.0)
• Diploma in Computer Application

Bachelor of Science
Physics (Honors)

Technical Skills:

• Platforms: Teradata,Oracle,SQL Server, Linux, Unix Shell
• Languages: C, C++,Advanced Teradata SQL, UML Use Cases.
• Tools: Teradata SQL Assistant, Nexus Query Chameleon, Erwin Data Modeling Tool,Informatica,Microstrategy,HP Qulaity Center,T2S access database for documenting data mappings
• Requirements Gathering Experience:
• Successfully Completed ESDM Requirements Lead Bootcamp process.
• Experience in conducting requirements elicitation processes like JAD sessions to capture functional/non functional requirements.
• Experience in creating BAD,BOM,SRD,Target to Source data mapping documents, Use cases etc during the various phases of ESDM standard.
• Help maintaining the Risk logs, Issue logs
• Familiarity with MAW sessions
• Software development methodology:
• ESDM : Well acquainted with the various phases of ESDM model and the extent involvement of a Requirements Analyst/Data Analyst in Initiate, Solution Scoping, Design phases of BI Application development.
• Agile Methodology: Well Acquainted with the Agile/Iterative software development methodology as a requirements analyst for building a BI Application.
• Waterfall model :Well acquainted with the various cascading phases of waterfall model.
• Application: MS Office suite, Microsoft Visio
• Statistical software :Minitab, EXCEL(DATA ANALYSIS TOOL), Teradata Warehouse Miner, Informatica Data Visualizer
• Process Management Experience:
• Successfully completed Six Sigma (Equivalent Green Belt) course work
• Finished a project during course work following steps of DMAIC process
• Networking Protocols: DHCP, DNS, SMTP, SNMP, PING, SSH, TELNET, FTP, SIP and MGCP.

Projects:
Job Related:

• Shadowed and assisted Data lead to complete two Continuous production enhancement projects for Property line of Business at Nationwide Insurance to add required attributes to the Hybrid model. Facilitate documentations to developers to bring source fields from staging databases and help the QA team to design their test cases. Help create the target to source data mapping documentation. Assist testing team during system testing and resolve any design related issues or questions.
• Worked as Sr.Data analyst on AP2 (Auto Phase 2) project for Auto line of business to help build an integrated report (CONSOLE) using microstrategy for business users by merging Allied (Des Moines) platform data with Nationwide (Columbus Platform) data by retiring old legacy systems/databases and bringing in GAP attributes from the legacy data marts alongwith a new product which didn’t exist previously into the Hybrid data model.
• Conducted detailed business requirements elicitation sessions with business users to determine the gap attributes, their transformation rules, user end names to be displayed, level at which the attributes need to reported and document them in design doc (T2S mapping) document.
• Co-ordinate with SME’s/Data architects to develop Anchor ID’s for the new product to the be included into the hybrid system.
• Worked with lead data modeler to model GAP attributes to target table by performing detailed analysis.
• Work closely with project troika to co-ordinate environment set-up,help create ICR’s to migrate DDL’s from Dev to QA to Prod.
• Work closely with business, data leads, and data architects to determine the rules for major metrics (KPI’s) to be reported on the front end report builder.
• Single handedly performed analysis to develop new rules for the GAP attributes to be integrated in the Hybrid Model, additional join criteria’s, row building rules wherever necessary.
• Worked on developing new rules for loading claims data to the Hybrid model for the new product(Boats) and modify the load strategy as per requirement.
• Analyze Manuals system to ensure that we do bring in the policies entered manually by agents on front end. Do detailed analysis of the source system data to build rules to integrate into the hybrid model for the new product.
• During, UAT and system testing, help solving design as well as ETL issues by working closely with developers/testers.
• Co-ordinate with business and reference table management administrator to ensure that the fields which has correct descriptions and Type values entered in the reference table management cross reference table.
• Also, worked as a requirements/Data analyst in developing the BI application using agile methodology. Familiarity with agile ATDD (Acceptance Test driven development) environment, creating acceptance criteria to help developers build a piece of code and testers to test it, Actively participated in Iteration planning, release management meeting, show and tells,Retorspective. Familiarity with GHERKIN language.

Coursework Related:

• Created a database on a Health Insurance Company and used JDBC to connect the user front-end:

The database was created on Oracle 9i and using SQL following RDBMS, used JDBC to connect to the user end.

• Developed a 3D virtual conference center for Ohio University on Torque Game Engine using a complete software development process:
• The conference center was developed using latest gaming and virtual environment engines. It was developed on Torque engines platform and was coded in Torque’s Language which is a C++ like language. It consisted of the all the dynamics of a virtual conference center.
• The Project is an Engineering Management Contact Sheet to keep an account of the Alumni Information.
• Extensive SQL queries to create the database on phpMyAdmin.
• Used PHP and HTML to create the user end contact sheets.
• Project on Switch outages, coming up with research question and hypothesis related to the data found.
• Analyzing switch outage data from ARMIS website for all COSA and local telephone companies.
• Coming out with an analysis of the data using statistical software like SPSS and EXCEL, to predict the possible causalities of switch outages and graphical notation of the same, hence formulating a hypothesis based on that.
• ITS Challenge, 2010: Worked with my team to create RFP following different stages of project management to propose changes to the IT division of a pseudo company called Oxygenius Corporation.
• The project focused on long term cost saving for the three different divisions of the IT organization.
• Present an overview and highlight the changes proposed based on the system requirements.
• Discuss the risks and benefits along with detailed cost savings account sheets/ROI breakdown.