SUMMARY:

• Overall 15+ Years of experience with the last 10 years focused in BI/data warehouse space. Results - oriented IT professional with proven record in business information systems, focused on data modeling, data integrity, requirement analysis, testing and helping organizations maximize technology investment. Domain knowledge in financial services with an emphasis on trade management. Expert in all aspects of SDLC with focus on production support. Extensive experience in maintaining databases, reporting tools, data quality and providing analytic support for BI packages (Cognos Suite of Tools, SSIS)
• Business Intelligence · Production Support · Agile Methodology · JAD · Business Analysis · PMO · Architecture & Design · System Development · Data Analysis · Data Modeling · Database Development · Data Migration · Testing & Deployment · Mentoring · Leadership

TECHNICAL SKILLS:

Applications: ERWin, Cognos Suite of Tools, SSIS, SSAS, SSRS, Business Objects, MS Office, MS Project & Project Server, MS Visio Enterprise Architect, MS Visual SourceSafe, MS SharePoint, IBM Rational Rose, PVCS, Serena, Oracle Autoloader, Oracle Import and Export Utilities

Platforms: SQL Server, Oracle, Sybase, DB2 UDB, MS IIS, MS Enterprise ServicesMS SharePoint Server, Hyperion, Essbase

Development Tools: SQL, XML, XSLT, HTML, Unix Korn Shell Scripting, PowerBuilder, Visual Basic, Foxpro

PROFESSIONAL EXPERIENCE:

Confidential, Englewood Cliffs, NJ

BI Technical Lead

Responsibilities:

• Responsible for data modeling and analysis activities for multiple projects including identifying and enforcing data standards to ensure consistent and maintainable application metadata.
• Responsible for planning and designing appropriate BI dashboards, scorecards, reporting cubes and static reports using SSRS to meet information needs.
• Responsible for BI reporting requirements gathering and translating them into business requirements for the BI developers along with support for development and testing.
• Responsible for extracting data from heterogeneous data sources and transforming data to be loaded in the data warehouse using SSIS.
• Responsible for performing the technical design, development and component testing of repository changes, ETL solutions, reports and dashboards.
• Responsible for creation and review of project documentation including business and system requirements, technical architecture, test artifacts and manuals.
• Responsible for supporting and monitoring the entire BI environment with a focus on SQL Server Agent scheduled jobs and report execution performance.
• Responsible for managing day-day administrative activities for production support team including interaction with senior management, user community and other stakeholders in application development group.
• Responsible for mentoring the team members in Business Intelligence services such as dashboards, scorecards, reports, user interfaces and associated data structures.

Confidential, New York, NY

BI Developer/Data Modeler

Responsibilities:

• Responsible for managing day-day administrative activities for production support team including interaction with senior management, user community and other stakeholders in application development group.
• Support the company's enterprise architecture initiatives as member of IT Enterprise architecture team representing the enterprise information/data team.
• Responsible for analyzing requirements, assessing current state as well as strategic goals and devising plans for delivering the appropriate solution.
• Responsible for attending and contributing to architecture, modeling and design meetings.
• Responsible for performing table and interface design, development of logical and physical data model, ETL processes (SSIS), OLAP cubes (SSAS), BI reporting (SSRS).
• Responsible for understanding the data warehouse and data mart models and becoming familiar with the business information contained in each as well as the source systems.
• Responsible for supporting the company’s BI reporting SSRS by providing analytic support.
• Responsible for designing extremely reliable, scalable and high performing reports.
• Responsible for troubleshooting and correcting data and data processing errors in existing solutions.
• Transformed the business requirements into a conceptual and logical model.
• Responsible for developing modeling and naming standards.
• Responsible for facilitating the user acceptance testing, coordination with change and release management groups.
• Responsible for impact analysis of organization wide changes implemented on various applications.
• Responsible for mentoring the team members in the functionality and technicality of the various systems.

Confidential, Jersey City, NJ

CognosFramework Manager Architect/Developer

Responsibilities:

• Evaluated an existing Mainframe system generating reports and made recommendations to implementthe same in CognosFramework Manager.
• • Involved in gathering requirements for the report needs of the business user community
• Developed models and published packages in Cognos connection using Framework Manager
• Involved in setting up security in Framework Manager and Transformer
• Involved in building Multidimensional Cubes using Transformer and creating reports as per user requirements.

Confidential, New York, NY

Senior Analyst

Responsibilities:

• Created and formulated use cases, data flow diagrams, functional specifications, support manuals, test plans and strategies. Conceptualized, documented, and communicated the business and technical constraints and requirements within the scope of a project.
• Analyzed data requirements.
• Developed modeling and naming standards and writing modeling guidelines.
• Created logical data models..
• Maintained the data dictionary for the data models.
• Provided input to database/data architecture sections for several technical proposals submitted to the different departments.
• Built and deployed data quality rules to avoid data quality issues for business processes.

Confidential, New York, NY

Senior Systems Analyst

Responsibilities:

• Responsible for analyzing the business requirements and develop a technical solution.
• Responsible for defining, documenting and understanding all data definition, data sources and business meaning and usage.
• Responsible for developing policies, procedures and standards in order to promote consistency of systems development entities in the data repository.
• Responsible for data mapping between the source data and the data models.
• Responsible for developing logical data models inclusive of entities, attributes, relationships, definitions for integration with the enterprise data model.
• Responsible for creating the database components in the physical data model.
• Responsible for maintaining the data dictionary for the logical data models.

Confidential, Roseland, NJ

Senior Systems Analyst

Responsibilities:

• Responsible for obtaining data requirements through workshops with the business users.
• Responsible for developing plans to standardize legacy data sources in order to move to a unified enterprise data structure.
• Responsible for analysis of data requirements and translation of these requirements into logical data models.
• Responsible for developing modeling and naming standards and writing modeling guidelines.
• Responsible for identifying and enforcing data standards to ensure consistent and maintainable application metadata.
• Responsible for mapping the source data to the logical data elements during the creation of the conceptual and logical data models.
• Responsible for performing problem identification, analysis and resolution related to database issues.
• Responsible for creating and maintaining the data dictionary for the data models developed.
• Responsible for producing first pass physical data models for continued development by a DBA.
• Responsible for development of SQL scripts, shell scripts to check the integrity of the data downloaded from the Mainframe and populated in the database.
• Responsible for writing job scheduling scripts.

Confidential, New York, NY

Programmer Analyst

Responsibilities:

• Responsible for requirement gathering, analysis and design of the system.
• Designed the screens needed for the system using PFC services like data window services, application services, window services etc.

Confidential, Northfield, IL

Programmer Analyst

Responsibilities:

• Involved in the design and analysis of the system.
• Involved in development, testing and implementation of the system.
• Created ancestor user objects for other application objects to inherit from.