Summary

• Versatile creative IT professional with a focus on Data Warehousing/ Business Intelligence/Analytics
• A continuous learner with a strong poly-skill foundation. Diverse roles as Iteration Manager, Project Manager, Lead Systems Data Analyst, Data Architect, Application Architect Tech Lead facilitates adaptability, learning agility, problem solving, collaboration, effective communication, connecting the dots, generating ideas and leadership
• Domain knowledge in Banking, Finance sales, Brokerage, Accounting, Corporate Tax Compliance

PROFESSIONAL EXPERIENCE

Confidential

Iteration and Project Manager

• Serving as an Iteration Manager for a Tier-2 program with annual budget of 5M starting Jan 2014. Served a dual role of an Iteration Manager and a Project Manager for NW Bank projects from Dec 2011 Dec 2013.
• Spearheading a team of 22 indirect reports. Served as an Interim Analysis Manager for six months in parallel. Coached members within and outside the team.
• Facilitate line cadence meetings following Agile practices
• Facilitate process improvements to get better estimates for planning and a healthy work backlog
• Continuously planning and improving with the changing needs of business priorities, technology and resource changes
• Remove roadblocks, encourage de-centralized decision making within the team by actively participating and being the first point of escalation
• Prepare resource work plan, program roadmap, monthly budget forecasts and cost plans.
• Build strong relationships and collaborate with the Business Sponsor, Product Owner and other stakeholders.
• Maintain line VMS boards and RTC tool
• Key Achievements
• The NW Bank Data Enhancements effort would enable business users to have self-reporting capability via the BI solution, support predictive analytics, drive enterprise penetration growth by improving cross-sell capabilities to existing customers, increase client retention and much more .
• New reporting functionality helped reduce annual costs of 100K
• Helped jump start a new agile line, uplifted capabilities thru several process improvements which improved team's predictability metric and get better estimates
• Leading Monthly IM Exchange meetings and bringing together IM's from across the Enterprise to discuss challenges and learn good practices from one another.

Project Manager Business Intelligence Confidential

• Managed complex IT project successfully from its initiation till implementation. Comprised of multiple sub-projects executing in parallel.
• Team of 11 indirect reports
• Facilitated requirement gathering from key users and business stakeholders using structured interviews, group discussions and teleconferences
• Provided leadership and effectively managed geographically dispersed, cross functional team members of internal employees and external consultants.
• Prepared Work Breakdown Structure, resource plan, project schedule, project deliverables and monthly budget forecasts.
• Effectively managed technical and project related issues, risks and conflicts.
• Chaired weekly status meetings with business stakeholders, management, tech and QA teams
• Negotiated with the vendor for better price of consultants to keep project costs within budget
• Key Achievements
• Identified and resolved differences between the two BI platforms Microstrategy WebFocus preparing the foundation for future conversion efforts.
• Conversion helped bring down costs related to licenses associated to BI tool used earlier

Lead, Systems Analysis Confidential

Delivered as Lead Systems Analyst, Confidential

• Coordinated projects involving different teams across the Enterprise managing risk identification mitigation plans. Took up additional agile Iteration Manager responsibilities.
• Performed architectural duties, researched to integrate current state of data and systems spread out across several databases, platforms business units NFN, NF, Distribution channels for a Tier-1 ADP program roadmap. Built the complex integrated current state system context diagram, other supporting flow diagrams deliverables for deep dives.
• As Solutions Lead facilitated requirement gathering from key users on several projects via JAD sessions. Created story cards, mappings, swim lanes, workflows other deliverables using ESDm methodology.
• Mentored team members on key tasks. Offered SQL training to team.
• Key Achievements
• The ADP program roadmap and trend analysis helped identify process and technology improvements for an efficient future state.
• New functionality for BGA and Fee-based advisors added business value that would assist NF producers bringing in more business.

Confidential

As Tech Lead of BI projects.

• Successfully implemented two OLAP reporting projects in Microstrategy.
• Performed conversion of data model and architected the Microstrategy schema and public objects and development of management reports.
• Redesigned an existing large production database which is a relational model into a dimensional model. Used de-normalization techniques and Snow Flake schema design for the logical model.
• As Tech Lead for a data cleansing project:
• Facilitated requirement gathering of functional details from users.
• Data modeled, designed and developed ETL functions that cleansed the data coming from several administrative systems prior to loading it to the Warehouse. Trillium was used for data cleansing.
• Key Achievements
• Data cleansing saved the organization costs on returned mail sent out to wrong addresses
• On time delivery of the BI projects assisted Compliance and Supervisory teams to be compliant with government's regulatory rules on time
• Hands-On Managed team : WorkBench, AGILE, CLARITY, Sharepoint, RTC, VISIO, MICROSTATEGY, ORACLE, NETEZZA, Microsoft Word, Excel, Powerpoint, PL/SQL, UNIX, Korn Shell, SQL-STATION, WINSQL, SQL PLUS, SQL LOADER, sed, awk, ULTRAEDIT-32, TRILLIUM 7.5, ERWIN
• Managed Team: ATTD, INFORMATICA, TERADATA, Business Objects, WebFOCUS , Java, J2EE, Perl, RUBY, Cucumber, WebSphere, Javascript, LoadRunner, HTML, XML

Confidential

Consultant Data Warehouse Professional

• Developed Korn Shell scripts and PL/SQL procedures/ packages for the ETL functions to load data from different applications into a Data Warehouse. Used Rational Rose for Data Modeling.
• Key Achievements
• Integrated crucial data of different users in the warehouse for GE's 'Single Sign On' process
• Platform: HP / SUN SOLARIS UNIX, Korn Shell, ORACLE 8.0.5, PL/SQL 8.0, SQL PLUS 8.0.5, SQL LOADER, sed, awk, FTP, VISIO, Rational Rose, RUP

Confidential

Consultant Application Architect, Project Lead Tech Lead

• Performed in various roles to develop a State Tax Planning and Audit System. This system is used primarily by Tax Experts/Attorneys to find good Tax Filing strategies to be prepared for Tax Auditing by applying What-If scenarios to different parameters of the system.
• Managed project tasks during the requirement analysis, design and implementation phases
• Provided strong end-to-end leadership as a technical lead, project manager, application architect, data modeler and developer
• Analyzed requirements for the system from brain storming sessions with business users, meetings with a Corporate Tax expert. Translated the requirements to design the Relational Data Model, system design and its functionalities.
• Developed the Calculation and Change Engines based on different Tax Return Calculation algorithms using PL/SQL. The 'Change' Engine recognized what parameter got changed and recalculated the Tax Return depending on different functional aspects of the change.
• Key Achievements
• GE Corporate Tax used the What-If scenarios to determine the minimum Tax to be paid, that helped reduce the tax costs of various business entities.
• Platform: HP 9000, ORACLE 7.3.2, PL/SQL 2.3.2, UNIX, SQL PLUS 3.3.2, SQL LOADER, MS ACCESS, VISIO, ERWIN, Powerbuilder, Microsoft Excel, Microsoft Project, Microsoft Word

Confidential

Consultant Systems Analyst Software Engineer

• Designed, developed, tested and implemented programs for various clients in different platforms.
• Platform: MVS/XA, IDMS, ADS/O, ADS/A, COBOL-2, UNIX, C, INGRES, Powerbuiilder, SYBASE