SUMMARY

• Sr.BI Solution Architect/Technical Manager experienced with diverse technologies. Innovative business solutions provider, a problem solver with a proven ability to design, build, deploy and manage large - scale Data Warehousing projects in Finance, Sales & Marketing domains.
• Proficient in Relational Databases, Data Analysis, Impact Analysis, Fit-Gap Analysis, Data Governance, Data Integration, Dimensional modeling(logical/Physical), BI/ETL Architecture & Best Practices, SAP & Siebel Data migration & integration, System re-engineering/Re -Architecture, Business Process/performance Improvements, Data Quality & QA Automation, Enterprise Data Reconciliation, Business support, Project & Vendor management, Software development life cycle(SDLC) with Agile and waterfall methodologies.
• Developed and managed multiple analytics tools and systems for strategic business planning/decision, business analysis to support more than 1000 users.
• Skilled in leading large and globally distributed teams. Consistently meets deadlines within the budget while providing the highest quality product. Builds strong relationships with internal and external development teams, project managers, and business teams, ensuring alignment across multiple organizational levels and functions. Strong communication skills with an aptitude to learn.

TECHNICAL SKILLS

• Oracle
• SQL Server
• T-SQL
• SSIS
• PL/SQL
• PHP
• MySQL
• Hadoop Ecosystem
• MapReduce
• Hive
• Pig
• Sqoop
• Java
• JSP
• Servlets
• Java Script
• VB Script
• HTML
• CSS Visual Basic
• Oracle D2K Forms
• MS Office
• Unix Shell Scripting
• Informatica
• BusinessObjects
• Erwin
• QlikView/Qlik Sense
• OBIEE
• SAP BW
• Data Federator
• Denado
• SharePoint
• GitHub
• Crystal Reports
• AWS S3
• AWS Athena
• AWS Quiksight
• AWS Glue
• AWS EC2
• AWS Lambda
• DynamoDB
• Redshift
• Trillium
• Glacier/ Snowball
• Salesforce
• Siebel
• SAP
• Callidus
• Microsoft Visio
• Microsoft Project
• Jira

PROFESSIONAL EXPERIENCE

Confidential

Sr. BI Solution Architect/Technical Manager

Responsibilities:

• Developing centralized Data lake, the Confidential Big Data platform, redesigning the data ingestion process sourcing from Salesforce using AWS stack, leading teams to develop sales and marketing dashboards and transitioning users for future reporting system.
• Designing and developing Enterprise Data Reconciliation Java framework, a data validation process to ensure data quality and trustworthiness on Amazon Web services.
• Analyzed, designed and developed a frame work to identify the partners who tried to game the system to get additional incentives, recovered $700,000 from the partners across the globe.
• Redesigned and re-architected partner incentive program, implemented simple and scalable incentive Rule Engine and automated the entire incentive calculations. Saved $500,000 per year to the organization on application development and maintenance charges.
• Coordinated multiple Sales and Marketing system implementations and provided solutions to the reporting needs, including building new & enhanced subject areas with new/changed business model and entities.
• Partnered with the key business stakeholders in understanding business needs and ensuring key functional/non-functional requirements and objectives were addressed and achieved. Designed and developed 12 subject areas in Global Data Warehouse, Data Marts in EDW for Finance, global sales operations and world-wide field operations teams. Data ingested through API calls.
• Prepared retirement strategies and developed Roadmaps for OBIEE retirement and Led the OBIEE reporting system retirement, conducted Fit-Gap analysis, Data analysis, prepared field to field mapping documents and transitioned 1200 business users to Global Data Warehouse, retired 44 subject areas,360 DAC jobs,15 servers, saved $500,000/year in maintenance costs.
• Improved overall SQL/ETL pipeline Data load performance and reduced daily data load run time from 14 Hrs. to 4 Hrs., increased daily data load frequency from 1 to 3 Runs per day and Stabilized QlikView Dashboarding system, automated data validation checks, reduced run time from 8Hrs. to 3Hrs.
• Established and implemented Data Governance and Data Management policies, methodologies, work processes and supporting models to ensure data quality, integrity and security for Enterprise Data warehouse.
• Participated in Enterprise wide innovation day and presented self-healing application design and POC.
• Initiated Learning EIS & Confidential Business Process(LEAP), the knowledge sharing program enterprise wide, influenced and expedited funding from senior management.

Engineering Manager

Responsibilities:

• Conducted workshops with business stakeholders, analyzed business requirements to address issues being experienced by Tax, Sales Finance and FP&A, Managed and developed reliable and standardized deferred revenue forecasting reporting system in SAP Business warehouse.
• Estimated Project costs, Benefits & ROI, Participated in Business Priority councils, track and mitigate risks, Prepared Release plans, worked with Vendors in the hiring process, coordinated and delegated resources, led multiple projects, monitored project progress and results with teams of over 20.
• Developed proof of concept and created Dashboards for deferred revenue.
• Rolled out successfully Enterprise Data Warehouse Business objects & Informatica upgrades with zero downtime & zero defects, coordinated with vendors and released training suits for Business objects user community, supported more than 300 plus Revenue mart users across the organization.
• Worked with Business users and QA Managers/teams, reviewed use cases, test cases for data quality including regression. Provided project status updates to the senior management.

Sr. Business Intelligence Developer (Team Lead)

Responsibilities:

• Analyzed business requirements from Finance, Sales and recommended necessary solutions.
• Coordinated with stakeholders and ensured optimal level of services.
• Managed & rolled out multiple critical product developments and enhancements; created a record of zero issue.
• Participated in commit reviews meetings with business and project managers, provided high level solutions, project plan and release cycle for global compensation frame work.
• Ensured data quality by developing and implementing test plans, test cases and test processes.
• Led the integration team, designed and developed data integration jobs for Global Compensation Framework.
• Provided technical support to Sales Commissions team, diagnosed and resolved problems.
• Upgraded Callidus TrueComp Tool from version 3.5 to 7.1, designed and developed regression test suit for optimal results. Developed Custom user interface to run TrueComp Sales compensation pipelines.

Data Migration/Integration Specialist

Responsibilities:

• Led the data migration team to enable Confidential ’s use of Siebel software to provide world-class technical support to silver subscription customers.
• Conducted in-depth customer research on subscription customers, designed and built Enterprise customer data solution with universal customer master in Siebel.
• Architected ETL Data load, error handling, data cleansing and data reprocess strategies for migrating data into Siebel CRM application. Customized Siebel Analytics/OBIEE DAC ETL routines and reporting systems.
• Designed and developed ETL reconciliation & recovery routine to identify missing SAP data in Enterprise Data Warehouse. Analyzed budget, outlook and forecast data and designed and developed Planning file automation.