SUMMARY

• Business Intelligence Architect, Product Owner and Program/Tech Manager with 13 years of experience in Business Intelligence and Data Warehousing technologies.
• 13 Years of MS BI (SSIS, SSRS), 4 years of Power BI and 2 years of R and Python experience with multiple platform deployment, maintenance and upgrades.
• Highly experienced Developer, Architect, Tech Lead and Manager for all BI Tools.
• Experienced Tech lead and Manager, with expertise in managing medium to large scale, onsite and offshore teams for development projects as well as Production Support activities.
• Worked in top Health Care, Financial Services, and Hi - Tech Products industries with vast knowledge of business models and data flow.
• Hands on experience with content development in MS Power BI, MS BI (SSRS- SSIS), R, Python and other reporting and dashboarding tools.
• System Administrator with experiences installing and configuring Windows based BI Solutions.
• Strong knowledge and hands-on experience in sizing, securities, authorization, authentication setup and maintenance of production, quality assurance and development servers.
• Project Management skills with exceptional Planning, Organizing, Budgeting and Coordinating efforts.
• Proficiency in SQL, DAX, language utilized for development of reports.
• Strong knowledge of Data Modeling Concepts, snowflake schemas, multi star schemas, extended star schemas.
• Managed Projects and Production Support Cycles for 24/7 coverage on L2, L3, L4 levels.
• Experienced in customer interactions for requirement gathering, working closely with clients, and gathering business level information to be utilized to create universes, reports for ad-hoc reporting usage.
• Experienced in training Power users, Business Users, and developers for multiple BI platforms.
• Worked closely in creating test cases, performing UAT and testing reports and universes to ensure quality delivery.
• Assisted in creating ETL Jobs for SSIS, Informatica and Data Stage tools to capture ideal data for reporting and archiving purposes.
• Worked on multiple database systems including Oracle, Teradata, and MS SQL Server.
• Being a key project player, observed multiple full Life Cycle for projects, which included Requirement Analysis, Planning, Designing, Development, Test and Roll-Out / Go Live.

TECHNICAL SKILLS

• Microsoft Power-BI
• Microsoft Business Intelligence
• Data Stage, Informatica
• MS-Windows
• Service-Now, HPSM, HPQC
• R, Python
• Hadoop
• SQL, DAX, ETL
• Oracle, SQL Server

PROFESSIONAL EXPERIENCE

Business Intelligence Architect/Program Manager

Confidential, Dayton, OH

Responsibilities:

• Leading R, Python, Power BI and MS BI platforms, management, and maintenance.
• Work with Enterprise Architects to design the system and participate in discussion forum to extension enterprise wide
• Implemented Power-BI Report Server and Power BI Gateways, R
• Working as a Lead Developer for Dashboards, Ad-Hoc and R Reports and bug fixes for all platforms.
• Hands-On Administrator and application owner for MS BI and Power BI.
• Developed and maintained SQL and DAX based Power BI reports and dashboards with multiple data sources, including Oracle, MS-SQL Server, Flat-file sources, AAS.
• Lead ETL and Data-Modelling, cleansing and alignment efforts on Informatica, Power-BI.
• Managing a 24 people team, based in multiple global destinations for development as well as Production Support.
• Support server upgrades, patches, shutdowns, health-checks, license management, scheduling, including creating PowerShell and batch scripts to auto reboot and clean servers up.
• Created multiple test plans, performed QA, performance and validation testing on all BI platforms.
• Implementing Power-BI AD authentication and SSO for all Platforms utilizing OKTA web-based Authentication.
• Collaborating with ETL teams, SSIS and Informatica for ensuring data quality and accuracy.
• Redefined a new and more optimized content and report storage methodology along with server and content level backups including Disaster Recovery.
• Actively monitor and control all platform level securities including but not limited to user access, data security, database level restrictions and role-based authorizations.
• Involved in User Training and Developer training for Tableau, Power-BI.
• Redefined business processes for Projects and Production support activities.
• Worked heavily for implementation of Service-NOW, Cloud based ticketing system replacing HPSM.
• Heavily involved in multiple RFP for new technologies, testing, demos, and vendor evaluation.
• Governance meetings with VP/Directors to discuss about Risk/Highlights and progress of the project
• Closely work with other teams to reduce the risk or dependencies

Business Intelligence SME/Tech Lead

Confidential, Bloomfield, CT

Responsibilities:

• Requirement gathering, elicitation and documenting with Wire Frames for Reports
• Conduct meeting with Business users to understand the inputs
• Implement Agile methodologies and refining the user stories and Demo with user
• Maintain multiple ODS Data inputs from various sources and load into EDW, for outbound high visibility compliant data.
• Implementing SQL scripts for Data extract
• Requirement gathering for Report design and create BRD with wireframes
• Suggest business users with extensive approaches in reporting and secure sign off to implment
• Build/Manage SSIS ETL process flows and jobs.
• Manage over 1,000 Web Intelligence reporting and over 800 daily scheduled Web reports.
• Working with Control M, Tidal Scheduling and maintaining scheduling and triggering events.
• Working with BI Platform team for pre-upgrade assessment and testing.
• Part of Business Intelligence Platform/Production Support team.
• Configuring multiple application servers with load balancer and IIS to enable Single Sign-on (SSO) and Windows AD.
• Resolve all issues related to Business Objects (including all server, network, database, SSO and client applications) functionality - coordinate troubleshooting activities with Business Objects Technical Support and required resources - all break/fix issues.
• Tech Lead for Onsite and Offshore teams, coordinating efforts for fifteen-member team.
• Extensive data digging and data analysis, to ensure perfect data delivery required for reporting statistics.