SUMMARY

• Over 13 years and 5 months of experience in system and application software design, development in data warehousing and Business Intelligence using tools like SAP BODS 4.x, SAP Business Objects 4.x, Crystal Reports, QlikView, Xcelsius, Informatica and Teradata in global IT industry.
• Well versed with the concepts of Dimensional Modeling and experience in using Embarcadero ER Studio. Experienced in different stages of Decision Support Systems like development, enhancements, maintenance and support.
• Handled multiple projects in Data Integration using SAP BODS and Informatica.
• As an ETL lead experienced in single handedly handling the project development efforts.
• Dimensional Data Modeling Experience using Embarcadero - Conceptual, Logical and Physical
• Design, development and coding with ORACLE 11i/10g, SQL Server 2012 R2 and Teradata 13
• Extensively worked on Business Objects 4.0 enterprise suite and knowledge of BO 4.0 Migration.
• Business Objects XI R2 Certifies Professional.
• Teradata V2R5 Certified Professional.
• As a Lead Data Analyst involved in various business operations and helped the organization to achieve cost-effective production with increased quality, efficiency and satisfied customer service.
• Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into reports, designing universe, documenting and rolling out the deliverable.
• Define Business Process; identify the risk, doing risk analysis and providing baseline acceptance criteria and deliverables.
• Adept in providing Analytical Support to key business Applications /solutions
• Lot of experience in managing the quality assurance activities, preparing functional test plans, unit test plans, unit & system test cases, executing test cases and certifying the software work product on various platforms.
• Conducted technical training to the teams on BI tools (SAP BOBJ and Xcelsius).
• Excellent verbal and written skills, especially with regards to presenting findings to both technical and non-technical audiences
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs.
• Rich experience in translating business requirements to understandable IT systems requirements and managing the requirements lifecycle.

AREA OF EXPERTISE

• Requirements definition, functional specifications and gap analysis.
• Data Analytics
• Legal and Compliance to detect fraud and money laundering in Finance Securities as per the regulatory requirements.
• Human Capital Analytics
• Retail banking processes related to Preferred Banking.
• Understanding of Hedging process inside Insurance Domain
• Clinical Trial Management System for drug research.
• Financial risk management related to the process and environment

TECHNICAL SKILLS

Data Integration: SAP BODS 4.x, Informatica, SAS 9.1

Databases: Oracle, Teradata, SQL Server.

Languages: PL/SQL, SQL and Python.

BI Tools: Business Objects 4.0, Crystal Reports, MicroStrategy and QlikView

Data Modeling: Embarcadero

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

ETL Architect / Data Analyst

• Finding solutions for successfully moving policy information from source to booking systems.
• Designing the ETL solution for various products - Healthcare and Pro Plus.
• Handling mission critical issues related to data load in a highly demanding environment.
• Responsible for continuously improving the ETL process to avoid bottlenecks.
• Responsible for design, testing, support, and debugging of new and existing ETL and reporting processes.

Confidential, Tampa, FL

ETL Lead / Data Analyst

• Creating Data Mapping documents to support ETL Process.
• Designing and developing ETL routines to extract, transform and load data into the new DWH.
• Performance tuning of the ETL jobs.
• Driving the data model discussions to make sure the model is in line with the requirements.
• Preparing the risk mitigation plan and maintaining issue log.
• Presented findings and data to team to improve strategies and operations
• Planning and implementing the job schedules and creating dependencies.

Confidential, Tampa, FL

Data Analyst/Data Modeler

• Interacting with business users to identify their needs, gathering requirements and authoring Business Requirement Documents (BRD), Functional Specifications Document (FSD)
• Defining acceptance criteria for the business use cases.
• Manage the planning and development of design and procedures for metrics reports
• Identify, analyze, and interpret trends or patterns in complex data sets
• Data Modeling in Hadoop Hive environment.
• Analysis of Master Data Management (MDM) data sets for the solution.

Confidential, Los Angeles, CA

Lead - ETL Developer

• Development ETL jobs in BODS.
• Making changes to existing code to add new source.
• Timely reporting of the project status to various stakeholders.
• Co-ordination between the client and the project team.
• Understanding and documenting the Business requirements.
• Provide detailed project level estimates on the activities to be performed.
• Data Analysis and providing design approach on new development work.
• Providing support to UAT users and training them in various ways of understanding data.
• Overseeing all aspects of the project starting from Requirements Analysis to Production Implementation.
• Getting the things done in Onshore-Offshore model.

Confidential, Los Angeles, CA

Lead - Data Analyst

• Understanding the report requirements and documenting them.
• Analysis of requirements to come up with SMART goals.
• Identifying facts and dimensions based on functional requirements.
• Modeling the target database to hold package-tier enrollment data
• Planning the work to be performed by the offshore team and getting the work done.
• Single point of contact responsible for delivery and execution for the project.

Confidential, Montpelier, VT

Technical Lead

• Analysis of current reporting environment and understand the business requirements.
• Identifying new Dimensions and Facts for the proposed Data Warehouse.
• Responsible for the conceptual, logical, and physical modeling of the Enterprise Data Warehouse / Data Mart environments.
• Worked on assessment document preparation for future reporting needs.
• Regular interaction with various development teams, project manager, business analysts, and end-users.
• Developed POCs by building reports and dashboards using Tableau 8.3 to demonstrate quick wins.
• Developed visualizations using sets, Parameters, Calculated Fields, Dynamic Sorting, Filtering, Parameter driven analysis.
• Identify and define data sourcing, business rules and transformation logic for next phases of the project.
• Responsible for facilitating Joint Application Design (JAD) sessions and one-on-one interviews with the business.
• Supporting implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.

Confidential, Montpelier, VT

BI Reporting Architect

• Design and develop Business Objects Universes for PAM and Lawson
• Design and develop Business Objects Reports.
• Converting the existing Crystal Reports into WebIntelligence Reports
• Associated with data controls implementation for the whole of the Confidential .
• Metadata management - Across Confidential .
• Working closely with the business to come up with innovative solutions for viewing the data
• Worked on BO Explorer Visualizations.

Confidential, Richmond, VA

Onsite Team Lead

• Implemented agile development methodology for release phases.
• Analysis the data and develop/understand the ETL specifications.
• Worked on complex mappings, mapplets and workflow to meet the business needs ensured they are reusable transformation to avoid duplications.
• Managed requirements and design approach towards identifying mutually agreed solutions with offshore teams and business partners.
• Developed and modified Business Objects reports along with Universe modifications
• Also involved in ETL development and scripting in Informatica and Teradata.
• Designed and implemented fixes for BI Reports to meet the changing business requirements.
• Led the BI LO team from onsite and having a team of 10 at offshore.
• Involved in the process improvements for the HelpDesk and NOC related tasks to help the customers with high availability of the system.
• Planned and implemented twenty-five RIMs both ETL and Reporting and duly followed the stringent process guidelines and tough timelines.
• Conducted training and presentations to UAT and Operation group in CIS for the effective execution of the test scripts and flawless code validation.
• Participated as a key team member in planning and coordinating the testing of the product for one of the RIM implementations which required co-ordination between various other teams.
• Utilized my knowledge of ETL and Reporting methodologies to help users understand the technicalities and to come up with better requirements.

Confidential

Technical Lead

• Design and development of BO and Crystal reports.
• Design Development of the CCA Universe.
• Using with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• I mplemented software releases and patches on the user acceptance and production environments.
• Performed defect analysis of the real time issues in the production environment.
• Worked on creating self-service visualization dashboards using QlikView for Clinical Care Advance application as part of a proposal POC.
• Also involved in development of a new product solution using the existing reports as dashboards.

Confidential

Team Lead

• Development and maintenance of the Universes.
• Enhancement requirements processing.
• ETL support through QC reports.
• Creating reports using DesktopIntelligence and WebIntelligence.

Confidential

Team Lead

• Leading the team from offshore and responsible for completed delivery.
• Development and maintenance of Non Regulated Universe.
• Addressing the daily ad hoc report requests for clients.
• Writing the SQL and validating against database and the front-end application.
• Creating reports using Crystal Reports and Business objects WebIntelligence.
• Create and maintain the Crystal Xcelsius Dashboards.
• Maintaining the SAS code as part of SAS support.
• Documentation support as per the Federal requirement.
• Part of innovations team and responsible for the innovations.

Confidential

Team Lead

• Development of CDAS Universe
• Creating the parameter passing mechanism that suites the custom-built legacy application.
• Developing the WebIntelligence reports with complex formatting.
• UTC preparation as per the regulatory requirements.
• Involved in complete documentation of the process.

Confidential

Module Lead

• Lead the team in BO migration process from 6.x to BO XI R2
• Prepared Technical Design Document for reports
• Involved in Development of BO reports and modified the existing reports as per the requirement
• Involved in the Unit Testing and System Testing and Code Review
• Was part of process improvement initiatives
• Till date Met all deadlines and made necessary design & configuration modification as needed to meet the customer requests
• Performed POCs with the latest version to support the design tasks.
• Training the ETL team on Business Objects as part of knowledge sharing.
• Involved in taking resource interviews.
• Duly followed the quality process.

Confidential

Developer

• Involved in the creation of the Universes using the Business Objects Designer Module.
• Extensively used Supervisor Module for managing the repository as well as users.
• Developed mappings using Informatica PowerCenter Designer.
• Creation of reports using Web Intelligence Java Reporting Panel and Testing against the database
• Used Stored Procedure Data Providers.
• Met all deadlines and made necessary design & configuration modification as needed to meet the customer requests.
• Used Teradata as the source database and worked extensively on the V2R5.