Technical Lead Resume Profile, NJ - Hire IT People

Summary

Over 10 years of extensive and diversified experience in the IT industry specialization and expertise in Data Warehousing and Business Intelligence area.
Performed overall project management, analysis, architecture, design, development and implementation of data warehousing / business intelligence initiatives
Accomplished Data Warehouse Architect, Data Modeler and Designer
Managed the evaluation of ETL and OLAP tools and recommended the most suitable solutions depending on business needs
Microsoft certified professional in SQL Server and Windows applications C .
IBM certified Cognos 10 Administrator, IBM Certified Developer - Cognos 8.2/8.4/10.1 BI Metadata Models and IBM Certified Designer - Cognos 10 BI Reports
Strong domain Knowledge in Insurance, ERP and supply chain management.
Proficiency in Cognos 8.2 8.4, Microsoft SSIS and SQL Server 2012, 2008 and below, Crystal Reports 9.0.
A leader who offers in-depth experience in project management, information technology applications, process modeling, and data modeling.
Designed and developed the architecture of business intelligence components including data models, ETL, and enterprise reporting.
Expertise in Analysis of Databases, Data Warehouses and Data Marts for BI applications/solutions including design and development of data models, ETL, and enterprise reporting
Expertise in developing and managing TM1 and SSAS Cubes
Good problem solving abilities and organizational skills.

PROFESSIONAL EXPERIENCE:

Confidential

Role: Technical lead

Roles and Responsibilities : -

Analyzed and Proposed the concept of converting the reports to SSRS sourced from the SSAS cubes
Development of the reports in SSRS
Proposed BI solution for the international projections reporting
Data architect for the newly proposed solution for the standard reports and international reporting.
Design and development using SSIS and SSAS cubes for reporting using SQL Server database.
Responsible for the ETL and OLAP data model design.
Database development including stored procedures, functions and migration to SQL Server 2012
T-SQL Performance Tuning, Query Optimization, using SQL Profiler and other related monitoring including query execution plan and optimization the indexes.
Performance tuning using SSIS 2012 features like cache and project deployment models in the catalog.

Confidential

Role:Onsite Technical lead

Roles and Responsibilities : -

Design, develop and test Cognos 8.4 and Cognos 10.1 reports, Framework manager models for new applications and versions as per business need.
Play a key role in migrating the project's existing production reports and models from Cognos 8.4 to Cognos 10.1.
Create and schedule reports, jobs, events, dashboards based on business requirements and refresh the applications to ensure that the service level objectives are met.
Create and manage the TM1 cubes and validate the refresh data.
Setting alerts to aid business key performance indicators and work with clients for issues and upgrades.
Handle ad hoc requests in identifying and analyzing application issues, train and provide proper knowledge transfer to offshore team and new joiners.
Quality assurance coordinator and implement software quality assurance tools such as Cognizant's C2.0 to review project activities, audit planning and reporting activities for the project. Maintain and track the quality compliance of the project and tracking project audits with the delivery assurance group

Confidential

Role:Team Member

Roles and Responsibilities : -

Consulted with Business Unit Management and SME's to Identify and document Business needs and Objectives.
Dimensional data modeling using star and snowflake schema in data warehouse/ data mart environment
Design and development in Cognos 8.4 reports
TM1 cubes design and development
ETL development in SSIS packages
Developed ETL logic in stored procedures
Coordinating with client and offshore team
Maintaining and tracking the quality compliance of the project and tracking project audits with the delivery assurance group