SUMMARY:

• 14+ years of experience in IT industry as Sr. BI Architect and Data Analyst in Business Intelligence and Data warehousing Technologies.
• 11+ years of experience as a Data Analyst, Data Modelling, Data Integration, Master Data Management.
• Experience in Logical/PhysicalDataModeling, Relational and Dimensional Modeling for Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) systems using ERWIN9.0.
• Strong experience in the Analysis, Design, Development of Business Intelligence Solutions using Data Warehouse/Data Mart Design.
• Development and Maintenance of Datadictionary and Metadata.
• Efficient in DimensionalDataModeling forDataMart design, identifying Facts and Dimensions and strong understanding of principles ofdatawarehousing, fact tables, dimension tables, Slowly Changing Dimensions.
• Hands - on experience in Talend Open Studio Data Integration for Data integration and Data warehouse solutions.
• Proficient in using Informatica Power Center- Workflow Manager and Workflow Monitor to create and control workflows and tasks.
• Expert in designing and developing backend PL/SQL packages in database layer, functions and triggers.
• 8+ years of experience with Data Analytics using Tableau and TIBCO Spotfire.
• 8+ years of hands-on experience on TIBCO Professional and Web player.
• 6+ Years of hands-on experience on Tableau Professional.
• Strong Experience in Development of Dashboards/visualizations for Analytics.
• Installation, Migration Upgrades and Troubleshooting of Dashboards.
• Experience in all phases ofdatamining,datacollection,datacleaning, developing models, validation, and visualization and performing Gap analysis.
• Performeddataprofiling in the source systems that are required forDataMarts.
• 6+ Years for Project Management and Delivery
• Elicited business requirements, in partnership with the business and technology resources.
• Strong in Coordinating with Business, Data Owners, Customer Technical Review teams for smooth project implementation and Delivery.
• Strong in Coordination with Offshore - Onshore development and vendor teams for project development and delivery.
• Facilitated sessions to iterate through project risks and approve project lifecycle documents.
• Recognize opportunities for potential organizational, system or process improvements. Make recommendations or take appropriate action.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.x, Talend 6.1.1

Reporting Tools: Spotfire 7.8, Tableau 10.1

Data Modeling Tools: ERWIN 9.0

Databases: Oracle, SQL Server, Greenplum, Teradata

Project Management: Resource Management and Presales

PROFESSIONAL EXPERIENCE:

Confidential

Sr. BI Architect and Data Analyst

Tools: Talend 6.1, GreenPlum, Tableau10.1, Spotfire 7.8, Java, ERWIN 9.0

Responsibilities:

• Senior Consultant/Data Analyst: Coordination with Leadership to gather requirements, data for analytics for reviews and decision making.
• Coordination with Customer IT in application solutions and architectural proposals.
• Data Analyst: Analyze heterogenous sources for Sales and Marketing, Competitor information data. Structuring/ Reorganize data as per business legibility. Analyze and Design for Data Quality Processes.
• Extensively involved with Sales Force Architect team to implement WIN/LOSS modules and Product Book implementation for Competitive Intelligence and Analytics.
• Extensively involved with Pricing and Commercial teams to capture and operationalize pricing and Cost Details for Pricing intelligence and Analytics.
• Data Architect: Built data models (Logical and Physical). Built Sales and Marketing DataMart’s.
• Data Integration using Talend Studio with Sales Force, ERP systems, Application Databases.
• Created mappings using Lookup, Aggregator, Joiner, Expression, Filter, Normalizer and De-Normalizer, Maps Transformations. Developed reusable Transformation and Joblets.
• Hands-on experience with integration processes for the Enterprise Data Warehouse (EDW).
• Data Analytics: Extensively worked on Spotfire and Tableau Customizations to build Competitor, Marketing, Business and Price Analytics to cater sales and Pricing leaders.
• Developed visualization with interactive features such as multiple Markings, Filtering schemes, configuring Bar chart, Line chart, Graphical table, Combination chart, Scatter plot, Pie chart, Parallel coordinate plots, Gantt chart, Pareto chart, Table, Cross table, and Summary table visualizations.
• Worked on development of Dashboards for Key Performance Indicators for top management.
• Project Management: Managing and Mentoring 14-member Development team for quality deliverables. Daily Status/Risks reporting to Customer IT.

Confidential

Sr. BI Architect and Data Analyst

Tools: Informatica 9.x, Oracle 9.x, Spotfire 6.x, Java, ERWIN 9.0

Responsibilities:

• Senior Consultant/Data Analyst: Coordination with Leadership to gather requirements, data for analytics for reviews and decision making.
• Coordination with business to optimize processes and Operations.
• Coordination with Customer IT in application solutions and architecture proposals.
• Data Analyst: Analyze heterogenous sources for Structuring/ Reorganize data as per business legibility. Analyze and Design for Data Quality Processes.
• Data Architect: Built a data models (Logical and Physical). Built Sales and Marketing DataMart’s. Data Modeling (ERWIN) and Advance SQL PL/SQL programming.
• Data Sources: Integration with ERP systems, Kronos Systems and Application for Operational Data.
• Data Analytics: Extensively worked on Spotfire Customizations to build Operational metrics to gauge SAFETY, TIMELINESS, QUALITY and COST dashboards.
• Developed visualization with interactive features such as multiple Markings, Filtering schemes, configuring Bar chart, Line chart, Graphical table, Combination chart, Scatter plot, Pie chart, Parallel coordinate plots, Gantt chart, Pareto chart, Table, Cross table, and Summary table visualizations.
• Strong Experience in Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure.
• Project Management: Design/Development of data integration using ETL tools (Informatica/Talend), Managing/Mentoring 14-member Development team for quality deliverables. Daily Status/Risks reporting to Customer IT.

Confidential

BI Consultant and Project Lead

Tools: Informatica, Oracle, Spotfire 7.8, Cognos

Responsibilities:

• Data Architect: Built a data models (Logical and Physical) using ERWIN 9.0
• Data Analytics: Analytical Dashboards using Spotfire.
• Analyzed/Developed existing COGNOS Reports to Spotfire Dashboards and Visualizations.
• Developed visualization with interactive features such as multiple Markings, Filtering schemes, configuring Bar chart, Line chart, Graphical table, Combination chart, Scatter plot, Pie chart, Parallel coordinate plots, Gantt chart, Pareto chart, Table, Cross table, and Summary table visualizations.
• Data Sources: Integration with ERP systems for the PO module
• Strong Experience in Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor.
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Stored Procedure.

Confidential

BI Consultant and Project Lead

Tools: Informatica, Teradata, Spotfire 7.8, Java

Responsibilities:

• Data Architect: Built a data models (Logical and Physical). Built Sales and Marketing DataMart’s. Data Modeling (ERWIN) and Advance SQL PL/SQL programming.
• Data Sources: Integration with Oracle application database for Fleet Data.
• Analyzed/Developed existing Java Reports to Spotfire Dashboards and Visualizations.

Confidential

Software Engineer

Responsibilities:

• Customization of existing billing profiles for new/old offers.
• Implement/Enhancement of new mobile billing policies to the tool.
• Expertise in setting up environment and executing for UAT/IUAT/PROD and providing end to endsupport.
• Experience in setting up FTP, SFTP protocols for file transfers.
• Strong use of shell scripting languages including BASH for Linux and Power shell for Windows systems.
• Experience in QA process in progression and regression testing for new modules and customizations.
• Bug fixes and Change management.
• Testing of various voice billing profiles and new launches.
• Support data extracts and billing reports for end users.

Confidential

Application/Software Developer

Responsibilities:

• Bug fixes and Change management.
• Support data extracts and billing reports for end users.
• Experience in setting up FTP, SFTP protocols for file transfers.
• Strong use of shell scripting languages including BASH for Linux and Power shell for Windows systems.
• Experience in QA process in progression and regression testing for new modules and customizations.
• Testing of various voice billing profiles and new launches.