SUMMARY

• 13+ Years of competitive experience in Information Technology
• Experienced in Tableau, ETL Informatica Power Center, AWS DMS Migration, IDQ, SQL Developer & JIRA.
• Proficient in Tableau 2019.X/2018.x/10.x/9.x/8.x (Desktop, Server, Public, Reader).
• Experience in Informatica IDQ 10.2.X and Informatica Power center.
• Proficient in AWS DMS to ingest the data from on premise DB to AWS RDS.
• Worked for Major Clients like Confidential, Confidential, Confidential, Confidential, Confidential, Confidential and Confidential Systems.
• Have been working with various data sources such as Hortonworks Hive, SQL Server, Oracle and Flat files.
• Knowledge in Tableau Server administration activities like Installation, configuration, integration, upgrades, load balancing, user & group management, migration/promotion of content, and on - going maintenance.
• Business Requirement Gathering, Coordinating with Offshore Team and Delivery.
• Experience with Agile/scrum methodologies including creation of user stories, prioritizing meetings, release/sprint planning and conducting retrospective meetings.

TECHNICAL SKILLS

Reporting Tools: Tableau Desktop/Server v9.x/10.x, 2019, 2020

Data Warehousing ETL tools: Informatica Power Center 10.X/9.x, Power Exchange and IDQ

RDBMS: Oracle 8i/9i/10g/11g, MS SQL Server 7.0/2000/2005

Programming Languages: SQL, python, Java script and UNIX shell script

Cloud Platforms: AWS, DMS and Snowflake

Ticketing platforms: Service Now, JIRA

Other Tools: Toad, Putty, Sub Version

Data Bases: Oracle, Hortonworks Hive, DB2 Mainframe, ABABAS and Teradata

Data Modeling: Star Schema, Snowflake Schema, Erwin Tool

Domain Knowledge: Manufacturing, Banking, Energy and Tele Communications

PROFESSIONAL EXPERIENCE

Confidential- Tennessee

Informatica Technical Lead/Architect

Responsibilities:

• Development and testing ETL codes with Informatica and Oracle.
• Involved in Development activities according to the design documents, which should be in par with the client requirements.
• Creating ETL’s or mappings as per the business requirements.
• Create complex mappings, sessions, workflows for final installation and release to the client
• Reviewing the mapping and sessions and sequence of the workflows and sessions.
• Preparing SQL Queries for testing the data. It includes Data Warehouse, Pre-Stage Testing, Balancing and comparing the data.

Environment: DB2(Mainframe), ADABAS, Oracle and AWS Postgre SQL, Informatica Power Center, Power Exchange and Cleo

Confidential

Data Ingestion Lead/Developer

Contribution

• Data migrated from Oracle to Aurora using AWS DMS
• We have migrated 6 Oracle DB and 50 Tables using DMS
• SNS Notification’s, SNS topics and DMS event subscriptions enabled
• Enabled cloud watch logs and archived logs in S3 bucket.
• Enabled supplementary logs with help of DBA team’s
• Having knowledge on DMS endpoints

Environment: DB2 and Oracle, Tools: DMS (AWS Tool),Windows XP

Confidential

Business Analyst/Tableau Developer /Administrator

Responsibilities:

• Redesigned Business objects reports into Tableau (4 Dashboards).
• Enabled User filters for Dealer level security reports.
• Managing a team and involving in providing knowledge transfers for new resources to understand the end-to-end environment and the process to adhere.
• Lead and interacting with Business Analyst to understand the business requirements. Involved in analyzing requirements to refine transformations.
• Created action filters, scorecards using stack bars, bar graphs, scattered plots, geographical maps, grant charts using show me functionality, parameters and calculated sets for preparing dashboards and workbooks/sheets in Tableau.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Development and testing data Quality Rules and profiles with Informatica DQ and Analyst.
• Creating Data Quality Rules or mapplets as per the business requirements.
• Create complex Rules, profiles, scorecards for final installation and release to the client
• Reviewing the Scorecards and profiles.
• Designed, Developed and Implemented Tableau Business Intelligence reports
• Work closely with DBAs, application and ETL developers, change control management for migrating developed mappings to QA and PROD.

Environment: BDE (Hive), Tools: Tableau, Informatica IDQ, Informatica Cloud, python and JIRA O/s: Windows XP

Confidential

Tableau/Informatica DQ/Analyst Developer/Tech Lead

Responsibilities:

• Closely worked with the client and end user for any clarification between the Team and the client.
• Development and testing data Quality Rules and profiles with Informatica DQ and Analyst.
• Involved in Development activities according to the design documents which should be in par with the client requirements.
• Creating Data Quality Rules or mapplets as per the business requirements.
• Create complex Rules, profiles, scorecards for final installation and release to the client
• Reviewing the Scorecards and profiles.
• Preparing SQL Queries for testing the data. It includes Data Warehouse, Pre-Stage Testing, Balancing and comparing the data.
• Designed, Developed and Implemented Tableau Business Intelligence reports
• Responsible for dashboard design, look and feel and development
• Combined data sources by joining multiple tables and used data blending
• Created Customized and Interactive dashboards using multiple data sources
• Involved in production deployment planning and implementation.
• Hands on Experience Informatica Admin activates.

Environment: Oracle, BDE, Informatica IDQ, DVO, Informatica Analyst, Tableau, Unix, Oracle and JIRA O/s: Windows XP

Confidential

Informatica Developer/Tech Lead

Responsibilities:

• Development and testing ETL codes with Informatica and Oracle.
• Creating ETL’s or mappings as per the business requirements.
• Create complex mappings, sessions, workflows for final installation and release to the client
• Reviewing the mapping and sessions and sequence of the workflows and sessions.
• Preparing SQL Queries for testing the data. It includes Data Warehouse, Pre-Stage Testing, Balancing and comparing the data.
• Involved in production deployment planning and implementation.
• Hands on Experience Informatica Admin activates.

Environment: Oracle, Tools: Informatica 10.1, Unix, Oracle and JIRA, Windows XP

Confidential

Informatica Support

Responsibilities:

• Development and testing ETL codes with Informatica and Teradata.
• Creating ETL’s or mappings and reports as per the business requirements.
• Create complex mappings, sessions, workflows for final installation and release to the client
• Reviewing the mapping and sessions and sequence of the workflows and sessions.
• Ensure Design is following as per Confidential 's SDLC.
• Preparing SQL Queries for testing the data. It includes Data Warehouse, Pre-Stage Testing, Balancing and comparing the data.
• Involved in production deployment planning and implementation.

Environment: Oracle Tools: Informatica 10.1, Oracle and Spotifre, Windows XP

Confidential, St. Louis

BI Developer

Responsibilities:

• Interface with business customers and management for scope, estimates, requirements and project deliverables.
• Worked on Dual Axis concept while working with reports.
• Created Filters, Groups, Sets on Tableau Reports.
• Publishing sheets and dashboards on server Using Tableau Desktop.
• Created conditional filters and Action links to filter the data on dashboard.
• Created Bar Charts, Columns Charts, water fall charts, Funnel Charts, Heat Maps, And Geographical Maps.
• Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Responsibilities Direct interaction with Customers, Requirements Analysis, Effort Estimation, Handling Technical issues, Performance Optimizations, Reviewing Presentation of dashboard reports.
• Developing all materials related to UAT plan, test cases, and data in conjunction with input from users.
• Developed functionality for printing the reports as per the user’s choice.
• Creating Build List for objects developed to move QA & PROD.
• Scheduling and Library the Reports using Report Caster.
• Fixed the defects raised in Quality Center.
• Taken code sub-version.
• Updating Report inventory for each report before code deploying to the production.

Environment: Oracle, Database: Netezza, Essbase, Oracle, WebFOCUS 8.1.04, 7.7.05, 7.7.03, Tableau 9.3. Windows 2003

Confidential

BI Technical Lead

Responsibilities:

• Interface with business customers and management for scope, estimates, requirements and project deliverables.
• Involved in Development activities according to the design documents which should be in par with the client requirements.
• Creating ETL’s or mappings and reports as per the business requirements.
• Create complex mappings, sessions, workflows for final installation and release to the client
• Responsibilities Direct interaction with Customers, Requirements Analysis, Effort Estimation, Handling Technical issues, Performance Optimizations, Reviewing Presentation of dashboard reports.
• Developing all materials related to UAT plan, test cases, and data in conjunction with input from users
• Create Dashboard Applications, launch pages, and report in the WebFOCUS Managed Reporting Environment.
• Developed functionality for printing the reports as per the user’s choice.
• Creating Build List for objects developed to move QA & PROD.
• Scheduling and bursting the Reports using Report Caster.
• Involving ETL to data the data from various data bases like SAP, QAD into Data warehousing.

Confidential, Dearborn

BI Developer

Responsibilities:

• Create Dashboard Applications, launch pages, and report in the WebFOCUS Managed Reporting Environment.
• Interface with business customers and management for scope, estimates, requirements and project deliverables.
• Developing all materials related to UAT plan, test cases, and data in conjunction with input from users.
• Ensuring that all data is available for testing.
• Creating Manifest for objects developed.

Environment: Oracle 9i, Database: Teradata, Oracle, WebFOCUS 7.7.03, Information Builders (Data migration) 7.7.02, Windows XP

Confidential

BI Developer

Responsibilities:

• Analysis of B.O Reports, Universe and Developing the Master File and Reports in WebFOCUS.
• Developed functionality for printing the reports as per the user’s choice.
• Designed and developed functionality of exporting the reports to different formats like HTML, DHTML, PDF, Excel.
• Involved in designing TSD (Procedure Documents), Unit-Test cases, Checklist, Code Review.

Environment: Oracle 9i, Database: Teradata, WebFOCUS 7.6.9, Business Object 6.5.4, O/s: Windows XP

Confidential, Detroit, Michigan

BI Developer

Responsibilities:

• Creating Reports Using HTML layout Painter.
• Created OLAP Reports such as Drilldown/Drill up Reports.
• Created launch pages and modified the reports as per the user requirements.
• Created Graphs and customization of graphs as per the user requirement.
• Scheduling and bursting the Reports using Report Caster
• All the Reports were developed using Focus language.
• Designing the architecture in Visio.
• Creating Data flows, Process flows.
• Creating Test Cases, Requirement Traceability Matrix(RTM) and Design Documents in DM.
• Developing all materials related to UAT plan, test cases, and data in conjunction with input from users.
• Ensuring that all data is available for testing.
• Creating Build List for the objects developed.

Environment: Oracle 9i, Database: Oracle, WebFOCUS 7.6.4, Information Builders (Data migration) 7.6.4, Windows XP

Confidential, New York

BI Developer

Responsibilities:

• All Reports we are developed using Focus Language.
• Developed the reports as per the user requirements.
• Created launch pages and modified the reports as per the user requirements.
• Created Graphs and customization of graphs as per the user requirement.
• Created Conditional Formatting by using Developer studio.
• Created Active Reports and OLAP Reports.
• Organized data in reports by using across, sorting, ranking as per the user requirements.
• Scheduled reports using report Caster.

Environment: Oracle 9i, Database: Teradata, WebFOCUS 7.1.4, MRE 7.1.4, O/s: Windows XP