SUMMARY

• Proficient in Data Analysis, System Analysis, Business Requirement Gathering, Data Modeling, Technical Documentation with around 6 years of experience in IT.
• Experienced and comfortable working on various databases like SQL Server, Oracle, Teradata.
• Well conversant with test case design, test case execution, test data preparation, SDLC concepts, Defect Life cycle
• Expert in using design and management tools like Erwin and Toad, SQL Developer
• Expertise in software management tools such as Clear Quest, Quality center, HP ALM, JIRA for defect tracking and reporting
• Good exposure to Object Oriented Programming, Agile Methodologies
• Proficient in Data Governance, Data Lifecycle, Data Quality Improvement, Master Data Management, and Metadata Management
• Worked with Data governance team to evaluate test results for fulfillment of all data requirements
• Expertise in test data validation with Multi - dimensional cubes such as SSAS and BO.
• Analyzed performance improvement pathways by parallelizing the scheduled of Informatica jobs using UNIX Shell Scripting thereby improving time to deliver.
• Application Data warehousing experience in Financial, Banking, and Retail.
• Proficient in Oracle 11g, Teradata, SQL Server, PL/SQL on UNIX and Windows platforms. Extensive experience in Database activities like Data Modeling, Design, development, maintenance, performance monitoring and tuning, troubleshooting, data migration etc.
• Well capable in preparing Financial Reports, On-Demand Reports using Oracle SQL, Teradata. Developed Adhoc queries and Reports using Oracle, SQL, PL/SQL, and UNIX to fulfill business analysts, Operations Analysts and Financial analysts’ data requests.
• Proficient in preparing Presentations, Graphs, Pivot Tables using Microsoft Excel and PowerPoint
• Experienced in analyzing Business Requirements Documents (BRD), Functional Requirement Documents (FRD), Test Strategy and Test data preparation, Coordinating User Acceptance Testing (UAT), Preparing Manuals and Training Business Users

TECHNICAL SKILLS

Testing Tools: HP Quality Center 9.2/8.0, Mercury Quality Center 8.0/Test Director, Clear Case

Databases: DB2 V9.1, Oracle 10g, SQL PL, SQL Server 2008,Teradata, Microsoft PDW

SCMVC: VSS, Team foundation server, Clear Quest, Clear Case, IBM CMVC

Operating Systems: UNIX, Linux, Windows XP/2003 server, AIX

ETL Tools: Informatica 9.x/8.x/7.1, SSIS, Ab Initio, Data Stage

BI Tools: Hyperion Essbase, SSAS, SSRS, Cognos, Business Objects

Other tools: Erwin, ERStudio, Infosphere Data Architect, MS Office, Excel, VBA, Visio Finance Payables, receivables and general ledgerLanguages UNIX Scripting, Perl, SQL, XML

PROFESSIONAL EXPERIENCE

Confidential, Oakbrook, IL

Data Analyst

Responsibilities:

• Analyze the client data and business terms from a data quality and integrity perspective.
• Perform root cause analysis on smaller self-contained data analysis tasks that are related to assigned data processes.
• Worked to ensure high levels of data consistency between diverse source systems including flat files, XML and SQL Database.
• Develop and run ad hoc data queries from multiple database types to identify system of records, data inconsistencies, and data quality issues.
• Involved in translating the business requirements into data requirements across different systems.
• Involved in understanding the customer needs with regards to data, documenting requirements, developing complex SQL statements to extract the data and packaging/encrypting data for delivery to customers.
• Wrote SQL Stored Procedures and Views, and coordinate and perform in-depth testing of new and existing systems.
• Provided support to Data Architect and Data Modeler in Designing and Implementing Databases for MDM using ERWIN Data Modeler Tool and MS Access.
• Worked with Data Modeling team to create Logical/Physical models for Enterprise Data Warehouse.
• Reviewed normalized/Denormalization schemas for effective and optimum performance tuning queries and data validations in OLTP and OLAP environments.
• Exploited power of Teradata to solve complex business problems by data analysis on a large set of data.
• Built Fast Load and Fast Export scripts to load data into Teradata and extract data from Teradata.
• Familiar with using Set, Multiset, Derived, Volatile and Global Temporary tables in Teradata for larger Adhoc SQL requests.
• Used Teradata advanced techniques like OLAP functions CSUM, MAVG, MSUM MDIFF etc.
• Developed Reports using the Teradata advanced techniques like Rank, Row number and etc.
• Efficient in process modeling using Erwin in both forward and reverse engineering cases.
• Experienced in conducting JAD Sessions.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Documented data content, data relationships and structure, and processes the data using Informatica Power Center Metadata Exchange.
• Transferred data objects and queries from MS Access to SQL Server.
• Assisted ETL team to define Source to Target Mappings.
• Worked with Data Architect in Designing the CIM Model for Master Data Management.
• Compile and Generate Reports in a Presentable Format to the Project Team.

Environment: Windows 2000, Informatica, XML, MS Office, VBA Excel 2013, Access, SSRS SQL Server 2008, Erwin 9, Infosphere Data Architect, Teradata, Oracle 10g.

Confidential, New York, NY

Data Analyst

Responsibilities:

• Involved in Business and data analysis during requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
• Defined data requirements and elements used in XML transactions.
• Reviewed and recommended database modifications
• Analyzed and rectified data in source systems and Financial Data Warehouse databases.
• Generated and reviewed reports to analyze data using different excel formats
• Documented requirements for numerous adhoc reporting efforts
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Designed developed and implemented 2 professionally finished systems for tracking IT requests, and providing a data repository about reports. Documented all system functionality.
• Participated in testing of procedures and data, utilizing PL/SQL, to ensure integrity and quality of data in data warehouse.
• Metrics reporting, data mining and trends in helpdesk environment using Access
• Gather data from Confidential Help Desk Ticketing System and write adhoc reports and, charts and graphs for analysis.
• Identify and report on various computer problems within the company to upper management
• Report on trends that come up as to identify changes or trouble within the systems using Access and Crystal Reports.
• Guide, train and support teammates in testing processes, procedures, analysis and quality control of data, utilizing past experience and training in Oracle, SQL, Unix and relational databases.
• Maintained Excel workbooks, such as development of pivot tables, exporting data from external SQL databases, producing reports and updating spreadsheet information.
• Created cases for settlement claims analysts by printing documents from a website that maintains information, regarding settlement claim data, compiled documents and updated settlement claim data into database system
• Modified user profiles, which included changing users cost center location, changed user?s authority to grant monetary amounts to certain departments - monetary amounts were part of the overall budget amount granted per department
• Deleted users from cost centers, deleted users authority to grant certain monetary amounts to certain departments, deleted certain cost centers and profit centers from database
• Created a report, using SAP reporting feature that showed which users have not performed scanning of journal voucher documents into the system.
• Created Excel pivot tables, which showed a table of users that, have not performed scanning of journal voucher documents. Users were able to find documents by double-clicking on his/her name within the pivot table
• Load new or modified data into back-end Oracle database.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio

Environment: workflow manager, workflow monitor), SQL *Loader, Cognos, Oracle, SQL Server 2000, SAS/BASE, SAS/Access, SAS/Connect, Informatica Power Center (Power Center Designer, Erwin, Windows 2000, TOAD.

Confidential, Tampa FL

Data Steward/Analyst

Responsibilities:

• Monitor the Database for duplicate records.
• Merge the duplicate records and ensure that the information is associated with company records.
• Standardize company names, addresses, and ensure that necessary data fields are populated.
• Review the database proactively to identify inconsistencies in the data, conduct research using internal and external sources to determine information is accurate.
• Resolve the data issues by following up with the end user.
• Coordinate activities and workflow with other Data Stewards in the firm to ensure data changes are done effectively and efficiently
• Review the database to identify and recommend adjustments and enhancements, including external systems and types of data that could add value to the system.
• Extract the data from database and provide data analysis using SQL to the business user based on the requirements. Create pivots and charts in excel sheet to report data in the format requested
• Used VBA for excel to automate the data entry forms to help standardize data.
• Assist CRM Analyst with Email Marketing Campaigns, including Client Publications, Newsletters, and announcements.
• Assist other Data Stewards with Data Change Management (DCM) Inbox in resolving various tickets created by the User Change Request in Interaction Database.
• Developed and Created Logical and Physical Database Architecture using ERWIN.
• Designed STAR Schemas for the detailed Data Marts and plan Data Marts involving Shared Dimensions.
• Conduct Design reviews with the business analysts and content developers to create a proof of concept for the reports.
• Ensured the feasibility of the logical and physical design models.
• Wrote T-SQL Scripts to manipulate data for data loads and extracts.
• Used SSIS to extract, transform, and load data from transaction systems.
• DesigningSSISPackages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Implemented Slow Changing Dimensions (SCD) type 2 to maintain historical data.
• Utilized several Transformations like Lookup, Aggregate, Conditional Split, and Derived Column for implementing the Transformation Logic in the Packages.
• Created Stored Procedures, Tables, Functions, and Triggers in SQL Server 2008.
• Analyze the large datasets to draw key marketing insights from the dataset results.
• Assisted BI Developers to fetch reports using SSRS.
• Assist with end user training.

Environment: Oracle, Erwin 3.5, Windows 2000, MS Office, VBA Excel 2013, Access, SSRS SQL Server 2008, TOAD 7.

Confidential, NY

Data Analyst

Responsibilities:

• Assisted in test strategy and data creation for testing the mapping document
• Created and reviewed mapping documents based on data requirements
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Wrote UNIX script to profile data and validate the input data file from GL, AP and AR.
• Created data requirements and test data to test type II slowly changing dimension tables.
• Prepared data quality criteria and governance for Data Warehousing Application.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Worked with SSIS system variable, passing control and audit variables between packages.
• Created adhoc reports for testing and supporting UAT and presented in as Excel spreadsheets for data verification
• Wrote Macros to automate UAT test validation.
• Assisted UAT by testing data in different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis).
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Creating test cases for ETL mappings and design documents for production support.
• Setting up, monitoring and using Job Control System in Development/QA/Prod.
• Worked with ETL group for understating mappings for dimensions and facts.
• Analyzed data from various sources like Oracle, flat files and SQL Server.
• Worked on data issues with migration from development to testing.
• Extensively tested several Cognos reports for data quality, data values, functionality, calculations, fonts, headers & cosmetic.

Environment: QTP SQL *Loader, UNIX, Oracle8i, SQL Server 2000, Erwin, Windows 2000, Informatica Power Center 7.1 (Power Center Designer, workflow manager, workflow monitor), Mercury Test Director, TOAD 7.

Confidential

System Analyst

Responsibilities:

• Interact with customers both onsite and offsite, gather requirements and data.
• Contribute to the technical team activities (design, modeling, prototyping, coding, testing, and documentation) in full-life cycle of products.
• Worked with Direct Customer Database and Processes, document all of existing operational processes using MS Visio.
• Worked with CRM Implementation team to document process improvements.
• Provided end-to-end data analysis, documentation to map data, workflow, and processes from disparate sources.
• Work with users to analyze current business processes and procedures to help identify gaps and areas for process improvement.
• Implemented appropriate security policies, assign user authorization, and monitor user activities
• Generated reports using SQL and formatted the data in excel using advanced features.

Environment: Access, SQL Server, Informatica, MS Office, VBA Excel, Erwin, Visio.