SUMMARY

• I have 10+ years of IT industry experience working in a range of responsibilities with diverse client engagements globally including architecting, end - to-end BI/DW development & implementations, managing projects, product & technology positioning, solutions, Proof Of Concept, proposal, delivering trainings, and administering.
• Worked on multiple tools Informatica and Microsoft Business Intelligence suite using data warehousing techniques most of my career.
• I have a good understanding of BI tools used in market.
• Involved in multiple proposals of BI and working with sales team and interacting client to understand requirement and providing solutions. After solution/proposal acceptance providing estimation, resourcing and creating budget.
• In-depth knowledge and experience in managing Schedule, Scope, Risk, Quality, Communication and Resources with proven ability to deliver high quality IT products and services on schedule and under budget using
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Experience in working with business analysts to identify study and understand requirements and translated them into ETL code.
• Strong verbal, written, and interpersonal communication skills with ability to bridge the gap between Business Client and IT department.
• Have Good Experience as Onsite coordinator with exposure of onsite offshore model.

TECHNICAL SKILLS

Databases: Oracle 7.x/8.x/9x/10g/11g, SQL Server 2008/2005/2003/2000 , MS-Access.

ETL Tools: Informatica Power Center 8.x/9.x, Informatica Power Exchange 9.x, Informatica Developer 9.x, SSIS.

Data Modeling: Visio

Portals: SharePoint 2010, MOSS 2007 (BI)

Reporting Tools: MS SQL Server reporting services.

Programming Languages: Unix Shell Scripting, Oracle PL/SQL (Stored Procedures, triggers, Indexes), XML, ASP.Net, HTML5, CSS, C, C++,C#.Net, ADO.Net.

Database Skills: SQL, PL/SQL.

E2E Tools: Biztalk Server 2005, 2008

Operating Systems: Windows 2007/XP/2000, UNIX.

PROFESSIONAL EXPERIENCE

Confidential

Technology Lead

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Preparation of technical specifications and design (source to staging, staging to Confidential ).
• Created ETL design documents and flow diagrams.
• Architecting, designing, development, and implementation of various ETL tool
• Handling multiple projects and distribution of work for team and assist team in development.
• Working on Initiatives at Confidential /Account level to make process easier.
• Setting up labs to work for Initiatives and to provide trainings.
• Engaged with sales team in BI technologies for solutioning and creating proposal for various clients.
• Working with a project manager to assign the task and tracking the team.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Extensively used Informatica Power Center, Power Exchange and Informatica Developer.
• Optimizing/Tuning mappings for better performance and efficiency.
• Performed Code review to ensure that ETL development was done according to the company’s ETL standard and that ETL best practices were followed.
• Worked extensively on Source Analyzer, Mapping Designer, Mapplet designer and Warehouse Designer and Transformation Developer.
• Analyzing the data using Informatica Developer and creation of rules.
• Used Autosys for scheduling various data cleansing scripts and loading processes, maintained the batch processes using UNIX Scripts.
• Involved in production support.
• Managing the team of 18 Members.
• Extracted data from various sources like Oracle, flat files and DB2, MS SQL, Teradata, MainFrame.
• Experience in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules and Cache Management.
• Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Experience in integration of various data sources like Oracle, DB2, Teradata, Mainframe, SQL server and MS access and non-relational sources like flat files into staging area.
• Tuned mappings using Power Center-Designer and used different logic to provide maximum efficiency and performance.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Loading data from various data sources and legacy systems into Oracle production to develop warehouse using Informatica.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.

Confidential

Software Engineer

Responsibilities:

• Consulting, business requirement gathering, architecting, designing, development, and implementation BI/DW techniques leveraging but not only limited to Informatica (Microsoft BI Suite).
• Interacting and bringing together thoughts from project, functional and Business teams.
• Accountable for end-to-end client interaction. Good exposure of working internationally with diverse portfolio of clients and in an offshoring model.
• Operational responsibilities include Project delivery, knowledge transfer, BI Proof of Concepts, development and implementations.
• Assist engagement managers and sales team in BI/Data Warehousing Estimation and RFPs/ RFIs
• Lead and coach a team of responsible for development of BI Projects.
• Ramping up on new Microsoft BI and competitive BI technologies for solutioning and competitive purposes.
• Integrating heterogeneous BI Environments for analytical/reporting needs.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Good understanding of OLAP concepts.
• Developed several Mappings and Mapplets using corresponding Sources, Targets and Transformations
• Extensively work done in developing and debugging Informatica mappings, mapplets, Sessions and workflows.
• Well versed in OLTP Data Modeling, Data warehousing concepts.
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non- Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).

Confidential

Responsibilities:

• Client interaction to understand business process, gather application requirements and frame SRS/SDD/TSD/Product Notes.
• Lead various EAI integrations.
• Responsibility included business process modeling, project conceptualization and end-to-end project delivery.
• Participate and provide inputs in solution design.
• Developers co-ordination and participate in frequent project reviews, during Build and Testing phases.
• Hand-holding users during rollout.
• Creating Custom pipeline component.
• Created POP3 adapters with the help of framework provided for BizTalk 2004
• Using orchestration for fulfilling business logics.
• Work on adapters FTP, File, SOAP, POOP3, HTTP, SMTP, SQL and MSMQ.
• Exposing orchestration as web service to consume by customers.
• Using Envelope schema for multiple messages.
• Creating stored Procedure for selection and insertion of messages in SQL server.
• Worked on Sequence and Parallel Convoy.

Confidential

Responsibilities:

• Preparation of the project specification Document & Test Cases.
• Development of the application and understanding the project requirement.
• Unit testing of application and Integration testing.

Confidential

Responsibilities:

• Preparation of the project specification Document & Test Cases.
• Development of the application and understanding the project requirement.
• Creation of Stored Procedures.
• Unit testing of application and Integration testing.