SUMMARY

• 8+ years of overall experience in Business Intelligence and Data Warehousing
• Responsible for spearheading two projects under BI vertical, devising Go - To-Market strategy and delivering end to end analytics and BI projects
• Built analytical solutions accelerators to solve business problems related to front end analytics
• Designed and implemented teh logic to forecast teh call drops and teh inability to provide a sustained handholding of mobile towers for a telecommunication service provider
• Good working noledge of INFORMATICA, SSIS,ORACLE, TABLEAU, COGNOS ANALYTICS and TIBCO SPOTFIRE
• LOBs worked across-Investment Banking, Supply Chain, Healthcare, Retail, Market and Research, Telecom Domain
• Highly proficient in Agile, Test Driven, Iterative Scrum and waterfall software development cycle
• Excellent hands on experience in Data Analytics
• Worked on teh data warehouse design and analyzed various approaches for maintaining different dimensions and facts in teh process of building a data warehousing application
• Served as data steward to validate high profile or external data to ensure accurate reporting
• Prepared highly interactive Dashboards for 2010 Symposium, Pulse 2014 held at Las Vegas, United States
• Active member of globally recognized BI Forums
• Full Life-cycle Business Intelligence (BI) and Data Warehousing project experience, starting wif requirements analysis, proof-of-concepts, design, development, testing and implementation.
• A Decisive Team Player wif teh ability to meet deadlines, handle multiple tasks and being flexible in work schedules
• Excellent Team Leader. Efficient at leading initiatives and establishing strong Client Relations
• Excellent debugging skills and good problem solving ability

TECHNICAL SKILLS

Business Intelligence Tools: TABLEAU DESKTOP 8.x/10.x, TABLEAU PUBLIC 8.x/10.x, TABLEAU READER 8.x/10.x, TABLEAU SERVER 8.x/10.x

TIBCO SPOTFIRE -7.7.1: COGNOS ANALYTICS 8.x, 10.x,11.x (Cognos Administration, Report Studio, Query Studio, Analysis Studio, Cognos Connection, Event Studio, Business Insight, Active Reports, Framework Manager (Relational and DMR), Access Manager, Workspace, Workspace Advanced and Transformer)

Data Modeling: Normalized, De-normalized, Star and Snow Flake Schemas

Reporting Tools: Report Studio, Query Studio, Analysis studio, Active Reports, Business Insight, Workspace Advanced

Databases: My SQL,SQL Server, Oracle

ETL Tools: SQL Server Intelligence Services (SSIS) 2008, 2009INFORMATICA 9.1 (Designer, Workflow Manager, Workflow Monitor, Repository Manager)

Programming Languages: PL /SQL, JavaScript, SQL, Scripting on Unix

Configuration Management Tools: Rational Clear Case 7.1.2.1 and Clear Quest 7.1.2

Quality Assurance Tools: Web Technologies

Others: Bugzilla,, JIRA,HP QCHTML, XML,CSSISM, Service Now

PROFESSIONAL EXPERIENCE

Senior Lead Tableau Developer/Technical Business Analyst

Confidential

Roles and Responsibilities:

• Led multiple requirement gathering and impact analysis session wif business sponsor teams to create functional specification document and design solutions to enhance business decision making
• Performed teh required data wrangling before connecting to teh data source from teh Tableau client
• Performed data/systems analysis to determine best BI solution (reports, dashboards, scorecards, data cubes) using Tableau
• Did performance tuning of teh reports as a result of which teh execution time got reduced from 1.5 hours to 20 minutes
• Developed individual datasets and tested them for formatting and data correctness, and published teh workbooks on teh Tableau server for scheduled refreshes- These reports helped customer analyze teh impact of evolving market conditions and gain insights into underlying performance drivers across Region, Countries, Legal entities and departments
• Created Schedules and extracted teh data into Tableau Data Engine
• Combined Tableau visualizations into Interactive Dashboards using filter actions, parameters, highlight actions and published them to teh web. These dashboards helped customer align their budget plans and perform budget forecasting
• Created complex formulas and calculations wifin Tableau to meet teh needs of complex business logic
• Worked extensively wif Advance analysis Actions, Calculations, Parameters, grouping sets, Background images, Maps, Blending features in Tableau
• Defined best practices for Tableau report development
• Provided technical assistance to other developers

Environment: Cognos 8.4, Tibco Spotfire 7.7.1, SQL Server 2009 Jul 2015-Oct 2016

Lead BI Developer/Data Analyst

Confidential

Roles and Responsibilities:

• Developed multiple business critical reports using Confidential Cognos reporting. These reports helped teh customer quantify their margins based on product category, price, promotion etc.
• Created audit reports using complex sql queries for a large home improvement customer. These reports helped teh customer streamline their logistics cost using informed forecasting
• Coordinated wif Offshore team to accomplish on time deliverables to teh customer and provided onsite UAT support. Teh helped in saving 500k per year for teh customer.
• Loaded data from multiple upstream customer data sources using standard ETL tools and sql queries into DSS data warehouse. This helped teh customer have a single and consistent view of their transactional data and saved 40 man hours per week for teh customer

Environment: Cognos 10.2.1, SQL SERVER 2005

Module Lead

Confidential

Roles and Responsibilities:

• POC for BI requirements in Persistent
• Analyzed teh data and loaded teh data sets in teh database tables for teh Cognos Reports
• Created reports in report studio by using complex Stored Procedures. This helped in having teh underlying data encapsulated into chunks dat are identifiable and accessible all wifin one location and prevented from having incurred an added cost of a DBA
• Scheduled meetings and presented demos to teh Sales Team
• Performed Data Validation and Unit testing of teh reports developed
• Provided walkthrough of approach document to business for sign off
• Worked closely wif teh delivery manager to recruit and train new team members bringing them up to speed on existing system architecture. Swift noledge transition helped reduce teh learning curve for new team members resulting in minimum business impact and maximum client satisfaction

Environment: SSIS 2008, Tableau 8.1 Desktop, Tableau 8.1 Server, Tableau 8.1 Public, Tableau 8.1 Reader

Senior Tableau Developer/Technical Business Analyst/Data Analyst

Confidential

Roles and Responsibilities:

• Created approach papers from business requirement documents and other business artifacts to be used by downstream development, testing and creative teams. Translated functional requirements into technical solution design
• Worked extensively on complete data mapping of all source systems as part of data analysis
• Extensively used SSIS transformations such as Script component, Pivot, Multicast, Derived column, Data conversion, Row count and Send Mail Task
• Designed, build and deployed TEMPeffective SSIS packages
• Designed reports using Filters, parameters and Action Filters
• Developed and modified Business Intelligence analytical reports /dashboards using Tableau Desktop
• Created rich dashboards using Tableau and prepared user stories to create compelling dashboards to deliver actionable insights
• Explored SDK and implemented LDAP authentication for external users in an existing application

Informatica Lead/Data Analyst

Confidential

Roles and Responsibilities:

• Worked as a Senior ETL Lead handling Environment and Integration Configuration and ensuring high availability of ETL system wifout missing any client SLA
• Performed 24X7 activities including - monitoring, troubleshooting & problem solving
• Fixed daily issues such as - incorrect data issues, missing files, long running jobs, failures due to outage, logic issue
• Created alerts for long running jobs, load status, outdated/orphaned objects in repository using Repository queries
• Optimized workflow tasks to enhance teh performance which includes re-designing, SQL optimization, modifying mapping logic etc.
• Automated jobs for process improvement to stabilize teh system and make it more robust
• Handled Informatica admin tasks like creating folders, relational connections, deployments, moving files\scripts from one server to another and modifying odbc.ini file to support database migration or new connection
• Managed Deployment Across environments
• Supported upgrade of Informatica and Netezza systems which included end to end testing of major jobs
• Worked on incident and problem tickets and resolved them well wifin teh SLA
• Carried out maintenance activities such as Informatica server bounce, installed Hot Fix and EBF, etc.

Environment: SSIS2008, Cognos 10.1.1, Microsoft SQL Server 2008

Business Analyst/Data Analyst/Cognos Lead Developer

Confidential

Roles and Responsibilities:

• Gatheird business requirements, definition and design of teh data sourcing and data flows, data quality analysis, working in conjunction wif teh data warehouse architect on teh development of logical data models
• Used SSIS to create .dtsx packages to validate, extract, transform and load data from different source’s and mapped them onto destination
• Managed large number of Meta Data Tables which are used in teh process of ETL in SQL Server 2008
• Involvement in defining scope for new releases and helping business in solving existing issues.
• Prepared Data Dictionary, Requirement Specification, Column Mapping Document for teh reports developed
• Designed, developed and implemented Framework Dimensional Model and package using Cognos 10.1.1
• Designed teh UI for teh Dashboard and created a Dashboard in Report Studio as per teh requirement
• Reused Layout Component References to help centralize and simplify repetitive report design tasksand hence saved lot of development time
• Created detailed reports involving grouping, sorting, conditional formatting, drill definition, Java Scripts, cascading prompts and hyperlinks in Report Studio
• Responsible for all object migration from Development environment to Production
• Worked wif multiple teams - Data Base team and QA team to resolve issues as in and when required

Cognos Developer

Confidential

Roles and Responsibilities:

• Prepared Training Material and conducted trainings sessions on COGNOS 10.1.1
• Understanding operational systems, data sources and data mapping
• Designed, developed and implemented associated reports for reporting and analysis to facilitate end users
• Did data testing of reports by firing custom SQL against database, testing of functional and cosmetic issues
• Managed data security, object security, and package security for various users in Framework Manager