Deputy Director,Business Intelligence and Analytics

Accomplished Senior Business Intelligence and Analytics Executive delivering outstanding Business Intelligence Applications in Utilities, Manufacturing, Benefits Administration , Insurance and Government Services . Additional Strengths include :

• Leadership and Team Management
• Expertise designing STAR SNOW FLAKE Schemas
• Business Analytics Problem Solving
• Application Development and Support using SDLC and AGILE methodologies
• Crisis Management and Disaster Mitigation
• Hands-on experience on relational databases ,ETL Reporting Tools,Unix ,SQL, Developing BI Dashboards and Reports,Mobile Reporting on Tablets and Smart Phones

• Helmed the Business Intelligence and Reporting practice and Leading a team of architects, data analysts and developers ,streamlined enterprise reporting, strengthend skill level of staff and improved performance, restructured legacy systems to boost responsiveness,introduced governance statndards for capacity planning,system uptime , budgeting and services
• Responsible for Strategic Planning of Enterprise-wide Datawarehouse Development, Business Intelligence Reporting, Application Development Using Informatica , OBIEE , Oracle 11G and Support of the applications, led the report and dashboard development for the business units withing the Agency
• Responsible for Development Database Architecture / Design / Data Delivery / Reporting across multiple data sources structured, semi-structured and unstructured , balancing the need for access against security and performance requirements.
• Developed a model management strategy in support of enterprise reuse and data-sharing objectives Ensured focus on information/data quality for the Data Warehouse by developing and publishing data standards such as a common business vocabulary, naming conventions, data standards, transformation rules and related enterprise consistency specifications
• Spearheaded and delivered high-priority enterprise wide projects like Mobile Reporting , Big-Data initiatives with new governance statndards , developed SOPs around project portolio to manage new requests
• Working closely with the business to help with the development or use of process models, creation or use of information or target data models, interface designs, and development of internal and external checks and controls to ensure proper governance, security and quality of information assets
• Translated strategic requirements into usable data/information architecture, including data models, associated meta-models, and common business vocabulary and taxonomies, and guide solution development to achieve consistency of information assets across the application portfolio. Developed a metadata management and repository strategy to manage data architecture project artifacts
• Facilitated consistent business analysis, information acquisition analysis and design, data access analysis and design, archiving and recovery strategies, security, and change management Liaison with Infrastructure Engineering and Application teams to ensure appropriate database system configuration scalability/performance.
• Eliminated major post release issues after by improving the development , migration and support process , developed innovative dashboards for production support to detect production issues thereby ensuring faster resolution of production issues

• Planned, Designed, developed, managed, documented and executed projects for the City Of New York's Analytics Datawarehousing initiative. Managed development and integration of Business Intelligence solutions through all phases of the SDLC
• Solutions Architect for 10 Business Intelligence Projects , built data models , ETL components , data base objects, Unix shell scripts, built reports using OBIEE
• Lead and Delivered multiple project teams with 15 direct reports, developed projects that leveraged a wide range of technologies, including Informatica, Talend, XML, Oracle, SQL Server , Sybase , OBIEE to create innovative business solutions.
• Architected solutions for new and existing datamarts using ERWIN and Ralph Kimball Methodologies for datawarehouse design.
• Worked on IBM Websphere MQ to create queue manager , queue's and load messages to the message queues
• Led efforts towards negotiating software licensing and vendor management, managed budgets up to a million dollars
• Worked on Production Critical Defects, Unit Testing and Integration Testing.
• Partnered with senior stakeholders to review business initiatives, process improvements and new project requirements to keep portfolio of projects aligned with current needs
• Eliminated major post release issues after by improving the development , migration and support process , developed innovative dashboards for production support to detect production issues thereby ensuring faster resolution of production issues
• Involved in putting together a comprehensive strategy for migration and QA activities

Senior Tech Specialist responsible for application development, requirements gathering, database design, implementation and maintenance of various projects across the firm, using Informatica 8.1, Sybase, UNIX

Worked as a Senior Consultant to develop Integrys Energy's new datamart using Informatica, SQL server, Erwin for data modeling, provided consultancy towards design and implementation of the project, provided post implementation production support

Worked as a Business Analyst to analyze and study the impact of conversion of a legacy loan processing system to a new platform, liaised with business users , technical users , development team to provide a detailed analysis and path towards the migration to the new system

• Worked on deputation for various projects for General Electric Co and worked on various projects with varied responsibilities
• Primary responsibilities included
• Coding , Developing Informatica mappings based on the new data model, testing, creating test cases and test data.
• Interacting with Report Users and Business Analysts to understand and document the Requirements and translate these to Technical Specifications for Designing the Informatica Mappings.
• Involved in Problem Solving, Trouble shooting and developing End User Notes.
• Involved in writing SQL queries.
• Used Union, Intersection, minus and Master/Detail in the source qualifier sequel overrides
• Implementation, Performance tuning of the mappings.