We provide IT Staff Augmentation Services!

Bi Solution Architect / Data And Business Analyst Resume

SUMMARY:

Detail and results oriented analyst(BI, Data, Reporting, and security) with experience and proven track record in managing technology and operations teams. MBA in project and technology management with 12 years of hands on experience with technical proficiency and management skills to work effectively in a team and across cross functional groups. Background in technical areas including proficiency in Oracle, SQL, .Net along with BI and project management skills will provide effective and proactive leadership for organization.

PERSONAL STRENGTHS:

  • Highly organized and dedicated, with positive attitude.
  • Able to handle multiple assignments under high pressure and consistently meet tight deadlines.
  • Thrive on working in a challenging environment.
  • Able to work in team and individual.

TECHNICAL SKILLS:

Programming Languages: Visual Basic 6.0, C, C++, Java, C#, ASP, ASP.Net

Web Technologies/Systems: HTML, ASP, VBScript, Microsoft Front Page 2000, Macromedia Flash 5.0

Database Technologies / Systems: ODBC, Oracle 8i to 11GR2, Access 2000, Microsoft SQL Server 2000 to 2012, PL - SQL, SSRS, SSAS, SSIS, Data Warehousing, Data Mart, Business Intelligence

Operating Systems: Windows 9x/NT/2000-2012, UNIX

Other: MS Performance Point, SharePoint (2010, 2012), MS Project server, Crystal Report, Dash-boarding with Proclarity and MS BI, Cognos, Oracle Hyperion

EXPERIENCES:

Confidential

BI Solution Architect / Data and Business Analyst

Responsibilities:

  • Define project scope time to time, goals and deliverables that support business goals in collaboration with senior management and stakeholders.
  • Prepared requirements analysis for the product in order to create reporting tool and created System analysis and technical design document for the new reporting tool.
  • Worked with business stakeholders to define business key performance indicators (KPIs) and develop semantic layers in the BI tool to support these KPIs; advised power users of the reporting tool on best practices for the BI tool and best use of semantic layers; managed end-user access to semantic layers of the BI tool.
  • Provide project deployment and life cycle support for DB and software system.
  • Work in co-ordination with the consulting team to analyze the existing flaws in the administration modules validation procedure and created solution by implementing new validation modules.
  • Provided management support to the offshore/onsite End-to-End integration/ Regression Test Team.
  • Managed the reporting and analytics platforms to ensure that scheduled jobs were successfully run and analytics data met timeliness/completeness requirements
  • Maintain work flow and budget requirement for project and system.
  • Support corporate planning of IT strategies and policies.

Skill Set: OBIEE, SSRS, MSSQL BI(2012), MS Projects, Visio.

Confidential

BI Solution Architect / Analyst

Responsibilities:

  • Established cross-functional relationships and directed all requirements gathering, data analysis and documentation for enterprise projects to centralize data into one multi function data ware house system with advance reporting processes.
  • Assisted in developing business intelligence strategies in coordination with data architect.
  • Managed project management with scope of work, cost estimate, budget, work force, resource management, and deliverance.
  • Managed full life cycle development of business intelligence systems for company.
  • Provided support for Reporting services such as Analysis Cube Processing, Reporting services Pro-Clarity.
  • Coordinated with users and developers for all data models techniques.
  • Applied Improved team production and efficiency with cross training along with best practice of project and team management process.

Environment: Used: UML, OBIEE, Hyperion, SQL 2005 and 2008, .Net.

Confidential

DBA / BI Analyst

Responsibilities:

  • Work closely with application developers and business users to design databases
  • Create and maintain BI environment for groups and departments in company.
  • Helped group to configure Replication, Log Shipping, and Failover clustering to meet customer needs for production environment to development environment.
  • Managed project management with scope of work, cost estimate, budget, work force, resource management, and deliverance.
  • Established cross-functional relationships and directed all requirements gathering, data analysis and documentation for enterprise projects to centralize data into one multi function data ware house.
  • Supported multi dimensional data modeling for data warehouse system.
  • Provided support to create better database architecture to support business intelligence.
  • Managed full life cycle development of business intelligence systems for company.
  • Schedule and Deploy schema changes, data conversion, data fixes and packages throughout many different environments including Development, System Test, UAT, Production, Training and several others
  • Lead a team of database developers in the extraction, transformation, and load process from of a different file base system to SQL base such as Access, Oracle, Excel, and flat files.
  • Convert customer requirements into logical and physical database designs and models.
  • Created migration process from one SQL version to next.
  • Create, modify, and maintain written documentation and modify existing stored procedures, triggers, and views.

Environment: SQL Server 2000,2005 and 2008, Oracle 8i, 9i, & 10g, SSRS,SSIS,SSAS.

Confidential

Sr. Database Administrator / Developer

Responsibilities:

  • Work closely with application developers and business users to design databases
  • Design databases using Visio and Erwin at the ORM, logical and physical level.
  • Implementation Batch processing Performance monitoring and tuning SQL Trace / SQL Tuning Oracle Logminer Process automation.
  • Oracle Fail Safe (High Availability) implementation and support Database replication Data cleansing, extraction and monitoring SQL Programming PL/SQL Programming Backup plans.
  • Supporting Oracle 9i database system and optimizing the requirement of the system.
  • Storage re-arrangement and savings Oracle database security and patching Oracle database capacity analysis and planning Archived records Oracle database (data warehouse) implementation.
  • Participate in the definition, documentation and application of our Coding and Naming Standards.
  • Provide support to developers/testers to resolve technical problems with data and/or databases.
  • Lead a team of database developers in the extraction, transformation, and load process from of a different file base system to SQL base such as Access, Oracle, Excel, and flat files.
  • Convert customer requirements into logical and physical database designs and models.
  • Perform database maintenance and modifications to ensure databases are operational, as well as diagnose and correct any database environment problems; monitor database usage, and report on database performance and system availability.

Environment: SQL Server 2000 and 2005, Oracle 8i & 9i, VB, ASP, ASP.Net, .Net

Confidential

Database Administrator / Developer

Responsibilities:

  • Monitor MS SQL servers for errors and performance degradation.
  • Creating Stored Procedure in T-SQL, Cursor, and Triggers for database functionalities.
  • Upgrade existing MS SQL Server software to newer versions and/or Service Pack Levels.
  • Set up alerts, operators, SQL Mail, SQL Agent Mail, and notifications.
  • Set up and schedule jobs that perform backups and database structure checks.
  • Develop reports for different department using SQL Server Reporting Services.
  • Created OLAP cubes for SQL Analysis Services.

Environment: SQL Server 2000 and 2005, Oracle 8i & 9i, VB, ASP, ASP.Net, .Net,C#, C++, COM

Confidential

Application Developer

Responsibilities:

  • Responsible for Team co-ordination for the project and delivery of the project.
  • Built web-based applications in ASP, which involved a Search application, Report builder using Crystal Report 8.5 utilities.
  • Wrote Stored procedure and triggers in SQL 2000 for better performance of large query in application.
  • Also created web based reporting application using java, Crystal Report, ASP, and SQL 2000.

Hire Now