SUMMARY:

• Over 12 years of extensive Information Technology experience in Business Intelligence/Data Warehousing across various domains including Pharmaceutical, Banking, Insurance, Telecom, Retail and Hospitality. Over 9 years extensive experience in architecting and creating Dashboards / scorecards, Mobile applications using Confidential Intelligence Server, Confidential Desktop, Confidential Web, Confidential office, Confidential Architect, Confidential Object Manager, Confidential Enterprise Manager, Command Manager, SDK. Over 6 years extensive experience leading enterprise data warehouse and reporting system teams in large and complex AGILE environments and delivering BI/DW projects on - time and within budget.
• Hands on experience in Logical and Physical Data Modelling, Database Schema Design, Development and Administration using Teradata, Teradata SQL, ORACLE, SQL, PL/SQL, IBM DB2, Hadoop.
• Experience in designing ETL processes using Informatica, Data Stage, Ab-Initio 2.8, TERADATA utilities and Unix Korn Shell scripting.
• Extensive knowledge and experience in all stages of Software Development Life cycle (SDLC), Rational Unified Process (RUP), and Project life cycles, Agile and Waterfall software methodologies.
• Expertise in analysing and redesigning business processes and in gathering business process information to create clear, concise and complete business and functional requirements. Expertise in developing Use Case diagrams, User Stories, Sequence diagrams, Data Flow diagrams, Process Flow diagrams and Class diagrams.
• Excellent interpersonal and communication skills with proven ability to develop strong relationships within the organization in order to coordinate project operations, and leading diverse customer base (internal and external) and contention on resources and prioritizing on delivery tasks.
• Successful at transforming business ideas and processes into complete solutions and configuring applications to fit the company's business model.
• Extensive Experience leading system releases and coordinating skill groups and communications, interpret overall IM Strategy and drive through operational level development tasks and proven customer engagement skills.
• Coordinated User Acceptance Testing (UAT) and presentations to end-users, system verification and validation.

TECHNICAL SKILLS:

RDBMS: Teradata v12, Oracle EXADATA, DB2, MS Access, Sybase, SQL Server 2000

OLAP/ETL: Business Objects 5.1/4.x/3.x, WebIntelligence 2.0/2.6, Infoview 1.0, Cognos Impromptu6.0, Cognos PowerPlay 6.6.1, Confidential 9/8/7.x/6.0, Informatica, Ab-Initio 2.8.

OS: MS: DOS, SCO UNIX, Red Hat Linux, UNIX (Sun Solaris), MVS, MP-RAS, Windows98/ XP/2000/NT, Hp R-11i/9000/3000, IBM Aix 4.x.

Hardware: SUN Ultra 450, SUN E6500, HP: UX 10.0, IBM Compatible PC's, EMC2 5000 servers.

Applications: Erwin, MS Visual Studio, Designer 6i, VB 5.x/6.0, crystal reports, Web logic, Visual Caf, Rational Rose

Utilities: BTEQ, Fastload, Multi: Load, TPump, Queryman, WinDDI, Oracle SQL- Loader, ERWin 3.5.2, TOAD, Visio, Enterprise Manager 1.2.2

Languages: Java, C, C++, SQL, XML, HTML, DHTML, MQ-Series, UML, COBOL II, JCL, Visual Basic, PL/SQL, SQL*PLUS

Others: ER Data Modeling, Normalization Techniques

PROFESSIONAL EXPERIENCE:

Confidential

Technical Lead/Sr. Developer

Responsibilities:

• Performed project scope Determination, Requirements Gathering, Requirements Analysis, Design, Development, Testing, UAT Presentations, Implementation and Post production support of BI projects.
• Leading an onsite team of 25 and a Confidential Global Development Centre Team, in Europe. Extensively worked in both Ad-hoc and standard reporting environments and architected Confidential Mobile dashboards and scorecards scalable to large volumes of data.
• Worked closely with stake holders, business users and developers to formalize a business idea and define requirements. Conducted periodic meetings with technical team in order to make sure that developments are adhered to the business requirements and customer’s expectations.
• Implemented agile delivery approach for BI projects. Provided Technical Leadership to Business Intelligence/Enterprise Data warehousing team. Designed and created Confidential Projects, Facts, Attributes, Hierarchies, Transformations, View filters, Derived Elements, Thresholds and Drilling.
• Designed Components, Templates, Filters and generated Confidential Reports in grid and graph mode. Developed and Administered Confidential projects/users and designed reports. Refined reporting business requirements. Created necessary objects to meet report requirements.
• Created and maintained attributes, metrics, filters, prompts and reports. Maintained security for all users. Created database views and performed quality assurance for all reports. Performed technical problem solving, performance monitoring, tuning and troubleshooting. Coordinated and deployed Confidential report changes to the Production environment.
• Designed, Developed, Tested and supported ETL processes for a Data Warehouse from their legacy systems. Designed, developed System and Unit Test plans and performed extensive System, Regression and Unit Testing of the ETL Job streams.
• Created Batch processes using FastLoad, BTEQ, UNIX Shell and Teradata SQL to transfer, cleanup and summarize data. Provided Production support / Data warehouse support on call and ensured all jobs run successfully and data being processed timely and data being made available to the Business users / Customers.
• Designed the Schema, finalized naming and coding standards throughout project life cycle. Coordinated efforts with other developers, end users, DBAs, and UNIX administrators in resolving on-going production problems.
• Created proactive delivery reports using Confidential narrowcast servers. Monitored and Tuned Performance of Confidential Intelligence Server. Developing Metrics and compound metrics, filters for complex reports.

Environment: Hadoop, Confidential 9.4, Oracle, SQL Server 2005, Windows NT / 2000, Windows XP.

Confidential

Technical Lead/Sr. Developer

Responsibilities:

• Provided leadership to the entire Business Intelligence Team at Coles. Lead and delivered multiple projects with-in budget on time at Coles. Developed the Project Scope, Vision, Project plans, Estimates, Road Maps and Traceability documents. Performed the as-is and to-be Assessment to understand the underlying gap in the business process.
• Extensively worked in both Ad-hoc and standard reporting environments and architected Confidential Mobile dashboards and scorecards scalable to large volumes of data.
• Worked closely with stake holders, business users and developers to formalize a business idea and define requirements. Conducted periodic meetings with technical team in order to make sure that developments are adhered to the business requirements and customer’s expectations.
• Implemented agile delivery approach for Coles BI projects. Extensively worked in both Ad-hoc and standard reporting environments and architected dashboards scalable to large volumes of data.
• Designed Components, Templates, Filters and generated Confidential Reports in grid and graph mode. Developed and Administered Confidential projects/users and designed reports. Refined reporting business requirements. Created necessary objects to meet report requirements.
• Created and maintained attributes, metrics, filters, prompts and reports. Maintained security for all users. Created database views and performed quality assurance for all reports.
• Performed technical problem solving and troubleshooting. Coordinated and deployed Confidential report changes to the Production environment.
• Analyzed gathered requirements data, verify requirements and create functional design specifications (FDS). Created Requirement Traceability Matrix to make sure the current project requirements are being met.
• Performed project scope Determination, Requirements Gathering, Requirements Analysis, Design, Development, Testing, UAT Presentations, Implementation and Post production support of BI projects.

Environment: Confidential 9.2.1, Oracle Exadata, Windows NT / 2000, Windows XP.

Confidential, Vienna, VA

Technical Lead/Sr. Developer

Responsibilities:

• Leading an onsite team of seven and a Confidential Global Development Centre Team, in Europe. Extensively worked in both Ad-hoc and standard reporting environments and architected Confidential Mobile dashboards and scorecards scalable to large volumes of data.
• Worked closely with senior managers, business users and developers to formalize a business idea and define requirements. Conducted periodic meetings with technical team in order to make sure that developments are adhered to the business requirements and customer’s expectations.
• Provided leadership to the entire Business Intelligence Team at Confidential . Lead and delivered multiple projects with-in budget on time at Coles. Developed the Project Scope, Vision, Project plans, Estimates, Road Maps and Traceability documents. Performed the as-is and to-be Assessment to understand the underlying gap in the business process.
• Worked closely with stake holders, business users and developers to formalize a business idea and define requirements. Implemented agile delivery approach for the BI projects. Provided Technical Leadership to Business Intelligence/Enterprise Data warehousing team.
• Analyzed gathered requirements data, verify requirements and create functional design specifications (FDS). Created Requirement Traceability Matrix to make sure the current project requirements are being met.
• Developed Logical and Physical Data Models for all the Insurance subject areas as per the requirements and available source data.
• Created Technical Architecture Diagrams and Data Flow Diagrams. Developed the Project Scope and Vision document in assistance with the Project Manager. Also performed the as-is and to-be Assessment to understand the underlying gap in the business process.
• Assisted the testing team in developing the test plan, test conditions, and test cases based on business requirements and technical specifications. Developed estimates, project plans (Microsoft project), training material, BI reports using Micro strategy
• Extensively used MS Visio to develop the solution concept, business timeline and wireframes. Worked with Development and QA teams to transition business requirements into QA test cases and assist in UAT.
• Performed project scope Determination, Requirements Gathering, Requirements Analysis, Design, Development, Testing, UAT Presentations, Implementation and Post production support of BI projects.

Environment: Business Objects, Confidential 9.2.1, Teradata, Windows NT / 2000.Windows XP.

Confidential, Orlando, FL

Technical Lead/Sr. Developer

Responsibilities:

• Performed project scope Determination, Customer Requirements Gathering, Requirements Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post production support of BI projects. Involved in the complete Reports development life cycle.
• Extensively worked in both Ad-hoc and standard reporting environments and Involved in creating Reports scalable to large volumes of data. Developed and Administered Confidential projects/users and designed reports.
• Lead projects through entire systems development life cycle, including creating timely/thorough status reports and leading status meetings.
• Generated Report services Documents and implemented Confidential Reports by creating Projects, attributes, hierarchies, metrics, filters, and templates. Designed Prompts and Filters to generate reports in grid and graph mode.
• Built Narrowcast Server to deliver reports and alerts via multiple delivery methods and publications. Involved in developing the logical data model that serves as the map for schema object creation in Confidential 7.2.2 Architect and allows for multidimensional analysis. Upgraded and Migrated Confidential Projects from Confidential 6.x to Confidential 7.x
• Migrated the target data warehouse from ORACLE to TERADATA. Created logical and physical models. Created new database objects, tables, views, macros, and users in TERADATA to support the functions of the existing objects in ORACLE. Monitored tablespace usages in the databases. Extensively used T- SQL.

Environment: Confidential 8.1.1, Oracle 8i, Windows NT / 2000.Windows XP.

Confidential

Architect/Business Analyst

Responsibilities:

• Performed project scope Determination, Customer Requirements Gathering, Requirements Analysis, Design, Development, Testing, End User Acceptance Presentations, Implementation and Post production support of BI projects. Involved in the complete Reports development life cycle.
• Extensively worked in both Ad-hoc and standard reporting environments and Involved in creating Reports scalable to large volumes of data. Developed and Administered Confidential projects/users and designed reports.
• Lead projects through entire systems development life cycle, including creating timely/thorough status reports and leading status meetings.
• Generated Report services Documents and implemented Confidential Reports by creating Projects, attributes, hierarchies, metrics, filters, and templates. Designed Prompts and Filters to generate reports in grid and graph mode.
• Attended training in WhereScapeRED.

Environment: WhereScapeRED, Confidential 8.1.1, Oracle 8i, Windows NT / 2000.Windows XP.

Confidential, DE

Technical Lead/Sr. Developer

Responsibilities:

• Extensively worked in both Ad-hoc and standard reporting environments and Involved in creating Reports scalable to large volumes of data. Lead projects through entire systems development life cycle, including creating timely/thorough status reports and leading status meetings.
• Designed Components, Templates, and Filters and generated Confidential Reports in grid and graph mode.Developed and Administered Confidential projects/users and designed reports. Refined reporting business requirements. Created necessary objects to meet report requirements.
• Created and maintained attributes, metrics, filters, prompts and reports. Maintained security for all users. Created database views and performed quality assurance for all reports. Performed technical problem solving and troubleshooting. Coordinated and deployed Confidential report changes to the Production environment.
• Designed ETL process to extract data from SQL server2000 and SAS to Teradata and performing data scrubbing, restructuring and consolidation for Web reporting. Created Batch processes using FastLoad, BTEQ, Unix Shell and Teradata SQL to transfer clean up and summarize data, Wrote Perl and UNIX Shell scripts. Automated transfer of data entry using Informatica Power Center.
• Developed and assembled reports for technical documentation of production incidents and system changes. Conducted Code Reviews and Design reviews in both the development phase and the data migration effort made to production systems.

Environment: Confidential 8.0/7.5,Informatica 7.1.3, SQL, BTEQ / BTEQWin, FastLoad, MultiLoad, FastExport, TPump, Visual Explain, OleLoad, Queryman, DB2, Oracle 8i, Windows NT / 2000.Windows XP.

Confidential, GA

Technical Lead/Sr. Developer

Responsibilities:

• Designed Prompts and Filters to generate reports in grid and graph mode. Auto prompt filter feature gave end-user a choice of different filtering criteria each time they run the report.
• Worked with Confidential Architect to build Hierarchies, Attributes, Facts and Relationships between various attributes and developed perfect logical models for reporting environment.
• Extensively worked and developed Metrics, filters and prompts to give Decision makers a handy tool to choose the criteria for reports and view information in different perspectives. Implemented Narrowcast Server Services by sending Reports to users via E-mail with Static and Dynamic Subscription sets and personalization.
• Built Narrowcast Server to deliver reports and alerts via multiple delivery methods and publications. Involved in constructing the logical data model that serves as the map for schema object creation in Confidential 7.5 Architect and allows for multidimensional analysis
• Involved in various backend Informatica ETL development tasks and production support. Developed standard and reusable mappings and mapplets using Mapplet Designer. Used different transformations like Source Qualifier, Joiner, Aggregate, Lookup, Stored Procedure and Router Transformations in mappings.
• Responsible for technical documentation of the entire ETL process. Worked on debugging and performance tuning of mappings and sessions. Created and scheduled Sessions and Workflows using Informatica Workflow Manager.

Environment: Confidential 8.0, 7.5, 6.0, Informatica 7.1.3, Teradata (v2r5), Teradata V2R4.1, SQL, BTEQ / BTEQWin, FastLoad, MultiLoad, FastExport, TPump, Visual Explain, OleLoad, Queryman, DB2, Oracle 8i, Windows NT/2000, Windows XP.

Confidential, VA

BI Developer/Business Analyst

Responsibilities:

• Designed, Developed, Tested and supported ETL processes for a Data Warehouse from their legacy systems using Ab-Initio. Designed, developed System and Unit Test plans and performed extensive System, Regression and Unit Testing of the ETL Job streams.
• Created Batch processes using FastLoad, BTEQ, UNIX Shell and Teradata SQL to transfer, cleanup and summarize data. Provided Production support / Data warehouse support on call and ensured all jobs run successfully and data being processed timely and data being made available to the Business users / Customers.
• Designed the Schema, finalized naming and coding standards throughout project life cycle. Coordinated efforts with other developers, end users, DBAs, and UNIX administrators in resolving on-going production problems.
• Created proactive delivery reports using Confidential narrowcast servers. Monitored and Tuned Performance of Confidential Intelligence Server. Developing Metrics and compound metrics, filters for complex reports.
• Implemented Ab-Initio configuration and well-tuned setting up environment for Production and development environment. Responsible for deploying Ab-Initio graphs and running them through the Cooperating systems mp shell command language.

Environment: NCR Teradata 4.x, Confidential 7.3.2, Ab-initio 2.8, Oracle, PL/SQL, Korn Shell Scripting, Teradata, Hp- Unix, TOAD.