SUMMARY

• 7+ years of professional experience in Analysis, Design, Development, Support and implementations of application in Client/server environment using Oracle 10g/8i/8.0/7x, Developer 2000, SQL, PL/SQL, Forms 4.5/6i, Reports 3.0/4.5/6i.
• Extensive experience in Conducting requirement workshops to create mapping documents for ETL projects source data identification and analysis.
• Profiling and scanning of data using PL/SQL Stored procedures, Database Triggers.
• Oracle based application software design, development and implementation and application maintenance.
• E - R diagrams and Normalization Techniques of tables.
• Analyzing business requirements and translating into functional specifications, system designs
• Data analysis and adhoc reporting by writing queries on Oracle, SQL Server and MS Access.
• Expertise in Microsoft office suite.
• SDLC (Software Development Life cycle) and Test Planning Process.

TECHNICAL SKILLS

Operating Systems: Windows7, Windows Vista, XP

Data Bases: Oracle9i,11g, MYSQL, MS Access, SQL server 2005, Teradata.

Database languages: SQL

Applications: SAS, Microsoft Office, Word, Excel, PowerPoint, Project, Visio.

Web Languages: HTML, XML, PSP

Front end Developing tools: developer 2000(Forms6i/4.5, Reports6i/2.5)

ETL Tools: Informatica 9.x, Data Stage 6

Reporting Tool: BO XI 3.2

Test Management Tool: HP QC / ALM

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

Sr. Data Analyst

Responsibilities:

• Created customized and adhoc reports for various campaign execution based on certain criteria.
• Scrubbed data to accurately generate customer pull. Provide output files in various file format based on customer request.
• Reviewed specifications for feasibility of customer list pull criteria and commit date
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Involved in requirements analysis by interacting with analysts for the creation of Data marts using Informatica.
• Write SQL queries to validate source data and created mapping document for the target data.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Created ETL execution scripts for automating jobs.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used TOAD Software for Querying ORACLE and Used WinSQL for Querying DB2.
• Incumbent data warehouse was having trouble keeping pace, and its slow response time was preventing users from getting necessary information in time to be useful. After realizing significant performance, we decided to migrate to Netezza
• Executed Campaign based on customer request and reviewed execution log to keep track of the number of records going into and coming out of every job step
• Created waterfall reports to show total lead pull, number of records dropped as result of each suppression or set of suppressions
• Responsible to design, develop mapping document for to maintain the data marts (Load data, Analyze using OLAP tools).
• Provided output by segments for each Direct mail files
• Analyzed the output counts report and sample records for customer approval/satisfaction
• Profiled various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
• Executed campaign based on customer requirements
• Followed company code standardization rule

Environment: Windows XP, SQL, Oracle, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, BTEQ), UNIX, ETL Tools Informatica 8.6, TOAD, Quality Center 9.2.

Confidential

Data Quality Analyst

Responsibilities:

• Worked with Requirements Analysts and Subject Matter Experts to identify, understand and document business needs for the data flow.
• Worked closely with various Financial, Mortgage and Credit Consumer Group business teams in gathering the business requirements.
• Worked with Central Distribution Hub (CDH) team in developing strategies to handle data from EO (Enterprise Originations) to CDH and then CDH to downstream systems.
• Initiated and conducted JAD sessions inviting various teams to finalize the required data fields and their formats.
• Worked with Chief Data Architects to slice the data requirements into work streams and various components.
• Interacted with the SME’s to analyze the data extracts from Legacy Systems (Mainframes and COBOL Files) and determine the element source, format and its integrity within the system.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Served as a resource for analytical services utilizing SQL Server, and TOAD/Oracle.
• Run the SQL queries using TOAD and SQL Navigator.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Delivered requirements for integrating transaction, previous day and current day information reporting, for ACH, Wires, Memos, Returns, Controlled Disbursements, Lockbox, and Data Exchange.
• Was responsible for indexing of the tables in that data warehouse.
• Reverse Engineered the existing ODS in to Erwin.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• Created job schedules to automate the ETL process.
• Worked on data modeling and produced data mapping and data definition documentation.
• Configured the Data mapping between Oracle and SQL Server 2005.
• Designed and implemented basic SQL queries for testing and report/data validation.
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• Highly contributed to the enterprise metadata efforts by completing the data mapping repository (DMR) information.
• Ensured the compliance of the extracts to the Data Quality Center initiatives.
• Gathered and documented the Audit trail and traceability of extract information for data quality.
• Worked with the Business and the ETL developers in the analysis and resolution of data related problem tickets and other defects.

Environment: Mainframes, COBOL, MS Excel, MS Access, MS Visio, Oracle 10g, UNIX, Windows XP, SQL,PL/SQL, Sybase Power Designer 12.1.

Confidential

Data Analyst

Responsibilities:

• Worked with SME’s from 8 different source systems to gather, analyze and document business requirements for the project
• Collaborated with SMEs to determine member billing calculations/definitions from 3 different source systems to produce a reconciled view for online members
• Actively participated in the Logical Data Model design to support future expansion and development of the project
• Collaborated with QA team on test cases, test scripts, defect resolution and requirements clarification
• Wrote all Business and non/Functional requirements rules for the mapping document and delivered the Data blue print.
• Created the rules engine for identifying the golden copy of the master data and manually profiled the data to make sure the rejects were handled correctly.
• Updated the RTM on HP QC

Environment: HP QC, Unix, Infomatica 8.6, Oracle 10g

Confidential, New York

SQL Data Analyst/Reporting Specialist

Responsibilities:

• Ran queries and created SQL Ad hoc reports and Pivot Tables According to the user specifications.
• Performed ad-hoc queries on the database as needed to generate reports.
• Performed export/import activities between MySql, MS Access, SQL Server 2005 and MS excel.
• Provided data analysis support to Management and all company employees.
• Prepared reports according to third party vendor specifications.
• Generated new reports as required by Management.
• Maintained the schedule of generation of standard reports on a weekly and monthly basis.
• Prepared the mapping document for the ETL development Team and testing team
• Created the traceability matrix.
• Collected the report specifications by having either client meetings or with the employees.

Environment: MySQL, MS Access, Excel, SQL Server 2005 Windows Vista and windows XP.

Confidential, New York

Technical Support Specialist

Responsibilities:

• Understood the pharmaceutical software functionality by going through the functional specifications/training material
• Provided technical Assistance and pharmaceutical software training to staff
• Assisted with the implementation of Pharmaceutical software
• Maintained accurate inventory records
• Generated and presented reports using Excel