SUMMARY:

• Over 8+ Years of experience in the field of IT with an emphasis on Business Intelligence concepts like Data Reporting, Analysis, Mining, Design, Development, Data Migration, Implementation and Testing of Database/ Data Warehousing/Client/ Server/Web applications.
• Over 6 year of work experience in ETL (Extraction, Transformation, Loading) utilizing Informatica 8.5/8/7.1.x (Powercenter) & DataStage 7.5.
• Over 3+ years of experience on entire Business Intelligence Technologies including Business Objects XIR2/XI, 6.5.x, Crystal Reports XI.
• Worked on Informatica client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer
• Hands on experience with complex mappings from varied transformation logics like Unconnected and Connected lookups, Router, Aggregator, Joiner, SCD’s,LookUp Strategy and re-usable transformations
• Worked on DataStage client tools like DataStage Administrator, DataStage Designer, DataStage Manager, DataStage Director
• Hands on experience with DataStage Stages like Sort, Sequential File Stage, Row Merger, Row Spiltter,Link Partioner, Link Collector, Merger and Server Shared Container jobs.
• Strong SQL and PL/SQL experience in Oracle, SQL Server. Experienced in Relational Database Management Systems such as Oracle, MS SQL Server.
• Highly skilled in writing SQL queries, Stored Procedures, Packages, Cursors, Triggers and Functions.
• Good work experience in UNIX environment & Erwin Data Modeling, Star-Schema design
• Strong experience in Universe Design, Desktop Intelligence WebIntelligence and InfoView, Supervisor, Administration/CMC, creating Ad-hoc reports and archiving the reports
• Good Exposure to Cognos 7.0(Impromptu, PowerPlay,Acess Manager,
  Report Studio, Query Studio).
• Extensive experience in creation of ETL Mappings and Transformations using Informatica Power Mart/ Power Center to move data from multiple sources into target area
• Worked with End-To-End implementation with Data warehousing team and Strong understanding of Data warehouse concepts Star Schema, Snowflake Schema and Multi-Dimensional Models for query and analysis requirements.
• Developed Standard Reports, Charts, Drill Through Reports, Cross tab Reports, List Reports, Summary Reports, and Multi Object Reports
• Strong Experience of FTP & SQL*Loader.
• Excellent interpersonal, communication skills with the ability to manage multiple projects and meet deadlines.
• Good knowledge of code, design reviews and other process oriented procedures.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.5/8.1/7.1(Source Analyzer, Warehouse designer, Mapping Designer, Mapplet, Transformations), DataStage 7.5 (DataStage Administrator,Manger,Designer,Director)

BI Tools: BusinessObjects XI R2/XI/6.5 (Designer, Desktop Intelligence, Infoview, Supervisor, CMC, CCM, WebIntelligence), Crystal Reports XI/10,
Cognos 7.0(Impromptu, PowerPlay,Acess Manager,
Report Studio, Query Studio)

Database: Oracle 8/8i/9i/10g, SQL Server 7.0,TeraData 12, MS Access.

Tools: Erwin, Toad, SQL*Loader Eclipse 3.0, SQL*PLUS.

Platform: Windows 2003 Server/XP/2000/NT/95, UNIX.

Internet Technologies: HTML, DHTML, AJAX, CSS, JavaScript, XML, XSLT.

Languages: JAVA, J2EE, JavaScript, XML, XSL, HTML, WML, VB 6.0, C, C++.

Methodologies: Star Schema, Snowflake Schema

EXPERIENCE:

Confidential Mar 2008 Present
Brookfield, WI
Sr. BI Analyst

AT& T is a premier communications holding company in the United States and worldwide. The main objective of the project is to integrate customers of the Cingular systems, SBC into the ATT wireless by developing and maintaining Customer Information Data Mart. It included extraction of data from different source systems such as Relational, Flat files, Excel files and application databases like Access. ATT wireless has information such as Orders, Billing, and Remedy and Communications information.

Responsibilities:

• Worked with the Business analysts, end users, Data Modelers and the DBA for requirements gathering, business analysis, and testing, project coordination.
• Extensively used Informatica 8.1 to load data from Flat Files, Access and XML to Oracle 9i.
• Used transformations-Source qualifier, Expressions, Joiner, Aggregators, Lookups, Sequence Generator, Filter, Rank and Update Strategy
• Used ETL Process to Extract, Transform and Load the data from source into staging area and datawarehouse
• Involved in creating, modifying & maintaining complex reports using Crystal Reports
• Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis). Used filters, conditions, calculations, etc.
• Worked extensively on Web Intelligence for any new requests and performance issues.
• Used CVS as Source Code version control
• Developed Data Mappings and Mapplets between source systems and warehouse components using Mapping Designer
• Created Different types of Server Jobs & Transformations using DataStage.
• Extensively worked with the sources which are extracted from Oracle, flat files and XML files
• Worked with Lookup, Aggregator, Expression, Router, Filter, and Update Strategy transformations, SCD’s.
• Converted lot of Java web based applications reports into Business Objects ones.
• Managing the Universes, Business objects products, Stored Procedures, Repository and Document domains.
• Creating User groups, Users, Database connections.
• Created new reports from the scratch from java web based applications and modified some of the existing reports.
• Created Prompts, Conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Used DataStage Server Jobs (Filter, Sorter, Joiner, Expression), Server Shared Container, Created Templates from Jobs, Row Merger, Row Splitter, Pivot.
• Involved in installation and configuring of DataStage and created backup files of all Data stage Projects
• Extensively used Calculation contexts, Variables, Drill down, Slice and Dice, Breaks, Sections, Created the new Views and Aggregate tables for report performance.
• Involved in creating the staging area and to load the data from staging area to target datawarehouse
• Maintained the backup of all the source flat files, which get loaded every day in the server
• Implementation of slowly changing dimensions methodology to keep track of historical data
• Created sessions to run sequentially
• Used heavily SQL,PL-SQL

Environment: BO’s XI R2, Informatica PC 8.5/ 8.1, DataStage 7.5,Oracle9i/10g, PL/SQL, UNIX, TOAD, CVS, Java, JSP, HTML, DHTML.

Confidential Sep 2007 Dec 2007
Milwaukee, WI
Sr. ETL/Reporting Analyst

MGIC Investment Corporation is the parent of Mortgage Insurance Corporation (MGIC). Based in Milwaukee, Wisconsin, MGIC serves more than 5,000 lenders across the U.S. and in Puerto Rico.
As the nation\'s leading provider of private mortgage insurance, MGIC provides a critical component of our country\'s residential mortgage finance system, protecting mortgage investors from credit losses. Private MI also benefits consumers by helping them achieve homeownership sooner with low-down-payment loans.
Responsibilities:

• Developed the ETL process using Informatica tools like Source Analyzer, Warehouse Designer to load the data from source to target tables
• Developed several Mappings and Mapplets using corresponding Source, Targets and Transformations
• Involved in creating the functional documents & technical documents.
• Involved in Full life cycle implementation of BO where I involved in all phases of requirements gathering, functional & technical design, testing, training, maintenance of the Universe & reports.
• Created, modified, enhanced, tested, deployed, optimized, and maintained Business Objects Universes using Designer to include objects like dimensions, details, measures & tables, views according to the users requirements
• Created aggregate aware tables at the database level & derived tables with prompts at the universe level to create various levels of pre-aggregated measures.
• Created dashboards, metrics, Key Performance Indicators (KPI), analytics, goals, rules, alerts using Business Objects XI R2 & Crystal Reports.
• Worked extensively with the major functionality of BO like Breaks, Ranks, Variables, Alerter, Formulas, Calculated data items, Filters, Sorts, and Query prompt
• Created various stored procedures, functions, cursors, views to do the reporting with the OLTP transactional database.
• Created Dashboards, modified them to suit the business needs which will send the Alerts when Metrics meet the required criteria set by the business users.
• Created the Default, Custom Hierarchies & cubes created canned & ad-hoc reports with Multi-Level Scope of Analysis using drill down, drill across, drill up and slice and dice
• Created complex reports using cascading prompts etc.
• Created Aliases and Contexts for resolving Loops and checked the cardinality and Integrity of the Universe
• Involved in Creating Repository, Creating Users and User Groups and assigned different privileges to them depending on their profile.
• Used CMC (Central Management Console) to manage the universes, profiles of users, groups, reports etc.

Environment: Business Objects XI R2, Crystal Reports XI, Informatica PC 8.1, DataStage 7.0, Oracle9i, PL/SQL, UNIX, TOAD.

Confidential July 2005 Aug 2007
Brookfield, WI
Sr ETL Developer

AT& T is a premier communications holding company in the United States and worldwide. The main objective of the project is to integrate customers of the Cingular systems, SBC into the ATT wireless by developing and maintaining Customer Information Data Mart. It included extraction of data from different source systems such as Relational, Flat files, Excel files and application databases like Access. ATT wireless has information such as Orders, Billing, and Remedy and Communications information.

Responsibilities:

• Used ETL Process to Extract, Transform and Load the data from source into staging area and datawarehouse
• Extensively worked with the sources which are extracted from Oracle, flat files and XML files
• Worked with Lookup, Aggregator, Expression, Router, Filter, and Update Strategy transformations
• Used DataStage Server Jobs (Filter, Sorter, Joiner, Expression), Server Shared Container, Created Templates from Jobs, Row Merger, Row Splitter, Pivot.
• Involved in installation and configuring of DataStage and created backup files of all Data stage Projects
• Created sessions to run sequentially
• Worked with the Business analysts, end users, Data Modelers and the DBA for requirements gathering, business analysis, and testing, project coordination.
• Managing the Universes, Business objects products, Stored Procedures, Repository and Document domains.
• Creating User groups, Users, Database connections.
• Created Cross tab reports, Charts, Drilldown reports, Formulas, hyperlinks, percentage reports, Prompts using Crystal Reports
• Used Erwin for the Data Modelling.
• Created new objects, Filters and Complex measure objects in the Universe.
• Delivered quality deliverables & involved in all phases of software development life cycle.

Environment: BO’s XI R1/R2, Crystal Reports XI, Informatica PC 8.1, Erwin,Oracle9i, PL/SQL,
Cognos 7.0,UNIX, DataStage 7, TOAD, CVS, Java, JSP, HTML, DHTML.

Confidential, IL December 2004 July 2005
ETL/BO Analyst

The Walgreens Company is the leading U.S. drugstore in sales, store growth and technology use. The company’s strategy is to become the nation’s most convenient healthcare provider. The Project includes creating the reports to monitor the sales of the various products as per the region and by pulling the historic data from the EDW (Enterprise Data Warehouse). The project scope was to migrate the existing BO Environment from 6.5.1 to XI and also build a new reporting Application in XI. This application used for Senior citizens those having less Income are eligible for Drug prescription discount card through out USA.

Responsibilities:

• Successfully imported Business Objects Universes, Users and user groups from Version 6.5 to Version XI using the Import Wizard and migrated full-client reports to WebIntelligence reports using the Report Conversion Utility.
• Used ETL Process to Extract, Transform and Load the data from source into staging area and datawarehouse
• Involved in documenting the current business process requirements, processes & reporting system we developed.
• Involved in developing reports against OLAP, OLTP databases.
• Involved in maintaining the supervisor to provide various levels of accessibility to the users.
• Installed, configured Business Objects on UNIX server & Windows Environment.
• Involved in upgrading the BO versions from 5.1 to 6.5 & also in upgrading the reports from BO 5.1 to BO 6.5
• Involved in creating user roles, security access, server administration, password management using the Central Management Console (CMC).
• Performed UAT (User Acceptance Testing) to know bugs involved in the reports and corrected them if found any bugs in the reports.
• Involved in implementing the best practices, methodologies & strategies using Business Objects Designer & Reporter.
• Created the conversion logic from input source data to output target data where the data existed in XML format.
• Development and Deployment of templates & Complex Reports & used multiple data providers, Union, Sub Queries, Intersection, minus and Master/Detail, cross tab, Charts Translated Business Requirements into Universes for different users.
• Developed Complex Reports that involved multiple data providers, Master/Detail charts, cross tab, bar charts, pie charts, complex variables and calculation contexts
• Ranks and Alerts in the creation of reports.
• Created Drill-Through Reports to provide users with more detailed information and query linking.
• Accessing data from the database using TOAD (running on Oracle 9i client) to cross check the data accuracy and created reports.
• Provided production support for the existing crystal reports and modified them when needed.
• Provided extensive support for the users on application usage and trained users in the functionality of the software.
• Used CVS as Source Code version control

Technologies: Business Objects 6.5, XML, Oracle8i, PL/SQL, SQL server, Informatica 6.1,Crystal Reports

Confidential, USA May 2004 November 2004
Informatica Developer

This project has been developed to provide bank information to the customer in order to take effective decisions and build good customer relationship. It provides intelligent information to the management regarding its current business situation and thus helps them to understand the trends, performance and customer analysis of the bank. The project was implemented to extract data from data marts like Accounts (Savings bank Account, Current Account, Loan Account), Deposits (Fixed Deposits, Recurring Deposit) and Loans (Personal Loan, School Loan, Industrial Loan, and House Loan etc) to Oracle database. Various reports were generated regarding current business situation and analytical information about the bank business.
Responsibilities

• Developed the ETL process using Informatica tools like Source Analyzer, Warehouse Designer to load the data from source to target tables
• Developed several Mappings and Mapplets using corresponding Source, Targets and Transformations
• Created various Transformations like Joiner, Aggregator, Expression, Filter, Update Strategy and Lookup Transformations using Transformation designer to load the data to target tables
• Used Workflow Manager and Workflow Monitor to Create, Schedule and Monitor the Session
• Involved in performance tuning of mappings and sessions

Environment: Informatica Power center 7.1,BO 6.5, Oracle8i, Java,Jsp, TOAD

Confidential, India Apr 2002 February 2003
Programmer Analyst

This is an online database of all the job opportunities in the field of medical science in United States of America. It was developed using Servlets. Here we have two types of search, one is simple search, which get you the results depending upon the job position in the given state, if not it displays the same job position wherever available. And the second one is power search which get you’re the exact match depending upon the job position, state, nature of the job (Full- time, Part- Time…) and company name.

Responsibilities:

• Developed user interface screens and forms using Java.JSP.HTML.Javascript for the Client side validations
• Establishing connectivity to SQL database using JDBC
• Used Crystal reports to generate the reports
• Programming the Auto Responder using servlets using send mail command

Technologies: HTML, Java, JSP,Crystal reports, Sql Server 7.0, Win NT, and UNIX

EDUCATION:

• Masters in Information Technology .Major: Client/Server technologies
• Masters in Mathematics .Major: Boolean algebra and Discrete Mathematics

CERTIFICATIONS:

• Sun Java certified programmer, version 1.4
• Microsoft Certified Database Administrator
• Corporate Training in Informatica, BO, Cognos,DataStage from Wilshire Tech (INDIA) LTD.
• PGDCST(Post Graduate Diploma in Client/Server technology from Software Technological Group), STG India
• Specialization Training Course in Oracle 8, Developer 2000 Forms V4.5,Reports V2.5 from SQL STAR PEOPLE (INDIA) LTD. (ATC of Oracle Corporation), New Delhi, India
• Advance Diploma in Information Systems Management from APTECH , India