SUMMARY

• 10+ Years’ experience in IT sector with expertise in delivering projects of various sizes.
• Have worked in all facets of software development life cycle like analysis, design, development, unit testing, system integration, implementation and production support as a Database Designer, an Oracle Developer, and as a Data Architect
• Strong technical expertise in Conceptual Data Modeling, Logical Data Modeling, Physical Data Modeling, Enterprise Data Warehouse Design, Operational Data Store Design, Data Mart Design, Data Architecture, and Data Analysis.
• Expertise in writing and analyzing complex SQL queries to retrieve data from large data sets.
• Expertise in building database - centric Internet as well as client server applications for Oracle9i/10g/11g.
• Experience doing a proof of concept to understand capabilities of Data Visualization and Data Discovery tools such as Tableau and Qlikview
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques
• Effectively made use of Indexes, Partitioning, Collections, Analytical functions, Materialized Views
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL
• Developed materialized views for data replication in distributed environments
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables
• Created Packages and Procedures and worked extensively on Ref Cursor, External Tables, Collections, Dynamic SQL, Collections and Exception handling.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab and dollar universe
• An effective communicator with exceptional relationship management skills with the ability to relate to people at any level of business and management.
• Acquainted with the ETL framework and tools like Informatica, OBIEE.
• Areas of excellence: Relational Database Management, Data Modeling, & Data Warehousing Transition, Change & Release management PL/SQL Programming, Oracle Forms 6i/9i, C, C ++ Informatica (ETL) and OBIEE
• Expertise in Oracle, PL/SQL, Sound knowledge on Relational Database, Data Modeling, Data Warehousing, ETL methodologies & framework.
• Skilled in developing project plans, requirements specifications, user documentation, and architectural systems research.
• Highly adaptable in quickly changing technical environments with strong organizational and analytical skills
• Expertise in Sales IT domain with exposure on various process areas such as Inventory, Orders, Bookings, Forecast, Opportunities, Goal etc.
• Expertise on ERMO & Transition processes, planning, implementation & infra procurement.
• Driving end to end operations of large scale projects/initiatives.
• Implementing project plans within preset deadlines and SLA’s and on the Quality Parameters.
• Handling teams across India and US and ensuring all adhere to the given SLA’s.
• Mentoring and coaching team members as and when needed and also giving regular feedback.

TECHNICAL SKILLS

Database: Oracle, Teradata

Language: Oracle PL/SQL, SQL, C, C++

Tools: Informatica, OBIEE. BO, Dollar Universe

Other Tools: Software Products & Language Oracle Forms 6i/9i, Perl Script, Shell Script, Java

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Architect

Responsibilities:

• Data Architecture for GE Transportation Data Aggregation (Rail & Locomotives)
• Development of conceptual, logical, and physical data models; data quality; SQL and PL/SQL development; extract, transform, and load (ETL) strategies; tuning; replication; and solving object-relational mapping challenges; analysis of business and technical requirements, and mapping them to implementation strategies and design
• Worked on POC to understand the capabilities of Data Visualization and Data Discovery tools: Qlikview and Tableau.

Confidential

Database developer and Project Lead

Responsibilities:

• Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
• Develop, track, analyze, and communicate development related metrics to project stakeholders.
• Keep Management, Project Managers and stakeholders informed of current state of progress against pilot / production readiness criteria.
• Ensure completion of all deliverables within schedule, budget and quality constraints.

Confidential

Transition & Deployment Service Lead

Responsibilities:

• Deployment Management
• Project Assessment
• Infrastructure Support
• Communications

Confidential

PLSQL Developer and System Analyst

Responsibilities:

• IT analyst for One Cisco Forecast and involved in end to end execution and design processes.
• Involved in biz requirement gathering and BRD reviews.
• Documenting and analyzing the business rules to eliminate redundant and inefficient processes and practices.
• High level design document which gives a brief description of how the requirements are to be implemented
• Low level design document which contains a detailed description of the logic how the requirement is to be implemented.
• Star Data Model Design - Facts, Dimensions and Aggregates Design and Development
• Leading the development efforts for the project.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart

Confidential

System Analyst and Software Developer

Responsibilities:

• Being onsite lead for the project, I was involved in overall planning, execution, development, QA efforts & transition for the project.
• Identification of the various cross flows impacted due to the migration, boundary analysis formed part of this role.
• Involved in driving the UAT/load testing efforts prior to Go-Live.
• Worked closely with the GPSS RMO, transition and infrastructure teams which ensured successful Go-Live of the initiative.

Confidential

System Analyst and Software Developer

Responsibilities:

• I was the end to end execution lead for this project.
• Responsible for transition, change &release management activities for the project.
• Infrastructure engagement and discussions with the SCM,DBA,$U teams formed part of Confidential as execution &transition lead for CHAMPION.
• Closely coordinated with the 30+ application teams within GPSS for testing during the various test cycles being part of ERMO release.
• Successfullydeployed new interface to Oracle HRMS for around 30 applications within GPSS.
• Being the transition & execution lead was responsible for impact analysis for GPSS applications and coordinating with the various stakeholders.

Confidential

Software Developer

Responsibilities:

• Being offshore lead for this project was involved in requirement analysis,backend (Oracle) development and testing.
• Design and development of Dollar Universe jobs.

Customer

Confidential

Responsibilities:

• This application has scope of Global level as well as to a specified geographic location also.
• It calculates accrual amount and rebate amount that CISCO has to pay to its Partners and Distributors based on their Point of Sales Information provided by them under various Value Incentive Program carried by CISCO for product promotions.

Confidential

Software Developer

Responsibilities:

• Being offshore lead for this project was involved in requirement analysis
• Design and development of Oracle Forms for Rebate Engine

Confidential

Software Developer

Responsibilities:

• Maintain and enhance Oracle Based Online Application.
• To assist in some DBA level activities such as database installation, creating users & tablespaces, maintaining roles & rights, export & import.