SUMMARY:

• Overall 13+ years’ experience in Information Technology and Business Intelligence related fields with progressively increased levels of responsibility with, System Designing, Business Analysis, Application Development, Maintenance, Implementation, Project Management, Microsoft Power BI, Data Modeling expertise including understanding of Data sources, Relational and Dimensional Modeling, Data Mining, Report Writing, and Built Dashboards Solutions.
• Have full understanding of the Software Development Life Cycle (SDLC) and project Management Life Cycle (PMLC), management and Business Intelligence. I also have experience in managing products, analysis, development and delivery of high - performance technology solutions. Qualified to play integral role in the field of information technology where talents and experience will contribute to achieving company goals.
• Admirable experience in managing all business intelligence reports and providing data solutions as a project manager.
• Contributed project manager with responsibility for recruiting,, supervising, and retaining a team of more than 50 professionals both in US and abroad.
• Seasoned outsourcing/ offshoring professional with experience analyzing, transacting, implementing, managing, optimizing, and overseeing all aspects of O/O lifecycle.
• Managed team of onshore and offshore outsourced analysts and business intelligence developers.
• Sound knowledge of Customer Relationship Management (CRM).
• Experienced with leading meetings, managing teams, and owning team results and applying different business methods.
• Excellent aptitude for working with large complex amounts of data and an eye for detail.
• Specialized knowledge in Microsoft Power BI , Flow and Azure Analysis Services .
• Ability to leverage and/or engage others to accomplish projects.
• 5+ year of leadership experience.
• 8+ Experience in designing, developing, implementing and supporting reporting, analytics and business intelligence solutions utilized to support business analytical and reporting needs.
• 8 + years’ experience in Sales, Finance and Commercial operations.
• 6+ years Business Analyst experience, ideally working in an Agile Scrum environment, with ability to work across multiple multi-functional teams.
• 8+ years of experience in Data analysis Taking complex datasets and transform into results that highlight business opportunities.
• Experience with data analysis, data modeling, Star Schema, Snowflake, data profiling and data mapping and ETL Procedure.
• Deep knowledge of Azure cloud platform and services 5+ years of experience in Azure Cloud.
• Knowledge of DevOps tools and methodologies.
• Knowledge of cloud development platforms.
• 5+ Years of experience in Microsoft Azure Cloud Services.
• 5+ Years of experience in Microsoft Power BI.
• Familiar with ASP.NET, Visual Studio, TFS, Entity/MVC, SQL Server, etc.
• 5+ years of experience understanding of Microsoft development suite SSIS and SSAS, as well as familiarity with standard data extract, de-duping, cleansing, integration, and aggregation techniques and best practices.
• Designed and managed public/private cloud infrastructures using Amazon Web Services ( AWS ) which include EC2, S3, Cloud Front, Elastic File System, RDS, VPC , Direct Connect, Route53, Cloud Watch, Cloud Trail, Cloud Formation, and IAM which allowed automated operations. Deployed Cloud Front to deliver content further allowing reduction of load on the servers.
• Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in deployment of Business Intelligence and Web Intelligence from various Database Sources SQL Server, Oracle, TeraData, MS SQL Server, DB2, Sybase and MS-Access.
• Supporting ETL data load and data transfer processes.
• Possesses a strong aptitude/passion for creative problem solving when dealing with ambiguity.
• Project management skills with high attention-to- detail on data and a strong focus on meeting deliverables with time limitations - have ability to multitask and prioritize.
• Implemented Power BI & Snowflake in a self-service environment. Report migration from SSRS to Power BI.
• Experience creating complete Power BI report solutions.
• Knowledge of BI reporting platform like Microsoft Azure, and Power BI etc.
• Experience with developing Power BI embedded applications.
• Experience knowledge in DAX.
• 5+ Experience in design, model and develop complex reports using Power BI & multiple data sources - OnPrem data storage and Snowflake.
• Experience with building visualizations/data sets in Power Bi and exposure other Microsoft Power Platforms like Power Apps/Power Automate.
• 8+ years of experience in Design, development and implementation of Business Intelligence Applications using SAP Business Objects Enterprise (XIR3/XI4.0/4.1/4.2).
• Experience defining Users and Groups and assign access restrictions to their profiles in Business Objects Central Management Console (CMC).
• Educate business stakeholders on intelligence reporting capabilities.
• Strong verbal and written communications with ability to effectively communicate multiple levels in the organization.

COMPUTER SKILLS:

Languages:

Proficient with: T-SQL, Oracle PL/SQL, MS SQL Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server 2017/2016/2014

Trilingual: Fluent in English, Spanish, And Hindi (Read, Write and Speak) Software

Database: Microsoft SQL Server, Microsoft Access, Oracle, and DB2

Development Suite: SSRS/SSIS/SSAS

Platform: Microsoft Windows 10/7, and Linux

Version Control Tools: Git, SVN, Perforce.

Build Tools: Maven, Ant.

Continuous Integration: Hudson, Jenkins, Bamboo

Scripting: Shell, Python, Ruby, PowerShell, C#

Configuration Management: Chef, Ansible, Puppet

Web Tools: JSP, PHP, XML, Spring Boot.

Application Servers: Apache Tomcat, WebLogic, WebSphere, Jboss, Nginx

Monitoring Tools: Splunk, Zabbix, Nagios.

Operating systems: Windows, Linux, HP-Unix, and Solaris

Containerization Tool: Docker, Kubernetes.

Bug Tracking Tools: JIRA, Remedy, HP Quality Center

Cloud: AWS, Microsoft Azure, Google Cloud

Microsoft Power BI: Desktop, Saas, Gateway, Embedded, and Report Server.

Microsoft Azure Services and Features: Data Lake, Data Factory, Storage Explorer, Azure DevOps, Azure Kubernetes Service (AKS) etc.

Familiar with additional Azure Services: On-Premises, IaaS (infrastructure as a Service e.g. Compute & Storage, Networking), and PaaS (Platform as a Service e.g. Compute, Integration, Data & Analytics), and Security & Management etc.

Tableau: Business Intelligence Reporting Version 4.3/4.2 Tools Business Intelligence Launch Pad, Information Design Tool, Central Management Console.

Dimensional Modeling: Star Schema Modeling, Snowflake Modeling, Fact and Dimensions Tables & Data Integrator

Management Tools: MS Project, MS Visio, Word, Excel, Power Point, and ServiceNow.

EXPERIENCE:

Business Intelligence/Microsoft Azure Architect Lead

Confidential, NJ

Responsibilities:

• Managed Business Intelligence projects from conceptualizations to implementation.
• Developed project plans, prepared a schedule, and ensured work according to same.
• Analyzed business requirements and developed project deliverables accordingly.
• Works independently and follow the agile methodology and processes.
• Suggest changes to senior management using analytics to support your recommendations. Actively participate in the implementation of approved changes
• Proven expertise in various business analysis methodologies and techniques, including data analysis, use case development, story writing, user acceptance testing, and product documentation.
• Facilitate business and systems analysis discussions and translate findings into clearly defined business requirements.
• Participate in system integration testing and user acceptance testing with the business users to ensure a high-quality delivery.
• Administered projects and prepared regular status reports.
• Coordinated with various stakeholders and management for execution of project appropriately.
• Sound knowledge of Customer Relationship Management (CRM).
• Work with Data Warehouse team and business operational teams to understand data sources and implement new requirements.
• Lead projects at various stages from requirements gathering and business rules analysis to creating physical database model, SSIS/SSAS development, BO Universe Architecture and Reporting.
• Participated in data warehouse business analysis sessions and involved in data mart creation from conceptual to physical design.
• Actively participate in the overall Data Warehouse/Business Intelligence strategy. Used Informatica tool extensively to extract data from database and load it into data warehouse repository.
• Lead projects at various stages from requirements gathering and business rules analysis to creating physical database model, SSIS/SSAS development, BO Universe Architecture and Reporting.
• Hands on SSIS, SSAS development and production support of around 32 data marts and the Enterprise Data Warehouse, Meta data and Universe creation for reporting.
• Lead and improvised existing Enterprise Data Warehouse.
• Extracted Data using SSIS from XML, SQL Server, Oracle and flat files, Excel perform transformations and populate the data warehouse.
• Coordinating with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema and Snowflake) and maintenance.
• Query Optimization for improving the performance of the data warehouse.
• Maintained through understanding of all major data sources internal to the organization experience and knowledge of report writing.
• Document ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, prepared test data for testing, error handling and analysis.
• Design, Development, Implementation of Data Migration and SSIS Application development projects and build across Development, QA and PROD environments.
• Multi Master Replication/ Streams Support (High Availability) for mission critical databases.
• Designed and implemented Data Synchronization from Oracle 12c to Snowflake database in Informatica intelligent cloud services (IICS).
• Extensively involved in the Analysis, design and Modeling. Worked on Snowflake Schema, Data Modeling, Data Elements, Issue/Question Resolution Logs, and Source to Target Mappings, Interface Matrix and Design elements.
• Design and develop logical and physical data models that utilize concepts such as Star Schema, Snowflake Schema and Slowly Changing Dimensions.
• Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Created self-servicing metadata models such as relational, DMR and power cubes for different functional areas using operational data stores/databases, including SQL Server, Oracle, and Teradata.
• Coordinating with various teams to minimize the impact on high priority jobs during critical issues. Meet project deadlines and deliverables by following up on resolving dependencies on timely basis.
• Built the AWS infrastructure from the scratch for the Project Excalibur App which is an internal application that logs the customer data.
• Responsible for creating tagging standards for proper identification and ownership of EC2 instances and other AWS resources.
• Used BOTO 3 and Fabric for launching and deploying instances in AWS. Configured Inbound/Outbound in AWS Security groups according to the requirements.
• Used IAM to create new accounts, roles, and groups. Extensively automated the deployments using AWS by creating IAM s and integrated the Jenkins with AWS plugins to pipeline the code.
• Designed and developed AWS Cloud Formation templates to create custom VPC, Subnets, NAT to ensure deployment of web applications.
• Worked on Multiple AWS instances, set the security groups, Elastic Load Balancer and AMIs, Auto scaling to design cost effective, fault tolerant and highly.
• Designed, developed, implemented and supported reporting, analytics and business intelligence solutions utilized to support business analytical and reporting needs.
• Maintained good working relations with all key teams of organization.
• Impo r te d dat a from SQL Serve r D B , Azure SQL D B to Po wer Bl to g enerate re po r ts. Assisted technical team in developing and analyzing operational reports.
• Used Load balancer, message queues to improve resiliency and worked at Scale by making use of Caching, Partitioning and other Techniques.
• Used Azure services and features to create Scalable and Resilient systems.
• Deployed a web services on a virtual machine which gives complete control over the execution environment, and App Service Platform as service.
• Used Azure services and features to create Scalable and Resilient systems.
• Used Azure Resource Group to encapsulate all the resources need to deliver applications, e.g. the App service, the App services plan, the Storage account, and the Azure SQL etc.,
• Added multiple Web servers for automatic load balancing between each instance.
• Created Da x Quer i es to generated computed columns in Po wer B l.
• Created Azure B l ob Storage for I mpo rt / E xport dat a to /fr om . CSV F il e.
• Use d P ower B l, Power Pivot t o de ve lop data ana l ysis proto t ype , and used Power Vi ew and Po wer Map to vi sualize re po r ts. Generated computed tables i n Po wer B l by us in g D a x.
• Developed reports, dashboards & scorecards, data exploration, and visual analytics using existing and emerging technologies and tools.
• Developed and maintaining more than 15 reports (from simple to complex using Power BI and TABLEAU 2018.2) using Teradata.
• Created 10 reports from Scratch and Pu bl ish ed Power B l Rep or t s in the require d or i g i n at i ons an d Made Po we r Bl Dash bo ards a va il ab l e in Web clients and mobil e apps. P ublished repo r ts an d das hboards using P ower Bl.
• E x p l ore data in a Var i ety of w ays and across mu l tiple v isu aliz at i ons us in g Power B l
• Use d P ower B l Gateways to kee p the das hboards and repo r ts up to date.
• Instal l ed an d Configu red Ente rp rise Gateway and Perso n al Gateway in Po wer B i Serv i ces.
• Maintained the production deployment process to ensure that best practices are followed.
• Develop and maintain internal tools and services to monitor production jobs to ensure they execute as expected. Proactively monitored application and infrastructure alerts and reacted quickly.

Environment : Power BI’s Components , SQL Server, Oracle, SSMS, SSRS, SSIS, SSAS, T-SQL, Business Intelligence Client Tools xi4.2/4.1, Tableau, ETL, Data Warehouse Bus Architecture, Teradata, Microsoft Azure Services and Features, Windows 10 . AWS, Terraform, Git, Maven, Jenkins, Puppet, Chef, Ansible, Docker, Mesos, Marathon, and Kubernetes, RedHat, Debian, Linux, Python, Nginx, Nagios, Log Stash, Kibana, Blue Green Deployment

Business Intelligence Project Lead

Confidential, Windsor, CT

Responsibilities:

• Data Architect/Modeler/Analyst Data Warehouse.
• Perform data modeling, data source analysis, data sourcing specifications, ETL design & specification.
• Create conceptual, logical, and physical data models to define the informational needs of the Data Warehouse
• Extensively involved in the Analysis, design and Modeling. Worked on Snowflake Schema, Data Modeling, Data Elements, Issue/Question Resolution Logs, and Source to Target Mappings, Interface Matrix and Design elements.
• Extensively Worked on Star Schema, Snowflake Schema, Data Modeling, Logical and Physical Model, Data Elements, Issue/Question Resolution Logs, and Source to Target Mappings, Interface Matrix and Design elements.
• Design and develop logical and physical data models that utilize concepts such as Star Schema, Snowflake Schema and Slowly Changing Dimensions.
• Developed a complex provider scorecard dashboard with multiple tabs using dynamic visibility. This dashboard shows the high-level information of rolling 12 months of provider performance data varying across different areas like productivity, machine utilization, compliance and quality. The dashboard also has the capability of drilling down to the detail data on to the detail Web Intelligence reports
• Coordinated with various stakeholders and management for execution of project appropriately.
• Extensive experience in integration of Informatica Data Quality (IDQ) with Informatica PowerCenter
• Developed, interpreted, and present a point of view and recommendation with respect to analytics/KPIs.
• Maintained good working relations with all key teams of organization.
• Assisted technical team in developing and analyzing operational reports.
• Designed progress controls to monitor progress for same.

Environment : Git, Maven, Jenkins, Ansible, Docker, Mesos, RedHat, Linux, Python, Business Intelligence Client Tools xi4.1/4.0, Business Intelligence Launch Pad and Information Design tool, Dashboard 4.1 SP5, SQL Server, SSMS, SSIS, Oracle, T-SQL, ETL, Teradata, Windows 10. Microsoft Live Office. Data Warehouse.

Business Intelligence Lead

Confidential, Hartford, CT

Responsibilities:

• Collaborate with key internal stakeholders and management to create/develop operational dashboards and standard reporting.
• Analyzed data to identify areas of concern or best practices opportunities and partner with stakeholders to further assess, determine counter measures or establish new processes as needed.
• Conducted a variety of tasks and support in creating BI reports, requirements, communications, and other key activities. Analyzed business requirements in collaboration with business end users, improving the quality, viability, and fit for requirements. Performed financial analysis to enhance decision making. Supported Operations team and developed productivity reports, in addition to analytical support.
• Developed effective queries for retrieving and analyzing data from a variety of sources, contributing to vendor evaluations as part of reporting enhancements, and supporting data driven decisions.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems from DB2, Oracle, SQL Server, Flat files to load into Staging, ODS, Enterprise Data warehouse, and subject oriented Data marts for Sales, Marketing and Finance departments.
• Worked extensively with the Business Objects Designer in preparing Universes from the warehouse database.
• Created 10 Web Intelligence reports from scratch.
• Key s: Increased selling of insurance premiums by 45% due to implementation of KPIs created from CRM system, resulting in enhanced customer relationships.

Environment : Business Intelligence Client Tools xi4.1/4.0, Business Intelligence Launch Pad and Information Design tool, Dashboard 4.1 SP5, SQL Server, SSMS, SSIS, T-SQL, ETL, Oracle, DB2, Windows 10. Microsoft Live Office.

Business Intelligence Developer

Confidential, Mellon, NY

Responsibilities:

• Designed and creation of database tables/views and processes to facilitate complex reporting in Business Objects / Oracle environments to replace complex manual processes.
• Provided technical advice and skills transfer on BusinessObjects solutions to end-users at all levels within organizations.
• Responsible for the development of bespoke computer-based content using Business Objects Knowledge Accelerator toolset to produce technical documentation for both end-users and support staff.
• Involved with the security set up and users and group access of the new Business Objects system through Central Management Center (CMC).
• Post go live, worked on report errors; performance enhancements; system maintenance; migration of legacy client reports; setting up new clients.
• Provided consultancy to new permanent staff on Business Objects usage, change processes and general guidance.

Environment : Business Intelligence Client Tools xi4.0, Business Intelligence Launch Pad and Information Design tool, Dashboard 4.1 SP5, SQL Server, SSMS, SSIS, T-SQL, Windows 10. Microsoft Live Office.

Business Intelligence Developer/Administrator

Confidential, NJ

Responsibilities:

• Responsible to talk to business users and finalize on any enhancements/new requirements needed by reporting department
• Created Users, User groups, defined the security and administered the User community Repository domains, using CMC
• Created universes using Business Objects Designer & Created reports using Desktop Intelligence/ Web Intelligence.
• Optimized the performance of the dashboards. Reduced the dashboard loading time by scheduling the backed source Web Intelligence reports for the live office and changing the live office refresh option to pick from the latest instance.
• Worked on Import Wizard to promote Reports/Universe to Production
• Created access level for specific functionality for User/Groups
• Implemented migrations of repositories (Universes, Reports, Securities, Categories) from DEV to UAT and then to PROD.

Environment : Business Intelligence Client Tools xi3.1, Business Intelligence Launch Pad and Information Design tool, Dashboard 4.1 SP5, SQL Server, SSMS, SSIS, T-SQL, Windows 10. Microsoft Live Office.