We provide IT Staff Augmentation Services!

Lead Bi Analyst / Lead Business Systems Analyst - Bi Resume

3.00/5 (Submit Your Rating)

El Segundo, CA

SUMMARY:

  • Extensive IT experience (over 10 years) in Finance, Insurance, Banking, Healthcare, Retail, Entertainment and Education sector.
  • Experienced with extensive participation in all phases of Software Development Life Cycle (SDLC) including analysis, design, coding, testing of software applications in client/server environment.
  • PMP and Agile Trained.
  • Knowledge and experience with industry Portfolio Management processes and best practices, technology concepts and Software Development Life Cycle methodologies (i.e.: Agile, Scrum, Waterfall, Iterative, etc.).
  • Strong leadership skills working with Executive management, technical architects and business end - users working through change management and new technology deployments.
  • Extensive experience in Data Warehouse, Business Intelligence (BI), Data Integration (ETL) design and implementation for Enterprise level solutions and solid understanding of key DWH & BI trends with proven records.
  • Highly developed business acumen with ability to shape and implement strategy, build collaborative teams, and optimize resources.
  • Expertise in business intelligence, data mining, machine learning and data visualization.
  • Extensive experience in Actuarial, Accounting and Financial Analysis.
  • In-depth knowledge of IT Service Management - particularly in the areas of Incident, Problem, Change, Service Request and Configuration Management
  • Worked in OLTP & OLAP environment that includes Production (24x7) support, QA and development databases.
  • Extensive knowledge of Reverse and Forward engineering, Conceptual model, Logical and Physical model.
  • Extensive experience in creation of User stories, Use Case Scenarios, Test Procedures, Business processes, work flow diagrams, mockups and process flows.
  • Extensive knowledge of Bigdata Services and solutions.
  • Extensive experience using MS SQL, MS SQL Query Analyzer, Oracle SQL Developer and ability to rapidly evaluate business systems and recognize the supporting data structures with little or no supervision.
  • Experienced in managing onshore as well as offshore teams, vendors and managing portfolios in a matrixed organization. Led teams and mentored individuals to increase productivity.
  • Extensive experience in working collaboratively with internal partners and vendor consultants.
  • Demonstrated high capacity to learn new technologies rapidly with no formal training.
  • Prioritized and handled projects in extremely challenging situations and delivered quality products.
  • Superior communications, well-organized, interpersonal, problem solving, project management skills to work within an aggressive and demanding project schedule and environment with the focus towards Customer Centricity.

TECHNICAL SKILLS:

RDBMS/Data bases (Data warehouse tools): SQL Server 2000-2008, Oracle 9x/10g/11g, DB2 UDB 7.2, MS Access 2000-O365, Mainframe

Oracle Tools: TOAD for oracle 12.1, Rapid SQL, SQL*PLUS, SQL Developer, SQL*Loader, SQL*Net, SQL Navigator Export/Import, Oracle Discoverer 10g, Oracle Enterprise Manager; Oracle People Soft; Oracle EssBase, Hyperion Financial Management (HFM)

ETL Tools: Informatica 9.5.1/8.x, MS SQL Server Integration services (SSIS) 2005-2008

Data Modeling and Data Governance: ERWIN 7.x, ERWin Data Governance, MS Visio 2003-Office 365, CollibraReporting and Analysis Tools

(Business Intelligence): IBM Cognos 8.1-10.2.1; IBM Cognos TM1 Executive Viewer 9.5-10.1; OBIEE 11g, Oracle HFM (Hyperion Financial Management), Oracle Hyperion Financial Reporting, Tableau 6.x-10.x, MS SQL Server Reporting services (SSRS) 2005, QlikView, Crystal Reports 8.5-10; Oracle EssBase, EAS, SmartView v11.1.2.1, ThoughtSpot, Paxata

Programming Skills: SQL, PL/SQL, VBA, C, JAVA, HTML,XML, JAVA Script, CSS. C#, DHTML, Visual Studio 6 (Visual C++, ASP.NET, VB.NET), Windows Forms, IIS 6.0, UML, OOD, ActiveX, COM, OLEDB, ADO, DAO; MAXL; Shell script (Unix)

Operating Systems: Windows 7/Vista/2000/2003/NT/XP; UNIX; MS-DOS

Scheduling Tools: IBM Tivoli Workload Scheduler (Maestro); ESP Job Scheduler, Control M Scheduler, UC4; CA Workload Automation V11.3.2.0

Web Development Tool: MS SharePoint 2007/2010; Dreamweaver 8; WordPress 4.9.5

Software Suites: Microsoft Office Suite 2003-Office 365 (MS Project, MS Visio, MS Access, MS Excel, MS Word,MS Outlook etc.); Adobe (Adobe LiveCycle Designer, Acrobat XI), etc; Ab Initio’s Data Quality Environment (DQE); IBM Lotus Notes

SFTP Software: IPSwitch WS FTP 12.3, WinSCP, FileZilla

Other: Microsoft Azure, Amazon Web Services (AWS), Hadoop, CA Clarity PPM; Microsoft Dynamics AX 2012; ServiceNow, JIRA, Team Foundation Server (TFS), Ariba, TFS, Caliber 11.3; Borland StarTeam 2009; HP Quality Center 10; PS Eagle Investment System; iRise (Visualization tool); Factory Talk view studio; RSlogix5000; RSlogix 500; Melsoft GX Developer; E-designer; Autocad; Pspice; mentorgraphic tools; VHDL; PuTTY v0.60, DBeaver 4.3.0

PROFESSIONAL EXPERIENCE:

Confidential, El Segundo, CA

Lead BI Analyst / Lead Business Systems Analyst - BI

Responsibilities:

  • Collaborated with the key Stakeholders, Senior Executives to develop the Data Warehouse and BI (Business Intelligence) processes, strategy and analytics roadmap for IT Data Services Department.
  • Outlined specific project plans and milestones for BI & Analytics initiatives.
  • Productized cloud and big data services and solutions and promoted incremental adoption of new technologies across BDs.
  • Wore multiple hats to facilitate department’s needs resulting in team productivity.
  • Performed role as a Scrum Master and worked with technical and business teams to define appropriate technical solutions following AGILE methodology for development and enhancements.
  • Partnered with data owners across different Broker-Dealers (BDs) to understand business requirements and reporting/analysis use cases and helped create efficient and effective reporting dashboards.
  • Documented data definition, data dictionaries, metadata of various data warehouses, databases and data-marts of the applications to ensure industry standard technical documentation practice.
  • Provided hands-on support to provision data from a variety of internal sources.
  • Built reporting and meta-data models to support strategic data initiatives.
  • Provided guidance and insight on BI development techniques and prototyping.
  • Quantitatively analyzed data errors and issues and determined the cause and took initiative corrective action after documenting it in JIRA.
  • Led the Enterprise Data Quality Management project resulting in an improved performance of the reports, standardized and harmonized data quality across various BDs.
  • Contributed to the maturation of the BI environment, including information & data acquisition, management and delivery solutions.
  • Actively participated in the development process with ETL team and led both on-shore and off-shore team in the development efforts meeting the business requirements deliverables on time and budget.
  • Prepared for and lead project team (both onshore & offshore team members) and executive steering committee meetings; communicated with impact and transparency.
  • Promoted and facilitated the development of self-service capabilities for the business in the access and reporting of data.
  • Contributed and engaged business partners across various BDs in Data Governance program.
  • Analyzed and solved complex business problems, Presented and Trained users to adopt to newer technology BI reporting solutions.

Environment: MS Office 365 Suite, MS Project 2013-O365, MS Visio 2013-O365, MS PowerPoint 2013-O365, MS Excel 2013-O365, MS Access 2013-O365, SQL Server 2008-14, ThoughtSpot, Paxata, QlikView; Splice Machine, Cloudera, Hadoop, Informatica 9.5.1, MS SharePoint O365, Unix, PuTTY v0.60, ServiceNow, SQL Developer, Oracle 10g-11g, OBIEE 10.x,11.x; IBM Cognos TM1 Architect 10.2.2.0; Oracle EssBase 11.1.2.1, Oracle Agile PLM, SmartView 11.1.2.5.520, Service Now; IBM Cognos 8 BI tool v10.2.1, IBM Cognos TM1 Executive Viewer 9.5-10.1, JIRA, TestRail, Confluence; Slack

Confidential, Burbank, CA

Process Improvement Consultant/ Sr Technical Specialist

Responsibilities:

  • Implemented the recommendations of intelligence reporting and management.
  • Interacted with various levels of client personnel, including c-level Executive Management and other Finance Department Personnel to gather requirements and shared finding through executive summary of the findings.
  • Provided industry and/or technology expertise to DTSS team and Partnered and worked collaboratively with IT leadership to establish project approach, timeline, and staffing requirements.
  • Provided advice and guidance throughout the project lifecycle and successfully implemented Process Improvement using AGILE methodology improving the financial cutover period with focus towards customer centricity.
  • Contributed to the development of methodologies, approaches, and models as per industry standards.
  • Efficient team-player and contributed individually ensuring accountability.
  • Mentored team members, assisted, trained users for request raised through service-now.

Environment: MS Office 365 Suite, MS Project 2013-O 365, MS Visio 2013-O365, MS PowerPoint 2013-O365, MS Excel 2013-O365, MS Access 2013-O365, SQL Server 2008-14, SSIS 2008-14, Informatica 9.5.1, MS SharePoint O365, Unix, PuTTY v0.60, ServiceNow, SQL Developer, Oracle 10g-11g, OBIEE 10.x,11.x, SAP BusinessObjects Enterprise 14..0.5.882 ; IBM TM1 Performance Modeler 10.2.2.0; IBM Cognos TM1 Architect 10.2.2.0; Oracle EssBase 11.1.2.1, Oracle Agile PLM, SmartView 11.1.2.5.520, IBM Cognos 8 BI tool v10.2.1, IBM Cognos TM1 Executive Viewer 9.5-10.1, JIRA, HP Quality Center 10.0, WinSCP v3.7.5; UC4 Scheduler; CA Workload Automation V11.3.2.0; Confluence; Slack

Confidential, El Segundo, CA

Lead Business Analyst -IT / IT Project Manager

Responsibilities:

  • Established and implemented fully functional project management functions for scope management, issue/risk management, workplan management, quality management, deliverable management, and resource management.
  • Partnered and worked collaboratively with IT leadership to establish project approach, timeline, and staffing requirements.
  • Strategically assembled the team to meet the demand and budget of the project.
  • Demonstrated executive impact and integration with project leadership team; built trust and credibility with project team members.
  • Developed and delivered against comprehensive project workplan, drive execution and report progress using enterprise project management tools.
  • Ensured development and sign-off of project scope, adhere to change management process.
  • Delivered PMO & GIT (Global IT) Operational Excellence by collaborative work effort.
  • Facilitated thorough issue/risk management and provide oversight for on-time resolution/mitigation/escalation.
  • Managed deliverable, review and approval process, made certain that all deliverables align with standards and receive proper tracking and timely sign-off.
  • Used Project Methodologies (such as waterfall, AGILE, etc) depending upon the scale of the project to ensure timely delivery of the application development.
  • Managed all cross-program dependencies; evaluated impact to project plan and resourcing and communicated impact analysis to various application team project managers.
  • Continued to enhance company’s project management processes and supporting toolkit.
  • Provided leadership in organizational adoption of common project delivery methodology and tools.
  • Developed formal technical mentoring and support relationships with GIT resources to help address common project management challenges.
  • Boosted ITIL-based service and customer satisfaction metrics as a result of implementing procedures for IT incident monitoring. Document and Maintained RFPs and vendor contracts.
  • Managed and acted SME for BI support channels/team to match functionality to Finance department’s business requirement through thorough documentation and being a liaison.
  • Maintained a positive outlook with an optimistic and professional attitude at all times.
  • Wore multiple hats and mentored & assisted technical team in development phase when needed.
  • Ensured requirement specifications are aligned with industry standards and best practices

Environment: MS Office 365 Suite, MS Project 2010-O365, MS Visio 2010-O365, MS PowerPoint 2010-O365, MS Excel 2010-O365, MS Access 2010-O365, SQL Server 2008, SSIS 2008, Informatica 9.5.1, MS SharePoint 2010, AWS, Unix, PuTTY v0.60, ServiceNow, SQL Developer, Oracle 10g-11g, OBIEE 10.x,11.x, Oracle EssBase 11.1.2.1, Oracle Agile PLM, SmartView 11.1.2.5.520, IBM Cognos 8 BI tool v10.2.1, IBM Cognos TM1 Executive Viewer 9.5-10.1, Oracle Hyperion Financial Management, Oracle BI Publisher, Oracle Peoplesoft, Tableau 9.3, TFS (Team Foundation Server), JIRA, HP Quality Center 10.0, WinSCP v3.7.5; UC4 Scheduler; CA Workload Automation V11.3.2.0

Confidential, Wilmington, DE

Lead Business Systems Analyst / IT Project Manager

Responsibilities:

  • Defined processes and tools best suited to each project. Moved between agile and waterfall approaches depending on project specifics and client goals, creating detailed project road maps, plans, schedules and work breakdown structures (WBS).
  • Led and Coordinated between the onsite as well as offshore development team. Focused teams on business objectives and tracked progress to ensure project milestones were completed with the desired results on time and on budget.
  • Mitigated risk factors through careful analysis. Anticipated and managed change effectively in rapidly evolving Global business environments.
  • Maintained and ensured the consistency, integrity and accuracy between various databases (including the Solvency II data warehouses, the General Ledger System and other reporting databases).
  • Successfully completed employer offered courses like PMP Power Prep; Agile; Managing Global Projects; Clarity Project & Program Management; Negotiation, Conflict Resolution and Brainstorming Skills in a Cross Cultural Context; etc.
  • Followed AGILE principles and standards for successful delivery of the DW/BI Projects.
  • Played a technical lead role in designing and delivering large-scale ETL solutions using Informatica and multiple database technologies (MS SQL Server, Oracle).
  • Administered the SQL-based report processes, including monitoring SQL processing and reviewing stored procedures and scripts when needed.
  • Partnered and worked with other project managers and business owners through the whole SDLC process, understanding and refining systems requirements, clearly documenting the development process.
  • Collaborated with Product Manager & Project Specialist to develop Project Team Structure, Organization Chart and Project Definition.
  • Developed new periodic reports as requested by other departments in the company and Re-engineered existing reports to the best practice methods. Authored Request for Proposals (RFPs) and vendor contracts.
  • Acted as a liaison between user departments, information systems department, 3rd party software developers, and external data recipients.
  • Participated in the design of new applications and data models, including evaluating alternatives, collecting requirements, acceptance testing and documentation.
  • Developed working knowledge and ongoing documentation of all company data structures, including mappings between various database sources and business rules.
  • Given presentations and provided status report about the project(s) during weekly PMO status meeting.
  • Implemented ITIL compliant change management process using standard IT Infrastructure Library (ITIL) and IT Service Management (ITSM) methodologies.
  • Assisted Internal and External Audit teams in fulfilling SOX and other compliance requests.
  • Authored project documentation, policy documents, Use cases, training presentations and provided training to business users.
  • Partnered with business teams to look for opportunities to enhance existing reporting capabilities.
  • Played several roles in Corporate Systems (Actuarial, Risk and Treasury - ART) as well as in Finance Actuarial Department. Played vital role in bridging the gap between IT group and business partners/ customers in the organization and in challenging environment with successful delivery of several projects which led to promotion to Lead Business Systems Analyst/ Project Manager.

Environment: MS Project 2007-2010, MS Visio 2007-2010, iRise, MS PowerPoint 2007-2010, MS Excel 2003-2010, MS Access 2003-2010, SQL Server 2005-08, SSIS 2008, Informatica 9.5.1, MS SharePoint 2007-2010, Team Foundation Server 2013 (TFS) Oracle 10g-11g, OBIEE 10.x,11.x, Oracle EssBase, IBM Cognos 8 BI tool (v8.3)-10.2.1, IBM Cognos TM1 Executive Viewer 9.5-10.1, QlikView, Oracle Hyperion Financial Management, Oracle Peoplesoft, Microsoft Dynamics AX 2012, Caliber 11.3, Borland StarTeam 2009, CA Clarity PPM, JIRA, Ariba, Ab Initio’s Data Quality Environment (DQE), Tableau 8.x, HP Quality Center 10.0, ServiceNow, IPSwitch WS FTP 12.3, WinSCP, FileZilla, iRise

Confidential, Wilmington, DE

Technology Liaison II/ VBA Developer

Responsibilities:

  • Served as a liaison between various Business Teams, Product Teams and Application Development Teams; translated business needs into application and software requirements.
  • Reviewed project requests or change requests, conducted data gathering interviews and translated business needs into application and software requirements by delivering a detailed Business Requirements as well as Functional Specification documents.
  • Represented Business during IT discussion while in Finance Actuarial department and clearly articulated business requirement to IT partners.
  • Determined business application software requirements to address complex and varied business needs. Made recommendation on design solutions to complex and varied business needs, while managing user expectations and project scope.
  • Played a lead role in analyzing business requirements and designing end-to-end ETL solutions that met business needs.
  • Developed process models, data flow diagrams (DFD) using MS-Visio and detailed Business Policies, and modified the business requirement document in several projects.
  • Collaborated with analysts, data modelers and architects during data modeling, data mapping and system specification activities.
  • Acted liaison between Business customers and the technical team and followed AGILE methodology for BI solution.
  • Conducted Joint Application Development (JAD) Brainstorming sessions with team staff to generate leads on Process Improvements suggestions. Co-ordinated with Business Development Team to ensure the closure of Leads.
  • Oversee unit testing, system and integration testing, and performance testing to validate the solution.
  • Utilized available test tools to execute Unit, Functional, Regression and Integration testing of the new code. Documented test results, including defects, following project guidelines by utilizing HP Quality Center.
  • Developed expertise of system functionality to assist business users in development specifications for enhancements, defect resolution.
  • Supported the application owned and performed administrative tasks for granting specific level access to the users.
  • Developed and managed critical relationships with IT, consultants and vendors, internal end users and business customers/leadership.
  • Supported development of Training and Procedures materials as well as communication materials for implementation releases.
  • Worked with Project Manager/Stakeholders to ensure compliance with project plan deliverables.

Environment: MS Project 2007,, MS PowerPoint 2007, MS Visio 2007, ERwin 7.0, MS Access 2003-2007, MS Excel 2003-2007, SQL Server 2005-08, SSIS, SSRS, MS SharePoint 2007, Oracle 10g-11g, Oracle EssBase, OBIEE 10.x,11.x, Crystal Reports 8.5,C#, VB Script, ASP.Net 2.0, ADO.NET, XML1.1, Visual Basic 6.0, IIS 6.0, IBM Cognos 8 BI tool (v8.3), IBM Cognos TM1 Executive Viewer 9.5-10.1, Tableau 6.x, Oracle Hyperion Financial Management, Ab Initio’s Data Quality Environment (DQE),HP Quality Center 10.0, ServiceNow, IPSwitch WS FTP 12.3, WinSCP, FileZilla

Confidential, McLean, VA

Access/ Excel VBA Developer (IT Consultant)

VBA Developer

Responsibilities:

  • Elicited reporting requirements, Developed and deployed process tool in support of registering users of their shared assets of using various repositories based upon prioritized business needs. This Shared Information Asset Access management tool controlled systematically access of users to repositories based on the metadata which are collected in Shared Repository Registry and usages were controlled on periodic basis.
  • Subject Matter Expert (SME) on information requirements, metric planning, report design and online publication processes for the application.
  • Developed web pages with MS Access as backend database with linked excel files.
  • Communicated with various departments including IT and Legal department for various variable funds/products and data reporting issues.
  • Developed Report generation application for Liquidity and Contingency (L & C) datamart project and implemented automated solutions for manual processes.
  • Pulled the source data from Eagle Investment system and used General ledger as source data after analyzing the data using SQL query analyzer.
  • Analyzed financial fundamentals and capital needs for ongoing corporate operations and new projects.
  • Acted as both a user and developer of applications created in Excel and Access to prepare timely and accurate fund performance, financial statements, analytical and reporting on both a periodic and an ad-hoc basis.
  • Trained staff and assisted them to provide support for end-to-end delivery of solution and usage of registry based on business needs.
  • Successful improvements to models and processes that allowed efficiency gains in Cash & Earnings and Business Plan formulation and wrote technical guide and job-aid guide for users.

Environment: MS Access 2000-2003, MS Excel 2003, MS Visio 2003, SQL Server 2000, Oracle8i, C#, Dreamweaver 8.0, VB Script, ASP.Net 2.0, ADO.NET, XML1.1, Visual Basic 6.0, IIS 6.0, Oracle PeopleSoft, DB2, Eagle Investment System, Crystal Reports 8.5

Confidential

Graduate Assistant

Environment: Factory Talk view studio, RSlogix5000, RSlogix 500, Melsoft GX Developer, E-designer, Autocad. Pspice, mentorgraphic tools, VHDL (Very High Speed Integrated Circuit Hardware Description Language), modelsim, Ansys, C, C#, VB 6.0, MS Excel 2003, MS Access 2003

Confidential

Office Assistant

We'd love your feedback!