SUMMARY

• Around 9 years of Proficient experience in implementing Data Warehousing and Business Intelligence/Data Analysis solutions to large corporate clients especially working with various industries such as Manufacturing, Banking, Financials, Healthcare, Account Receivables, E - business and Retail.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Experience in using Software Development Life Cycle (SDLC) concepts, principles to plan and carry out difficult and complex assignments including managing integration projects, process improvement and IT strategy projects.
• Strong Data Warehousing experience using Oracle 11g/10g/9i PL/SQL, Oracle Warehouse Builder, ETL Informatica 8, OLTP, OLAP, ROLAP, MOLAP, Dimensional Data Modelling using Star & Snow Flake schema.
• Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME's), Development and QA teams.
• Good experience in Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• Ability to understand current business processes and implement efficient business process.
• Expertise in defining scope of projects based on gathered Business Requirements including documentation of constraints, assumptions, business impacts & project risks.
• Experience in Strategic Planning, Requirements Analysis/Gathering, and Process Analysis & Improvement.
• Conducting requirement gathering sessions, feasibility studies and organizing the software requirements in a structured way.
• Extensive experience/SME in IT environment/infrastructure building (Unit/Test/Stage/Prod), Service Delivery, Release Management. Experience as of a client delivery role with direct interaction with clients and developing written documentation for the various communication.
• Experienced in and mentoring team members with product knowledge and business processes.
• Implemented and administration of Oracle 9iR2 /10gR2 Real Application Clusters (RAC) on UNIX, Solaris, Linux (RHEL) platform.
• Proficient in Database Backups and Recovery using Logical Backups (Export/Import), Physical Backups (Cold/Hot) and Recovery Manager (RMAN).
• Implemented Data Recovery (DR) and High Availability solutions using Oracle 11g/10g Standby Database using DATA GUARD.
• Expertise in Oracle, PL/SQL, UNIX & exposure with large database applications of Data warehouse as well as Client/Server in various stages of SDLC like Development, Enhancement, Maintenance and Production Support.
• Experience in UNIX Shell & Perl scripting and CRON Jobs to monitor database status and analysis.
• Monitoring system performance using vmstat, iostat, SAR, Top etc.
• Expertise in ETL Process using the SQL *Loader from various sources (Flat files, Excel, CSV, Text Files, etc.).
• Expert user with MS Office suite of applications like MS EXCEL.
• Very Energetic, Pro-active and Creative. Capable of forming and maintaining positive and productive team environments with integrative thinking skills.

TECHNICAL SKILLS

Database: Oracle11g/10g/9i/8i, SQL Server 2000/2005, MySQL 5.

Operating Systems: Linux (RHEL 5/4), Sun Solaris 8/9/10, HP-UX 11.0, IBM AIX V6/5LMicrosoft Windows 95/98/2000/2003/ NT/XP.

Languages/Tools: SQL, PL/SQL, TOAD, UNIX Shell Scripting, PERL scripting, Crontab.

Oracle Tools and Utilities: Import, Export, Data Pump, SQL *Loader, SQL Trace, RMAN, TKPROFExplain Plan, Auto Trace, AWR (STATSPACK), ASH, ADDM, VI editor and FTP.

ETL Tools: Informatica 8.1, Oracle Warehouse Builder 10g/9i/8i (OWB), OBIEE.

Data Modeling Tools: Erwin 3.5

Others: SQL Developer, IBM Tealeaf 9.0.1, Keynote, SAP Business Objects 4.

PROFESSIONAL EXPERIENCE

Confidential, Bothell, WA

Sr. Data Analyst

Responsibilities:

• Provide the Improvement of customer experience/reduction in customer struggle and system reliability (ex. error reduction).
• Proactive - Analyze the sessions using Tealeaf for customer struggle through daily review of trends and regular CSAT/Session deep dives.
• Reactive - Daily analysis of operational trends for potential issues. Analyze and support the resolution of identified issues.
• Accountable for resolution of issues and enhancements uncovered by CEA.
• Daily analysis of system health (sales volumes, conversion trend, error rates, etc.).
• Analysis and root cause determination of identified issues.
• Weekly recommendations on how to improve customer experience (via daily deep dive).
• Accountable in driving resolution to production problems and issues through partnership with DET towers and LOB owners.
• Analyzing the Customer related session and Errors using the IBM Tealeaf tool to find the issue caused during the Day time.
• Identify Root causes the ERROR related to customer to find out the API failing in Service Layer Database and extract the Application logs & Front End logs from servers engage the Problem Management team to look further to resolve the issues.
• Responsible for the generating the reports related the ERROR on Sales & Service using the SAP Business Objects on daily basis and provide the date to Business people.
• Standardizeand operationalize PAR and CE reports for all ofDET Services and Line of Businesses (LOBs).
• Proactively identify and resolve PAR and CE issues.
• Implement and operationalize tools for real-time alerting and analysis. Operational Intelligence (OI).
• Involved the in iPhone launch and provide the error reports spike related to the Full website (www.att.com) & Confidential & Confidential Mobile App.
• Identify and analyze the scope of the projects (as-is/to-be); on-exchange/off-exchange; design and document sprints; assist in sprintly build deliverables.
• Perform ETL process for CSAT data from SQL Server Reports & analyze the sessions using the Tealeaf and provide recommendations to Business to improve the experience using PPT.
• Implement and operationalize tools to measure, track, alert, and analyze performance, availability, reliability, and CE issues.
• Actively facilitate issue resolution, change management (CCB) and dependency management.
• Extract the data from Service Layer database to check which API failing during the launch using SQL queries.
• Contribute the on-going analysis and provide the Recommendations to site improvement user related issues.
• Prepared Documents related to issues found & fixed and On-boarding guide for others to understand the business.
• Provide the 24*7 call support during launches and monthly.

Environment: Oracle 11g, IBM Tealeaf 9.0.1, Sun Solaris 5.10, SQL, SQL*Developer, SAP Business Objects 4, SQL Server 2008. MS Excel.

Confidential, Seattle, WA

Sr. System Analyst/Data Analyst

Responsibilities:

• Providing operational support to Amazon Finance by performing data mining tasks on GL/SL data as well as related source systems /OLTP (Online Transaction Processing) system databases to identify sources of imbalance and variance.
• Executed operational duties relating to researching transactions, reconciliation issues, and reporting.
• Identified the differences between GL and SL amounts and implemented remediation plans to address system/process issues related to imbalanced transaction pools.
• Substantiated and qualified reconciliation issues by developing use cases to identify common behaviors of imbalances and variances by transaction type and geography.
• Met with the business stakeholders to provide clarity around issues, proposed corrections/workarounds to address GL and SL variances, and obtained sign-off for remediation plans.
• Led effort to identify all open issues needing a root cause fix and worked with Amazon Finance team management to schedule fixes on their IT roadmap.
• Developed on boarding documentation and delivered to new teams members, which helped narrow the on boarding process from one month to a week and a half.
• Worked closely with Development team in Launching new products on Confidential for the Retail and Marketplace business across the world.
• Consult and advice on new product launches and migrations established as SME by client.
• Conducting UAT for the new products launches and provides additional support to the development team further successful launch.
• Installing of Oracle 11g database for the internal process analysis on Red Hat Linux 5.
• Installation of MySQL 5 Database in windows 7 for reconciliation of financial Data warehouse data.
• Responsible for the generating the reports from Oracle Business Intelligence 10.1.3.4.1 Application on monthly basis for metrics.
• Responsible for the SL and GL variance research of Sales Invoices in Japan region in vice versa on monthly basis, to provide the quantification of amount variance to the Financial Accountants.
• Running the ETL jobs in Data warehouse for different regions and load into a local Oracle 11g Database for the on-going analysis.
• Responsible to identify and disposition unbalanced transactions with SL account and to determine if any GL impact exists by Geography.
• Writing the PERL scripts to automate the filtering out of transactions.
• Tuning SQL query in the PERL scripts in such a way that it will retrieve the required data within least amount time.
• Investigating imbalances in the systems to identify the root cause if any and drive those root causes to the Development Team for the closure, perform the backfills.
• Writing PERL Scripts for the different systems to extract the Data for the research process.
• Responsible for loading data from DW, different source systems of data into internal Virtual Oracle DW, Oracle 11g and MySQL databases by using oracle feature SQL*LOADER.
• Using the Remedy tickets to the TIER2 team to perform the backfills into the various legacy systems.
• Generating the reports for reconciliation using the MS EXCEL PIVOT tables, Vlookup.

Environment: Oracle 11g/10g, Oracle 10g Client, MySQL 5.0, PERL 5.0, Oracle Financial Application 11i, OBI 10.1.3.4.1, Red Hat Linux 5, Windows 7, Hyperion Essbase, Oracle DW, SQL, MS Excel.

Confidential, Hartford, CT

Sr. System Analyst/Data Analyst

Responsibilities:

• Involved in Data warehouse design and develop database structure
• Responsible for loading ESS datawarehouse from ADP EV4 systems as well as from files to Oracle database using SQL Loader.
• Responsible for writing PL/SQL Programs stored procedures, packages, functions which accomplish solutions to existing application which served as service/Change request.
• Sole Responsible for designing new applications in ESS like Performance feedback tool and learning & Development Tools, which technically used PL/SQL and UNIX.
• Involved in Migration of the databases from Oracle 9i to Oracle 10g.
• Configured RMAN for backup and recovery strategy. Restored database-using point in time recovery.
• Configured Data Guard to ensure high availability, data protection and disaster recovery for enterprise data and monitored regularly whether primary and standby databases are in sync.
• Reviewing and approving SQL scripts supporting DEV and QA databases. Worked on SQL Tuning and database tuning and troubleshooting database issues.
• Managing database activities like number of users, memory usage, alert log files, trace files, archive log files, system health for optimal performance.
• Responsible for designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems (Flat files, Sybase, MS SQL server and Oracle) feeds using PL/SQL and Unix Shell scripts
• Responsible for writing UNIX scripts to schedule jobs, which refresh data from one database to another in warehouse and automation of emails.
• Analyze Problem Reports to identify the root cause and recommend and/or implement code changes to correct the defect
• Act as I. Confidential . Systems Lead, coordinating the efforts of both on and offshore resources throughout the life cycle of a project. Ensure all aspects of project management are fully executed.
• Participated in requirement reviews, design, design reviews, development, system testing, and implementation phases as necessary.
• Coordination of project schedules and resource assignments based on regular meetings with customers.
• Lead teams and have the ability to manage complex processes and issues.

Environment: Oracle 10g/11g, PL/SQL, OBIEE, Oracle Warehouse Builder 10g, LINUX, IBM-AIX.

Confidential, Boston, MA

System Analyst/BI/Data Analyst

Responsibilities:

• Involved in Design & Develop of Logical and Physical Model of Star Schema including Dimension and Fact tables.
• Involved in migrating data from Sybase to Oracle staging tables.
• Generate the scripts for the updated data model using the script generator.
• Developed PL/SQL Programs to load data to DW from various sources.
• Analyses and discuss the business requirements with the clients.
• Responsible for the development, implementation and support of the Production database of the server.
• Optimized and modified the triggers, complex store functions, procedures, data type etc.
• Used Oracle Analytical Functions to get tuned performance related issues.
• Involved in analysis and translation of business requirements into technical lineage documents.
• Closely examining the Oracle Architecture specification and bottling down the exact performance issue area.
• Using the V$ Performance Views for instance tuning. In addition, using the explain plan for query tuning.
• Hands on Experience to write DDL scripts for UAT/production deployments.
• Obtaining a full set of operating system, database and application statistics, examine the data for any evidence of performance problems.
• Design the front end screen for operations team using Oracle Forms
• Developed Functional (Business terms) and Technical Design documents.
• Involved in data conversion from one database to Data Warehouse.
• Developed Staging jobs where in using data from different sources formatted, Cleaned, Summarized, aggregated and transform into data warehouse.
• Developed PL/SQL scripts for ETL (Extraction, Transformation & Loading).
• Involved in performance tuning of mappings and complex queries.
• Worked with DBA to get required table space, permissions on source tables and to kill unwanted sessions.
• Design reports which uses built in data warehouse using Reports 6i
• Have exposure with Clear Case/Clear Quest for Code Version changes as well as bug logging
• Hands on experience in schedule and maintain the Production Jobs through Autosys.

Environment: Oracle11g, PL/SQL, Oracle Warehouse Builder 10g, ODI, Informatica, IBM-AIX, OEM, Sybase 12.5, OBIEE 10.1.3.

Confidential, OR

Data Analyst/PL SQL Developer

Responsibilities:

• Responsible for integrate the extracted source OMAR data into 11iG star schema.
• Responsible for System study, Architectural Design and Detailed Design and Develop of Logical and Physical Model of Star Schema including Dimension and Fact tables.
• Responsible for administering and supporting production and development Oracle 10g Databases.
• Managing database activities like number of users, memory usage, hit ratios, alert log files, trace files, archive log files, system health for optimal performance
• User maintenance and security audits, Creating and managing privileges & roles to ensure the application / database security.
• Cloned/Refreshed Database environments to create patch, test, development and QA environments.
• Creating users, allocation to appropriate tablespace quotas with necessary privileges and roles for all databases.
• Wrote PL/SQL Programs to load data to target from source Oracle OMAR System.
• Extensively involved in writing PL/SQL stored procedures, functions, triggers and packages to meet the business requirements and update the existing objects based on change requests.
• Arranging the minutes of sessions for the updating the technology and for new reporting requirements for managers.
• Involved in creating the macros for excel sheets to convert the data into a compatible format for loading.
• Involved in building End User Layer, building Business Areas, generating Reports and establishing Security issues i.e., Security Structure for Star Schema Access.
• Expertise in preparing DDL Scripts and PERL scripts.

Environment: Oracle10g, PL/SQL, RMAN, SUN SOLARIS, LINUX, Oracle Warehouse Builder, Perl, UNIX.

Confidential

Oracle DBA/PL SQL Developer

Responsibilities:

• Responsible for integrate the extracted the source data from different systems into SCMDW star schema.
• Responsible for Data loading to Data Warehousing size of 1.5 terabyte system from different source systems and provided application support to end-users which are run based on this Data warehouse.
• Responsible for administering and supporting production and development Oracle 10g Databases.
• Performed Monthly Cold Backup, Weekly Hot Backup and daily incremental backups using exp/imp, cold/hot backup, and RMAN backup technology.
• Developed shell scripts and automated nightly jobs using crone to schedule the backups, exports, refresh test DB from production site and build development, testing staging DB’s.
• Planning the backup policies and Backup/ Recovery of databases based on the criticality.
• Job monitoring via Oracle Workflow which run from UNIX, crontab.
• Modification to existing UNIX shell script and mappings as per change request raised by business.
• Responsible for Database security management for Oracle Discoverer users.
• Worked in Production support to resolve end-user issues earliest.
• Follow up with customer to keep them informed of issue status until issue is resolved. Thoroughly documented information for each request using IBM’s Problem tracking tool “Manage now”
• Resolved user issues via telephone dialogue in response to requests raised in Manage now, Conducted additional research as needed to respond to customer issues on application use
• Generated SQL and PL/SQL scripts to as per requirement
• Troubles hooted performance issues and bugs within packages, forms, and reports using dbms output, Forms debugger, explain plan and TKPROF.
• Documented business rules, functional and technical designs, test cases, and user guides.

Environment: Oracle9i/10g, PL/SQL, Oracle Warehouse Builder, Oracle Discoverer, Oracle Forms, Reports, AIX, UNIX.

Confidential

Database Developer

Responsibilities:

• Responsible for Enhancement of present system and given support to team to resolve end user issues earliest.
• Startup and shutdown of database whenever it needs
• Creating users and assigning privileges to users & roles.
• Performing periodical backups using Hot Backup Strategy.
• Performing monthly cold backup during planned down time.
• Production Support - Handling inquiries.
• Wrote database PL/SQL triggers and procedures, Function, Packages to provide backend security and data Consistency.
• Trouble shooting for the end users requirement and Optimizing database
• Tuning application using tools like Explain plan, SQL*Trace and TKPROF for high efficiency.
• Loading data using SQL*Loader (both conventional and direct path loading) and Stored procedures.
• Developed stored procedures and complex packages extensively using PL/SQL and shell programs
• Developed triggers, packages, procedures and functions using PL/SQL
• Performance tuned DB queries
• Developed shell scripts to send notifications after the process of data creation is complete.

Environment: Oracle 9i/8i, PL/SQL, UNIX, Windows NT, SQL Server, SQL*Loader, SQL, SQL * Plus.

Confidential

Oracle Developer

Responsibilities:

• Developed Complex SQL Queries to update and maintain the database.
• Modification of oracle parameters and involved in the database startup/shutdown activities in a maintenance window.
• Performance tuning of the SQL queries using TKPROF and Explain plan.
• Attended the performance issues and database trouble shooting.
• Troubleshooting Database performance by checking Alert Log file.
• Database performance tuning using relational database concepts and tools like STATSPACK etc.
• Data sourcing, transformation and loading using Export, Import, SQL*Loader.
• Performed Tablespace Management such as create tablespaces.
• Developed Stored Procedures using PL/SQL to validate and insert data into Application Tables.
• Developed PL/SQL Functions, Cursors for various calculations in the application.
• Responsible for Tuning SQL Queries and Query Optimization, fixing bugs encountered by users.
• Created various database objects like tables, partitioned tables views, synonyms, table spaces, user roles, database links, indexes, constraints using TOAD.
• Organizing reporting needs for different divisions.
• Standardizing the format for reports based on users needs and documenting reports.

Environment: Oracle 8i, HP-UX, Windows NT/2000, TOAD6.3, SQL, PL/SQL, Statspack.