SUMMARY

• Accomplished and dedicated Business Consultant with close to 9 years of experience in Information Technology sector.
• Solution driven, highly analytical and skilled business specialist with excellent focus and attention to details.
• Strong background in Requirements gathering, data analysis, business intelligence, and data warehousing systems, and proven history of accomplishments in improving efficiency and productivity of business processes.
• Demonstrated strong leadership abilities, team work skills, exceptional planning, agility and data driven, results oriented decision making at all phases.
• Technical Business Analyst with close to 9 years of experience in Data Analysis and Business Intelligence
• Skilled in Data Analytics with expertise in complex SQL queries for high volume environments
• Strong Data Modeling and Data Extraction skills with experience creating end to end data pipelines from Data store to the end user
• Always updated with ever changing Business Intelligence tools and software environment, expertise in Tableau (8.1 - present), Kibana, SAP Business Objects
• Experience working in several AGILE Projects environments with SCRUM implementation

TECHNICAL SKILLS

Business Intelligence: Tableau, SAP Web Intelligence, Business Objects, Microsoft Dynamic CRM 360, Advanced MS Excel, MS-Office, Visio, Microsoft Access.

Tools: Informatica Power Center 9.5.1 Rally -Agile software, SOAP UI, Postman

Databases: SAP, SAP BW, Webx Analyzer, RDBMS-DB2, Oracle 12c, Teradata V2R12/V2R6

Operating Systems: Windows 7/XP/2003/2000/NT, Basics in UNIX

Language: UML, Advance SQL, PL/SQL, UNIX

PROFESSIONAL EXPERIENCE

Technical BI/ Data Analyst /Business consultant

Confidential

Responsibilities:

• Currently working on IOT DDI Platform - IoT Enablement Platform, based on Dynamic Digital Interaction platform, will enable PURCHASER to create solutions helping its customers to address the challenges that are common when creating solutions in the IoT domain. This provides solution to handle device and data management for an IoT ecosystem as well as exposing pre-integrated API’s to developers.
• Validation of IoT devices and data driven decision impacting the customer experience.
• Experience in working with IoT technologies like MQTT, LWM2M, WIFI, NB-IoT devices.
• Data design and validation for different scenarios like High Availability, Alarm, Certificate validation.
• Passionate about Data and developing business insights from data, involved in data analysis and reporting.
• Identifying, debugging and closure of defects, conducting SCRUM meetings and defect analysis triaging in RALLY tool.

Business Data Analyst/BI Analyst

Confidential

Responsibilities:

• Lead & Subject Matter Expert - Business Intelligence analysis and spearheaded new strategies for automation of different dashboards in Tableau/Splunk for AuxDB project (new data warehousing and reporting solution) . 30% improvement in productivity in a $1M project.
• Exploratory and Visual Analytics of business processes using ELK (Elastic Search, Logstash and Kibana) and anomalies detection using Machine learning techniques in Kibana. Providing accurate business Insights of key data and regular interpretation of data to C-level executive to drive business.
• Defining and driving business analysis of an opportunity worth of $14M from various complex data sources, by giving complete technical solutions insights to executives by defining various business strategies.
• Experience in conducting complex data analysis and other statistical techniques. Strong analytical/modeling skills with ability to convert raw data into actionable business insights.
• Data design, data modeling to create reports in Tableau. Responsible for ensuring the contractual SLAs are met across the program. Involved in Defect testing through SQL and Data validation.
• Creation of user Stories and generating extracts using Informatica ETL workflows and validating by SQL queries.
• Proactively engage with multiple product owners by giving new SLA/KPI framing requirements and data validation rules.
• Orchestrating and defining the requirements from Business owners, creating Requirements traceability matrix. Conducting workshops to define and clarify the business requirements for Big Data Analytics.
• Product management and strategy defining for improving operational efficiency in Analytics platform.
• Accountability and manage of ad-hoc projects/reports for daily, weekly and monthly in support of driving business insights, business intelligence for various business operations.
• Working closely with management and other business functions to understand requirements and provide insightful dashboards, reports, data visualizations, and metrics in Tableau and other BI tools.
• Proposed business solutions to improve efficiencies in analytical process and strategy defining.
• Recognize and adopt best practices in process improvement via LEAN principles. Data driven reporting and analysis: Involved in data integrity, test design, analysis, validation, and documentation.
• Proficient in SAP Business Objects, Tableau, and other Business Intelligence reporting tools.
• Provides technical support and coordination with operation team for development of key driver analysis, statistical linkages, and calibration between metrics.
• Experience in Rally-Agile Software. Actively participated in Release, Deployment, Change Management & improvement initiatives, and alignment process.
• Conducted SCRUM meetings, strong analytical skills with customer facing in determining the requirements and provide solutions to both external and internal stakeholders at top executives and among directors of business.

Business consultant/Analyst/BI

Confidential

Responsibilities:

• Developed Executive C-level Financial Presales Reporting dashboard in Tableau to control expenses by addressing the OPEX budgets, forecasting, sales spend allocation budget and revenue on a near real time basis. OPEX expenses were controlled by $2 million annually increasing revenue by 20%
• 90% improvement in productivity by enhancing the quality and speed of proposal development by increasing the ability to plan and manage pre-sales spending levels.
• Individual collaboration with McKinsey & Company, in designing a new methodology for pre-sales reporting to Executive Leadership. This designed new reporting tool was rolled out across all customer units in Regional North America with annual savings of $70 K.
• Requirements gathering working with technical and business team of a $1B Digital Transformation of entire Billing platform.
• Prepared functional specification document, Business requirements, user stories, business use cases, testing plans and scripts based on requirements.
• Data modeling cum design and development of dashboards in Tableau using SQL queries.
• Defined and developed the dashboard for 13 SLA’s and 17 KPIs reports.
• Quantitative Data Analysis and delivering data driven recommendations and Business Intelligence solutions to leadership team.
• Data validation with emphasis on Root Cause Analysis, statistics, and operational insights to identify business problems.
• Experience with Splunk reports, Business Objects, and other Business Intelligence applications.
• Business Process Design by process modeling, use case analysis, implementation and troubleshooting.
• Performed gap analysis of business operations and IT operations, risk identification and mitigation.
• Worked closely with the project management team to analyze and consolidate request requirements to improve the decision planning process and project deadlines.
• Strong experience in UAT and functional testing.
• Excellent communication skills, technical writing and strong business analyst skills involved in requirements gathering and in all phases of SDLC.
• Conducted SCRUM meetings and experience working in SCRUM and Agile methodology using RALLY software.
• Achieved Operational Excellence by defining new business process and critical KPIs to understand trends. Proven record of accomplishment of initiative, outstanding performance, and excellent interpersonal skills with a strong 'Customer Focus'.

Senior Systems Engineer

Confidential

Responsibilities:

• Techno Functional Analyst / Module Lead for five team members in developing Enterprise Data Warehouse (EDW) reports for Business Intelligence
• SME and Business Analysis of complex business requirements and translating into specification designs of High level, low level documents.
• Increased productivity 33% by delivering product application in two months instead of six months.
• Automated scripts achieved 35% increase in productivity by eliminating time-consuming manual processes and performed testing with less than 10% defects.
• Developed project delivery timeliness and managed projects and resources to successful completion.
• Experience with Data warehouse management, Extracting, transfer and Loading (ETL) from different systems such as Oracle, Teradata and SAP using Informatica.
• Report Development & Analysis as well as Database Development. Design and development of Informatica ETL mappings, workflows. Worked with XML source files by creating XML definitions.
• Data Profiling, Data modeling developed complex SQL queries, table schemas aggregates and performed Quality assurance.
• Impact analysis and involved in all phases of SDLC waterfall and agile project methodology.
• Experience in Data Warehouse for orders, delivery, and inventory to generate business intelligence reports for analysis and business decision processes. Created SAP BO reports for business decision-making and delivery process.
• Supported production by running scheduled jobs, diagnosing session problems, and fixing mappings for minor business changes.
• Worked on performance improvement and achieved exceptional results by reducing load time.
• Mentoring, Functional Design, technical design, Testing, User manuals, user training.