OBJECTIVE:

To obtain a responsible and challenging position to utilize my experience and add values to the organization.

SUMMARY:

• Over 10 years of IT experience on Data Warehouse technologies using MSBI Tools(SSIS,SSRS),Cognos 8.1,8.4,10.2.2, Hadoop CDH 5.3.2, IBM Tableau V2.1.2 and Informatica 7.1.1
• 2 Years out of 10 year of IT experience in Microsoft Power BI(Power Pivot, Power Map), Microsoft Business Intelligence (MSBI) tools (SSIS and SSRS 2012) on SharePoint 2013,5.5 years out of 10 year IT experience in Cognos 8.1,8.4 and Cognos 10.2 and which includes Analysis, Development, Maintenance, Testing and Support and rest 2.5 years as ETL developer using Informatica 7.1.1
• Business Analyst creates user story for new cognos report development, enhancement/modification.
• Agile Team does planning session and includes user story in a sprint.
• User story gets assigned to me followed by BA/developer knowledge transfer.
• Developer enters a SM9 Change Request which is Tool that tracks change requests
• Pre - Approved versus Standard
• Pre-Approved
• Adding or modifying a Calculation or Field to an existing Cognos Report(s) with no Cognos Framework Manager or Cognos Data Manager job stream modifications
• Creating Hive Tables, loading with data and writing hive queries which will Run internally in map reduce jobs.
• Installed Oozie workflow engine to run multiple Hive and Pig jobs
• Moving Newly Created Cognos Report(s) with no Cognos Framework Manager or Cognos Data Manager job stream creation
• Modifying Filters on already existing Cognos Report(s)
• Creating new Filters for an already existing Cognos report(s)
• Standard
• Framework Manager Development (new/modification) using Framework Manager.
• Dynamic Cube development(new/modification) using Cognos Dynamic Cubes
• Reports/Dashboards development using Report Studio, Workspace Advanced
• Development of Teradata tables using as per reporting requirements
• ETL Team uploads data from various data sources to Teradata Data ware House.
• Developer fills out a TD template and uploads completed TD to SharePoint
• Version control enabled
• Developer Submits TD for approval then reviewer has 2 business days
• Developer updates TD, if necessary and developer re-submits TD if necessary
• Coding will not begin until TD is approved
• All development is done in DEV environment then unit testing is done in DEV environment
• Developer uses Cognos Code Review Template to create a code review document
• Reviewer updates document or requests a one-on-one with developer
• Developer updates document if necessary and re-submits document if necessary
• UAT will not begin until code is approved
• Developer/Tester knowledge transfer
• UAT Tester creates test plan and requests test plan review
• UAT Tester creates test cases in QC then tests report(s) in DEV environment
• Developer supports tester as needed and makes changes based on testing
• After UAT Testing complete
• Create task within SM9 Change Request Ticket assigned to the Data Management (DM) team
• Attach documentation to Task
• Attain approvals for migration (if a standard change)
• If multiple reports are involved, Developer is responsible for creating an export of the content within DEV Cognos Administration for the DM team to use as an import in the PROD environment.
• Following migration of objects, DM team notifies developer to verify objects were migrated and are operating properly.
• BA conducts final validation of successful migration to PROD environment.
• Experience in migration of Cognos 8.4 reports to Cognos 10.1 platforms.
• Experience in building HIVE Data warehouse using Spark 1.3 SQL context on top of HDFS.
• Good understanding of the project life cycle process and ability to work in a team.
• Extensive experience in collaborating with Business analyst/Business users/clients to understand the requirements and create high level and low level design documents and provide solutions for the requirements. Performed lead role in design, development and execution of project release lifecycle.
• Adept in handling customers, technically driving projects, leading teams and maintaining strict quality focus.
• Well versed with Agile Scrum and SDLC methodologies
• Familiarity with Trade Finance E.g. -Import LOC, Export LOC, Direct Collections, Electronic Funds Transfer using SWIFT, SEPA, FED and CHIPS messages, CHAPS/RTGS Clearing systems, Retail banking, Retail and Logistics domain.

TECHNICAL SKILLS:

BI Tools: Cognos 8.1/8.4/10.1/10.2.2 (Framework Manager, Report Studio, Analysis Studio), Knowledge on Cognos Transformers, Cognos 10.2.1 Workspace and Workspace Advanced, Cognos 10.2.1 Dynamic Cubes, Microsoft Business Intelligence (MSBI) tools (SSIS,SSAS and SSRS) 2012,Power BI

ETL Tool: Informatica 7.1.1

Platforms: Windows 2000/XP/NT/2003/Windows 7/UNIX

Other Tools: Hadoop CDH 5.3.2, MapReduce HDFS, Hive,Spark 1.3, SQL, Pig, Sqoop, Oozie, ZooKeeper, MySQL HBase SQL * PLUS 10.2, Toad 9.6.0, Remedy 8.1, File Zilla 3.10, SQL Developer 3.2, Global PAYplus SOA,Sharepoint 2013

Data Bases: Oracle10/11g, SQL Server 2005, Teradata 14.10,IBM Netezza 7.1

Office Tools: MS Word 2010, MS Excel 2007, MS Power Point 2010

Issue Tracker System: HP Quality Center 11, JIRA 6.3.8

PROFESSIONAL EXPERIENCE:

Confidential,Seattle,Washington

BI Developer

Responsibilities:

• Involved in implementation of data cleansing, Slowly Changing Dimension phenomenon using Informatica.
• Involved in in design and implementation of Star Schema, Snowflake Schema and Multi - Dimensional Modeling.
• Involved in designing RDBMS, ER model, Logical Model and Dimensional Model based on business requirements.
• Involved in Creating Hive Tables, loading with data and writing hive queries which will Run internally in map reduce way.
• Moved user information from MS SQL Server to HBase using Sqoop.
• Created Mapreduce jobs using Hive Queries.
• Analyzed the data by performing Hive queries and running Pig scripts to know user behavior
• Installed Oozie workflow engine to run multiple Hive and Pig jobs
• Handled importing of data from various data sources, performed transformations using Hive, MapReduce, loaded data into HDFS and extracted data from iSeries system into HDFS using Sqoop
• Worked extensively with Sqoop for importing metadata from iSeries system and migrating the ETL jobs into HDFS performing aggregations.
• Created Hbase tables to store various data formats of data coming from different portfolios
• Created Hive queries, performing data analysis and improving performance using tuning parameters.
• Involved in Designing of DMR, Complex Dynamic sorting reports.
• Meeting various Application owners and understanding their requirements
• Using Java & Java Script Code whenever it is necessary and integrated with the Cognos reports.
• Writing user defined stored procedures using dynamic cursor and deploy them in framework manager for all the complicated calculations
• Designing the Reports, Dashboards and Framework Model using Dimensional Modeling based on the client requirement.
• Monitoring Report performance, troubleshooting and system configuration
• Delivery of solutions that meet customer expectations.
• Developed IBM Netezza tables using IBM Aginity Workbench as per reporting requirements
• Creation of dashboards using Tableau desktop to get sales trends
• Creation of Cognos relational and multidimensional reports using cognos report studio to get sales measures year based on year to date, period to date, week to date time periods
• Implemented Package level and Data level security using Framework manager
• Created Placeholders query items that are used solely for organizing query data using Framework manager
• Developed Data models, project and publishing packages using framework manager.

Environment: Cognos 10.2.1, Netezza, DB2, Developer Studio, Advanced Java, Windows, AS 400,Aginity workbench for Netezza, IBM Tableau V2.1.2, Hadoop, MapReduce HDFS, Hive, SQL, Pig, Sqoop, Oozie, ZooKeeper, MySQL HBase

Confidential

Power Developer

• Understanding existing business model and customer requirements.
• Developed TD using TD template then sent to Reviewer for review and approval.
• Developed Teradata tables using Toad client as per reporting requirements.
• Developed Data models, project and publishing packages using SSAS.
• Involved in implementing Type 2 SCD in Dim Geography and Dim Category.
• Development of drill down and drill through reports for Agency and Geography modules.
• Developed Online charts of customers with high risk using power excel module of Power BI.
• Developed slicing, dicing and filters of excel data using power excel module of Power BI.
• Developed Q&A module for users using power query module of Power BI.
• Developed data models from multiple sources in excel using Power Pivot module of PowerBI.
• Deployed large sized excel workbook developed using power excel to SharePoint server.
• Developed BRD and Test Specifications as per user requirements.
• Execution of Unit and SIT Test scripts to validate the requirements.
• Reviewed TD, CR’S and suggested improvements.
• Followed Agile Methodology with Stories, Sprint and Scrum

Environment: SQL Server 2008, Teradata 14, SSAS, Microsoft Visual Studio 2010, Sharepoint 2013, Power BI for Office 365

Confidential

Senior MSB Developer

• Developed SSIS Packages to load the data into Staging and Destination Tables
• Development of ETL strategies like Derived Column, Data Conversion, Conditional Split, Union All, Multicast and lookup using SSIS, database designing using SQL Server 2012.
• Database designing using SQL Server 2012
• Developed Containers and tasks like For Loop Container, For Each Loop Container,Sequential Container, Execute SQL Task, Send Mail Task, Bulk Insert Task, FTP Task and Execute Package Task using SSIS
• Experience in generating Reports using SSRS.
• Experience in creating Tables, Stored Procedures, Functions and Indexes.
• Development of Internet sales module data using SSRS and deployment to Sharepoint portal

Environment: SSIS(Sql Server Integration Services), SSRS(SQL Server Reporting Services), SQL, PLSQL, T-SQL, SQL SERVER 2012, Sharepoint 2013 Windows 2000/XP.

Confidential

Senior Cognos Developer

• Involved in the entire project life cycle from analysis, installation, development, testing, production and end user support
• Worked closely with business users while gathering requirements
• Developed data models and published packages in Cognos connection using Framework Manager
• Developed data models by creating various joins between query subjects and also resolved various types of joins between them
• Used Framework Manager to model metadata from different data sources and published packages to Cognos Connection
• Involved in setting up security in Framework Manager and Dynamic Cubes using Cognos Cube Designer
• Involved in building Multidimensional Cubes using Dynamic cubes
• Developed Reports like list, chart, cross tab, cascading, burst, Master-Detail, Drill Through in Report Studio
• Developed Reports Dashboards, Complex Reports having many calculations, child reports, HTML items etc. in Report Studio
• Used Cascading prompts, Filters, Bookmarks to create efficient reports in Report Studio
• Experience in creating Ad-hoc reports using Cognos Query Studio so that BA's can slowly build up their report by dragging on one item at a time
• Creating and setting privileges on Users/User Groups
• Involved in Testing and improving Report Performance
• Efficient in writing SQL Queries in Oracle 11g
• Performed content/portal Administration
• Implemented package level, object level and data level security in the reports.
• Fine tuned the reports, underlying queries and tables using indexes.
• Worked on Production Support and fixing report/package/data issues.
• Worked on Data Analysis, Validate reports and find data quality issues
• Prepared Weekly Status Reports (PMO) and shared with the Managers
• Production Support which involves solving user problems and Provided End User Training and Support
• Prepared User documentation to train users and functionality of each report

Environment: Cognos 10.2.1 BI Report Studio, Query Studio, Workspace, Workspace Advanced, Framework Manager, Basic Dynamic Cubes and Oracle 11g, Toad for Oracle

Confidential

Senior Cognos Developer

• Migration of Cognos 8.4 reports version to Cognos 10 version to achieve latest cognos 10 features.
• Understanding the existing business model and updating the reports as per user requirements.
• Involved in fixing the issues in Cognos 10 migrations.
• Involved in developing and executing UTC scripts.
• Involved in formatting the reports after migration.
• Involved in developing the missed drill through links after migration.
• Created various SQL’S for test cases.
• Knowledge of Fundtech GPP-SP ISO 20022, XML messaging, SOA,High Value/ High Care Payments, Mass Payments, SEPA Payments, UK Faster Payments, PACS (Payments Clearing and Settlement), PAIN (Customer Credit Transfer Initiation), CAMT (Cash Management FI to FI Payment Cancellation Request)
• Knowledge for Global PAYplus - SPuControl rules engine which provides business professionals to move new payments services from inception to market in real time with no IT intervention
• Knowledge for static data setup for different functionality in BANK environment like Local Office Profile, Parties Profile,Account Types Profile, Accounts Profile,
• Country/Currency Profile, Calendar Profile, System Parameters,MOP Profile, Membership Profile, Value Date Determination, Mandate Profile, Fee Type, Fee Formula Profile, FX Related, Bulking Profile, Sending Times, File Summary,
• Knowledge for Major business flows in GPP Identify first in chain, Load party, Load account, MOP selection(Membership, Value date, Fees Posting),N-Messages,R-Messages

Environment: Cognos 8.4 BI Report Studio, Query Studio, Business Insight, Business Insight Advanced, Framework Manager, Cognos 10, SQL Developer,GPP-SP Version 4

Confidential

Cognos Reports Developer

• Discussions with Business users for Business and Architectural requirements.
• Understanding the business requirements and designing applications to meet their needs.
• Generated reports as per the requirements using Cognos Impromptu
• Designed, developed and maintained catalogs, Impromptu reports, templates, hot files, PDF files, snapshots, drill through.
• Used Multidimensional analysis for Data Retrieval using Powerplay structure
• Used Multidimensional analysis for Data Retrieval using Powerplay structure
• Extensively worked on prompts based on the user needs and format required
• Defined conditions, calculations and prompts in the catalog
• Different department users used the Powerplay environment that is customized for each user depending on the requirements
• Created Hierarchies from providing drill down options for the end-user
• Enabled users to access the distributed HTML reports through local network intranet/internet, and via email
• Reporter Operations such as Sum and Average, Intersection, etc., Exception Highlighting Sorting, Ranking etc.
• Extensively worked on prompts based on the user needs and format required
• Developed Ad-hoc report using Query Studio.
• Import/export the Cognos content from DEV to QA to Prod environments.
• Enabled users to access the distributed HTML reports through local network intranet/internet, and via email
• Created various reports (List, Crosstab, Mailing Labels, Form Letter, Free Style) using Cognos Report Studio.
• Scheduled the reports through Schedule Management in Cognos Connection.
• Developed jobs with multiple report scheduling to distribute report at particular time interval.
• Developed Query prompts, Calculations, Conditions and Filters in the Reports to select relevant Trade products.
• Used Drill through reports to link two or more reports.
• Designed reports with conditional formatting to highlight data in a report to better identify exceptional results
• Involved in Unit testing.

Environment: Cognos 8.3 BI Suite (Frame work Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio), Windows 2000 server, MS SQL Server 2000, MS ACCESS, Windows XP, 2000

Confidential

Informatica Power Center Developer

• Preparing design documents and sent for review and approval before actual development.
• Developed new mappings using Informatica PowerCenter 7.1.1
• Implemented Incremental Load, Slowly Changing Dimension Type 1 in Informatica.
• Resolving errors from existing mappings.
• Preparing Unit Test Cases to validate mappings as per requirements.

Environment: Informatica PowerCenter 7.1.1, Oracle 10g, Red Hat Linux