SUMMARY:

• More than sixteen years of analysis and software development experience as a business intelligence and data warehouse (BIDW) technical consultant and architect.
• Experience in business analysis, design and requirement gathering.
• Experience in identification of tasks, time estimations cost estimations, project planning and project co - ordination and status reporting.
• Analyzed source data for potential data quality issues and addressed these issues in ETL procedures.
• Developed technical design documents and mappings specifications to ETL adhering to the business rules.
• Provided support for existing systems and worked on new development initiatives simultaneously.
• Actively participated in design and analysis sessions to ensure sound team decision-making.
• Supported systems and user acceptance testing activities, including issue resolutions.
• Completed technical documentation to ensure that the system was fully documented.
• Strong communication skills (both oral and written) and the ability to work effectively in a team environment as required.
• Strong exposure to legacy data mapping from Source to Target, data conversion and data cleansing using cleansing transformation rules.
• Hands on experience in designing the data models such as star and snowflake schemas using Erwin as a tool.
• Special emphasis on the administration, support and performance tuning of the ETL, OLAP and the overall architecture flow of the sources, transformations, targets and the data warehouse.
• Developed UNIX scripts for scheduling the ETL jobs. Involved in the creation of Autosys jobs.
• Designed, developed, tested, implemented andtroubleshoot ETL mappingsand workflows in a large data warehouse environment.
• Developed logical and physical data models for the data warehouse projects.
• Experience in identifying tasks, estimations, project planning, project co-ordination and status reports.
• Experienced in developing test plans, test cases and executed test scripts.

TECHNICAL SKILLS:

Development Technologies: Informatica Power center 9.1/8.x/7.x/6.x, UNIX Shell Script, (BTEQ, Fast Load, Multiload), Oracle PL/SQL

Case Tools: Erwin 8/ R7/ 4.x / 3.x

Tools: TOAD, SQL*Navigator, Oracle Enterprise Manager, Autosys, MS Office, MS Projects, MS Visio, HPQC, Microsoft Visio, Lotus Notes, Microsoft Outlook.

Operating Systems: Windows XP/2000/NT, UNIX (Solaris, AIX), LINUX (SUSE, Redhat)

Databases: Oracle, SQL Server 2008/2005, Teradata (V2R5, V2R6, V12, DB2 UDB, MYSQL, XML, Netezza

Reporting Tools: Cognos, Business Objects, Micro strategy

Systems: SAP R3 (ECC 6.0/4.6c), SAP BW, PeopleSoft, Callidus.

Configuration Management: PVCS, Clear case, SharePoint.

PROFESSIONAL EXPERIENCE:

Confidential, South Burlington, VT

Data Mart, Enterprise Data Warehouse, Big Data

Responsibilities:

• Designed an information strategy that maximized the value of data as an enterprise asset.
• Maintained the logical/physical data models. Coordinated the metadata associated with the applications.
• Developed technical design documents. Developed and communicated data standards.
• Maintained data quality metrics. Planned architectures and infrastructures in support of the data management process and procedures.
• Supported the build out of the data warehouse, data marts and operational data stores.
• Effectively communicated with other technology and product team members.
• Qualifications/s.
• Under data integration concepts, multiple data architectures that could support a data warehouse.
• Translated functionalrequirementsinto technical design specifications.
• Developed technical design documents. Optimized data loads and data transformations.
• Translated the client user requirements into technical architecture vision and implementation plans.
• Designed and developed the architecture for all data warehousing components (e.g. tool integration strategy) and source system data.
• ETL strategy, data staging, movement and aggregation; information and analytics delivery; and data quality strategy)
• Designed the data warehouse data storage strategy/techniques (ODS, EDW, DM, ROLAP, and MOLAP, etc.)
• Designed the data warehouse sub-system (e.g. QA/QC, ETL and Query metrics)
• Oversight of the tool evaluations and selection hardware recommendations, sizing and configuration RDBMS installation, configuration and tuning oversight and/or coordination of system testing phase problem and issue resolutions.
• Mentored and developed junior staff participation in proposal development and client presentations.

Environment: Informatica Power Center RT 9.0.1/ 8.6.1 , Informatica Developer (Data Profile), TOAD (Data Modeler, Oracle), Microsoft Office 2007, Microsoft Projects 2003, Microsoft Visio 2007, Teradata 12, Cognos, SharePoint, Autosys, SAP ECC 6 / 4.6, Oracle 11G/10g, PL/SQL, HP Unix, F-Secure SSH Client, MS Windows, Relay, SAP BW, TOAD 9, HP Quality Center, SQL Server 2012/2008/2005 , Seibel, UNIX, Netezza, Data stage, DQ Analyzer, TOAD Data Modeler 4.2, Mainframe (JES 3), CICS, VSAM dataset files, Big Data (1010 Data)

Confidential, Columbus, OH

Enterprise Data Warehouse, Data Mart

Responsibilities:

• Interacted with the project team members responsible for developing reports, interfaces, data conversion programs and application extensions.
• Overseen the activities for all assigned projects from planning to delivery and sustaining support to ensure that the projects met established business objectives, time and budget constraints.
• Provided scoping and estimated the data warehouse activities.
• Presented technical information in easily understood terms in both verbal and written form.
• Worked closely with the fellow IT staff and project management to document standards and procedures for the definition of architectures (architecture roadmap).
• Interacted and worked directly with the customer team members on projects and support issues.
• Facilitated communication upward and across the project teams.
• Followed the change management and problem management processes.

Environment: Clarity, Erwin R7, Informatica Power Center 8.1, Clear Case, Microsoft Projects 2003, Microsoft Visio 2003, Microsoft Office 2003, SQL*Plus, TOAD, Linux, Unix(Sun Solaris), MS Windows, Teradata V2R6, Oracle 10g, Micro strategy, Oracle 10g, PL/SQL.

Project Lead/Data Warehouse Architect

Confidential, Brooklyn, NY

Responsibilities:

• Participated in requirements definition, analysis and the design of database solutions.
• Map business requirements to logical and physical data models.
• Reversed engineer source system data structures.
• Collaborated with the data architects for data model management and version control.
• Conducted data model reviews with project team members.
• Captured technical metadata through data modeling tools. Created data objects (DDL).
• Enforced standards and best practices around the data modeling efforts.
• Ensured data warehouse and data mart designs efficiently support BI and end userrequirements.
• Collaborated with the BI teams to create reporting data structures.
• Collaborated with the ETL teams to create data landing and staging structures.
• Collaborated with application and services teams to design databases which fully metthe business and technical requirements.
• Maintained expertise and proficiency in the various application areas.
• Developed a thorough knowledge and understanding of cross system interactions andrelationships in order to develop an enterprise view.

Environment: Oracle 10g/9i, PL/SQL, SQL*Loader, Informatica Power Center RT6.2, Business Objects XIR2, Erwin 4.x, PL*SQL, SQL*Server 2000, TOAD, Microsoft Project 2000, Visual Source Safe, Rational Clear Case, UNIX Sun Solaris, MS Windows, Excel

Business Analyst / Project Lead

Confidential

Responsibilities:

• Reviewed database designs and setup to ensure that new or modified data bases met acceptable database standards. Proactively monitored databases and provide feedback to application teamson performance. Mentored other team members on technology and the process.

Environment: Oracle9i/8i, Oracle Tools (Export, Import, SQL*Loader, PL/SQL, RMAN), UNIX (HP, AIX), Informatica Power Center RT6.2, Business Object 6.5, Microsoft Word, Excel, PowerPoint, TOAD, SQL*Navigator, Oracle Enterprise Manager, PeopleSoft, Oracle Warehouse Builder, SQL Server 2000.

Oracle DBA

Confidential

Responsibilities:

• Developed, administered and maintained the Enterprise data warehouse database.
• Developed Oracle PL/SQL packages, procedures, functions, and views.

Environment: Oracle 7.x, Oracle Tools (Export, Import, SQL*Loader, PL/SQL), Microsoft Word, Excel, PowerPoint, TOAD

Oracle DBA

Confidential

Responsibilities:

• Administered the Oracledatabases, including maintenance, upgrades, patching, cloning, tuning, performance monitoring, installation, backup and restores.

Environment: Oracle 7.x, Oracle Tools (Export, Import, SQL*Loader, PL/SQL), Microsoft Word, Excel, PowerPoint, TOAD, Oracle Developer 2000.