SUMMARY:

• Over 13+ years of comprehensive & in - depth experience in the Information Technology (IT) industry with specialization and expertise inData Warehousingand Business Intelligence area within several industries including commodity, retail, telecommunication, and banking & financial services industries.

• Expertise in Data warehousing concepts along with implementation of Business Intelligent systems for large Data Warehouse and Data Marts.
• Experience (Onshore/Offshore) in the field of developing Business Application Software using Client/Server tools and in Data modeling forData Warehouse/Data Martdevelopment, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications.
• Experience in Service delivery and day to day management of services delivery to the client.
• Exposure in overallSDLCincluding requirementgathering, development, testing, debugging, deployment, documentation, production supportand Extensive experience in Project. Involved projects related toData Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Practical understanding of theData modeling(Dimensional & Relational)concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables. Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
• Experience in extracting, transforming and loading (ETL), Report Development, Business Intelligence analysis tools, Database Analysis, and common Administration tasks.
• Skilled in managing projects through their full life-cycle, interfacing successfully with business stakeholders and technical teams.

TECHNICAL SKILLS:

Major Skills: SSRS, SSIS, SSAS, SQL 2008R2, SQL2012, SQL, T-SQL, Visual Basic 6.0, VB .Net, Crystal Report, Tableau, Autosys

Operating System: WINDOWS XP, UNIX

Back-End: Oracle, Sybase, MS-SQL, MS-Access

Front-End: Visual Basic 6.0, VB .Net

PROFESSIONAL EXPERIENCE:

Confidential

Architect

Responsibilities:

• Key communications role between internal customers and software platform teams.
• Regular reporting and communication with internal customers regarding the performance, compliance, and improvement recommendations of web-based software systems
• Establish and maintain a high level of customer service relative to internal and external customers.
• Work with leadership in other areas to solve problems and present solutions while maintain positive relationship.
• Responsible for maintaining and tracking key metrics and KPI’s, trend analysis, work breakdown reporting and other measurements for assigned areas.
• Establish plans and administer the overall policies and goals for assigned areas of responsibility.
• Manage budgetary responsibilities for assigned areas.
• Suggest process improvements where appropriate.
• Identify and propose solutions for areas of risk or exposure.
• Provide recommendations for Team Member additions, skill developmental areas and opportunities for learning.
• Ensure Business Continuity needs are being addressed.
• Work directly with functional analysts and understand business functionality and requirements for day to day activities and future analysis and develop new data warehouse/BI functionalities or tools to meet these requirements.
• Participate in meetings with the client to discuss IT requirements, issues, projects, and status of action items
• Support existing data warehouse reporting platform and applications to ensure operational availability and scalability.
• Assess existing and available data warehousing technologies and methods to ensure our Data warehouse/BI architecture meets the needs of the business unit and enterprise and allows for business growth. Provide recommendations on evolution of the architecture.
• Research, define and deploy BI improvement opportunities and streamline the business intelligence processes
• Create detail design, work on development and perform code reviews.
• Analysis & implementation of better performance strategies.
• Developing various business reports and analytics report.

Confidential

Sr. Technical Lead

Responsibilities:

• Response to service requests and infrastructure incidents.
• Ensure technical team(s) engagement for incident resolution.
• Communicate status to client and Atos management
• Facilitate SLA and operational reporting including metrics and capacity management
• Ensures compliance with IT change processes and communicates changes to clients
• Participate in meetings with the client to discuss IT requirements, issues, projects, and status of action items.
• Ensure documentation is maintained and delivered to client.
• Work directly with functional analysts and business users in understanding the information needs of the business and developing new data warehouse/BI functionalities or tools to meet these requirements.
• Support existing data warehouse reporting platform and applications to ensure operational availability and scalability.
• Assess existing & available data warehousing technologies and methods to ensure our Data warehouse/BI architecture meets needs of business unit and enterprise and allows for business growth. Provide recommendations on evolution of the architecture.
• Research, define and deploy BI improvement opportunities and streamline the business intelligence processes
• Create detail design, work on development and perform code reviews.
• Analysis & implementation of better performance strategies. Developing various business reports.

Confidential

Sr. Technical Lead

Responsibilities:

• Develop, maintain, and monitor detailed project schedules
• Track project changes and make necessary updates as needed
• Collect and compile meeting documents to distribute both internally and to clients
• Participate in client planning,, and support discussions
• Lead weekly status meetings and monthly executive meetings
• Ensure coordination between different consulting teams
• Manage expectations and escalations of both internal team members and clients
• Interacting with business user and understanding the requirement.
• Analyzing business requirements (Productivity related - KPIs), understand the various data sources.
• Manage artifacts - versions, including software code, documents, design models
• Develop the ETL as per the approved data model.
• Design and develop the technical/functional specification for ETL development and implement using SSIS.
• Implement Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Recommend opportunities for reuse of data models in new environments. Analyze data-related system integration challenges and propose appropriate solutions. Developing SQL Script according to the business requirement.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.
• Co-Ordinate with Developers & business user for any production/pre-production related issue.
• Leading development team and Preparing Estimation plan sheet, weekly status report and attending weekly status and review meeting.

Confidential

Technical Analyst

Responsibilities:

• Interacting with business user and understanding requirement. Get data from multiple sources, cleanse and transform the data, and load the data into appropriate data stores for analysis and reporting.
• Created and maintained the Data Model repository as per company standards.
• Developed normalizedLogicalandPhysicaldatabase models to design OLTP system. Designed a STAR schema for the detailed data marts and Plan data marts involving confirmed dimensions. Conducted design walk through sessions with Business Intelligence team to ensure that reporting requirements are met for business.
• Collaborated with the Reporting Team to design MIS report, dynamic report, Monthly Summary and detailed reports.
• Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic
• Developing SQL Script according to the business requirement.
• Co-Ordinate with Developers & business user for any production/pre-production related issue.
• Leading development team.

Confidential

Associate Projects

Responsibilities:

• Direct and/or execute the technical characteristics of the overall strategy of the data warehouse and ETL process.
• Work closely with IT and the Business group to understand business reporting requirements and analyze logical model, and develop subject matter expertise in a short time.
• Facilitate Joint Application Development (JAD) sessions for gathering requirements for building a data warehouse and data marts.
• Participate in development and execution of tactics and strategies to optimize data quality in data warehouse

Confidential

Technical Associate

Responsibilities:

• Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS)Brief Description: The LLU service assurance functionality will be available to the CPs via two channels, the B2B Gateway and the BT regulated web Portal
• Fault management services for MPF and SMPF faults will be offered as part of this functionality. For both the cases the data items would be passed to OR Siebel, which after performing validation will create a
• Trouble Report in OR Siebel and will subsequently pass the data items to NEO to progress the fault further. NEO would be responsible for sending the events updates back to OneSiebel in the form of KCIs and KSUs.
• In case of B2B these KCIs would be passed back to the CPs to track progress of fault. In case of Portal, CP can log onto portal application to view the KCIs. Project is the design for OR Siebel to Neo interface for LLU MPF/SMPF Service Assurance functionality.