SUMMARY

• Over 5 years of IT experience with Business Intelligence, Data Mining,ETL, BI Reporting tools and PL/SQL Programming.
• Expert in developing reports,ETL mappings, Fixing Data quality issues in different BI environments. Skilled trouble shooter with proven ability to provide the creative and effective BI solutions.
• Proven functional report requirement gathering by developing good rapport with the business users.
• Adept experience in data analysis on large data sets using SQL Server.
• Worked extensively on data import/export and migration requests using MS SQL Server.
• Supported critical stages of Electronic Discovery Reference Model (EDRM) such as Analysis and Production.
• In-depth understanding of all stages of software development life cycle (SDLC).
• Create, implement and manage electronic discovery solutions for the culling, processing, hosting and conversion of electronically stored information (ESI) for end clients.
• Extensive experience with ETL including Designing and Building ETL for data integrationand business intelligence initiatives. complete understanding of various features of Informatica Power Center including General Architecture, Platform Support, data Integration, Data Cleansing and transformations, development and administration, concurrency and security, Error Handling, Performance and Scheduling..
• Extensive Knowledge of different Schemas (Star and Snow Flake) to fit reporting, query and business analysis requirements
• Performed Data Analysis before creating Mapping documents.
• Good understanding of RDBMS concepts with hands on experience in Oracle 8i/9i/10g database and Oracle Forms.
• Extensive experience in writing SQL and PL/SQL programs Stored procedures, Triggers, Functions for back end development.
• Experienced in tuning the database and the Mappings for effective performance.
• Hands on experience in Software Quality Assurance including Test Case creation and execution.
• Extensive working knowledge in MS access database and Excel
• Knowledge on creating reports using Business Objects 6.5
• A good team player with ability to learn and implement new technologies at faster pace. Effective in end user interaction with good written and verbal skills.
• Extensive knowledge of data warehouse methodologies and data modeling.
• Good technical & communication skills, self-motivated at learning new skills, efficient at multitasking

TECHNICAL SKILL SETS

• Cognos BI 10.1/8.3, Cognos Cubes.
• Cognos Report Studio, Framework Manager
• Informatica 8 series.
• PL/SQL Programming
• Business Objects XI 3.1.
• SQL Tuning in an Oracle Environment
• Windows 7/XP
• Oracle 10g/11g Environment.
• Performance Tuning & Data Validation.
• Data Mining

EDUCATION & TRAINING

4 years of Bachelor's Degree in Computer Applications.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA
Senior BI Developer
Jan 2009-Current

Confidential is a multi-national insurance company withthe varietyof insurance offers for the customers in different part of the world. BI projects for different groups had developing ETL mappings using Informatica 8.6.1 for data warehouse development, producing BI reports using Cognos 10.1, data validation using complex SQL queries .Working with the business users and finalizing the requirements.

Key projects:

• Served as report developer using Cognos report studio, metadata modeling using Cognos framework manager.
• Cognos cube design and development using Transformer.
• Converting user requirements into Cognos cube dimensions and measures.
• Data mining using complicated Oracle SQL queries
• Experience in Cognos business insight and business insight advanced.
• Responsible for day-to-day reporting operations for the risk management and loss mitigation departments.
• Worked with business users in finalizing the requirements and functional specs.
• Everyday interaction with risk management and loss mitigation departments for data quality and data mining.
• Successfully worked with multiple business entities on business intelligence projects.
• Worked as ETL developer by developing complicated mappings using Informatica 8 series.
• Balanced development between ETL and Reporting, to obtain good performance.
• Developed sql queries for data quality issues.
• Data validation of all the Cognos reports by comparing the data to the source system.
• Developed Cognos dash boards and portal in Cognos connection.
• Maintained 3 different reportingenvironments for data consistency.
• Monitoring daily ETL jobs to make sure data is flowing properly.
• Managed workflows and dependencies for multiple mappings.
• Developed stored procedure in Oracle PL/SQL for populating the summary tables so that reports can be executed against stored procedures for better performance.
• Helping users with the ad-hoc reports.

Environment: Cognos BI10.1, (Transformer, Power play, Report Studio, Framework Manager) Informatica8.1, Oracle11g, Windows XP/Windows7.

Confidentialt, Bangalore, India Jun 2007 -Dec 2008
Client: Confidential, Los-Angeles , CA
BI Developer

Report development in Cognos 8.3, migrating reports from cognos to business objects, gathering requirements and writing the functional documents, working with the data warehouse team members in fixing the ETL issues, responsible for the day- to-day reporting issues.

Key projects:

• Involved in reporting projects for marketing and financial applications.
• Worked on Cognos data security based on the user privileges.
• Developed and managed Cognos schedules in Cognos connection.
• Developed summary tables using stored procedures for faster execution of the reports.
• Trained business users in Cognos connection and report execution.
• Worked on offshore onsite IT project with various teams located in different parts of the World.
• Worked with ETL developers for data integrity and quality.
• Developed ETL mappings using Informatica 7 series.
• Worked on a data migration project from set of Cognos reports to business objects.
• Resolving table joins and traps to enhance the performance of the reports.
• Developed Informatica mappings by usage of aggregator, SQL overrides in lookups, source filter in source qualifier and data flow management into multiple targets using router transformations.
• Extensively involved in performance tuning of the ETL process by determining the bottlenecks at various points like targets, sources, mappings, sessions or systems. This led to a better session performance.
• Involved in creating the run-book and migration document (from Development to Production).
• Document the process for further maintenance and support.
• Worked on test cases and use cases.

Environment: BO XI3.1, Cognos BI 8 Series (Transformer, Power play, Report Studio, Framework Manager) Informatica 7 Series, Oracle10g, Windows XP