SUMMARY:

• Around 16 and half years of Professional experience as Software consultant including in designing, development, testing, training and implementations of Data warehouse, DataMart and client/server applications.
• Involved Full Data warehouse life cycle in the project, requirement analysis, modeling and designing, database and end user application development.
• 14 years’ experience in online analytics, system analysis, creating technical design documents project plans, managing Data Warehouse projects, creating data models, dimensional data modeling primarily star schema, performing data migration, data integration, defining user interfaces, executing large projects, assuring quality, training and deployment
• Extensive experience in environments requiring direct customer interaction during specifications design, development and product implementation phases.
• Excellent knowledge and experience in data warehouse development lifecycle, Agile methodologies, dimensional modeling, repository management and administrationimplementation STAR, Snowflake schemas and slowly changing dimensions
• Strong in converting business requirements to project documentation and technical specifications.
• Extensive experience in using Business intelligence report tools like Business Objects, Cognos BI Suite, OBIEE Suite, Crystal for warehouses and data marts.
• Sound knowledge of Data ware housing concepts, Bank, Insurance, Reinsurance, Retail Sales, Financial, Pharmaceutical.
• Working knowledge of data warehouse methodologies and concepts such as Inman and Kimball.

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo, NY

BI Data Architect

Responsibilities:

• Involved identify the business need for Data, translating business functional requirement in to design technology implementation, Data mapping sessions, research for solutions, Data modelling, Design the data extract process, Development & planned for UAT testing, Production immigrations and Support BUA tasks.
• Perform business requirements analysis, should be capable of capturing business requirements and write detailed Technical Design documents of commercial loan data conversion in to Confidential and de - conversion, Confidential data in to Enterprise data warehouse, Confidential interfaces to various regulation reports, Confidential data directory, MDM, Data requirements to Enterprise credit risk teams, Confidential data reports and Dashboards for various lines of business, regulations, Accounting, finance, bank third party vendors, commercial ops and various departments in the bank.

Environment: DataMart 6.5.1, Business objects 4.1/3.7/3.1 XI, Crystal 2005/2008 Informatica Power Center/exchange/IDE/IDQ/MDM 9.6, Oracle 11g, MS SQL server 2008 R2, Batch scripts, PL/SQL, Toad, MS-Visio, MQ/JMS MS Access 2007, Window 2008 server, Erwin, OBIEE 11

Confidential, Portland, ME

DW Architect

Responsibilities:

• Involved in system study, analysis of the requirements and designing of the data conversion project and Basel II which extract data from Confidential and Commerce bank legacy source systems and reports for various retails and commercial line of business users

Environment: Business objects XI R2/ 3.1, Crystal reports2008, InfoPower Center 9.x /8.x, Power exchange 9.x/8.x, IDE8.5, Oracle Discover10.1, Oracle 11g/10g, MSSQLserver 05/08, Erwin, Mainframe SEQ files, VSAM Files, Korn shell scripts, PL/SQL, Perl script, XML, MS-Visio, (HP, AIX) Unix

Confidential, Auburn Hills, MI

DW Architect, EDW

Responsibilities:

• Worked with the business analyst to understand business requirements to populate EDW DB from legacy source system and other different source systems.
• Created Technical Design Documents, HLD documents. Test case, Test plan and Test results, deployment documents.
• Involved in finding data trends in the CIS data and implemented in cleaning methods as per business requirements.
• Involved in loading data from mainframe DB2 tables (Legacy) in to DB2/AIX data base tables and report designing.

Environment: Cognos report net 1.1,Informatica Power Center 8.1.1, Informatica Power exchange 8.1.1,IDE/IDQ 8.1, Oracle 9i/10g, DB2/AIX64 9.1.3, Mainframe DB2, Mainframe VSAM and SEQ files, XML, Korn shell scripts, PVCS, PL/SQL, TOAD, MS-Visio, CA7 Scheduler, Sun Solaris 2.6, WindowsXp

Confidential, Richmond, VA

ETL Architect

Responsibilities:

• Design the optimal ETL process for conversion, daily interfaces and reports after analyzing the business requirements.
• Develop design documentation, test results documentation and standard operating procedures (SOP) documentation.

Environment: Cognos report net 1.1, Informatica Power Center 7.1, Power exchange 7.1.4, Oracle 9i, DB2 UDB, Sybase, Pro*C, XML, Korn shell scripts, Perl Scripts, Windows, Tivoli, PLsql developer, MS Visio, PVCS, JMS messaging services, TIBCO, MS SQL Server 05, AS 400

Confidential, Kansas City, KS

Tech Lead, BIRTS

Responsibilities:

• Developed a system for long-term decision-making, strategic plans, support and solutions giving mainstream users the ability to access, analyze and share information in the company’s database.
• Involved in gathering end-user requirements, documenting, and developing prototypes.
• Prepare estimations as per the user requirement and make sure the deliverables are delivered as per schedules.

Environment: Cognos BI suite 7.2(Power Play transformer (OLAP), Cognos upfront, Cognos impromptu, Cognos Access Manager, Cognos visualize), Informatica Power Center 8/7.1, Oracle 9i, DB2, Sybase, MS SQL server 05, Flatfiles, Autosys, Perl Script, Unix as Server and Citrix as Client, Teradata utilities (Fast Load, MultiLoad, TPump and BTEQ)

Confidential, Chicago, IL

Tech Lead

Responsibilities:

• Involved as a BI/ ETL tech lead developer role in the project.
• Involved in Development, production support and enhancements phases of the project.

Environment: Business objects 6.5, Informatica Power center 6.2/7.1, Oracle 8i, MS SQL serverD2k, UNIX as Server and Citrix as Client, COBOL, IMS, VSAM, PC Anywhere, Unix Shell ScriptsXML sources, VB6

Confidential, NY

DW Developer

Responsibilities:

• As an ETL and BI developer

Environment: Informatica Power center 6.2, Cognos BI suite6.0Windows 2000 Server, Oracle 8.1DB2, SQL server, UNIX, Perl script, AWK, Shell script, Control-M