SUMMARY

• Accomplished Data warehouse Architect with over eleven years of experience in different phases of software development life cycle (SDLC) including analysis, design, development, testing and Production.
• Strong understanding of relational database design concepts and in depth knowledge of OLAP solutions.
• Dynamic, result - oriented, team player with a sound understanding of BI Architecture.
• Excellent working knowledge in the ability to interpret and analyze customer requirements to develop and design new Reports/Dashboards.
• Strong ability to think laterally to provide solutions, exercising independent judgment and decision-making in the diagnosis and resolution of problems.
• Aggressive in identifying and solving inefficient operational processes.
• Keenly focused on customer requirements and service levels that directly contribute to measurable results.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. Cognos Developer/Informatica Developer

Responsibilities:

• Involved in gathering the Requirements with Business users and prepared Functional Requirement Specifications for report development.
• Extensively worked on loading Dimensions and fact tables in a star schema.
• Designed & Implemented SCD methodology including type 1 and type 2 changes to keep track of historical data.
• Created mapping using various transformations like Source Qualifier, Joiner, Filter, Aggregator, Lookup, Stored Procedures, Router, Sorter, Rank, Expression and Update Strategy.
• Participated in implementation and testing of various type 1 and type 2 dimensions.
• Designed and built staging tables to restrict the data for Incremental loads.
• Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.1.0.
• Involved in Migration and Upgrading of Frame work models, power play cubes and Reports from series 7 to Cognos 8.4 and from Cognos 8 to Cognos 10.2.2.
• Proficient in deploying Reports and Packages from one environment to other environments (export, import and Copy to Clipboard)
• Expertise in handling Administration tasks like bursting and scheduling the reports.
• Created Data Source Connections in Cognos Connection for new development.
• Involved in creation and maintenance of BMC Control-M jobs that submit Cognos cube build scripts that perform automatic publishing of Power Play Cognos cubes providing version control.
• Developed Transformer Models and publishing the Cubes to Cognos Connection to be used for multidimensional analysis.
• Design and developed Relational and DMR Framework Manager Models with Physical layer, Logical Layer and Reporting Layer and published them to cognos portal for standard reporting and Adhoc Analysis.
• Implemented the Security levels in Cognos framework Manager.
• Developed IQD packages out of Frame work Manager Model and published them to portal and used as a source to create Power play Cubes.
• Created filters and prompts within the Framework Model for improving performance of the Model.
• Converted 100+ Oracle Discoverer reports (an integrated Oracle product) to Cognos 10.2.2(JFS OIS enterprise reporting system).
• Developed the complex reports using Cognos Report studio like summary reports, detail reports, Drill through reports and Drill down reports.
• Developed Child Care BI dashboards comprising several lists, charts, and cross-tabs in a single page as well as multiple pages.
• Provided optimal customer support in troubleshooting and resolving the service tickets for ODJFS BIC Customer Service within sufficient timeframes.
• Deployed the packages and reports from Development to Production.
• Performed Unit testing of reports writing SQL statement at backend/DB and validating against Cognos report studio reports.
• Resolved issues resulting from User Acceptance Testing (UAT).
• Responsible for knowledge transfer, training and communication to end users and team members.

Environment: Informatica 9.1, Cognos Analytics 11, Cognos 10.2.2/10.1/ 8.4.1 Report Studio, Query Studio, Cognos Connection, Cognos Map Manager, Framework Manager, Power play Transformer, Cognos Scheduler, MotioPI, PL/SQL, IBM DB2, Oracle 11g/10g/9i/8i, TOAD, Unix, Flat Files, Shell Scripting, Quality Center & Control - M.

Confidential, Columbus, OH

Sr. Informatica Developer

Responsibilities:

• Collaborated with business analysts and technical team for requirement gathering and business analysis and prepared high-level design document to provide an overview of technical design specification system.
• Analyzed the existing application physical data model and suggested changes to data Model based on the ETL and Referential Integrity gap requirements.
• Accommodated ETL Mappings according to Database Management change requests.
• Developed Data Quality architecture for ETL environment.
• Worked with Shortcuts across Shared and Non Shared Folders, used Parameter files and Mapping Variables for Incremental Load.
• Created User Defined functions, reusable transformations to be re-used during the development life cycle
• Coordinated with Source System Owners to analyze sources for data feeds, mappings and Defaults for the Data and Created folders, groups, users and assigned permissions and privileges to groups and users using the Informatica Repository Manager.
• Maintained Development, Test and Production Repositories using Repository Manager.
• Also used Repository Manager to maintain the metadata, Security, Backup and Locks.
• Standardized parameter files to define session parameters such as database connection for sources targets, last updated dates for Incremental loads and many default values of fact tables.
• Performed tuning of Informatica Mappings for optimum performance and SQL overrides in place of homogeneous sources.
• Designed and coded rejected row handling process.
• Designed and implemented CDC backup process for Mainframes.
• Designed data loading sequence and populated data into ODS, staging and warehouse with business rules following Data warehouse methodologies.
• Implemented SCD Type 1 and Type 2 to update the dimensional schema.
• Implemented Data Validation and Exception handling logic in the mapping to handle at runtime.
• Added enhancements such as mail functioning, success flag, pre and post session functions etc.
• Optimized the mappings using various optimization techniques and debugged some existing mappings using the Debugger to test and fix the mappings.
• Provided detailed technical, process and support documentation like daily process rollback and detailed specifications and very detailed document of all the projects with the workflows and their dependencies.
• Responsible for best practices like naming conventions, Error Handling and Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level.
• Involved in Unit Testing, System Testing, User Acceptance Testing to check whether the data load into target are accurate which was extracted from different source systems according to the user requirements by generating several SQL test scripts, validating against test cases based on the pre-defined test plans.
• Created data lineage documents for data flow and ETL process based on Informatica mappings to support the project once it implemented in production.

Environment: Informatica Power Center 9.1.0 (Designer, Repository Manager, Workflow Monitor, Workflow Manager), Autosys, Oracle 11g, DB2 V 9.1, Flat Files, AQT, Ultra Edit, UNIX Scripting, AIX, Windows XP.

Confidential, Columbus OH

Sr. Cognos Architect/Informatica Developer

Responsibilities:

• Developed CFSR Performance Dashboard, dashboard provides maximum flexibility, as well as allows leaders to identify and monitor children for each permanency measure.
• Worked on creating Data Warehouse for SACWIS in Ohio, using Infomatica.
• Created adhoc reports, drill through and CFSR Metric Indicator reports based on user request.
• Extensively used features likes Conditional blocks, Bookmarks, Conditional formatting, HTML, Prompts, and Drill throughs.
• Used Java scripts in HTML item to set the most current dates in the Dashboard reporting.
• Used Cognos Connection as Web Portal to manage reports, develop prompt pages and conditional variables.
• Set up the security at the package level, query subject level and query item level.
• Created Query Prompts, Cascading Prompts, Calculations, Conditions and Filters.
• Extensively worked on loading Dimensions and fact tables in a star schema.
• Involved in the design and implementation of Bridge tables in a data warehouse.
• Responsible for developing and testing ETL mappings for Fact Child Disability fact table and surrounding dimensions.
• This fact table tracks disability claims and the dimensions provide data groupings for federally required reports.
• The fact table is treated as type 2 with current flag and effective date ranges due to updates and deletes in the source schema.
• Responsible for building bridge tables to implement many-to-many relationship between fact table and a dimension.
• Analyzed source data and developed Fact Allegation table with supporting dimensions.
• This table tracks abuse allegations for the Department and vitally important for correct reporting.
• Lead testing of various fact and dimensions tracking child foster care placements.
• Participated in implementation and testing of various Type 1 and Type 2 dimensions.
• Used the Workflow manager to create workflows, worklets and tasks.
• Delivered and sign-off of deliverables pertaining to the Operations Data warehouse.
• Prepared design documents, ETL data mapping and migration documents.

Environment: Informatica Power Center 9.1.0 (Designer, Repository Manager, Workflow Monitor, Workflow Manager), Cognos 8.4.1 Suite, Oracle 11i/10g, Quality Center.

Confidential, Cincinnati OH

Sr. Cognos Lead Admin/Architect

Responsibilities:

• Installed and configured Cognos 8.4.1 Business Intelligence environment and performed knowledge transfer in support of this company’s evaluation of Cognos for its national rollout of new insurance products.
• Consult and assist Sales and FID departments with the usage of Cognos Tools.
• Monitoring daily cubes and Reports that are scheduled to run and Burst to users every morning before business day starts.
• Externalized IQDS out of Cognos 8.4.1 Framework Packages to support Power play Cubes.
• Created individual state reports for the FID department to give the ability to enhance their risk management capabilities by providing a visual depiction of FID’s experience and exposures on both countrywide and state maps.
• Involved in setting up Groups/Roles to secure the models and packages (Data Level) using Access Manager.
• Uploading Burst tables, run the reports, and Burst them to Agents based on alpha sorts during Month End Processing.
• Created High-level design and analysis documents and set up a meeting with Business to get their approvals.

Environment: Cognos 8.4.1/8.3 Suite, Framework Manager, Power play Transformer, Oracle 11i/10g, TOAD, HTML, MS-Access, MS- Excel, Unix, AIX, Windows NT.

Confidential, Washington DC

Sr. Cognos Product Specialist

Responsibilities:

• Involved in Migration and Upgrading of Reports from Cognos 8.3 to Cognos 8.4.
• Designed and modified reports with Java SDK in Report Studio.
• Created Power play Cubes using Power play Transformer generated Power play Reports.
• Involved in setting up Groups/Roles to secure the models and packages using Access Manager.
• Created High level design and analysis documents and set up a meeting with Business.

Environment: Cognos 8.4/8.3/8.2, PL/SQL, IBM DB2, SQL Server 2005, DTS, Oracle 11i/10g, TOAD.

Confidential, Pleasanton, CA

Cognos Developer

Responsibilities:

• Develop the HR Dashboards for the Kaiser Management of the HR activities and
• Write BTEQ scripts in Teradata as part of ETL task to load the target systems
• DesignedNational Dashboard reports on the critical performance metrics in the path toward Best Quality, Best Service, Most Affordable and the Best Place to Work which make up the KP Value Compass.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Designed Multidimensional Model (IT Performance Measurement DMR) in Framework Manager used MDX functions for report generation.
• Implemented security (Data Security, Object Security, Package Security) to the package based on user requirement.
• Created Dashboard (National Dashboard, HR Dashboard and Hawaii Dashboard, NCAL Dashboard) reports for the IT department to check the performance of the IT employees.
• Extensively used features likes Conditional blocks, Bookmarks, Conditional formatting, HTML, Prompts, and Drill throughs.
• Used Java scripts in HTML item to create run and reset buttons.
• Created summary tables to increase the performance of the Dashboard reports.
• Worked independently for writing test cases, test scripts, executing them, and preparing the consolidated test results.

Environment: Cognos8.4Suite, Oracle10g,Teradata Sql Assistant12.0,DB2, SqlServer2005,T-SQL, Analysis Services (SSAS), SQL Server Integration Services, Toad.

Confidential, Eagan, MN

Cognos Developer

Responsibilities:

• Involved in migration of catalogs, reports from Cognos Series 7/CRN to Cognos 8.2 using Migration Utilities.
• Designed models using Framework Manager and deployed packages to the Report Net Servers
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database.

Environment: Cognos 8.2 Suite, Cognos Report net 1.1, Cognos Transformer, Power play Window/Web, Impromptu 7.3,Mig Utilities, Oracle 10g,SQL Server 2000, Unix Shell Scripting.