iPhone Application Developer Ahmedabad : www.sufalamtech.com Sufalam Technologies Pvt Ltd

[sufalamtech]

Dear All,

We, Sufalam Technologies Private Ltd is-Ahmedabad-based Offshore Development Company providing services in-web application development, mobile application development, offshore product development to global clients.-

iPhone/Android Application- Developers
Java, J2ME, Objective C, Android

Job Type:-Full Time

Experience:-0-2 Years (Fresher having good knowledge in Java and C/C++ can apply)

Joining Time:-As early as possible

We believe in growing individuals along with the Company. At SufalamTech, You will be expected to take up challenges and will be given high responsibilities.-

Please only apply if you have correct attitude towards work and have the vision to grow.

Please send your latest CV to career@sufalamtech.com with following details.

Current Salary (if applicable):
Expected Salary:
Reason of Job Shift-(if applicable):
Any Contracts with Current Company-(if applicable):
When can you join?

Shortlisted candidates will be invited for the written test and personal interview.

Thanks & Regards,
Sufalam Technologies Private Ltd.
4th Floor, Right Wing, Drive-In Screen Building,
Drive-In Road.
Ahmedabad -380054
Gujarat, India.

http://www.sufalamtech.com

[Guest-IJT]

Name : Rajendra N Ahire
Email : raj.ahire25 AT gmail.com
Designation / Skillset : System Admin/ Tech Support/ Unix Aix ^.2
Dear Recruiter :
Perhaps you are interested in hiring an AIX System Administrator with superb knowledge of basic concepts in AIX and dedication to company satisfaction. I believe that my in depth knowledge and understanding on these technologies along with extensive hands-on in installing and maintaining the same and good understanding of LPAR, DLPAR, and storage technologies namely DAS, NAS, and SAN will be extremely valuable to your company.
My background, qualifications and work experience in system administration appear to be well suited to your company’s specific requirements. I am confident that I can make significant contribution to your company, specifically by providing excellent technical service support to your company and clients.
My achievements range from installing and configuring AIX operating systems a number of times on POWER machines at SOLAIX Technologies and at other places. I would like to offer my exemplary communication and technical skills to your company, as well as my dedication in providing superior UNIX System Administration.
Please refer to the accompanying resume to provide you with further details of my qualifications, in consideration for the position of UNIX System Administrator. I believe that I can be an asset to your company.
I look forward to hearing from you and thank you for sparing your valuable time in reading my letter and resume.

Resume :
CURRICULUM VITAE
Mr. Rajendra N Ahire

Objective
Seeking a challenging position as AIX Systems Administrator in a reputable company to enhance my skills and for career development.
Experience Summary : - 2+ Years
Highlights
- Configured UNIX infrastructure, and support for IBM RS/6000 servers. such as : OS installation and upgrade
- Monitor system performance and implement performance tuning ,using tools like iostat, vmstat, netstat etc.
- Manage user accounts and their permissions.
- Scheduling and performing backup and restore operations, server monitoring and health check.
- Management of Disks, LVM, File Systems & paging space using admin tool SMITTY.
- Device management in AIX.
- Basic knowledge of storage technologies like SAN, NAS, DAS.
- Understanding of LPAR and DLPAR.
Education
- B.E. (COMPUTER SCIENCE AND ENGINEERING) from BGPS Mandal Hi-Tech Institute of technology, Aurangabad. Dr.B.A.M.University, (Maharashtra). Completed in July-2008 securing DISTINCTION (67.12%)
- Diploma In Software Testing From ATS InfoTech (PUNE).
- Completed IBM 104 Test, ‘IBM Certified Specialist - System p Administration’
..
Professional Experience
1) Organization :- Muttha Associates (Jain Constructions) Pune.
Duration : - July 2010- Till Date.
Designation : - Network Engg. (UNIX System Admin).
Responsibilities :
- Responsible for all aspects of AIX System Administration and support for a RS-6000 server such as : OS installation and upgrade.
- Monitors system performance and implements performance tuning.
- Morning checks of systems/software, performing backups of data, Applying operating system updates, and configuration changes.
- Adding/deleting/creating/modifying user account information, resetting passwords.
- Responsibility for documenting the configuration of the system, troubleshooting any reported problems, System performance tuning, Keeping the network up and running.
- Answering technical queries.
2) Organization :-Sharadchandraji Pawar Polytechnic College.
Duration : - Jun 2009 – Jun 2010
Designation : - Lecturer and Head of Department.
Responsibilities :
- Holds a position of Lecturer and Head of department in Sharadchandraji Pawar Polytechnic, Aurangabad
- Subjects covered as a lecturer are like C, C++(OOPs).
- Acting as an External examiner in M.S.B.T to control the semester Exam.
- Acting as an Member of Internal Squad in M.S.B.T. Exam 2009-10
- Conducting Oral & Seminar in college.
- Setting up & checking the semester exam papers for R.B.T. (M.S.B.T).
3) Organization :- HCL Info system Pvt Ltd.
Duration : - 25 NOV 2008 to 27 May 2009.
Designation : - Technical Assistance.
Client : - National Information Center [N.I.C]
Environment : Linux, Java, Postgres-SQL
Job Profile : - The job involves providing support for C.I.P.A (Common Integrated Police Application), Project as Technical Assistance.
Responsibilities :
- C.I.P.A. was developed by the HCL Info system Ltd. under ‘NIC’ a division of Govt. of India.
- Organizing the training for the C.I.P.A software to police Dpt.
- Installing the NIC Linux & Updating the C.I.P.A. new version on the client side.
- Resolving all queries related to the C.I.P.A. software. Like Provide the IP address, Make the server and client, connectivity related issue, File shearing, CD Burning, and Pen Drive Mounting.
- Taking the Backup and restoring the Database from the server.
- At the end of every month, we take the monthly backup of the database and submitting the N.I.C head quarters Mumbai.
Technical Expertise
Operating Systems : UNIX : IBM UNIX AIX 6.1, Ubantu
MICROSOFT: Windows XP, Vista , Server 2003, 2008.
Languages Known : C, C++.
Testing Tools : Manual Testing & Automation tool like, WIN Runner, Q.T.P.
Database : MS-ACCESS. SQL
Subjects of Interest : OOPS, Computer Network, C-Programming.
Date:
Place: Mr. Rajendra N. Ahire
-------------------------------------------------------
More Information about this submission and submitter:-
___________________________________________________
Submission ID : 4373303
Date & Time : 15th Jul 2011 5:36 AM (UTC)
IP Address : 122.182.28.114
Browser Info : Mozilla/5.0 (Windows NT 5.1; rv:5.0) Gecko/20100101 Firefox/5.0
Predicted Country : India

[Guest]

Sreenivas
E-mail : Sreenivas_dwh AT yahoo.com
SUMMARY
- Having 9.7+ years of IT experience in Requirement Analysis, Design, Development, Testing, Implementation in Support of Data Warehousing ETL using Informatica power center /power mart and Reporting done using Siebel Analytics, OBIEE,Cognos,Business Objects and PL/SQL.
- Over 8.5 + years of experience on Informatica power center 5.x/6.x/7.x/8.x.
- 5 + years of experience in OBIA implementations.
- Around 5.6 + years of experience in OBIEE, Siebel Analytics 7.1/7.8.4 and DAC,Answers,Dashboards
- Around 1.5 years of experience in Cognos reporting and one project experience in Business Objects.
- Around 2+ years of experience in Datamodelling techniques using ER Studio.
- Over 2+ Year experience on Mobile CRM& BI Applications using Pyxis Mobile Applications for Blackberry.
- Experienced in designing of ETL processes, integration, maintenances, troubleshoot and tuning the processes.
- Working as an Informatica Administrator and Responsible for Creating Repositories, taking Backups and migration of Repositories and Repository restorations and Refreshing Repositories and other Administrator tasks.
- Proven and extensive experience in Architecting BI solutions and Datamodelling techniques and identified data the requirements including data elements and relationships as well as impact analysis on existing data structures.
- Strong knowledge in Dimensional modeling, Star schema, Snowflake Schema, data warehousing & Business Intelligence concepts and Decision Support systems.
- Worked closely with clients to understand the requirements and Designed/develop creative reporting solutions.
SKILLS
BI/DWH Informatica 8.x, 7.x, 6.X, & 5.2, SQL Server 2000 -DTS Packages, SAS Base 8.2
OBIA, OBIEE, Siebel Analytics 7.8.5.1-(DAC, Administrator, Answers, Dashboards, Ibots)
Cognos 7.x - Cognos Report Net – Report Studio & Query Studio.
Business Objects XI, Crystal Reports
DBMS Oracle 9i, 10g, SQLServer2003, 2005, Teradata,MS Access,Informix.,sybase
Data Modeling ER Studio, Erwin, Dimension Model for DWH/DM
Languages Java 1.2, C++, C, COBOL, SQL, PL/SQL
Front End/GUI Developer 2000, Visual Basic 5.0, and 6.0
Web Technologies HTML, DHTML, JAVA SCRIPT
Tools TOAD, Citrix, Visual Source Safe, MS Visio, Autosys, BMC Remedy
CRM Tools/ ERP Siebel CRM, Pyxis Mobile Applications, mPac, SAP BO XI
OS/Environment Windows NT, Windows 2000/XP, UNIX
Testing Tools Test Director, Mercury Quality Center
Trainings (1). Certification Program in Cognos Report Net in Patni Computer Systems, Bangalore.
(2). Business Objects XI in Patni Computer Systems, Hyderabad.
(3). Pyxis Mobile Applications and OBIEE in INVESCO, Houston, USA.
Certifications (1). Cognos Report Net. (2) Cognos Impromptu
AWARDS & REWARDS
Received best performer award from customer SBC and AT&T in Patni Computer Systems.
Received 2 times best performer Quarterly awards from INVESCO in Ness Technologies.
HANDS ON EXPERIENCE IN DOMAINS
1. Banking and Finance 2. Telecom
3. Pharmaceuticals 4. Retail Sales
PROFESSIONAL PROFILE
Working as a Technical Lead in Ness - INVESCO, Hyderabad from Jan 2007 to Till date
Worked as a Sr Engineer (S/W) in Patni Computer Systems, Bangalore from Apr 2005 to Jan 2007
Worked as a Programmer in Global ERP Solutions, Hyderabad from Apr 2002 to Mar 2005
PROJECT INFORMATION
Project #1 CE-CRM BI-Reporting
Technology OBIA- OBIEE, Informatica Power Center 8.x,DAC, SQL Server 2005, Pyxis Mobile Applications 6.2
Duration Sep 2010 – Till date
Client INVESCO, USA
The CE CRM (Continental Europe Customer Relationship Management) Project forms the next phase of the IVZ mandated global rollout of the Viaduct CRM system. Currently Viaduct is used in NA, UK and Asia Pacific. Although this initiative will provide many local benefits to CE, this CRM deployment should be viewed as a strategic imperative for the Global Distribution group. Moving CE on to the same CRM platform will allow client information to be shared across regions, helping to support a more collaborative sales strategy in targeting global, high potential clients.

Viaduct will replace the existing CRM system used in CE : Goldmine. Goldmine has been used for almost five years and has been extensively used to support the CE CRM business processes. Additionally CE has created an Access Database which stores additional CRM data, used for reporting. OBIEE and BO Reports is currently used to meet all the CE CRM reporting requirements. The project includes the rollout of Analytics, the Siebel reporting tool, to enable Crystal Reports to be replaced for CE CRM reporting.
Responsibilities
As a DWH/DM Designer :
- Working with different IT & Business groups to understand and determine the Impacts to the Data Warehouse and/or Data Marts for different projects
- Gathering business requirements and actively involved in analyzing, designing, developing, and testing and deploying custom data warehouse systems/applications; defining data requirements and designing databases to satisfy client business objectives.
- As a Warehouse Developer and a Data Analyst, the role involves developing source to target data attributes mapping, developing Target data dictionary, performing source to target attributes gap analysis, gathering and clarifying requirements from the users.
As Data Modeler :
- Participated in the Data mart designing using ER Studio as a modeler for new models.
- Updated existing data models as per new requirements.
As a BI(OBIEE) Reporting Developer :
- Configuring metadata and building Oracle Business Intelligence Repository consisting of three layers (Physical Layer, Business Model & Presentation layer) and creates business reports.
- Extensive experience in configuring Interactive dashboards with drill-down capabilities, Security Setup, Metadata Objects and Web Catalog objects.
- Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules Time Series.
- Expertise in complete life cycle implementation of OBIEE with Star and Snow flake schema.
- Experienced in DAC to configure, monitor and schedule ETL routines.
- Configured and modified several mappings from multiple sources like Siebel CRM, PeopleSoft, Oracle 10g, flat files and loading data to OLAP systems.
- Working on different layers of ADMIN Tool of OBIEE and developed new Siebel Analytics Dashboards and Reports.
- Developed new OBIEE Dashboards and Reports. Created and modified the existing reports as per Client request and worked on Analytics Repository.
- Expertise in Oracle PL/SQL Programs, Procedures, Functions, Triggers and other objects.
- Worked on Mobile BI apps Using Pyxis Mob Applications for Blackbelly,Ipad,Iphone….etc
As an ETL Developer :
- Reviewed Functional Design Document and Technical requirements Document and prepared HLDs and sharing the work among team members.
- Worked closely with Business Analyst, Discussed and Gathered the Analytics requirements from different user groups.
- Understanding database design and attribute descriptions and maintain and update data warehouse metadata repositories
- Maintaining and updating business intelligence ad-hoc & production master models
- Maintain and update Extract, Transform & Load (ETL) processes and developed database procedures, Aggregated Fact tables to optimize ETL processes.
- Supporting and implementing data integration processes for multiple source systems and heterogeneous systems.
- Involved in the creation of Technical design documents (SRS, Design Documents, and Source to Target mapping and UTP).
- Identification and resolution of problems encountered by the users of the systems.
- Grasped Comprehensive knowledge on power exchange to Industry-wide technology standards such as email, LDAP, and Web Services.
- Expertise in ETL (Extract Transform Load) data integration and Data Warehouse experience using Informatica Power Center 8.x/7.x, Repository Admin Console Informatica Power Connect for PeopleSoft/Siebel.
- Participated in User trainings and UAT.
Project #2 MARS ETL & Commissions Reporting
Technology OBIA- OBIEE, Informatica 8.x, DAC,SQL Server 2005, Pyxis Mobile Applications 6.2, ER Studio
Duration Apr 2009 – Oct 2011
Client INVESCO, USA
The Intention of this Project is to define the business requirements for converting AIM Private Asset Management’s of APAM, Vest mark, Wachovia, Wells Fargo, UBS,SSB,MSSB and Merylynch companies Daily Sales and Monthly Position files data would be loaded in to the MARS Data Warehouse and Creating BI reports on New Architecture.
Responsibilities
As a BI(OBIEE) Reporting Developer :
- Configuring metadata and building Oracle Business Intelligence Repository consisting of three layers (Physical Layer, Business Model & Presentation layer) and creates business reports.
- Extensive experience in configuring Interactive dashboards with drill-down capabilities, Security Setup, Metadata Objects and Web Catalog objects.
- Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules Time Series.
- Expertise in complete life cycle implementation of OBIEE with Star and Snow flake schema.
- Experienced in DAC to configure, monitor and schedule ETL routines.
- Configured and modified several mappings from multiple sources like Siebel CRM, PeopleSoft, Oracle 10g, flat files and loading data to OLAP systems.
- Working on different layers of ADMIN Tool of OBIEE and developed new Siebel Analytics Dashboards and Reports.
- Developed new OBIEE Dashboards and Reports. Created and modified the existing reports as per Client request and worked on Analytics Repository.
- Expertise in Oracle PL/SQL Programs, Procedures, Functions, Triggers and other objects.
- Worked on Mobile BI apps Using Pyxis Mob Applications for Blackbelly,Ipad,Iphone….etc
As an ETL Developer :
- Reviewed Functional Design Document and Technical requirements Document and prepared HLDs and sharing the work among team members.
- Worked closely with Business Analyst, Discussed and Gathered the Analytics requirements from different user groups.
- Understanding database design and attribute descriptions and maintain and update data warehouse metadata repositories
- Maintaining and updating business intelligence ad-hoc & production master models
- Maintain and update Extract, Transform & Load (ETL) processes and developed database procedures, Aggregated Fact tables to optimize ETL processes.
- Supporting and implementing data integration processes for multiple source systems and heterogeneous systems.
- Involved in the creation of Technical design documents (SRS, Design Documents, and Source to Target mapping and UTP).
- Identification and resolution of problems encountered by the users of the systems.
- Grasped Comprehensive knowledge on power exchange to Industry-wide technology standards such as email, LDAP, and Web Services.
- Expertise in ETL (Extract Transform Load) data integration and Data Warehouse experience using Informatica Power Center 8.x/7.x, Repository Admin Console Informatica Power Connect for PeopleSoft/Siebel.
- Participated in User trainings and UAT.
Project #3 Global VIADUCT Business Intelligence - Support
Technology OBIA- Informatica 8.x / 7.1.2, OBIEE,DAC, Pyxis Mobile Applications, SQL Server 2005
Duration Jan 2009– Till date
Client INVESCO, USA
The purpose of this project is loading data from various systems (mInstitutional, mWholesaler, VIDUCT, WINS, MARS, IRIS and CSC) in to INVESCO Siebel Data warehouse. All the jobs are scheduled from Autosys job scheduler. MIR3 is the North American Issue Escalation System. It is an automated system that sends out email notification and calls to the various on call resources based on the numbers set up in the system. For instance whenever an autosys job fails, MIR3 will send an automated call to the CRM primary on call resource.
Responsibilities
Monitoring jobs and giving solutions for failure jobs.
Project #4 INVESCO UK Retail CIM
Technology OBIA- Informatica /7.1.2, Siebel Analytics 7.8,DAC, SQL Server, Pyxis Mobile Applications, ER Studio
Duration Oct 2007 – Dec 2008
Client INVESCO, USA

UK Retail Sales, UK Institutional Sales, IDD are in the process of retiring an obsolete and unsupported CRM application (Goldmine) and migrating to the Siebel CRM platform (VIADUCT) used by INVESCO North America. In Case of IDD, data will be integrated from VIADUCT and Chronicle TA to allow IDD to build reports that combine Sales and CRM data. In case of UK Retail Sales, data will be integrated from VIADUCT, Chronicle TA, 3PD, and Touchstone to allow UK Retail Sales to build reports that combine Sales, Market Share and CRM data as well as viewing embedded sales reports within the Siebel CRM System.
The new reporting model will use existing VIADUCT Analytics infrastructure as much as possible and will be augmented where necessary to support the reporting needs of UK Retail Sales.
Responsibilities
As Data Modeler :
- Participated in the Data mart designing using ER Studio as a modeler for new models.
- Updated existing data models as per new requirements.
As a BI(OBIEE) Reporting Developer :
- Configuring metadata and building Oracle Business Intelligence Repository consisting of three layers (Physical Layer, Business Model & Presentation layer) and creates business reports.
- Expertise in complete life cycle implementation of OBIEE with Star and Snow flake schema.
- Experienced in DAC to configure, monitor and schedule ETL routines.
- Configured and modified several mappings from multiple sources like Siebel CRM, PeopleSoft, Oracle 10g, flat files and loading data to OLAP systems.
- Working on different layers of ADMIN Tool of OBIEE and developed new Siebel Analytics Dashboards and Reports.
- Developed new OBIEE Dashboards and Reports. Created and modified the existing reports as per Client request and worked on Analytics Repository.
- Expertise in Oracle PL/SQL Programs, Procedures, Functions, Triggers and other objects.
- Worked on Mobile BI apps Using Pyxis Mob Applications for Blackbelly,Ipad,Iphone….etc
As an ETL Developer :
- Reviewed Functional Design Document and Technical requirements Document and prepared HLDs and sharing the work among team members.
- Worked closely with Business Analyst, Discussed and Gathered the Analytics requirements from different user groups.
- Understanding database design and attribute descriptions and maintain and update data warehouse metadata repositories
- Maintaining and updating business intelligence ad-hoc & production master models
- Maintain and update Extract, Transform & Load (ETL) processes and developed database procedures, Aggregated Fact tables to optimize ETL processes.
- Supporting and implementing data integration processes for multiple source systems and heterogeneous systems.
- Involved in the creation of Technical design documents (SRS, Design Documents, and Source to Target mapping and UTP).
- Identification and resolution of problems encountered by the users of the systems.
- Expertise in ETL (Extract Transform Load) data integration and Data Warehouse experience using Informatica Power Center 8.x/7.x, Repository Admin Console Informatica Power Connect for PeopleSoft/Siebel.
Participated in User trainings and UAT.
Project #5 INVESCO VIADUCT Siebel Upgrade
Technology OBIA- Informatica7.1.2, Siebel Analytics 7.8,DAC, SQL Server 2000/2005, Oracle-10g, ER Studio
Duration Jan 2007 – Oct 2007
Client INVESCO, USA
Institutional business users of AMVESCAP, North America to report on the business critical reports and metrics, use VIADUCT Siebel Analytics instance. This is a down stream system of Siebel VIADUCT instance, a CRM system used by all Institutional business users. VIADUCT CRM instance is a customer centric OLTP system where as VIADUCT analytics is a Data warehouse system, optimized for business reporting and metrics collection. The purpose of this Project is need to add new Subject Area Information in the Siebel Data warehouse and capture the existing application details and requirements for Siebel Analytics upgrade Process.
Responsibilities
- Requirements gathering and requirements Analysis.
- Worked on upgrading the Informatica 6.2.1 version to 7.1.2 as part of Siebel upgrade.
- Involved in the creation of Technical design documents (Upgrade Checklist, SRS, Design Documents and Source to Target mapping and UTP).
- Upgraded the Siebel Data warehouse from the Old Environment to Current Version in DAC.
- Validation of the Informatica mappings and workflows according to the process flows. Fixing defects of the existing mappings and Participated in the UAT.
Project #6 VMU_Business Intelligence Reporting
Technology UNIX, Oracle 10g, PL/SQL, SAS 8.2, Siebel Analytics, Informatica
Duration Apr 2006 – Jan 2007
Client Virgin Mobile USA
Work Location Patni Computers Systems-TBU, Hyderabad
Virgin Mobile plc is a mobile phone service provider operating in the UK, Australia and Canada, and the US. The company was the world's first Mobile Virtual Network Operator, launched in the UK in 1999. This Project is aimed at delivering the Business requirement reports for the Virgin Mobile USA. There are two different kinds of reports :
Adhoc Reports and Recurring Reports. Virgin Mobile uses these reports for high-level business analysis and decision-making. Based on client requirements, we created reports by extracting data from the Siebel related database using Siebel Analytics, SAS/ACCESS, SAS/Base and PL/SQL.
Responsibilities
- Extracting the data from various databases.
- Analyzing of the data for the business requirement.
- Generating the business and ad-hoc reports.
- Preparing Unit Test Plan and executing Unit Test Cases.
Project #7 RUSS (Enterprise Sales Compensation-AADM DWH)
Technology Informatica7.1.1, Teradata, Oracle9i, SQLServer, DB2, PL/SQL
Duration DEC 2005 – April 2006
Client SBC - AT&T; USA.
Work Location Patni Computers Systems, Pune
This project essentially redirects existing billed revenue data into a new sales compensation calculator. Existing regional (e.g., CSTAR) and enterprise (e.g., AADM) solutions will very likely be impacted and may, in some cases, be replaced. The new solution will address enterprise data needs and will traverse all existing regions (Northeast, Midwest, Southwest, West and Global).and load them into a new sales compensation calculator.
Responsibilities
- Detailed Analysis of the requirements.
- Involved in data migration from heterogeneous sources.
- Involved in the creation of Technical design documents (Upgrade Checklist, SRS, Design Documents and Source to Target mapping and UTP).
- Responsible for the development of various mappings and Work flows i.e. ETL logic for the extraction, transformation and loading of data into the Targets
- Fixing defects of the existing mappings.
- Involved in Extraction, cleansing and transformation of the data by using different types of transformations.
Project #8 Affiliate & Adjustment Data Management (AADM 1.6)
Technology Informatica 7.1.1, Business Objects, Oracle 9i, SQL Server, PL/SQL
Platform Windows 2000, UNIX
Duration Sep 2005 – Dec 2005
Client SBC; USA
Work Location Patni Computers Systems, Pune

The primary objective of this solution is to improve data processing integrity with an initial focus on Affiliate related compensation transactions. Additional objectives are the reduction in the number of environments conducting compensation functions and move from a regional approach to an enterprise environment. With the consolidation of environment, the related costs for maintaining multiple system environments will also be reduced. This particular solution intends to achieve these objectives by employing a common mechanism for data extraction/acquisition from Affiliates, transformation/conditioning, and loading/submission into the core (existing Legacy) compensation system(s).
Responsibilities
- Involved in data migration from heterogeneous sources
- Responsible for the development of various mappings and Work flows i.e. ETL logic for the extraction, transformation and loading of data into the Targets
- Involved in the creation of Technical design documents (Upgrade Checklist, SRS, Design Documents and Source to Target mapping and UTP).
- Fixing defects of the existing mappings.
- Prepared and maintained of various documents.
Project #9 UCB BIA Data ware house
Technology Informatica7.1, Business Objects, PL/SQL
Duration Apr 2005 – Sep 2005
Client Advantage Management Solutions, Irvine, CA.USA
Work Location Patni Computers Systems, Bangalore


The Ultimate objective of the UCB BIA project is to deliver seamless information to the field force. When all the implementations are done data should flow in the below mentioned manner
From external vendor such as Ultmarc and IMS to the Customer Master.
From Customer Master, internal data source to Operational DB.
From Operational DB to data mart, Sales Report system and SFA
From SFA back to Operational DB
Project involves developing three main applications.
(1)A Windows GUI utility to extract, transform and load data into the Customer Master and Operation DB.
(2)A Web Portal to allow MR (Medical Representative) and management to view customer info adds and modifies customers, and view simple reports.
(3)A Sales Report system where customized report in Excel can be generated in regular Interval to top managements.
Responsibilities
- Responsible for the development of various mappings and Work flows i.e. ETL logic for the extraction, transformation and loading of data into the Targets.
- Involved in the creation of Technical design documents (Upgrade Checklist, SRS, Design Documents and Source to Target mapping and UTP).
- Unit testing. Test the mappings, workflows and check the quality of the deliverables.
- Involved in data migration from heterogeneous sources. Prepared and maintained various documents.
- Workflow Automation Process.
Project #10 BASEL II
Technology Informatica 6.2, Oracle 8i, PL/SQL, Business Objects
Duration May 2004 – March 2005
Client Abbey National, U.K.
Work Location Global ERP Solutions, Hyderabad
This project addresses the Basel II recommendations. This requires that the banks first define their credit, operational and market risk. The project currently undertaken by Abbey National deals with defining the credit risk of the bank. The Aim of Basel II recommendations is to calculate risk-weighted assets relying on 4 basic inputs 1) probability of default (PD) 2) loss given default (LGD) 3) exposure at default (EAD) 4) maturity (M).

The main intention of this project is to deliver no. of risk values by account wise on a monthly basis. These contain a row for each open account plus, all accounts that have closed within the Month found on source databases. Each account within the table will allocate no. of risk values. Transformation rules are needed to create each no of risk value. Each risk value is derived in two different possible roots. It will look up pre calculated values, which have been already stored (or) it will perform calculation. It will be useful for the functional user to analyze the different kinds of risks and to make a strategic decision.
Responsibilities
- Responsible for the development of various mappings and Work flows i.e. ETL logic for the extraction, transformation and loading of data into the Targets.
- Unit testing. Test the mappings, workflows and check the quality of the deliverables.
- Involved in the creation of Technical design documents (Upgrade Checklist, SRS, Design Documents and Source to Target mapping and UTP).
- Preparation and maintenance of various documents and Prepared Unit Test Plan and executing Unit Test Cases.
Project #11 Sales Report System - Project
Technology Cognos, Oracle, PL/SQL, Windows NT.
Duration Feb 2004- Dec 2004
Client Future Shop-USA/Canada
Work Location Global ERP Solutions, Hyderabad
This Decision Support System provides fund managers with convenient graphical approach to View and analyse portfolios. Designing popular designs like Sales and Profitability Analysis, Root Cause Analysis, Percent of Plan Analysis, Quality Analysis for creating different Reports like Variance Reports, Top Ten Reports, Exception reports, Trend over time reports, Quarterly Revenue statement, Business mix reports etc....
Responsibilities

- Created and Maintain Catalog, User classes and Access Privileges.
- Creation of Drill Through Reports, Slice/Dice Reports, Parent/Child Reports and Sub-Reports
- Scheduling the Reports, tasks and recurring tasks using COGNOS Scheduler
- Managing the different data source to create Power Cubes
- Providing extensive analysis by Adding Calculated Fields, Prompts, Filters to Catalog
- Creating Snap-Shots, Thumbnails, Hot Files
- E-Mail a Report/Publish as HTML etc…
Project #12 Marketing Campaign Datamart
Technology Informatica, PL/SQL, Oracle 8i, Cognos
Duration Nov 2002 - Jan 2004
Client Abbey National, U.K.
Work Location Global ERP Solutions, Hyderabad


The project is about developing operational customers Data mart. The fact tables contain data of the marketing details and details of the customers. In this project along with loading fact tables, slowly changing dimensional tables were also loaded. This fact table describes campaign and contact history. The fact table is sliced by a number of conformed dimensions as follows : Campaign, Customer, Customer mini dimensions, characteristics, segment and customer indicators, Holdings, Holding mini dimensions, characteristics and holding indicators. This is a special type of fact table in that it is tracking an event; i.e. marketing campaign, and as such there is not a measurable fact appropriate to this table.
Responsibilities
- Responsible for the development of various mappings and Work flows i.e. ETL logic for the extraction, transformation and loading of data into the Targets.
- Validation of the Informatica mappings and workflows according to the process flows. Fixing defects of the existing mappings.
- Prepared and maintained various technical documents.

Project #13 Sales and Order Processing System
Technology Oracle 8, PL/SQL, VB 5.0
Duration Apr 2002 to Oct 2002
Client Ayurvedic Company
Work Location Global ERP Solutions, Hyderabad

This project was developed for Ayurvedic Company, which has spread all over Andhra Pradesh. This project deals with maintenance of products transaction and sales and orders. This project involves in maintaining the information of chemist, doctor, representatives and distributors. Since these are the centre keys of transaction for company. This project contains different type of reports creation with respect to the chemist, doctor, representative wise and state, district, and zone wise.
Responsibilities
- Involved in Study, Analysis, and Design and Development phases of this project.
EDUCATION
MCA with First Division from Nagarjuna University Guntur, India.
BSC (M.P.C) with First Division from Nagarjuna University Guntur, India.