SUMMARY:

Dynamic and Experienced Information Technology Professional with over a decade of expertise within the Data Warehouse - Business Intelligence environments with competencies and knowledge related to data Integration, DW architecture, dimensional data modeling, ETL design, BI reporting and project management & execution. Repeatedly demonstrates the ability to apply technical skills in achieving tactical and strategic business needs. Management background include leading teams, developing & managing budgets, creating strategies, establishing goals & delivering against the objectives of assignments to meet timelines, budget and quality criteria.

TECHNICAL SKILLS:

ETL:  Informatica PowerCenter 9.x, 8.6.1, 8.1, 7. , Master Data Management, Metadata Manager 8.x, Power Exchange, SQL * Loader, IBM Infospere Meta data Workbench, , Datastage, SSIS , OEMM

Reporting:  Business Objects XI R3/6.5, Infoview, Desktop Intelligence, Crystal Reports, SSAS, SSRS, Microstrategy 9.4/10.1

Databases & Data Modeling:  Oracle 11g/10g/9i,Exadata, SQL Server 2008 R2, Sybase ASE, ER Studio 7.1/6.1, ER WIN, MS Visio, Teradata

Programming Languages:  SQL, PL/SQL, Unix Shell Scripting

Schedulers:  Appworx 6.1.4, v8, Autosys r11.3

Project Management:  Microsoft Office (Power point, MPP, Visio), HP Portfolio and Project Management (PPM)

Other Tools/Applications:  TOAD, SQL Plus, PL/SQL Developer, Winscp, Putty, CuteFTP, MS Office, MS Visio, DB Artisan, Microsoft Access®, MS Project®, Visual Source Safe 

PROFESSIONAL EXPERIENCE:

Confidential, Wilton, CT 

Sr. Tech - DWH

Responsibilities:

• Perform data analysis and data profiling of the various asset class data from accounting systems to verify integration requirements.
• Define data acquisition strategy and drive execution of data governance and quality framework, programs and integration by collaborating with other groups
• Design and define Extract Transform and Load (ETL) routines to acquire data from varied source systems and ensure reporting use high quality data adhering to standards
• Provide data lineage mappings for data integration into data warehouse to provide basis for data integration (ETL) specifications
• Develop and recommend data management policies, standards, practices and security measures to ensure effective and consistent data management operations
• Adopt quality assurance practices to include an appropriate modeling methodology, helping to establish department standards and procedures
• Foster the delivery of required enterprise data definitions, business glossary and business rules for critical data entities and data attributes
• Troubleshoot issues, provide timely restoration of service, conduct root cause analysis, and make recommendations for long-term solutions

Confidential, Stamford, CT 

Data Warehouse Specialist

• Established project level logical data models which provided basis for detailed design of all application including data warehouses/marts and databases
• Translated business and data requirements into Logical data models in support of Enterprise Data Models, OLTP, Operational Data Structures and Analytical systems.
• Reviewed and critiqued data models produced by others, participating in walkthroughs and audits; ensuring appropriate documentation is produced
• Data Modeling (both normalized models for operational systems and dimensional models for Reporting and/or Analytic systems) for delivering the Finance Data Mart for financial reporting
• Established sound MDM support structure and facilitate leadership for a strong functional and technical team supporting new projects and ongoing initiatives
• Managed MDM Practice with oversight of project initiatives and maintain the hierarchies for Enterprise Data Elements.
• Evaluated, recommended, and implemented new architectural solutions and best practices into Reinsurance group’s development processes
• Designed and built data transformation (ETL) processes to manipulate data into and out of Cash, Actuarial, Insurance finance data marts considering error-handling, alerting, restart ability and high performance for future supportability and ease of enhancements
• Developed & supported complex data extraction, transformation and load (ETL) programs in various data environments using Informatica, SSIS, batch scripts, Oracle, SQL Server 2008, AutoSys on Window and UNIX  based machines
• Supported OLAP cubes & Reports in various data environments built using SSRS and SSAS, and troubleshoot in case of incidents
• Assisted senior management in budget and workload planning
• Supported and led design, estimation and planning tasks for the solution

Confidential, New York, NY

Data Warehouse Architect

• Designed processes for capturing and maintaining metadata using Informatica Metadata Manager from all data warehousing components; generate data dictionary reports, data lineage from metadata for PPM DW project
• Performance tuning of the Informatica jobs using best practices and tuning standards
• Primary ownership of all aspects of the end to end Business Objects reporting system including definition of technical requirements, development, implementation and support
• Design and develop BI components for the delivery of dashboards, ad hoc queries and canned reports using Business Objects XIR3
• Designed and developed reports in web development and working with data from multiple sources of varying technologies

Confidential, Richmond, VA

DW Architect 

• Designed ETL processes for the data transfer between ODS to atomic data warehouse and corresponding data marts
• Participate in MDM, metadata and data governance design, implementation and maintenance activities
• Developed data integration architectures for Metadata Management platform
• Designed and developed Universes in Business Objects XIR3 to enable self service user base to develop basic reports and analytics including complex features such as aliases, derived tables, contexts and aggregate aware function
• Implemented ad-hoc, canned, linked reports and Xcelsius 2008 dashboards in integration with QAAS and Live Office
• Executed multiple projects simultaneously and successfully ensuring the co-ordination between onsite & offshore teams as an onsite Project Manager