SUMMARY:

• Six years of hands on experience as a Database Analyst/Database Programmer/Business Analyst.
• Experience in Oracle, SQL, Teradata, PL/SQL, Ms Excel, Ms Access, Oracle backend development in UNIX, Windows environment.
• Performed Adhoc reports by using Oracle, Teradata, BTEQ, and Unix.
• Experience with Teradata Utilities (BTEQ, Fast Load, Mulitload, Fast Export) 6.01.
• Experience in gathering requirements, preparing and analysing Business Requirement Documents (BRD) and follow up the status of the requirements for releases.
• Experience in Functional Requirement Document (FRD) and Process Specification Document (PSD), and propose changes as per various internal and external requirements gathered for process improvement and changes and created those with MS Visio .
• Created Change request and tracked CRQ in BMC Remedy for functional changes and incident changes.
• Experience in Jira Code and used it for Release Management Process.
• Supported and Involved in DQ and DQ tech validations and verifications.
• Supported Data Quality monitoring and metrics, Data Lineage documentation defined by the business and data management team.
• Good Expertise with BTEQ Commands.
• Extracted data from existing data stores, Developing and executing departmental reports for performance and response purposes by using oracle SQL, MS Access, MS Excel, PL/SQL.
• Good Experience in preparing financial reports using oracle SQL, PL/SQL, Teradata, BTEQ.
• Experience in Data warehouse, ETL - Extraction/Transformation/Loading, Data Analysis, Data migration, Data preparation.
• Expertise in UNIX (Sun Solaris 2.6/2.8 and HP-UX OS- 11, AIX) - Vi Editor, Korn Shell Scripting.
• Good experience in submission of batch jobs using Oracle and Teradata.
• Experience in Analyze data and prepare reports by using SQL, PL/SQL, UNIX.
• Provided ad hoc reports and queries using Ms Excel, Ms Access, SQL, PL/SQL AND UNIX
• Performed in-depth quantitative analysis or data analysis.
• Developed weekly, biweekly, monthly reports by using Ms Excel, Ms Access, SQL, PL/SQL AND UNIX.
• Designed & developed various Ad hoc reports for the finance (Oracle SQL, PL/SQL, SAS, Brio).
• Created data structures by using SQL, MS ACCESS, PL/SQL, UNIX, Oracle Dev2000,6.0, Oracle Designer, Oracle Discoverer
• Very good problem/bug tracking (troubleshooting) as well as resolving skills.
• Good Experience in script conversion from Oracle to Teradata.
• Team player with good communication and presentation skills.
• Experience in Data Analysis, Project Management, Project Designing, Project Planning, Project Development, Project Testing and Implementation
• Client-Server software development using Visual Basic 5.0/6.0, SQL Server 6.5/7.0.
• Experience in mapping out functional requirements into the technical specifications.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Shell Scripting, C++, JAVA, VB Script, VBA, ASP, Oracle 8i (SQL and PLSQL), SAS

Database Tools: Oracle 8i/9i, Teradata, Netezza, MS SQL Server, DB2, MS-Access

Front End Tools: Oracle Developer2000, Toad, Sas DataFlux Management Studio, SAS web Studio, Visual Basic and MS Access, Teradata, Fast load, Fast Export, TOAD, ALM/HP QC

Reporting: Oracle Reports, MS Excel Reports, MS Access Reports, Brio Reporting, BMC Remedy, Jira Code

Functional: SR Data Quality Analyst, Business System Analysis, Data Analysis, and Project Management

Others: MS Office Suit (Word, Excel, Power Point), MS Project 95, SQL Assistant, Toad, BTEQ

Operating Systems: UNIX, Sun Solaris 8, MS Windows, NT Server 4.0, Windows XP

WORK EXPERIENCE:

Confidential

SR Data Quality Technical Analyst/ Project Coordinator

Responsibilities:

• Designed and developed daily, weekly, monthly reports related to daily jobs and prepare the duration and duration variance Report.
• Responsible for gathering requirements from SAS Developers and Data Management team and identifying the data sources required for the reports.
• Experience in gathering requirements, preparing and analysing Business Requirement Documents (BRD) in Excel and follow up the status of the requirements for releases.
• Experience in Functional Requirement Document (FRD) and Process Specification Document (PSD), and propose changes as per various internal and external requirements gathered for process improvement and changes and created those with MS Visio .
• Created Change request and tracked CRQ in BMC Remedy for functional changes and incident changes.
• Involved in DQ and DQ tech validations and verifications.
• Supported Data Quality monitoring and metrics, Data Lineage documentation defined by the business and data management team.
• Support liquidity risk management regulatory and data management deliverables
• Experience in Data Governance metadata, lineage, querying and sourcing of data from various databases includes Oracle and Netezza.
• Experience with repository based data quality tool to profile, standardize, and match data.
• Experience in performance tuning and optimization for increasing the efficiency of the scripts.
• Experience in requirements gathering, high-level design, and general application development and implementation methodology
• Experience with SAS Dataflux Data Management Studio developed business rules in BRM like writing sql and set up the dimensions
• Data cleansing and enrichment operations that flow from source to target using dataflux management studio and web management studio.
• Worked on QKB, data job, process job, standardization scheme, RDM,BRM etc, in Data flux
• Writing SQL queries and subqueries for huge data pulls and ad-hoc reports for analysis.
• Proficient in importing/exporting large amounts of data from files to Oracle to Excel Sheet.
• Wrote hundreds of DDL scripts to create tables and views in the company Data Warehouse.
• Expertise in generating graphs using MS Excel Pivot tables and creating presentations using Power Point.
• Documentation of scripts, specifications, other processes and preparation of Technical Design Documents.

Confidential

Business / Data Analyst

Responsibilities:

• Designed and developed weekly, monthly reports related to the marketing and financial departments by using SQL, PL/SQL, Ms Excel, Ms Access, and Teradata.
• Developed SQL, BTEQ (Teradata) queries for extracting data from production database and built data structures, reports.
• Created Change request and tracked CRQ in BMC Remedy for functional changes.
• Extracted latest accounts data from Oracle, Teradata database by using SQL,BTEQ,PL/SQL
• Developed the Interfaces in SQL, PL/SQL for data calculations and data manipulations.
• Performance tuning and Optimization of large database for fast accessing data and reports Ms Excel,
• Reports generated for various departments like Tele Marketing, Mailing, and New Accounts by using SQL.
• Ad-hoc reports developed using Oracle, SQL, PL/SQL, UNIX.
• Designed, Developed Ad-hoc reports as per business analyst, operation analyst, project manager data request.
• Extracted data from existing data stores, Developing and executing departmental reports for performance and response purposes by using oracle SQL, MS Access, MS Excel, PL/SQL.
• Extracted data from existing data stores and performed ad-hoc queries.
• Developed and maintained the MSACCESS database and applications.
• Performed in depth analysis in data & prepared weekly, biweekly, monthly reports by using SQL, PL/SQL, SAS, Ms Excel, Ms Access, UNIX.
• Designed, developed various Ad hoc reports for the finance (Oracle SQL, PL/SQL, MS Access, Brio).

Confidential

Data Analyst

Responsibilities:

• Helping teammates in converting their monthly reports to Crystal Reports.
• Developing critical reports like drill down, Slice and Dice for analysis.
• Providing weekly and monthly reports to Business Analysts and Operation Analysts.
• Coordinating various work processes between Marketing and Retention teams.
• Daily duties including transferring and converting data from one platform to another to be used for further Analysis.
• Creating permanent and volatile tables in Teradata and using SQL script to generate reports.
• Produced various batch jobs and cataloged procedures for the execution of the batch portion of the system
• Used Teradata utilities (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD) for loading data to tables and Unix scripts to run jobs on servers.
• Working with Emergency Management services to resolve the issues with EMS events.
• Using Dual control process with another Data analyst for EMS events.
• Used SAS ODS to generate reports
• Created tabular reports using Base SAS & SAS/Reports procedures
• Working with huge data sets with more than 30 millions of rows.
• Performing Statistical analysis for Transactors team.
• Generated reports using Proc Tab, Proc Report, Data Null, Proc SQL and Macros.
• Created many weekly, biweekly and monthly reports to measure the performance for each line of business.
• Developed weekly, biweekly, monthly reports by using Teradata, Ms Excel, Ms Access, SQL, PL/SQL and UNIX.
• Designed & developed various Ad hoc reports for the finance (Teradata SQL, SAS, MS ACCESS, and MS EXCEL).
• Created pivot tables and Graphs in MS Excel by getting data from Teradata tables. Performing Adhoc reporting by using Teradata, BTEQ SQL and UNIX.
• Executed test cases and test scripts for manual and automation testing. Defects are raised in the HP Quality Center/HP ALM for logging, tracking and reporting bugs in the application.
• Created manual Test Cases in HP QC/HP ALM for various User Stories based on Release and Sprint Plan
• Created numerous processes and flow charts to meet the business needs.
• Created documentation and updated them so as to reflect the most current process.
• Tools utilized included Teradata V2R6, Excel, Oracle 10g, MS SQL Server 2005, UNIX Shell Scripting, SSRS, SSIS, ALM/HP QC.