Experience Summary:

• 10 years of IT experience in Software Development Life Cycle.
• 8 years of experience as Business Intelligence Developer and Data Analyst in Production, Development and Staging Environments.
• Senior Technologist in developing and delivering end-to-end MSBI solutions.
• Expertise in OLTP/OLAP System Study, Analysis and Dimensional Modeling.
• Involved in Designing Dimensional Model Star schema, Snowflake schema, Facts, Dimension tables and Slowly Changing Dimensions Type1, Type2, and Type3 .
• Have created and deployed dimensional cubes in SSAS.
• Strong Communication Management skills with Excellent Role playing capabilities.
• Extensive experience in Installation, Configuration and Updates of SQL Server.
• Move large amount of data using parallelism in SSIS.
• Extensive experience in Data warehousing tools SSIS, SSAS, SSRS and Data Modeling Tools.
• Expertise in Designing and Deployment of Reports for the End-User requests using Web Interface SSRS.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon.
• Created and Scheduled Jobs in SSIS.
• Data Warehousing experience using ETL, DataStage 7.5 DataStage Manager, DataStage Administrator, DataStage Designer, DataStage Director , SQL Server DTS, TOAD 9.0.1
• Batch process reports using subscriptions.
• Have packaged and moved the Jobs smoothly between environments like Dev, QA and including production environment.
• Good work ethics with excellent communication and interpersonal skills with a strong attitude towards learning new technologies quickly supporting the project requirements.
• Had good interactions with the business users and service center directors in providing clarifications.
• Bachelors in Computer Science Engineering,

Technical Skills:

Reporting:

SQL Reporting 2005 / 2008 R2 SSRS , .Net Charts, Cognos 8 BI

ETL:

SSIS 2008R2, MS SQL Server 2000/2005/2008 R2, SSIS, MS Access, SQL, PL/SQL, SQL DTS, SQL Query Analyzer, DataStage 7.5 Designer, Administrator, Manager, and Director , Oracle.

Programming:

SQL, PL/SQL, Transact SQL, SQL Plus 8.1.5.

Dimensional Data Modeling:

TOAD Data Modeler, Erwin, SSAS, Star Schema, Snowflake Schema, OLAP, OLTP.

Operating systems:

Windows NT, 2000, XP, Vista.

Database Tools:

SQL Server Management Studio 2005 / 2008 R2, SQL Server 2005/2008 Business Intelligence Studio, TOAD 9.0.1.

Professional Experience:

Confidential

Confidential is one of the world's largest financial institutions, serving individual consumers, small- and middle-market businesses and large corporations with a full range of banking, investing, asset management and other financial and risk management products and services. The company provides unmatched convenience in the United States, serving millions of consumer and small business relationships with retail banking offices, ATMs, online banking. Bank of America is among the world's leading wealth management companies and is a global leader in corporate and investment banking and trading across a broad range of asset classes, serving corporations, governments, institutions and individuals around the world. Bank of America offers industry-leading support to approximately 3 million small business owners through a suite of innovative, easy-to-use online products and services. The company serves clients through operations in more than 40 countries.

Small Business Banker - Deposits

The project is to develop a reporting plaform for smallbusiness banker department to report on deposits made to all accounts by bank of america's small business customers by region by market by branches by customer by month for rolling 13 months.

Small Business Banker - Sales Performance

This project is to develop a reporting tool for analytics department to report and track of sales associates in each branch. It is also used to determine their goals vs actuals per quarter. This involves development of a process to extract source data from various systems and includes the services rendered by Small Business Banker.

Responsibilities Microsoft BI Architect

• Design, maintain and enhance all BI components and optimize for reporting efficiency and scale.
• Understand business users to define dimensions and measures.
• Extract data from Teradata, DB2 flatfiles for Business Intelligence platform.
• Establish, maintain and administer ETL environment, including scheduling, distribution, and permissions.
• Developed SSIS packages to move large amount of data in parallel from Teradata, DB2 system to the BI Data mart.
• Optimized the usage of ETL vs ELT approach.
• Involved in testing the newly developed with the pre-migration Reports.
• Evaluated Report Performance upon completion of the reports and validated output data.
• Deployed packages, Reports from a development environment to test environment.
• Developed, managed, and coordinated all user acceptance testing.

Confidential

Confidential is a not-for-profit managed care organization, sponsored by some of nationally recognized hospitals and medical centers in Confidential . Confidential aims providing high-quality health care coverage to individuals and families in Confidential service areas through a variety of government-sponsored health insurance programs, including Confidential Child Health Plus, Family Health Plus, Medicaid, and Medicare Advantage. Confidential is one of the fastest growing health plans in New York and New Jersey with over 900,000 members and a network of more than 24,000 providers.

Confidential

Member Passport provides service information for all current active Members for all Medicare line of business. The information will be used to send the Member Passport for Medicare Members twice a year. This involves development of a process to create and store the current Active members from all Medicare line of business and includes the services rendered by them and date of service for those services.

Confidential

The project is to batch generate CCMS Care Plan reports for the Medicare SNP Members using standard Member Summary Report components. In addition, support Meaningful Use on behalf of providers, by sharing the Care Plan information with the providers.

Responsibilities Microsoft

BI Architect

• Develop architecture / implementation plan for BI projects.
• Design, maintain and enhance all BI components and optimize for reporting efficiency and scale.
• Analyze user needs and create cardinalities, contexts, joins and aliases.
• Work with business users and define dimensions and measures.
• Establish, maintain and administer reporting environment, including scheduling, distribution, user permissions, and updating reports and dashboards
• Evaluated Netezza GreenPlum appliance for Business Intelligence platform.
• Developed SSIS packages to move large amount of data in parallel from Legacy system to the BI Data mart.
• Optimized the usage of ETL vs ELT approach.
• Created customized report for different type of reports standardization of report formats, filter options, page break options, and output options as well as additional flexibility in terms of report data selection.
• Created complex reports using union queries, conditional formatting and prompting, drill-through.
• Created reports with cascading prompts.
• Batch generate PDF Reports using Subscriptions.
• Involved in testing the newly developed with the pre-migration Reports.
• Evaluated Report Performance upon completion of the reports and validated output data.
• Deployed packages, Reports from a development environment to test environment.
• Developed, managed, and coordinated all user acceptance testing.

Confidential

Confidential are licensees, independent of the association and traditionally each other , offering insurance plans within defined regions under one or both of the association's brands. Blue Cross Blue Shield insurers offer some form of health insurance coverage in everyConfidential They also act as administrators of Medicare in many states or regions of the US, 10 and provide coverage to state government employees as well as to the federal government employees under a nationwide option of the Federal Employees Health Benefit Plan.

Confidential

The project is to develop a end-to-end BI solution to serve new set of Uniform Benefit Summary Reports as Patient Protection and Affordable Care Act PPACA required that the Secretary of Health and Human Services develop standards for a report for individuals and group health insurance. And all health insurance issuers offering group health insurance coverage to provide enrollees and potential enrollees an accurate summary of benefits and coverage explanation. The report was required by Federal law that this document provides consumers an easy way to compare policies and understand their coverage.

Responsibilities

BI Architect

• Developed BI procedures to ensure conformity, compliance with HIPAA standards and to translate business rules and functionality requirements into BI Solutions.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems.
• Experience in database design process and data modeling process.
• Designed Dimensional Data Model to implement the consolidated view of Memebers and Claims using data modeler.
• Designed a high level architectural model for the ETL implementation of Insurance Claims, Membership Coverage and Status Tracking for the developers.
• Studied existing OLAP system s and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Documented and Maintained Data Dictionaries with the updated Data Model Enhancements.
• Involved to planning and designing SSAS 2008 Cubes and building attribute relationships for optimal performance of Hierarchies and Fact Dimensions.
• Implementation and delivery of BI platform solutions to develop and deploy ETL, analytical, reporting using SSAS, SSIS/DTS, SSRS.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Up gradation of System Configuration.
• Experience in Performance tuning.
• Developed SSIS Packages and Stored Procedures to feed data for the new system.
• Performed break fixes manual processing of Adhoc loads as per request.
• Created / scheduled SQL server jobs and maintenance activities of Database.
• Involved in writing Queries for data analysis and analysis on the defects raised by end-users and fixing the defects.
• Managed and coordinated all user acceptance testing.
• Created customized report including, filter options, page break options, output options as well as additional flexibility in terms of report data selection.
• Created complex reports using union queries, conditional formatting and prompting, drill-through.
• Assisted users in troubleshooting their queries.

Confidential

Confidential, a world leader in insurance and financial services, is the leading international insurance organization with operations in more than 130 countries and jurisdictions. AIG companies serve commercial, institutional and individual customers through the most extensive worldwide property-casualty and life insurance networks of any insurer. In addition, AIG companies are leading providers of retirement services, financial services and asset management around the world.

Confidential

DBG Metrics Reporting a division of AIG Domestic Brokerage Group, requires us to report the compliance and inventory of policy services. In addition, we were expected to support and enhance every step of the reporting process as per the business requirements.

Confidential

The Performance Plus Scorecard is an application supporting Performance Management Program operations. The application measures performances of employees chosen by HR, who can be categorized as Underwriter UW , Underwriter Assistant/Service Center Specialist UA or Underwriting Technician UT , based on Policy/Sub Policy Issuance Timeliness, Policy Issuance Quality from Quality Reviews and Binder Billing Timeliness for Policies or Contracts. Based on above mentioned measures, the application produces scorecard summaries that list the scores for each work type, combined work type scores, and final scores for an individual or a selected range of individuals.

Expense Allocation AIG :

The scope of the project is to automate the process of Expense Allocation Report generation and web-enable the Expense Allocation report. The process entails consuming the data feeds from source systems, followed by application of data transformations, based upon given set of business rules resulting in allocation report which would be available online for the end user to access and compare across time period. This report allocates expenses directly associated to Divisions. Data for calculations consists of completed items in WTS, Cruis, eStart and Accutrac, for the reporting month. Data is filtered to include only the items that are applicable by service centers, divisions and their respective work types to come up with the expense Allocation Model.

Quality Timeliness AIG :

The Risk Management Group RMG has developed the Q T Monitoring System to measure the effectiveness of Quality and Timeliness Q T of the contract booking process by Underwriters. The process entails the creation of Compliance Error Analysis Reports during the first two months following the contract booking and renewal dates in DMS. The system automates and improves the process of monitoring and reviewing quality and timeliness for booked contracts prior to the pre adjustment and adjustment periods performed by the Fusion Group. It also provides Dashboards for Senior Management to enable operational insights and better decision making.

Accutrac AIG :

Accutrac is a 3rd party records management software. Accutrac provides complete control of critical business documents, a comprehensive strategy for records management and information management. Accutrac centrally manages records from inception through active onsite management, archival storage management, to and through destruction - wherever the records reside. With Accutrac, records management security and consistency improves through records classification, indexing, retention and hold management. Accutrac is used for maintaining and meeting legal, regulatory and compliance obligations in AIG.

Responsibilities

Sr BI Developer

• Involved in gathering business requirements from business users.
• Developed and supported the Extraction, Transformation and Load process ETL for a data warehouse from various data sources including EDW.
• Analyzed the source data, cleansed, standardized source data and provided cleansed data to ETL.
• Integrated different source feeds and extracts from systems across enterprise.
• Designed High-level design documents and ETL mapping specifications.
• Effectively worked with Data Modeler to develop Logical and Physical Dimensional Model for Data Marts.
• Designed and developed Job Sequence for the ETL jobs.
• Map the source and target databases by studying the specifications and analyzing the required transforms.
• Set up and Configured SQL Server 2008.
• Used PL/SQL to populate the data marts.
• Created customized report for different type of reports standardization of report formats, filter options, page break options, and output options as well as additional flexibility in terms of report data selection.
• Created complex reports using union queries, conditional formatting and prompting, drill-through.
• Created reports with cascading prompts.
• Graphical presentations like pie chart, bar charts, line charts were created for analysis and statistical information.
• Involved in testing the newly developed with the pre-migration Reports.
• Assisted users in troubleshooting their reports.
• Evaluated Report Performance upon completion of the reports and validated output data.
• Deployed packages, Reports from a development environment to test environment.
• Developed, managed, and coordinated all user acceptance testing.

Environment:

SQL Server 2008/2005 SQL Integration Services SSIS , SQL Reporting Services SSRS ,ETL, MS SQL Server 2000, SQL Query Analyzer, Oracle 10g, TOAD 9.0.1, Autosys, Windows NT, Cognos 8 BI Report Studio , Datastage 7.5 Designer, Director, Manager Administrator , Windows NT.

Confidential

• Princess Cruises - A recognized leader in worldwide cruising. Today the liner has grown to become the third largest cruise line in the world, renowned for innovative ships, an array of onboard options, and an environment of exceptional customer service. Princess Cruises is part of Carnival Corporation, one of the largest vacation companies in the world.
• The Princess Reservation System is driven by voyages and booking. This consists of online CICS transactions and batch processes. The Online system consists of transactions which define and maintain key componensts of business like ships, voyages, bookings, agents, tours, packages, etc. The batch process do update, create extracts and downloads and produces reports from the information captured by the online system. The project is carried out both at onsite and at offshore.

Responsibilities

• Requirement Analysis for Work Request / Change Request on online / Batch applications.
• System Design / Impact analysis on business process changes.
• Optimization of System Design.
• Coding of programs for new business applications or Conversions.
• Customer/User support for business queries and problems.
• Lead role in Planning and creating critical tools / applications for the project. Requirement Specification for the new proposed tools / applications, Construction and Testing of the tools / applications.
• Testing of Online and Batch applications.
• Documentation of the Reservation System.
• Technically guiding and co-ordinating with Team Members.
• Re-engineering Reservation System Group and Agent system.
• Onsite-Offshore co-ordination involving client interaction and status reporting on technical related deliveries.

Environments:

Operating System: Windows XP, Mainframe OS/390. Programming: COBOL / CICS / VSAM / JCL. Database: DB2, UDB.

Confidential

Confidential is a worldwide company based in the Confidential. Confidential core businesses are passenger transport, cargo shipment, and aircraft maintenance. The company uses Mainframes for its cargo handling. Confidenttial Invoices right requires a number of checks, corrections and dealing with complaints. A process that disproportionately contributes to this workload, is the Ad Hoc Contract process. An Ad Hoc Contract is one that is made locally to sell the remaining capacity at the last moment.

Responsibilities

• Analysis of tickets raised by users.
• Development of test plans for unit testing and system testing for the changes.
• Identifying the code components and impact analysis of the same.
• Modification to Remote Stored Procedures RSP's and Remote Procedure calls RPC's .
• Capturing any defects in the code and resolution of the same.
• Peer reviews of back-end code by de-bugging before the testing and delivery.

Environments:

Operating System: Windows XP, Mainframe OS/390. Programming: COBOL / JCL. Database: DB2, UDB.