SUMMARY:

• Knowledge of full life cycle implementation in building a Data Warehouse. On Oracle and Big data platform. on Hadoop, Oracle and Informatica
• Strong analytical and communication skills to work across teams (technical and non - technical) and ability to work independently.
• Excellent leadership skills including issue management, team building and staff management.
• Experience in Leading team of Onsite-Offshore Model
• Extensively used ETL methodology for supplying Data Extraction, Transformations, loading to process solution in a corporate - wide - ETL Solution using Informatica Power Center 6,7,8.x
• Experience in Tableau Reporting
• Knowledge of Hadoop and HIVE, Spark,RESTful API, Kafka,Sqoop
• Very strong in writing SQL, PLSQL scripts in Oracle 9i,10g,11g,Python, Unix shell scripts
• Extensively worked on Data migration, Data Cleansing and Data Staging of operational sources using ETL process and providing data mining features for Data warehouses.
• Exposure to Dimensional Data modeling, star schema and snow flake schema modeling.
• Proficient in all phases of the systems development lifecycle, including requirements definition, system implementation, system testing and acceptance testing.
• Good knowledge on Business Analysis
• Versatile team player with proven problem solving skills, excellent communication and interpersonal skills. Exceptional ability to master new technologies, concepts

COMPETENCIES

Programming Skills: SQL*PLUS 8.x/9.x, PL/SQL 8.x / 9.x,Python, Unix Shell Script, Spark

Report Tools: Tableau OBIEE, COGNOSE

Databases: Oracle 11g/10g/9i/8i, MYSQL, HIVE,MONGODB

ETL: Informatica 9X, 8.x/7.x/6.x/5.x (PowerCenter),Sqoop

Operating Systems: Win 95/98/2000/XP/NT, Windows Vista, Windows 7,Linux, Ubuntu

PROFESSIONAL EXPERIENCE:

Confidential, San Jose

Technologies: Hadoop, Hive, Spark, Tableau, Mongo DB, RESTful Web services, Informatica 9.6

Data Lead

Responsibilities:

• Working as Analyst/ Tech Lead
• Design the Architecture of Integration of Rest API, Mongo DB and Hadoop Platform
• Tableau report building
• UNIX shell scripting.
• Co coordinating between onsite and offshore team
• Participated in all phases including Client Interaction, Design, Coding, Testing, Release, Support and Documentation.
• Do performance tuning of Integration ETL
• Provide Leadership to Team at and onsite and help them on resolving technical issues.

Confidential

Technologies: Informatica 9.1, MS SQL,Netezza

Tech Lead/Project Lead

Responsibilities:

• Working as Tech Lead
• Co coordinating between onsite and offshore team
• Participated in all phases including Client Interaction, Design, Coding, Testing, Release, Support and Documentation.
• Do performance tuning of Integration ETL
• Provide Leadership to Team at and onsite and help them on resolving technical issues.

Confidential, San Jose, CA

Technologies: Informatica 9.1, Unix Shell Scripting, Oracle, OBIEE 10g, Hive, Sqoop

Tech Lead/Project Lead

Responsibilities:

• Worked as Tech Lead to build analytical platform and worked on various analytics projects.
• Design the Architecture of Integration of test logs and bring data in data mart for analysis purpose
• Tableau report building
• Unix shell scripting.
• Co coordinating between onsite and offshore team
• Participated in all phases including Client Interaction, Design, Coding, Testing, Release, Support and Documentation.
• Do performance tuning of Integration ETL
• Provide Leadership to Team at and onsite and help them on resolving technical issues.

Confidential

Technologies: Informatica, Oracle, Unix Shell Scripting

Onsite Data Integration Lead

Responsibilities:

• Co coordinating between onsite and offshore team
• Participated in all phases including Client Interaction, Design, Coding, Testing, Release, Support and Documentation.
• Do performance tuning for current ETL
• Provide Leadership to Team at and onsite and help them on resolving technical issues.
• Developing ETL’s to integrate different systems.
• Developing batch schedules to process data.
• To apply performance tuning techniques and maintain productivity and time-standards.
• Using repository manager to create folders, users, user groups and assign privileges according to functionalities.
• Dimensional modeling using STAR schemas (Facts and Dimensions).
• Involved in Unit testing, integration Testing and writing test scripts.
• Used Informatica 9.1 to create, schedule, monitor and send the error messages in case of process failure.
• Design and development of UNIX Shell Scripts.
• Worked on data conversions and data loads using PL\SQL and Informatica Mappings
• Involved in Performance Tuning.
• Designed a mapplet to update a slowly changing dimension table to keep full history which was used across the board.

Confidential, San Jose, CA

Technologies: Informatica, Oracle, OBIEE, Unix Shell Scripting

Onsite Tech Lead

Responsibilities:

• Working as Tech Lead
• Co coordinating between onsite and offshore team
• Participated in all phases including Client Interaction, Design, Coding, Testing, Release, Support and Documentation.
• Do performance tuning for current ETL
• Provide Leadership to Team at and onsite and help them on resolving technical issues.
• Supporting the application by providing solution to the problems faced by the Analysts.
• Proactively monitoring the Application to avoid major impact on to the Business
• To apply performance tuning techniques and maintain productivity and time-standards.
• System study & maintenance.
• Using repository manager to create folders, users, user groups and assign privileges according to functionalities.
• Dimensional modeling using STAR schemas (Facts and Dimensions).
• Involved in Unit testing, integration Testing and writing test scripts.
• Wrote stored procedure to check source data with Warehouse data if it not present written that records to spool table and used spool table as Lookup in Transformation.
• Used Informatica 8.6 to create, schedule, monitor and send the error messages in case of process failure.
• Generated weekly and monthly report Status for the number of incidents handled by the support team.
• Design and development of UNIX Shell Scripts.
• Worked on data conversions and data loads using PL\SQL and created measure objects, aggregations and stored in MOLAP mode.
• Involved in Performance Tuning.
• Designed a mapplet to update a slowly changing dimension table to keep full history which was used across the board.
• Provided 24*7 Production Support.
• Responsible to gather and document reporting requirements for the business core team
• Translated and documented high level requirements into technical design documents
• Built OBIEE Repository at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables, Hierarchies, Levels, and data source mapping) and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model.
• Understanding the design considerations for star schemas and its relationships.
• Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security. Extensive experience in Metadata Modeling at all three layers (Physical, Business Model and Presentation) using the OBIEE. Administration Tool. Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
• Designed and Engineered Caching for drill downs, Cache Seeding (IBots) and Cache purging processes.

Confidential

Technologies: Cognos Report net, Oracle, Unix Shell Scripting

Offshore Lead

Responsibilities:

• Creating a new client reporting instance.
• Creating client users and permissions.
• Providing a set of base reports, plus any client variations.
• Analyzes client customization requests and recommends a solution.
• Implementing custom reports.
• Modifying the base Cognos model when necessary to meet a unique customer request.
• Creating user and passwords using LDAP.
• Creating Cognos access control lists and configures for each client.
• Deploying new/revised Cognos models to staging and production.
• Troubleshooting Cognos failures related to:
• Cognos server failure
• Apache failure
• OpenLDAP failure
• Database access failure

Confidential

Technologies: Oracle PL/SQL, Confidential Reporting tool

Developer

Responsibilities:

• Getting information for New Reports from client.
• Developing new reports.
• Bug fixing in existing reports.

Confidential

Technologies: Oracle PL/SQL, Visual Basic

Developer

Responsibilities:

• Knowledge transfer from onsite to offshore.
• Supporting software from India office.

Confidential

Technologies: Oracle PL/SQL, Visual Basic, Crystal Reports

Developer

Responsibilities:

• Taking project requirements from client.
• Database designing.
• Software development and testing.