PROFESSIONAL SUMMARY

• Senior Business Intelligence Developer with 7 years of experience in Airline, Pharmaceutical Industry working with cross - functional teams in the development, documentation and delivery of process innovations driving the attainment of business goals with Experience in Business Intelligence using Power BI, SSRS, IBM Cognos, Tableau, Data Stage, NiFi and other supporting tools.
• My focal point has been providing Analytical & Business Intelligence Insights and Solutions. Dependable team player with ability to collaborate effectively and skilled at working with Multiple Users.

TECHNICAL SKILLS

Data Ingestion: Apache NiFi, Apacahe Kafka

Data Transformation: IBM Datastage, Informatica

Database: Teradata, SQL Server, Oracle, Mongo DB, Apache Hue, Apache Cassandra

Reporting: IBM Cognos, Tableau, Power BI, SSRS, ThoughtSpot, DOMO

Data Lake: Big Data, ADLS

Data Modelling: IBM Cognos Framework Manager, IBM Cognos Transformer, Alteryx

Ticketing: Cherwell, JIRA, Service Now, xMatters

Deployments: IBM Urban Code deploy, Jenkins Pipeline

Scheduler: IBM Tivoli, Unix/Linux, IBM Cognos Event studio

Other: GIT HUB, Reference Data Manager (attacama), Rally

Languages: Python

Cloud: Azure

PROFESSIONAL EXPERIENCE

Confidential, Fort Worth, TX

Senior Business Intelligence Developer

Responsibilities:

• Working with both structured and instructed data to create ad-hoc BI visualizations.
• Development of Analytical solutions by creating Dashboards, Visualizations and Reports using the Reporting/BI tools (IBM Cognos, SSRS, Tableau, Power BI, Thought Spot, Microsoft SQL Reporting Services (SSRS)
• Developed Power BI reports using DAX calculations and Queries.
• Experience in Modelling the data in Thoughtspot so the users can get answers easily with search IQ
• Created reports and in Thoughtspot and scheduled the Jobs
• Working with multiple data sources such as Oracle, SQL Server, and Teradata.
• Developed Data Ingestion flows using Apache NiFi, Apache Kafka to load data into Data Lake (Big Data).
• Development of Accessibility Scorecard and BSO Scorecard using tableau and Cognos to provide Data Insights and highlights the Key Performance Indicators (KPIs) that matter most to your business.
• Development of Multiple ETL jobs using IBM Data Stage to Transform and load both Structured and unstructured data in to Data Ware house.
• Scheduling jobs using IBM Tivoli Workload Scheduler
• Use of IBM UCD (Urban Code Deploy) for automated deployment of code in Dev, Test, Cert and prod environments.
• Creating Cherwell Incident Tickets, JIRA’s and working on xMatters for deployments and production support Items.
• Everyday use of Teradata, Oracle and SQL server to write Complex queries and get the data answers for business Users.
• Writing Complex queries and did Data analysis to identify the data mismatch and find the root cause of the gaps between App DB and the EDW data flow.
• Working with Data Modeler and DB developers to build and refine data structure from the ground up.
• Creating Reference Data Manger Solutions using atacama
• Use of GITHUB to commit the code and version controlling
• Created user stories in Rally and did prioritization with Product owners.
• Working on Production Support Issues along with the Application teams and developers.
• Development of CI/CD Pipeline and Experience in Jenkins Pipeline
• Experience in Agile Technologies and DevOps.
• Created all user stories Rally and did prioritization with Product owners.
• Worked with various teams on identifying and resolution of the data gaps in the App, DB and BI Reporting flow.
• Testing and deployment of all the changes to Prod environments.
• Working and communicating closely everyday with other teams on the requirements and Changes/enhancements to bridge the gap.

Confidential, Fort Lauderdale, FL

Business Intelligence Developer

Responsibilities:

• Involved in gathering requirements with Business Users
• Experience in working with offshore team in design, build and development of reports.
• Worked closely with Data Warehouse Team in Design, Development and Implementation of the project
• Created Reports and Dashboards using Report Studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Up and Drill Down).
• Worked on POC by extracting, transforming and modelling the data using Cognos Data Manager
• Analyzed the Database Tables and views and extracted the sql for creating Framework models and packages according to business requirement.
• Developed Cognos Reports and Dashboards.
• Tested and promoted the reports from Development to Prod.
• Designed and implemented the folder structure for cognos in DEV/PROD
• Demonstrated BI reports to show the functionality and different flavors of the tools.
• Created List reports, Charts and Cross-tab reports using Cognos Report Studio.
• Developed Dimensional modeling using Framework Manager and generated reports using Analysis Studio and Report Studio.
• Created securities for different user groups at package level for read, write and execute permissions
• Created multiple dashboards on Operations, sales Trending etc.

Confidential, Irving, TX

BI Analyst

Responsibilities:

• Interacts with the business teams to gain an understanding of the business needs and technological requirements.
• Analyze and creates detailed documentation of business systems and user needs, including workflow, program functionality, and steps required to develop or modify application integration.
• Worked on Prod issues and Bug fixes by communicating with all teams
• Designed and implemented workflows using UML modules for logistics process.
• Created ad-hoc reports to users in Tableau by connecting various data sources.
• Analyzed the database tables by writing the SQL queries.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Coordinated with the offshore team in delivering the requirement, in design and development of Reports and Cubes.
• Installed database Clients for SQL Server 2005 and Oracle, established and tested database and content store connectivity on the Cognos Production environment.
• Created Executive level Dashboards in Cognos showing various high level key performance indicators.
• Scheduling and Bursting of reports to distribute to different end users.
• Provided data security, object security and package access in Framework Manager, and also secured the folders by setting up access permission in Cognos Connection.
• Created SOP for migration of Framework Manager Packages, reports, Data Manager Packages, fact builds, dimension builds and the job streams.
• Created reports such as Job Size, Port Warehouse Inventory Management, Gross Margin Reports against the finalized Freight and non-finalized freight factors present in the cube.
• Sustained the scheduled data manager jobs to generate cubes.
• Unit tested the update reports for performance and consistency against different amounts of test data.