PROFESSIONAL SUMMARY

• 12 years of working experience in Business requirement gathering, Analysis, Design, Development and Support of OSS and IT Applications in Financial, Telecom, Automotive and Manufacturing Domain.
• 6 years as development lead & portfolio lead responsible for end - to-end IT delivery in Telecom and Financial domain.
• Lead Data Quality analyst responsible for 3 major OSS conversions.
• 10 years of working experience in Data warehousing & ETL programming using Oracle PL/SQL, TALEND and Datastage and reporting using Cognos BI reporting.
• Extensive working experience in Data warehousing models with STAR schema and Snowflake schema. Worked extensively on data modelling using dimension, fact, fact-less fact and degenerate dimension tables; data granularity and hierarchy, denormalization; ETL operations from data source to data warehouses and data warehouses to data marts; Optimization and usage of advanced PL/SQL features for data warehousing environments.
• Functional expertise in network inventory management, credit finance and telecommunication billing systems.
• Testing Plans & Data Quality/Analysis for Amdocs Cramer provisioning system with Inventory Models.
• Good understanding of Software Development Life Cycle (SDLC) experience including Integration testing, Database Testing and industry best practice.
• Experience in interact with business users & clients to collect requirements & business rules and convert them into High & Low Level Design Docs.
• Experience in creating data base objects like procedures, functions, packages and collections.
• Extensive working experience using advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL. 
• Expertise in Oracle SQL & PL/SQL performance tuning and extensive use of Explain Plan and HINTS for Query optimization.
• Effectively made use of Indexes, Table Partitioning, Analytical functions, Materialized Views, partitioned large Tables using range partition technique.
• Extensive working experience in creating user defined error frameworks & exception handling.
• Experience in developing technical solutions with advanced SQL concepts.

TECHNICAL SKILLS:

Design Tools: CA Erwin, MS Visio, SAP Power Designer

ETL Tools: IBM Datastage, TALEND

Reporting Tools: IBM Cognos BI

SQL Tools: Toad, PL/SQL Developer, SQL Developer

Languages: SQL and PL/SQL, Shell Scripting, HTML/xHTML, JavaScript, Cold Fusion

Databases: Oracle 11g/10g/9i, SQL Server, POSTGRE SQL, MySQL

Automation Testing: TOSCA 9.0

Scheduler/Deployment: AutoSys, UNIX Cron, Oracle DB scheduler, Datical, HPDMA

Operating Systems: Win XP/2000, UNIX, HP-UX

PROFESSIONAL EXPERIENCE:

Confidential, NC

Database Architect/Lead - Data Analyst

Responsibilities: 

• Database architecture and design for the data copy tool (CCAR DCT) and 3 new flood determination (Flood Calculations, Flood QA and Flood Preclose) initiatives.
• Highly normalized design models were designed and implemented for Flood OLTP systems. Denormalized extraction model designed for CCAR DCT.
• Responsible for the overall maintenance of development, test and load database of the account working on an onshore-offshore model.
• Understanding of the business requirements and work with the data mapping team to set up the development databases.
• Involved in the creation of database objects like Tables, Views, Triggers, Stored Procedures, Functions and Packages & Indexes.
• Extensive use of SQL Query, joining tables, analytical functions in queries, PL/SQL with the use of Cursors, REF Cursors and loops. 
• Develop and maintenance of AutoSys jobs for data extraction from feeds using PL/SQL and shell scripts.
• Modified scripts to increase performance by using BULK collect techniques.
• Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Implement ANSI SQL practices, has abundant knowledge to write code in ANSI standard i.e. Joins, Views and stored procedures has been written in ANSI standard.
• Created UNIX scripts, Controls files for SQL loading tables fetched from SORs.
• Convert UNIX CRON jobs used for APPIAN services to AutoSys.
• Involved in Unit Testing, Integration and system Testing of PL/SQL objects and deliverables.
• Performance tuning and provide solution on complex queries.
• Worked on the initial design for the in house data copy tool.
• Custom built Oracle PL/SQL procedures and views for data quality checks on data from source feed.
• Worked on the feasibility analysis of Datical and incorporating the same to the project.

Confidential, KS

Lead - Data Warehouse Architect /Data Quality Analyst

Responsibilities: 

• Designing the DQ data warehouse in line with the source data and target system structure for TIRKS - MARTENS and ISYS - ARM.
• This involved multiple staging layers and finally the target tables, from which the flat files were generated and ftped to the target system.
• Analysis and definition of conversion scope for source inventory data warehouses.
• Create staging tables, PL/SQL packages, XSD schema in Oracle database, incorporate master data and business logic in reference tables to validate, map and extract data from source system and load into staging database.
• Experience in generating Ad hoc SQL reports using regular expressions & analytical functions like CUBE, ROLLUP, GROUPING and Window functions.
• Advanced Oracle SQL 10g programming using PIVOT, WITH clause and extensive usage of Analytical functions.
• Creating low level technical design documents which helps in converting complex business logic into technical solutions.
• Gather stage reporting requirements from business and identify the changes to existing conversion reports.
• Develop PL/SQL package to read data from staging tables, perform data mapping and Supported business users testing in MOCK and Production. Resolving defects during conversion.
• New development and modification of existing PLSQL stored procedures and functions in upgraded Applications as per client requirements.
• Create UML diagrams to depict conversion process flow.
• Performed Data Analysis / Data Quality to assist in the development and execution of PL/SQL scripts to support the ongoing AMDOCS conversion program by reporting on the quality of the network inventory data and other ARM object like Number, Subscriber Circuits etc. and their relationships.
• Carrying out Users Acceptance Test (UAT), go-live activities and Post implementation support.

Confidential, PA

Portfolio Manager/ Data architect

Responsibilities:

• Database design for enhancement projects for Risk History system and Reserve Allocation.
• The architecture involved incorporating new database entities into an existing model, correlating the established objects with new.
• Responsible for overall activities of the portfolio.
• Managing the Demand Capacity, Incident tracking, Time management, DART and overall reporting to the Client and Accenture management.
• Estimation and project planning through tracking the project to closure.
• Provide solutions to the team on complex modules.
• Worked extensively on writing complex SQL queries (cursors, sub queries, correlated sub queries), Analytical function like LEAD, LAG, RANK, DENSE RANK, CUBE, ROLLUPS to build optimized query and produce tabular reports.
• Provided 24x7support for multiple applications.
• Build SQL Loader process to load data from flat files to Oracle Database.
• Extensive use of UNIX Shell scripts to run Loading process with proper debug mechanism.
• Participated in system analysis and data modeling which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
• Experience in Data Analysis and managing data warehouse and data marts.

Confidential, PA

Team Member

Responsibilities: 

• Developed Low level design LLD documents for various interfaces based on the business requirements.
• Designed and developed several mappings involving active and passive standard/reusable logic using Datastage.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Analytical functions, Materialized Views and WITH Clause.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Have utilized Oracle Hints - DRIVER SITE, PARALLEL and many others to tune existing scripts to run faster.
• Primary On-Call support for PROD - 24/7.
• Working with DBA's and running jobs based on the priority.
• Production & Test batch maintenance. Automated the process of executing the jobs in sequence and created shell scripts for getting emails on job failures.
• Providing the Metrics showcasing the count of tickets, SLA performance, productivity etc.
• Expertise in handling errors using Exceptions.
• Extensively used Cubes & Rollups for making cross tabular reports.
• Assisted & worked with QA Teams for bug testing, User Acceptance Testing (UAT) & System Integration Testing.

Confidential

Team Member.

Responsibilities: 

• Analysis of Client requirements and providing design solution and test criteria.
• Developed Low level design LLD documents for various interfaces based on the business requirements.
• Has being the primary support resource in production support from offshore.
• Got exposure to work with Business users and interacted with them directly to understand the requirements and fixed nearly 10-15 critical tickets in a month where we faced issues for missing compensation to the users. Got appreciations from Delivery Lead and got awards for the same.
• Implementing and following quality processes and maintaining CMM related process documents.
• Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
• Programming ETL logic using PL/SQL procedures.
• Experience in Data Analysis and managing data warehouse and data marts.
• Preparation of unit Test cases and Test Plan (CTP)

Confidential

Team Member

Responsibilities: 

• Extraction of Package data from one view of Interspec and store in Data Warehouse.
• Retrieval of sales data from Data Warehouse/Cubes.
• Setting up of the development and test environment.
• Construction of cubes for packaging information.
• Generation of two reports on packaging material used in product sold: one annually and monthly.
• Extraction of initial load (data from January 2006 till July 2007) of package data from Interspec.
• Involved in the requirement gathering and requirement freezing.
• Analysis of Client requirements and providing design solution.
• Providing the data modeling solution for the project.
• Providing query solution for cube building and generation of reports.
• Integration testing of Datastage jobs.
• Authentication of reports.

Confidential

Team member

Responsibilities: 

• Implementation of the change requests as per client requirement.
• Providing quick fix to critical incidents.
• Identifying existing bugs and providing a fix.
• Integration Testing and User Acceptance Testing.
• Worked extensively on database related change requests.
• Trouble shooting critical production incidents and providing solution to the level 2 team.
• Handling escalated production incidents and fixing them.
• Involved in work estimation for the team using scientific techniques like Functional Point Estimation.
• Generation of reports as per client requirement.
• As Reference data manager, was responsible for maintaining the static data that is being displayed on the portal.
• Was involved in the stabilization, bug fixing and enhancement of the DCM script. (The Dynamic Content Migration (DCM), a java based export/import tool would move data from preview to publish on a daily basis)
• Analysis of Client specifications and providing design solutions to the team.
• Involved in PL/SQL Coding and worked on shell scripts.
• Implementing and following quality processes and maintaining CMM related process documents.
• Preparation of unit Test cases and Test Plan (CTP)

Confidential

Team Member

Responsibilities: 

• Setting up of the offshore development environment.
• Analysis of Client specifications.
• Worked on the database related change requests.
• Involved in debugging, code fixing and data manipulation activities.
• Maintenance of the database and the LDAP server.

Confidential

Team Member

Responsibilities:

• Involved in the 2004 enhancement phase.
• Analysis of Client specifications, Application design, Database design & Coding
• Delivery and production support.
• Handling change requests involving major enhancements, time bound production support, changes to database and design.
• Testing: Unit testing, Module testing & Integration testing.