RANJEETHA SRINIVAS

Senior BI Developer

423-***-****

Profile:

8+ Years of IT industry experience

7+ Years of Data warehousing experience

* ***** ** ********** ** Informatica Power Center

* ***rs of experience in Cognos

Summary:

8+ Years of experience in SDLC (design, development, testing and implementation) of Informatica power Center and Cognos Business Intelligence applications.

3 Years of expertise in using methodologies for data extraction, transformations and load processing in corporate-wide ETL solutions using Informatica Power Center 9.x on Windows platform.

5 years of expertise in Analysis, Design, Development and Implementation of Cognos 10.1/8.4/8.3 BI Suite (Report Studio, Query Studio, Framework Manager, Cognos Configuration, Cognos Connection, Analysis Studio, and Metric Studio), Report Net, Cognos EP 7 Series, (Impromptu, Power Play Transformer, Impromptu Web Reports (IWR), Upfront) and Power Play Enterprise Server and Power Play Tools, Solution focused, Custom-driven BI professional.

Good work experience in Informatica Data Integration Tools – Such as Repository Manager, Designer, Workflow Manager, Workflow Monitor and Scheduled workflows using Workflow Manager.

Working knowledge and understanding of Dimensional Data Modeling using Star Schema, Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling using ERWIN.

Experience in Implementation of slowly changing dimensions methodology to keep track of historical data. Experience in implementing complex business rules by creating optimized and efficient mappings with appropriate transformations.

Well versed with the complete BI Life Cycle Development Process.

Expertise in using Cognos 10.1 BI Suite (All Studios), Report Net Suite (Cognos Connection, Query Studio, Report Studio and Framework Manager), Cognos Enterprise Series 7 Suite (Impromptu, Impromptu Web Reports (IWR), Power Play Transformer, Power Play for Windows, Cognos Query, Cognos Visualizer, Upfront and Cognos SDK, Hands on experience in administering, deploying, and maintaining Models, Reports, and Cubes.

Knowledge on Cognos 11.1 version.

Experienced in SSMS tools such as SQL Profiler, SQL Query Analyzer for Query Optimization

Got good knowledge in creating and maintenance of catalogs which involves in defining joins, governor settings and client server balancing.

Good experience in using Framework Manager IQDs to create Power Play Models in Power Play Transformer.

Knowledge of software development kit (SDK) and created applications published packaged in Framework.

Excellent skills in Oracle SQL, PL/SQL, MS-SQL, DB2.

Got good Knowledge on SSIS, SSRS, and SSAS in SQL Server.

Expertise in handling Informatica tools Power Center 9.6/9.8.1.

Excellent team player at all levels with ability to perform independently

Self-motivated and possess excellent critical thinking ability, good interpersonal and communication skills.

Technical Expertise:

BI Tools

Cognos 8.4/10.1/10.2 BI Framework Manager, Report Studio, Query, Studio, Analysis Studio, Transformer, SQL Server Reporting Services (SSRS), Tableau 9.3/10.0

ETL Tools

Informatica Power Center 9.x/8.x, Developer Tool 10.2, DT Studio, SQL Server Integration Services (SSIS).

Database Tools

SQL Server Enterprise Manager, SQL Server Management Studio, Query Analyzer, SQL Profiler, BCP

Languages

C, C++, Java, VB Script, SQL, PL /SQL.

Web Technologies

SQL Server 2008/2012/2014/2016/2017, MS Access, Oracle 10g/ 9i. DB2

Operating Systems

Windows 7, Windows XP/2000/NT/98/95, UNIX 7.8.

Professional Experience:

HMS, TX June’ 19 – May’ 20

IDQ Developer/Analyst

HMS advances the healthcare system by helping healthcare organizations reduce costs and improve health outcomes. The company’s coordination of benefits services includes providing validated insurance and helping find liable third parties. HMS program integrity services identify improper payments and over-payments and attempt recovery, as well as reduce fraud and waste.

Responsibilities:

Experience in using Developer tool version 10.2 hotfix.

Interacted actively with QA manager to get the business requirements.

Experienced in using IDQ tool for applying rules and develop mappings to move data from source to target systems.

Experience in developing Transformations, Mapplets and Mappings using Developer tool to implement business logic.

Used various Data quality transformations such as aggregator, expression, joiner, lookup, router, sorter etc.

Strong Data analysis to ensure accuracy and integrity of data in the context of Business functionality.

Developed mappings to process multiple flat files from source to targets.

Extensively worked on performance tuning of IDQ mappings.

Involved in developing DT code for the given business requirement.

Developed Parser code in DT Studio for field validation and file validation.

Knowledge on using various objects Parser, Mapper and Serializer in DT Studio.

Hands on experience on using query tool Sql server management system.

Experience in production support of existing and new mapping code issues .

Deployed the new mappings or any existing code changes to production environment on weekly basis.

Environment: Developer tool 10.2 Hotfix, SQL Server 2017, Sql Server Management tool, DT Studio, Unix 7.8, Windows 7.

Santander Consumer USA, TX Feb’18 – Mar'19

Informatica ETL Developer

Risk Data is essential for Santander and its Subsidiaries to achieve their business objectives. To ensure effective data management, data must be subject to defined governance and controls, and clear rules to ensure that it is accurate, timely, consistent and capable of aggregation.

Responsibilities:

Involve in gathering the business requirements for Risk projects and molding them in to the technical specifications.

Involved in sourcing work performed by the IT Data Architects to map the data sources as per the requirements provided by Business.

Prepare detail level Technical design document with end to end data flow architecture.

Create Control-M jobs to create the files and drop to the auto batch server for the application to pick up on a daily basis.

Post-development data quality assessment results match as per the requirements.

Develop Informatica Mappings/Sessions/Workflows to load data from Source systems to Staging DB to DWH.

Create Parameter files to define Mapping, Session Parameters, column values etc.

Extract data from different file formats applied business logic to load them in the EDW.

Coordinate with Source system owners, day-to-day ETL progress monitoring, Data Warehouse target schema and maintenance.

Improve performance by identifying the bottlenecks in Source, Target, Mapping and Session levels.

Provide overall direction and guidance to ETL development and support for Production team

Create SQL scripts in SSMS for enhancing the performance, performing data validation to make sure all the modules are integrated properly.

Precise Documentation was done for all mappings and workflows.

On-Call rotation support.

Environment: Informatica 9.6.1, MS SQL Server 2016 / 2014, MS SSMS 12.0, BMC Control-M Workload Automation V8.0, Version Control Tortoise Git 2.5.0.0, MS Office 2013, Windows 7.

Blue Cross Blue Shield, Richardson, TX Jul’16 – Nov'17

Informatica ETL Developer

The Blue Cross Blue Shield Association (BCBSA) is a federation of 37 separate health insurance organizations and companies in the United States. The data integration is related to HPS Health and Dental, Individual Under 65 On and Off Exchange - PCP/ IPA assignment and maintenance, Plans to Network Mapping (PNM) changes, WPS Code changes, 834 Enrollment changes, Prime Enhancements and GHI Enhancements.

Responsibilities:

Designed detailed Staging Data Base model and Load Strategy from Source to Target.

Designed Mapping Specifications based on the Transformation rules to load data from source to Staging.

Designed and developed Informatica Mappings/Sessions/Workflows to load data from Source systems to Staging DB.

Used Parameter files to pass queries, define Mapping, Session Parameters, column values that frequently change etc.

Developed detailed Test cases for all the Informatica mappings.

Conducted code Reviews to maintain the Coding Standards.

Prepared Low Level and High-Level Design Documents.

Worked with Business and Development teams to fix issues in a timely manner.

Worked on Shift Basis and 24/7 rotation basis for support and trouble shoot Issues and Tickets.

Enhanced session and Workflow performance by applying performance tuning on targets, sources, mappings and Sessions.

Worked on front end Cognos tool to develop reports using report studio

Environment: Informatica 9.5, Cognos 10.2 (Framework Manager, Report Studio), Sql Server 2012, Excel 2010, Windows7, SQL Developer.

Dollar General, Nashville, TN Apr’15 – May’16

Sr. Report Developer

Dollar General Corporation is a United States chain of variety stores. Dollar General often serves communities that are too small for Walmart stores. It competes in the dollar store format with national chains Family Dollar and Dollar Tree, regional chains such as Fred's in the southeast, and numerous independently owned stores.

Responsibilities:

Working as a Sr. Cognos Report Developer on version10.2.

Developed various reports on Cost Centre, Batch Accounts, Inbound, Outbound and International.

Working on Lists, complex crosstabs, Drill Through reports.

Created Relational and Dimensional Models in 3 layers of FM and deployed packages on Cognos Connection.

Experience in writing customs SQL’s in FM and publish the packages.

Expertise in implementing Object level and Data level security in Framework Manager Models.

Also involved in developing Dashboard by using drill through’s, filter’s, java script.

Used JavaScript in Cognos reports to make the default prompts available according to the BRD.

Supporting reporting team on all technical aspects for go-live activities, using agile methodology.

Introducing Tableau to develop new reports on User’s demand.

Developed reports, dashboards using Tableau for quick reviews to be presented to business and IT users.

Developed Ad-hoc reports using Tableau Desktop.

Scheduled the reports to the user email ids weekly/monthly according to the requirement.

Migrating the reports from DEV to UAT and to PROD after the reports are reviewed by the users.

Actively involved in troubleshooting the Cognos report errors.

Responsible to maintain the Cognos services – start and stop sevices for restarting.

Environment: Cognos 10.2 (Framework Manager, Report Studio, Query Studio), SQL Server 2008, Tableau, Oracle, Windows7.

Blue Cross Blue Shield, Richardson, TX Jul’14 – March’15

Sr. Cognos Developer

The Blue Cross Blue Shield Association (BCBSA) is a federation of 37 separate health insurance organizations and companies in the United States. The data integration is related to HPS Health and Dental, Individual Under 65 On and Off Exchange - PCP/ IPA assignment and maintenance, Plans to Network Mapping(PNM) changes, WPS Code changes, 834 Enrollment changes, Prime Enhancements and GHI Enhancements.

Responsibilities:

Working as a Cognos Dashboard Developer on version 10.1 and 10.2.

Developed various Renewals reports, Commissions reports, small group renewals ACA reports for IL, TX, OK and NM corps

Migrated all the reports from Cognos version 10.1 to Cognos version 10.2

Used SQL Server Management tool to write the queries and cross check the Cognos report result with the sql result.

Also involved in developing Dashboards.

Worked on O65 project individually and delivered all the reports.

Supported reporting team on all technical aspects for go-live activities, using Scrum agile methodology.

Troubleshooting the existing report issues/reports which fails in prod.

Coordinate with Software Testers and Release Management to integrate the final work product into the production environment and provide off hours support as required.

Took traning sessions on Tableau from client side to introduce Tableau Ad-hoc reports.

Scheduled the reports to the user email id’s weekly/monthly according to the requirement.

Actively involved in identifying the cognos report bugs and identifying the report scope for users in Cognos.

Environment: Cognos 10.1 and 10.2 (Framework Manager, Report Studio, Query Studio), SQL Server Management Studio, Sql Server 2008, Windows7, Tableau.

NRG Energy Inc., Houston, TX Oct’13 – Jul’14

Cognos Report Developer

NRG Energy, Inc. (NRG) is an integrated wholesale power generation and retail electricity company in the United States. NRG is engaged in the supply of energy, services, and sustainable products to retail customers in competitive markets through multiple channels and brands like Reliant Energy, Green Mountain Energy, and Energy Plus

Responsibilities:

Worked as a Cognos Developer on version 10.1

Developed Lists, crosstabs, prompts, render variables using Report Studio.

Worked on Analysis Studio to build reports as well.

Worked on Framework Manager Models and published the Packages through Cognos Connection.

Working on AWS (Amazon Web Services) using Java Script where Cognos has to interact with the web services and get the data dynamically.

Involved in developing the Cube in Transformer.

Worked on couple of simple Active Reports.

Developed various dimensions, measures and calculation in Cognos Transformer

Taking backup of the cube weekly/monthly and running the cube as scheduled.

Taking backup of Models as well.

Worked on administration side like startandstop the Cognos services, rebooting the Cognos server, granting access if the user doesn’t have the Cognos access.

Use to deploy the reports weekly and maintained the status.

Worked on moving the reports from UAT to PROD and schedule the jobs accordingly.

Environment: Cognos 10.1 (Framework Manager, Transformer, Report Studio, Analysis Studio), SQL Developer, Sql Server 2008, Windows XP.

Citizens Property Insurance, Jacksonville, FL Jul’12 – Sept’13

Senior Cognos Developer/Analyst

Citizens Property Insurance Corporation is the largest insurer in the state. It provides Insurance protection to Florida property owners throughout the state. The Corporation insures hundreds of thousands of homes, businesses and condominiums. It has got Inspection Firms thru which the business units like Personal Lines and Commercial Lines are being inspected. Citizens also has business systems like ePAS, CAIS, Wind, Point, CTS etc which processes insurance policies, vendor firms and hosts claims information.

Responsibilities:

Working as a Cognos Developer as well as a Business Analyst.

Involved in gathering the requirements and developing the reports.

Developed Personal/Commercial Lines reports using Lists, Crosstabs, Charts and Prompts.

Scheduling the reports according to the user requests.

Created Models through data source and published the packages through Framework Manager to Cognos Connection.

Expertise in Object level and Data level security.

Created Dashboards on Agents, Underwriting and Claims request reports.

Created prompts, calculations, conditions, filters and other metadata objects using Report Studio.

Developed prompt pages and cascaded input prompts to filter reports on user specified criteria

Imported the excel sheet data saved on Data Repository through External Data and developed reports.

Troubleshooting and improving the performance of the existing/new reports.

Used AQT/SSMS to cross check the report data.

Develop Report Design Documents after the report development.

Develop Test Plans and Production Checklists before the deployment.

Following up the tickets and reviewing the statuses of the reports.

Environment: Cognos 10.1 (Framework Manager, Report Studio, Cognos Connection, Query Studio), Advanced Query Tool, Sql Server Management s/w, Sql Server 2008, Windows 7.

IBM/SETERUS, Raleigh, NC Jan’12 – Jun’12

Cognos Developer

Seterus, Inc. is one of the nation's leading specialty loan servicing companies. IBM-Seterus is taking industry leading steps in the mortgage industry to apply its broad and deep history of technology and business management to provide innovative solutions. In this CPS project we use Cognos to analyze and generate dynamic reports where we get the past and the forecasted data.

Responsibilities:

Involved in Installing and configuring the tool and its components on Windows7.

Used ETL (Informatica) to load the SQL Server data from flat files, client to DB2 Database.

Involved in gathering the requirements and developing the reports.

Developed the Model through Data Source in Framework Manager.

Involved in developing BEFOVA TOOL by using Report Studio which Forecasts the data.

Developed Reports using Lists, Crosstabs, Charts and Prompts.

Created Custom Reports using JavaScript to interact with java web services.

Created a Dashboard to view multiple views of the forecasted reports.

Used Data Studio to ensure the correct data for reports.

Involved in migrating the model and the reports.

Developed and Documented the BEFOVA Reports.

Used Cognos API as the main component for Cognos SDK.

Used IBM Cognos software development kit API in web pages using JSP’s.

Scheduled the reports in Cognos Connection on daily basis.

Taking back up of the reports from the content manager.

Testing the reports and troubleshooting the issues.

Environment: Cognos 10.1 (Framework Manager, Report Studio, Cognos Connection, Cognos Configuration), Cognos SDK, Informatica, Data Studio 3.1 version, DB2, Windows 7.

JP Morgan Chase, Irving, TX Apr’11 – Nov’ 11

Cognos Developer

Chase enjoys leading market positions in some of the highest growth markets in the United States and the primary goal of this project is to generate reports and develop light weight ETL jobs for VP and Managers of Chase Default home lending. Through its banking subsidiaries, the company provides deposit, credit, trust, and investment services to a broad range of retail, business, and institutional clients.

Responsibilities:

Involved in gathering client’s requirements and performing requirement analysis.

Used ETL (Informatica) to load data from source to ODS.

Customized data by adding Filters Prompts, Calculations, Conditions and Functions.

Performed data analysis between multiple data bases/schemas and verified data accuracy incorporating TOAD/SQL Developer to ensure correctness of data on reports.

Created public folders, private folders, personalized pages and custom views on Cognos Connection Portal.

Developed Framework Manager Models to import the data from multiple data sources, specified the overall relational data architecture (metadata) and generated packages of various subject areas to be published.

Migrated the reports from Cognos 8.4 to Cognos 10 version.

Involved in UNO documentation and development.

Worked on Owned Default Reports like creating Foreclosure reports, Bankruptcy reports, Loss Mitigation reports etc.

Tested and validated over 200 reports and did performance tuning of the complex reports for better performance

Used Report Studio to develop various types of reports like list reports of customer and account information, cross-tab summary reports, charts/graphs to track the performance over various periods of time, and master-detail, drill-through reports.

Created Dash Boards for multiple views of Reports in same Report page.

Developed metadata model, created and published packages incorporating Framework Manager.

Created IQD files in Framework Manager to be used in Power Play Transformer for creating multidimensional cubes.

Documented all requirements document, technical document, Unit test process document and preserved them in Share Point drive for use by others and for future references.

Scheduled periodic refreshes of reports using Schedule Management in Cognos Connection.

Supported Production issues like attending tickets created by end users on report issues such as data not found, report link broke, cannot log into Cognos portal, data mismatch etc.

Did Troubleshooting on administrative issues, reporting issues and resolving user’s problems.

Environment: Cognos 8.4 (Framework Manager, Report\Query Studio, Cognos Connection, Cognos Configuration), Oracle 9.6.1, SQL Server 2005, Windows Xp.

Contact this candidate