Preferred Industry Ü Information Technology

• Expertise in analysing data using various tools such as MS Excel, SQL, Informatica, Business Objects and Cognos.
• Experience in Data Warehousing, Data Analysis and Data Modeling. Exhibit in-depth understanding of business functional areas, business management issues, and data analysis.
• Seeking an opportunity and a challenging position that would utilize dynamic capabilities for career growth and advancement toward professional excellence.
• Analytical at identifying problems and rapidly implementing solutions.
• Extensively used Informatica Client tools - Source Analyzer, Warehouse
• Designer, Mapping Designer, Informatica Repository Manager and Informatica Workflow Manager.

Core Strengths

Project and Operations Management
Database Design and Analysis
Enterprise Solutions
Systems Implementation
Clients Needs Analysis
Continuous Process Improvement
Business Process Reengineering
Leadership and Team Collaboration
Conflict Resolution and Decision Making

Technical Acumen

ETL Tools
Business Software

Informatica Power Center 7.xx/8.xx
SAS Enterprise Miner, XL Miner, IBM Rational Modeler, SAP ECC 6.0, SAP BW 7.0, Erwin

Microsoft Products

Visio, MS Project, MS Office (Excel, Word, and PowerPoint)

Databases

MS SQL Server 2008, Oracle 10g/11g, and MS Access 2007

Languages

SQL, PL/SQL, UML

Credentials

• Master of Information Technology and Management
• Bachelor of Science in Electronics and Telecommunication Engineering
• SAS Institute Graduate Certificate in Business Intelligence and Data Mining

Related Experience

Informatica Developer | Confidential | Maharashtra, India | Jul 2008-Mar 2009 and
Confidential | Maharashtra, India | Apr 2008-Jul 2009

• Worked with Business Analyst to gather business requirements and involved in weekly team meetings.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Co-ordination with different vendors who are handling different sections of the project.
• Conducting training sessions for process support group.
• Expertise with analytical reporting using Advanced Excel features like Pivot tables and charts.
• Worked with subject matter experts, IT professionals, and software developers to define project scope and objectives.
• Understanding the existing application functionality, existing ETL mappings.
• Identified source systems, connectivity, tables, and fields, ensure data suitability for mapping.
• Used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Informatica Repository
• Manager and Informatica Workflow Manager.
• Developed mappings using Informatica Power Center Designer to transform and load the data from various source systems like Flat files and Oracle source database and loading to Oracle target database.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression and Sequence Generator transformations.
• Monitored Workflows and Sessions using Workflow Monitor.
• Precise Documentation was done for all mappings and workflows.

Network Analyst & Planning Intern | Confidential | Maharashtra, India | June 2006-June 2007

• Performed network modeling, planning and resource management.
• Performed Analysis of existing network sites and prepared upgrade plans using MS Visio.
• Performed Management Reporting in Excel.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.

Transportation and Parking Mgmt| Confidential | Richardson, Texas | May 2010-May 2011

• Managed smart card publishing.
• Data extraction from database using SQL Queries.
• Facilitated distribution of smart cards.
• Involved in Car Parking Management for UT Dallas.

Academic Projects

Database Management Systems

• Designed and implemented a database using the entity relationship modeling technique with understanding of relationships, data types, tables and queries
• Forms and Reports creation using SQL Server 2008 and access database.

System Analysis and Project Management

• Modeled an information system using Unified Modeling Language (UML) diagrams.
• Analyzed an existing system and identified the causes of an information related problem, and designed a new system using class, sequence, ERD, Use Case diagrams to mitigate these problems.

Key Achievements

• Awarded Dean's Excellence Scholarship for academic excellence by the School of Management, UTD
• Promoted to Deputy Manager Level in Reliance ADA Group of Industries for portraying excellent technical, management, communication and customer support skills.
• Distinction in Under-Graduate Engineering degree and Master's Degree at University of Texas at Dallas.

Affiliations and Activities

• SAP User's Group at University of Texas at Dallas.
• Association of Information Technology Professionals at University of Texas at Dallas.
• Volunteer for spring 2010 Career Expo held at University of Texas at Dallas.