SUMMARY

• 8+ years of IT experience in Complete Project Life Cycle.
• Experience in Requirement Gathering and Analysis, System Design, and Developments phases of Software Development Life Cycle (SDLC).
• Strong Experience in Data Modeling, Data Validation & Implementing Data ware housing Concepts.
• Excellent noledge on Data warehousing concepts - Star schema, Snow-flake Schema and worked on both OLAP and OLTP databases.
• 6+ years of strong experience in Data Warehousing experience using Informatica Power Center.
• 1+ years of strong experience in B2B using Informatica and Data Studio.
• 2+ years of strong experience as an Onsite Lead.
• Strong in working with Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Implemented Slowly Changing dimension types (me, II &III) methodologies for accessing teh full history of accounts and transaction information.
• Implemented various Transformations like Expression, Joiner, Aggregate, Lookup, Filter, Update Strategy, Stored Procedures, Unstructured Data and Router etc.
• Working experience with Informatica Orchestration, Warehouse Designer, ETL, DB2, Oracle, MS SQL Server 2005/2000, Business Objects 6.x/5.x.
• Extensive experience in BI Modeling/Report Authoring using Cognos 10.1 & Cognos 8 Suite, Cognos ReportNet 1.1, Cognos EP Series 7.1/7.2/7.3 .
• Experienced with Multiple Relational Databases including Oracle, MS SQL Server, Teradata and DB2.
• Also worked as Informatica Analyst preparing documents and communicating with teh Reporting environment.
• Extensive experience on production support and troubleshooting/test issues with existing reports and cubes.
• Strong working experience in Data Warehousing concepts, Star Schema and Snowflake Schema methodologies.
• Experienced in coding using SQL, PL/SQL stored procedures/functions, triggers and packages.
• Excellent Team player with strong Analytical and Logical skills, Good communications skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.1/ 8.6/8.5/8.1.1/8.0/7.1.2/7.0/6.2/5.1/1.2/1.7, Power Mart 6.2/5.1/4.7, Informatica B2B, DT Studio.

Reporting Tools: Cognos V10.1, 8.1, 8.2, 8.3& 8.4 BI (Framework Manager, Query StudioReport Studio, Analysis Studio and Event Studio)Report Net 1.1 and Cognos EP Series 7.X (Power play Transformer, Power Play windows/web, PPES, Impromptu, Upfront

Databases: Oracle 8i/9i/10g, MS SQL Server 2000, MS SQL Server 2005, MS Access 2003, DB2 and TeradataV2R6.

Data Analysis: Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.

Dimensional: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Data Modeling Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Modeling Tools: Erwin 4.5/4.0/3.0,Oracle Designer.

Environment: PL/SQL programming, UNIX shell scripting.

Tools: and Servers: Toad, Autosys, Control-M, SQL Developer, IIS Web Server, Tomcat.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr.ETL Informatica Developer

Responsibilities:

• Reviewed teh Business Processes for teh project, and, tasks involved in it.
• Understood teh logic behind teh business processes and modified according to requirements
• Documentation for business data flow from source to Data Mart.
• Creating Entity and attribute definitions and created physical data model using Erwin.
• Worked with logical, physical, conceptual, star, snow flake schema data models
• Worked with business and Data analysts for requirement gathering, development, and testing.
• Analyzed existing Marketability Data Mart is satisfying teh Business rules or not.
• Performance tuning of mappings, transformations and sessions to optimize session performance.
• Created mappings, sessions, and, workflow to create objective aggregates, for rolling up teh fact table information into higher levels, like geo, district, region, zone and nation levels. Fact table is at teh territory level.
• Roll up teh data using position, and, position hierarchy dimensions
• Created stored procedures and optimized performance by providing partitions, index and analyzing teh table.
• Used Debugger to test teh mappings and fixed teh bugs.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Designed and developed teh Informatica Workflows for Daily, Weekly, Monthly and Initial Loads
• Used Power Center server manager/Workflow manager for session management, database connection management and scheduling of jobs to be run in teh batch process using Control M auto scheduling tool.
• Migrated mappings, sessions, and workflows from Development to testing and then to Production environments.
• Created multiple Type 2 mappings in teh Customer mart for both Dimension as well as Fact tables, implementing both date based and flag based versioning logic.
• Tested teh data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Developed UNIX shell scripts to move source files to archive directory.
• Involved in Unit, Integration, system, and performance testing levels
• Extensively used SQL* loader to load data from flat files to teh database tables in Oracle.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow.
• Created various data marts from data warehouse and generated reports using Cognos V10.1.
• Developed Standard Reports, List Reports, Cross-tab Reports, Charts, Drill through Reports and Master Detail Reports Using Report Studio.
• Created Query prompts, Calculations, Conditions, Filters, Multilingual Reports Using Report Studio.

Environment: Informatica Power Center 9.1, Informatica Data Quality 9.1,Oracle10g, Teradata, SQL Server 2008, PL/SQL,SQL* Loader, Erwin, TOAD 9.5, Star Schema, Power Exchange, UNIX Shell Scripts, AS/400, Windows XP, and MS-Office tools.

Confidential, NJ

ETL Informatica Developer

Responsibilities:

• Gathered functional and technical requirements for Global data warehouse.
• Analyzed functional specs and created technical documentation.
• Extensively used ETL to load data from heterogeneous sources like flat files, oracle tables.
• Extensively used update strategy, look-up, expression, Joiner transformations for Inserting, updating, deleting teh data.
• Designed and developed full life cycle for data loads about terabyte size Data Warehouses OWB.
• Used Type -1 &Type - 2 slowly changing dimensions to maintain history.
• Created Mapplets for teh same repeating logic in mappings.
• Extensively worked with Teradata utilities likeBTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files
• Wrote stored procedures for data validations.
• Automated load run on Informatica sessions through UNIX Cron, PL/SQL scripts and implemented pre and post-session scripts, also automated load failures with successful notification through email.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database.
• Developed Stored Procedures.
• Created and ran workflows and Worklets using Workflow Manager to load teh data into teh ESTAR Database.
• Scheduled teh workflow using Informatica Scheduler.
• Experience trouble shooting and maintain Oracle data base
• Unit testing of teh mappings in Informatica 8.6.1 to check teh bugs during migration and check teh dataflow in teh mappings .Comparisons of teh results in both teh versions and documentation of teh results.

Environment: Informatica 8.6.1,Toad 9i,Cognos, Oracle 10g,Solaris UNIX, TeradataV2R6, OLAP, Flat files and UNIX Shell Scripting, SQL Server 2005.

Confidential, VA

ETL Informatica Developer

Responsibilities:

• Extensively worked on Business Analysis and Data Analysis.
• Interacted with teh users to convert business logic into ETL specifications.
• Extensively analyzed and used Ralph Kimball approach for building Data warehouse.
• Drafted Bus Matrix along with teh other team members.
• Extensively used ERWin for Logical / Physical Data modeling and Dimensional Data Modeling, and designed Star Schemas.
• Designed teh ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle as per business requirements using Erwin.
• Worked with Power Center - Designer tool in developing mappings and mapplets to extract and load teh data from flat files, Oracle to Oracle.
• Used Power exchange CDC (change data capture) for pulling from oracle source.
• Created different transformations like Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, Sequence Generator for loading teh data into targets.

Environment: Informatica Power Center 8.1.1/7.1.4, Informatica Power Connect, Work Flow Monitor, Trillium, ERWin 4.1, Oracle 9i, DB2, MS SQL Server 7.0/2000, Shell Programming, SQL * Loader, Business Objects 6.0, XML, TOAD, Flat files, Toad 7.0, Unix Shell Scripting.

Confidential, CT

Senior BI Developer

Responsibilities:

• Involved in Configuration/Install SQL Server 2008/2005 on client machine.
• Identified teh Fact and Dimension tables from teh SQL server based on teh requirements.
• Understanding existing data models, data flows and data dictionaries.
• Review, analyze and evaluate mapping documents.
• Involved in teh Installation and Configuration of Cognos 10.1 BI tools and Framework Manager.
• Deployment of reports from Development to Production.
• Implemented Third Party Security with LDAP and use those in creating Data Level, Object Securities in Framework Manager Models.
• Involved in Deploying reports, cubes and packages from Development to Production environment.
• Built Framework Manager Model, and established teh cardinalities to suit teh business needs.
• Developed and Published Packages in Framework Manager - Connecting and testing teh data source, creating database layer and presentation layer, defining appropriate relationships between query subjects.
• Created Dimensional models from relational data source in Framework Manager to publish packages to be used in Analysis Studio.
• Created, refreshed and supported Cognos Transformer OLAP models.
• Created various Prompts, Filters, and Calculations and used Conditional Formatting as per teh requirement.
• Created teh derived columns from teh present columns for teh given requirements.
• Created Dashboard Reports using various types of report layout options like charts (bars, lines, pie etc...), images, graphs, sub reports, hyperlinks, group by, drilldowns, drill through etc, to make them more attractive and understandable.
• Developed Reports using Conditional Formatting, Cascading Prompts and Report Bursting.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases.
• Created parameters (multi value, hidden, default etc.) for teh required fields using teh Report Studio in order to see teh dropdowns in teh end report.
• Created weekly, monthly and quarterly based Sales and Retail reports using Cognos.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Created SSIS packages with which data resources such as Excel, Access, XML were loaded daily in order to create and maintain a centralized data warehouse and made teh package dynamic to fit teh environment.
• Performed teh ETL operations of teh data between Excel/flat files and Database tables/views, during dis process many forms of data cleansing issues were resolved.
• Involved in Creating teh SSIS packages using different SSIS components and variables with data resources such as Excel, Access, XML to load daily in order to create and maintain a centralized data warehouse.
• Involved in developing/Deploying SSIS packages using BIDS for Data loads required for Reports.
• Involved in various Transformations in SSIS Dataflow, Control Flow using For loop Containers etc.
• Involved in Unit testing, System and Integration testing.
• Wrote an overall document to describe my work in details.

Environment: Cognos V10.1 Bi Suite (Framework Manager, Transformer, Cognos Connection, Query Studio, Report Studio, Cognos Dashboard and Event Studio).MSSQLServer2008/2005, SQL Server Analysis Services (SSAS), Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS).

Confidential, Washington DC

BI Developer

Responsibilities:

• Identify their business needs and prospects and document teh business requirements.
• Research on collected business requirements, identify teh bottleneck and iterate them with business groups. Translate business requirements into system specifications and develop reports as per teh client requirements.
• To replicate and enhance teh metadata model followed by customized set of reports, performance tuning and maintain numerous pre-existing report and a fully functional multi user Portal Dashboard for high profile clients and Senior Manager’s.
• Building models in IBM Cognos Framework Manager (Database Layer, Logical Layer, Presentation Layer, Packages).
• Implemented Third Party Security with LDAP and use them in creating Data Level, Object level, Package level and Row level Securities in Framework Manager Models.
• Complex Report Building Experience with Cognos 8 Report Studio to customize teh functionality in prompt page, Master detail Relationships, Drill through in Report page, Customized Prompts and Conditional Formatting.
• Creation of Models, Project and Publishing Packages using Framework Manager.
• Created various Prompts, Filters, and Calculations and used Conditional Formatting as per teh requirement.
• Creation of Dash Board Reports using Report Studio Modifying teh existing reports based upon teh change request by teh user.
• Analyzing teh Oracle Execution Plans, Table Structures to resolve teh performance issues in Cognos Reports, scheduling and distributing reports through schedule.
• Performance tuning by analyzing and comparing teh turnaround times between SQL and Cognos.
• Worked on Data Analysis, Validate reports and find data quality issues.
• Involved in Audit database configuration in Dev, QA and Prod environments.
• Implemented tuning settings changes for cognos query time limit in both Dev and Prod environment as per teh user requirement.
• Security Administration for setting up users, groups and roles and creating access permissions.
• Set security for individual reports in Cognos Connection.
• Involved in scheduling of Report Studio and Query Studio reports and sending reports via email to several business users.
• Utilized Cognos Connection to administer and scheduling reports to run at various intervals as well as teh Report Server.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos Connection.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Created reports in Analysis Studio using cubes and DMR models.
• Involved in building OLAP Transformer Cubes using IQD's, Packages and Reports as a source.
• Customizing user class security views in Cube by user classes / Roles.
• Created Technical design document for Report studio reports based on Functional specifications.
• Involved in deployment of teh Reports from Stage to Production.
• Resolved issues resulting User Acceptance Testing (UAT).
• Performed Data validations, Unit testing and preparation of Unit test cases.
• Troubleshoot Cognos Server Environment for teh better performance.
• Worked on Production Support and fixing report/package/data issues
• Worked on UNIX environment to change various file permissions, to move teh Parameter files and to compress old log files, Identifying and killing teh process at server side.
• Involved in tuning of SQL Queries for SQL OVERRIDE in Source, Targets and sessions.
• Redesigned some of teh mappings in teh system to meet new functionality.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, work lets, Assignment, Timer and scheduling of teh workflow.
• Used in maintaining database activities for various schemas using SQL and PL/SQL programming. Also responsible for fine tuning of SQL and PL/SQL code using Quest query optimizer.

Environment: Cognos 8.4 Bi Suite (Framework Manager, Transformer, Cognos Connection, Query Studio, Report Studio, Metric Studio and Event Studio),Oracle 10g, Cognos Series 7(Impromptu, Access Manager Power play Transformer, Power Play for windows / Web, PPES and Upfront). Toad for Oracle 9.7