Manager Data

RAJA BUSSA

Cincinnati, OH-*****

PH: 513-***-****; *********@*****.***

Over 10 years of experience as a Manager, BI developer in Informatica ETL tool and TIBCO Spotfire reporting tool. Proven managerial and Product development, and testing expertise in Financial, Banking, Pharma and Aviation industries.

Work Summary:

GE Aviation, Cincinnati, OH 2014 – Present

Business Intelligence manager

Managed onsite and off-shore teams Business Intelligence (BI) teams and drove the development of Dashboards and Reports of GE Aviation’s supply chain. Work included setting priorities, cost and schedule estimates, implementing using GE best practices, coaching and supervising. As a part of the job, drove daily statues meetings, coordinated team activities and drove product requirements.

Responsibilities:

Detailed business requirements process and approval for planning system.

Managed development, test and production environments.

Worked with Informatica and Spotfire tool for product development and implementation.

Documented and implement an end-to-end BI methodology for a successful delivery process, and ensured adoption.

Formulated and provided status updates on project plans and schedules to meet goals/objectives

interacted with the business, business strategy and customers to drive the development and evolution of effective products

Maintained technology standards and ensured compliance across all product lines.

Ensured that teams were using the appropriate tools and processes in the most effective manner.

Developed and implement Community of Practice for the software development team members

Ensured that goals and development plans are put in place for the entire team.

Drove ongoing collaboration with Quality Assurance (QA), BA, Product Owners, Project Managers and other teams to continually strive for transparent and efficient working relationships.

Technogies used: JIRA, Informatica, Spotfire, Tableau, Oracle, Greenplum, Teradata, ADS Composite, Attivio.

Glaxo Smith Kline, Durham, NC 2012 – 2014

Business Intelligence Manager

Responsible for overall development and implementation of eDx,electronic document exchange, which is a Global application used by all the pharma and doctors for research documents approvals. Coordinated and participated in meetings with different country users for the respective country pharma rules and regulations. Worked with different teams in different countries for analyzing the 21 CFR rules. Responsible for implementing the application in different countries for the regulatory rules and languages.

Responsibilities:

Actively participated in charting the strategic vision for the product, and owned the product roadmap and its execution.

Worked closely with engineering and user /business team to provide the input needed to guide the development of the product functionality.

Managed project risks and issues.

Constructed and communicated weekly status reports for the overall project status to the program managers, performance managers and training department.

Managed and ensuring customer expectations are met through the implementation and training cycle.

Interacted with the business users to understand their needs and to anticipate ways in which solutions can enhance business processes.

Technologies used : SharePoint, .Net, Informatica, Qlikview, MSSQL, Quality center, Oracle.

Freddie Mac, Mclean, VA 2010 - 2012

Spotfire Lead

HAMP, Home affordable modification program, a new mortgage payment system introduced for the home owners which required certain eligibility criteria and Mortgage Company’s participation in the program. Whoever participate in the program received a bonus as well as lower interest rates.

Responsibilities:

Created standalone and integrated dashboards and visualizations according to the business user’s requirements.

Worked with all levels of business teams supporting enterprise projects that involved reporting, analysis, and/or executive dashboards.

Co-ordinated with off-shore and on-site team for the requirement changes and deliverables.

Designed and implement BI metadata and data dictionary design and standards.

Defined and manage schema objects for existing and new projects

Documented systems through object models, data definitions and naming conventions.

Worked with visual designer and business users to translate functional designs/user stories into intuitive analytical solutions.

Assisted in developing and implementing data feeds to import into Spotfire

Provided guidance in Spotfire installation and configuration.

Supported user validation and testing.

Technologies used: Spotfire, DB2, Oracle, ADS, Flat files.

Capital One, Richmond 2008 - 2010

ETL Lead

4

7'( 2

Worked on Internet Account Acquisition (IAA) Application. IAA is web based application to apply new Capital One credit cards for both solicited and un-solicited applicants. IAA is used for different business areas like ISWG, GMC and Partners. IAA interfaced with other systems for credit decisioning including COMM Server, Capstone, BT, Unisys and Credit bureaus (for credit scores).

Responsibilities:

Participated in the business requirements gathering and prepared the design documents.

Involved with the source system team, data staging team to ensure proper dataflow to the staging environment. Processes.

Extensively worked in the performance tuning of programs, ETL procedures and processes.

Documented and Prepared Unit/Integration Test Plan and Test cases.

Coordinated with the offshore team to develop ETLs. This involved proper representation of the project scope and requirements, and explaining the ETL process and ETL standards.

Collaborated with the source system team, data staging team to ensure proper data flow to the staging environment.

Worked closely with the project team to formulate and implement a flexible system design that meets functional requirements.

Maintained proper running the Jobs in DEV, QA and Production environment and resolved the errors.

Technologies Used: Informatica power center, Quality center, DB2, Oracle.

Publix, Lakeland 2007 – 2008

ETL Developer

TEDM is a Publix Supply-chain PeopleSoft application which deals with the entire stores inventory. It is a database application mainly for the newly added supplies and sales to the store and also for the newly opened stores. It has different departments like pharmacy, grocery and food and maintains different database for each store.

Created the design and mapping documents.

Worked closely with user decision makers to develop the transformation logic to be

used in Informatica.

Created different transformations according to the business and technical requirements.

Resolved the database and performance issues.

Developing number of Complex Informatica Mappings, Mapplets and re-usable Transformations for different types of reports research studies for Monthly Loading of data.

Used Workflow manager for Workflow and Session Management, database connection

management and Scheduling of jobs to be run in the batch process.

Coordinating with source system owners, day-to- day ETL progress monitoring,

data warehouse target schema Design (Star Schema) and maintenance.

Technologies Used: Informatica Power center, Oracle, Tera Data, JIRA.

Verizon, Tampa 2006 – 2007

ETL Developer

RMS is a web based application mainly deals with claims, Approvals, Disputes, Adjustments and User Profiles. CVMT approval tool adjust the claims if they are below certain amount, the remaining big amount adjustments and disputes should be done manually. Enhancements and changes were made to the User profile and Claim search on the Webpage.

Responsibilities:

Coordinated with Data modelling and Report development team to create new tables and DB

Migrated old database to new database.

Worked extensively on transformations like Filter, Router, Aggregator, Lookup, Update

Strategy, Stored Procedure, Sequence generator and joiner transformations.

Used Connected and unconnected lookups in various complex mappings.

Responsible for development, test and production mapping migrations using repository manager. Also used Repository Manager to maintain the metadata, Security and

reporting. Performance tuning was done to the Informatica Repository and Mappings for optimum performance.

Developed and published reports on the web through Web Intelligence.

Technologies used: Informatica Power center, Share point, JIRA, Oracle.

Education:

Bachelor in Engineering

GITAM University, Visakhapatnam, India

Master of Business Administration (1993- 1995)

GITAM University, Visakhapatnam, India

Visa Status: US Citizen

Contact this candidate