SUMMARY:

Hands on developer, from early SQL languages forward to Informatica Powermart/Powercenter, Oracle, SQLServer and UNIX. With expertise in diagnosing problems, possess excellent analytical, organizational and problem - solving skills, able to provide quick accurate technical support. Assist with client and internal users. A goal oriented, highly motivated self-starter with a strong orientation to customer service. Able to work independently in self-directed work environments or across a wide array in collaboration with other teams as a Data/Business Analyst.

TECHNICAL SKILLS:

Languages: SQL, Informatica 6.x-9.x, Informatica Powermart/Power center, Ab Initio, PLSQL, Sqlserver, Business Objects, Focus, Holos, SQL, T-SQL, sqlserver,C, Natural, Rexx, Basic, Cobol

Databases: Oracle 8i-11, TeraData, MS Access, SQL

Operating System: UNIX, Solaris, HP-UX, AIX, Linux, Windows, MS-DOS

Software: SAP BPC, Microsoft Excel, Word, Office 2000/2003/2007, Project, Powerpoint, Access, Visio, Vi, Syncsort, TSO, JCL, Class in Tableau

Tools: Oracle, Control M, CA ServiceDesk, Teamtrack, Clearquest, Clarify, HP Quality Center, Tivoli, Toad

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, DE

Lead Data/Quality Analyst

• Responsible for identifying correct/incorrect data sources from up streams systems to create accurate reports to the downstream systems.
• Provide and update data mappings based on new and existing data sources.
• Ability to identify root cause for data anomalies and data quality issues and translate into meaningful explanations.
• Compare data/datasets to identify bad records from source to target systems using SQL queries, unix
• Mockup test data using Ab Initio for code changes for data transformations.
• Creating test plans, test strategies using HPALM.
• ETL using Ab Initio, Oracle, Control M, Excel.
• Analyze and revise existing functional requirements and technical documentation.

Confidential, NYC, NY

Business/Data Analyst - Data Solutions Delivery team

• Support ratings 360 project design and data processes and workflows for capital markets, BICRA and financial statements.
• Assist with system integration and user acceptance testing.
• Generate Data Requirements, review with Business Owners, and get sign off.
• Collaborate with the technical, data assurance and data content management teams.
• Provide Data Support to Developers and QA teams.
• Conduct Data Profiling, and Mapping documents across data domains (People,, Rating, Scores, etc).
• Analyzing data using sql, excel, pivot tables, vlookups.
• Assist with tracking, investigation and resolution of data issues raised thru Version One stories.
• Check which services are called from JSON code(.js) on web page using Google chrome.

Confidential, Jersey City, NJ

Business/Data Analyst

• Engage with business user to prepare and execute UAT testing for the reporting application infrastructure.
• Use SQL queries to gather appropriate data and get desired outputs for end users.
• Identification of data lineage, domain, valid values and data quality issues.
• Understanding of business requirement to create workflow environment.
• Create mappings using Informatica to source different sources into IntelliMatch.
• Defining rules/process to expedite on data profiling and automated identification of data quality issues.
• Create SQL queries ensuring application is stable and defect free.
• Extract, Validate, transform and summarize data generated from database using SQL, and MS Excel.
• Ability to analyze large amounts of data from multiple different systems, identify disparities and draw conclusions.
• Ability to gather business requirements, and in some cases develop process/system designs based on the analysis.

Confidential, Mount Laurel, NJ

Data Quality Analyst

• Responsible to test the upgrade to Oracle 11g, and Informatica 9.
• Create/Write test scripts against Systems Requirements Specification (SFS).in Excel and then upload to HP Quality Center Suite (ALM),
• Develop solutions to respond to business needs using SQL, Informatica, Oracle, HP Quality Center Suite (ALM), Excel.
• Responsible for various aspects of software application testing, ensuring application is stable and defect free.
• Support a number of projects and work with other ETL testing developers with onshore and offshore resources to test data warehouse, datamart and data integration solutions.
• Analyze data models and create SQL queries ensuring application is stable and defect free.
• Validate data using Informatica Powercenter 9.5.2.1 - Data Validation Option (DVO)

Confidential, Wilmington, DE

Data Quality Analyst/ Data Steward

• Identifies data integrity issues in the Bank Data systems and creates processes or audits to address data issues.
• Production Support - Identify issues, review errors, approve resolution, and advise of potential downstream impacts.
• First line of support for Business Users and Analysts including mailbox support, researching questions and maintaining web based knowledge base.
• Develop solutions to respond to business needs using SQL, Informatica, Ab Initio, Oracle, TeraData, HP Quality Center Suite (ALM), Excel, Tableau
• Trouble shooter using technical expertise to assist both sides (User/Level 3 Support) in understanding why data doesn’t appear as it should, and then work with both sides to see that it gets fixed.

Confidential, Wilmington, DE

Data/Quality Analyst

• Data warehousing and ETL processing to test credit card (POS) / Fraud Prevention applications using ETL tools.
• Compare data/datasets to identify bad records from source to target systems.
• Create test data using Informatica, Ab Initio for code changes for data transformations.
• Creating test plans, test strategies, resource scheduling and test timelines for credit card applications.
• ETL using Informatica, Ab Initio, Oracle, TeraData, HP Quality Center Suite, Control M, Tivoli, Excel.
• Analyze and revise existing functional and technical documentation.
• Participate in developer led code reviews & documentation and Business analyst Functional requirements.
• Quality Assurance / Control with a thorough knowledge of Software Development Life Cycle principles and QA methodology.
• Experience in Backend Testing using SQL queries and Unix Shell Scripts, Unix commands diff, wc, tail, head, grep, sed .

Confidential, Yardley, PA

Solution Architect

• Configure, build, and implement SAP BPC solutions including upgrades to BPC 7.5. SAP BPC utilizes OLAP technology with multi-dimensional which allows users to “slice and dice” the data according their needs (Configuration management).
• Data Tie Out and Validation.
• Conducted to clients in using SAP BPC.
• Configuring Appset, Applications, Dimensions, Properties in BPC.
• Create cubes in SQL Server Analysis Services (SSAS) and update/build SSIS packages.
• Establish, maintain and update BPC Security.
• Configuring EVDRE reports and fixed Report and Template Issues (Excel).
• Responsible for the designing the advance SQL queries, procedure, triggers, functions, scripts.

Confidential, Roseland, NJ

DATA WAREHOUSE - LEAD PROGRAMMER/ANALYST/QA/SUPPORT

• Designed and developed mapping process required to extract, transform, and load data ETL for Confidential Reporting into Oracle databases using Informatica, SQL, Unix. Responsible for ETL deployments and support in a large production environment.
• Analyze and performance tune tables, views, and ad hoc queries.
• Experience in working with and development of Star/Snowflake Schema Design, DataMarts and Dimensional Models, stored procedures, triggers, MQTs, views, cubes.
• Identified defects, user error or enhancements for Confidential reporting application. Work closely with development organizations and other corporate departments in US, India and Brazil to troubleshoot the situation, or creating a work around. Research resolutions to problems and provide reasonable set expectations when addressing the client or business partner. Provide daily updates or follow-ups to clients.
• Experience with Data Warehousing concepts, Data Analysis, Data Warehouse Architecture.
• Involved in all phases of Software Development Life Cycle (SDLC) for Confidential Reporting product.
• Recognized for the ability to meet and exceed client’s expectations in providing support.
• Supervised staff that provided product and technical support for clients.
• Produced Weekly and Monthly reports to upper management of the usage of Confidential reporting.
• Trained new employees in the use of specific Confidential applications, and processes.
• For all processes and procedures in production, change management was used
• Tested Confidential Reporting application and setup automatic testing using QTP and sql queries in sql oracle, SQL Plus.
• Identified numerous new methods for resolving common issues more efficiently.
• Excellent ability to resolve and document the root cause for reported issues. Troubleshoot and identified application vs. user problems

Confidential, Piscataway, NJ

DATA WAREHOUSE PROGRAMMER/ANALYST

• Data warehouse development and implementation for Financial and Time Mart using Informatica and Oracle databases in Unix.
• Developed mapping process required to extract, transform, and load data, ETL for Financial Mart from Oracle financials and Time Mart from Peoplesoft.
• Created mappings and Unix shell scripts for ETL process (extract, transfer and load) data.
• Assisted in designing the Data warehouse models.
• Tested new and existing mappings for Financial Mart using Metadata from ErWin.
• Use Pre-Session and Post-Session to run shell and SQL commands.
• Run session and batch jobs using Informatica Powercenter Server Manager.
• Oncall for production support.
• Responsible for weekly Crystal HOLOS (OLAP) time reports by Organization, Products, Projects. Data from Peoplesoft is loaded to oracle tables and cubes are created for the Holos reports.
• Designed and coded Profit and Loss reports in HOLOS (OLAP). Created cubes from oracle databases.
• Responsible for monthly data loads for HOLOS Financial reports.
• Developed common functions used by HOLOS programmers.
• Trained new Informatica and Holos Programmers.

PROGRAMMER/ANALYST/DATABASE ADMINISTRATOR

• Responsible for all aspects of software development for the Project Analysis Tracking System (PATS). The PATS system conveys financial information worth $1.18 billion from various feeder systems to the 7 Regional Telephone companies and other clients.
• Responsible for the Database design and Administration of PATS.
• Designed and coded new FOCUS programs and maintain the existing code for the on-line PATS system.
• Developed new Natural-2, COBOL and FOCUS code to improve the data feeds to load the PATS databases.
• Responsible for the monthly production cycle involving scheduling of the jobs, loading the database and sending the information to the clients.
• Created user and programmer documentation for the system.

DASD ADMINISTRATOR

• Administrator for the Financial Systems DASD.
• Set up Disaster Recovery Plan for production DASD.
• Responsible for restoring, compressing and allocating datasets, conversions and maintenance of DASD. Provided DASD charts and utilization reports. Installed HSM to archive, backup and delete datasets from DASD.