SUMMARY

• Extensive 7+ years of IT experience in Business Requirements Analysis, Application Design, Development, Implementations and Testing of Data warehousing.
• Extensive Data Warehouse experience using Informatica PowerCenter (Source Analyzer, warehouse Designers, Repository Manager, Server manager, Mapping/Mapplet / Transformations, Repository Server, Workflow Manager)
• Expertise in creating mappings, reusable transformations and workflows using Informatica.
• Experience in integration of various data sources like SQL Server, Flat Files into the staging area.
• Extensively worked to build complex mappings using Informatica designer components like expressions, Routers, Lookups, source qualifiers, aggregators, filters, joiners.
• Expertise in all aspects of designing structured information reports, developing ad hoc queries and DTS packages.
• Responsible for interacting with business analysts and business users to identify information needs and business requirements.
• Acquired excellent analytical, interaction, co-ordination skills, have immense leadership potential.
• Result oriented professional, self motivated with excellent verbal, written and interpersonal skills
• Outstanding team player with an aptitude to learn.

PROFESSIONAL EXPERIENCE

Sr. Data Warehouse Developer
Confidential, Rosemont, IL Jul. 2005 - Present

• Perform admin task like Informatica PowerCenter installation, Servicepack installation, Repository backup and restore, Deployment and scheduling of workflow, Monitoring workflow, etc.
• Deploy Sessions/Workflow from development to QA and from QA to production environment.
• Configure Email notification on development, QA and production environment.
• Responsible for mapping version control.
• Create and monitor Sessions using Workflow Monitor to load data into target SQL Server database.
• Analyze the system, met with end users and business units in order to define the requirements.
• Design and built an Informatica mapping that creates a table to support enrollment staff when legacy system is down which saves hundreds of man hour while legacy system is down or running behind.
• Maintain warehouse metadata, naming standards, ETL best practices and warehouse standards for future development.
• Extract the data from SQL Server, ORACLE databases, Flat files and load into target warehouse SQL tables using Informatica, DTS package and Business Information Exchange (BIX).
• Translate business requirements into source to target document.
• Use Informatica Designer to create complex mappings using different transformations like filter, Router, lookups, stored procedure, joiner, update strategy, expressions and aggregator to pipeline data to Data Warehouse/Data Marts.
• Extract PRPC data from Pega system to SQL Server using BIX.
• Troubleshoot problems by checking sessions logs.
• Tune Informatica Mappings for optimum performance.
• Responsible for the maintenance(Backup, Restore, Log file shrink, etc) of Team Development server.
• Developed a process toloop workflow in informatica to check on restore.
• Admin ER Studio repository and user setup in ER Studio.
• Write SQL Queries, SQL Procedures, DTS Packages to apply and maintain the Business rules.
• Devlope database report using Crystal Report and Reporting Services.
• Devlope DTS packages to perfrom cross platform data transfer/integration.
• Automated Contact letter communication process using DTS as well as First Data Bank update process using Informatica command task which save so many man hours.

Project Analyst
Confidential, Riverwoods, IL Aug. 2004 - Jul. 2005

• Designed/managed applications to provide enhanced information feeds to business users from Order Management.
• Updated application using SalesLogix client, administrator and SalesLogix architecture.
• Responsible for system data accuracy and audit procedures.
• Experience with cross platform data transfer/integration in MS-Access, SQL Server and ORACLE.
• Run SQL Queries to analyze and compare data and find discrepensies and make correction if require.
• Analyzed, designed and documented complex T-SQL Queries, Nested queries DTS packages and SQL Jobs.
• Devloped database report using Reporting Services.
• Provided user support to Business Unit Sales and Marketing users as require.
• Assisted in training to Sales Management Information staff where required.

Web Developer
Confidential, Gujarat, India Dec. 2002 - Jan. 2004

• Reviewed, analyzed, evaluated and developed application to meet customer requirements.
• Wrote detail description of user needs, program functions and steps required to develop or modify web applications.
• Worked with ASP, HTML, DHTML, VBScript, JavaScript, Dreamweaver, PhotoShop and SQL Server.
• Designed the application to meet the user's requirements document.
• Ensured web-based application is compatible with IE and Netscape, developed page layout, generated code, and debugged code.
• Developed a demo version of the product in MS-PowerPoint to solicit and incorporate feedback into the design.

Software Engineer
Confidential, Gujarat, India Aug. 2001 - Dec. 2002

• Studied customer needs, designed test plan and developed test cases.
• Involved in designing and architecture of the software.
• Developed process flowchart using MS Visio and MS Project plan using MS Project.
• Coded with Visual Basic 6.0, designed reports with the help of Crystal reports, and handled databases in SQL-Server and ORACLE.
• Compare reports against legacy system to make sure the software works and corrected it if required.
• Developed a demo version of the product in MS-PowerPoint to solicit and incorporate feedback into the design.
• Provided technical support to client whenever needed.

EDUCATION

• Master of Science in Computer Science
• Bachelor of Engineering in Computer Science

TECHNICAL SKILLS

ETL Tool: Informatica PowerCenter, Business Information Exchange(BIX), DTS
Programming Languages: Visual Basic 6.0, FoxPro 2.6, C, C++, Basic
Technology: ASP 3.0
Web Development: VBScript, JavaScript, HTML, DHTML, DreamWeaver-MX, MS-FrontPage, MS-Interdev
Database Software: SQL Server, ORACLE, MS-Access, Rapid SQL, ER Studio
Tools: Crystal Report, MS Visio, Tactician, MS Project, Adobe Photo Shop, Visual Source Safe, Putty, Cute FTP, WinSCP
Operating Systems: Windows 95/98/2000/XP, MS-DOS
Application Packages: SalesLogix 6.2, MS-Office

HONOR
Awarded Rajasthan Shiksha Parishad Award from Mayor of Surat.