Project Lead
WIPRO INFOTECH
Total years of experience :9 years, 2 Months
Since July’11 Till Date WIPRO INFOTECH Project Lead
Occupation or position holds Project Lead
Project DIB
Client Dubai Islamic Bank
Client Domain Banking
Technologies used ERWIN, Datastage, Netezza
Project Duration Feb-13 to till date
Roles and Responsibilities
1 Source system study and understanding customer business
2 Identifying data elements for Data warehouse Data Modelling
3 Creating enterprise data model using ERWIN
4 Designing of dim and facts for warehouse
5 ETL development of the designed data model through Data stage and Unix Scripting
6 Data modelling of I-Flex, LMS, Microsoft Dynamics CRM, FRS, MIS, LOS etc.
7 Design and implementation of data models for TAT, Central Bank & Enterprise Balance sheet
8 SAP universe designing and dashboard creation
9 Defining distribution keys, generating stats and grooming tables in Netezza
10 Customer engagement for UAT signoff
11 Production roll out
12 Knowledge transfer to customer L1 support team
Occupation or position holds Project Lead
Project PEX
Client Punjab Government, India
Client Domain Excise and Taxation
Technologies used Datastage, OBIEE 11g, Oracle 11g
Project Duration July-11 to Jan-13
Roles and Responsibilities
1 Requirement gathering (SRS creation)
2 Converting SRS into technical design/solution
3 ETL development using Datastge
4 Data warehouse designing
5 Installation of OBIEE 11g on Windows/Linux/AIX environment
6 Upgrading OBIEE from 11.1.1.5.0 to 11.1.1.6.0
7 Applying patches on OBIEE
8 Security implementation (LDAP, SSO, data level and object level) in OBIEE
9 RPD designing (physical layer, BMM layer star schema creation, hierarchy creation, presentation layer, RPD variables, cache purging)
10 Dashboard designing (filters, dashboard prompts, drill down, drill through, ad hoc reporting)
11 RPD and web catalog merging and migration from one server to another
12 Creating data models and reports in BI publisher 11g (drill through reports using RTF templates)
13 ETL review
14 Provide training to customer
15 UAT closures
16 Helping Pre Sales team for customer demo
Occupation or position holds IT Analyst
Project Trackwise BI
Client GE
Client Domain Healthcare
Technologies used OBIEE 10g, Teradata SQL Assistant
Project Duration SEP-10 to July-11
Roles and Responsibilities
1 Converting SRS into technical design
2 OBIEE RPD designing (joining different data sources, script calling in connection pool, physical layer, BMM, presentation layer, repository variables, setting execution precedence, implicit fact columns)
3 Creating dashboards
4 Cache seeding and purging
5 Implementing security in OBIEE (object level, data level, LDAP)
6 RPD and web catalog migration from one environment to another
7 Guiding and helping other team members
Occupation or position holds Consultant Oracle Applications
Project RRA
Client Sapient Internal Teams
Client Domain HR, L&D, Finance, TA
Technologies used OBIEE 10g, Oracle 9i
Project Duration OCT-08 to NOV-09
Roles and Responsibilities
1 Requirement gathering, system study & impact analysis
2 Writing PL/SQL (Packages, Stored Procedures, Functions and Triggers)
3 Modifying RPD (adding new tables, BMM layer designing)
4 Dashboard creation
5 Code migration from one server to another
6 UAT closures
7 Guiding and helping other team members
Occupation or position holds Consultant Oracle Applications
Project Pyramid Retire
Client Sapient Internal Teams
Client Domain HR, L&D, Finance, TA
Technologies used OBIEE 10g, Oracle 9i
Project Duration NOV-09 to Aug-10
Roles and Responsibilities
1 Requirement gathering, system study & impact analysis
2 Writing PL/SQL (Packages, Stored Procedures, Functions and Triggers)
3 Modifying RPD and dashboard creation
4 Code migration from one server to another
5 UAT closures
6 Guiding and helping other team members
Occupation or position holds Sr. System Engineer
Project Data mart, Switzerland
Client London Bus system Ltd.
Client Domain Transportation
Technologies used PL/SQL, Oracle 10g
Project Duration Aug-07 to Oct-08
Roles and Responsibilities
1 Converting SRS into technical design
2 Database installation (oracle 10g)
3 Writing PL/SQL (Packages, Stored Procedures, Functions and Triggers)
4 Creation and deployment of database patches to improve the performance of the live system
5 Guiding and helping other team members in solving database related problems
Occupation or position holds Programmer
Project Vendor Payment System
Client Maruti Udhyog Ltd.
Client Domain Finance
Technologies used D2K, UNIX, PL/SQL, Oracle 9i
Project Duration Oct-06 to Jul-07
Roles and Responsibilities
1 Writing PL/SQL (Packages, Stored Procedures, Functions and Triggers)
2 Providing Patches for the fixing of bugs in Oracle ERP
3 Production Support
4 Customizing existing forms and reports
5 Writing Unix shell scripts
6 Interacting with customer for requirement analysis
Occupation or position holds Software Engineer Trainee
Project KUMIS
Client Kurukshetra University
Client Domain Education
Technologies used D2K, PL/SQL, Oracle 9i
Project Duration Jul-05 to Oct-06
Roles and Responsibilities
1 Writing PL/SQL (Packages, Stored Procedures, Functions and Triggers)
2 Creating new forms and reports
3 Database import/export
4 Creating users, profile, grants and roles
5 Interacting with customer