We provide IT Staff Augmentation Services!

Bi Consultant Resume Profile

Herndon, VA

PROFESSIONAL SUMMARY

  • Seventeen years of experience in the field of Information Technology with responsibilities including Analysis, Design, Development, Implementation and Testing in Client-Server and Web-based n-tier Architecture across multiple business domains.
  • Strong experience in design and development of ETL tool kits using SSIS and Business Objects Data Services
  • Strong experience in analytics, enterprise data management, data warehousing and business intelligence systems
  • Proven experience in Database Administration, Security, Database Design, Data Modeling, to design High Availability and Disaster Recovery solutions using AlwaysOn, SS Analysis Services SSAS
  • Strong experience in Reporting Tools: SS Reporting System, BO Universe Designer, Webi and Crystal reports
  • Worked as solution architect to develop number of database solutions
  • Proven experience in Database Programming using RDBMS databases like SQL Server 2000/ 2005/2008r2/2012, ORACLE7.x/8.x/9i/Oracle 10g/11g using SQL, T-SQL and PL/SQL for querying against databases and for writing Stored procedures, Views, Triggers and Cursors, in NoSQL database MongoDB.
  • Strong experience in in logical data modeling, SQL query performance tuning and improving database efficiencies using Merge Replication, Data compression, partitioning of large tables etc.
  • Strong experience in developing applications using VB.NET, C .NET, ASP.NET, SOAP, XML, ADO.NET, JavaScript, IIS, HTML, WCF, REST
  • Used Version Controlling and Work Item Tracking tools such as Team Foundation Server TFS
  • Experience working in an Agile project lifecycle SCRUM
  • Proven track record within the areas of planning, quality assurance, designing, planning governance and application consolidation, project management, managing the scope, time and quality in all phases of the project.
  • Experience implementing various large scale IT enterprise projects in the Local and State governments, Private industry, Retail, Professional Societies and Trade Associations.

Technical Skills

  • Database Technologies: RDBMS: MS SQL Server 7.0/2000/2005/2008r2/2012, SSIS, SSAS, MS Access
  • NoSQL database - MongoDB
  • 2000, Oracle 7x/8i/9i/10g/11g, Business Objects Data Services, TOAD
  • Reporting Tools: SSRS, Crystal Reports, BO Webi Reports, Impromptu Cognos Reports
  • Microsoft Technologies: ADO.NET, ADO, ODBC, OLEDB,.NET Framework 1.1/2.0/3.5/4.0/4.5
  • Languages: VB.NET, C , C/Pro C, C , XML, SQL/T-SQL/ PL/SQL
  • Development Tools: Visual Studio.NET 2003/2005/2008/2010/2013
  • Operating Systems: Windows NT 4.0/95/98/XP/2007, UNIX System V R4.0, AIX UNIX
  • Web Technologies: ASP.NET, HTML, JavaScript, CSS, SOAP, REST, WCF, IIS

Professional Experience

Confidential

BI Consultant

Accomplishments:

  • Worked as solution architect to develop the database and BI solutions
  • Design and development of ETL tool kit using SSIS including .NET scripting component
  • Developed number of SSRS reports from TFS data warehouse to generate the metrics to track the development estimates, progress and effectiveness of the development process
  • Worked for Database Administration, Security, Database Design and to design High Availability and Disaster Recovery database solutions using AlwaysOn, improved the database efficiency and availability by implementing Merge Replication
  • Responsible for database performance tuning - used different techniques for example, Data compression, partitioning of large tables, Piecemeal Restore, etc.
  • Designed and created data warehouse Data Model Star schema with fact and dimension tables, Data Marts, Operational Data Stores and worked to build cubes using SS Analysis Services SSAS .
  • Implemented Full Text Search to enable faster search of the data for example, in the scanned documents .
  • Worked on MongoDB for performance improvement for the resource intensive queries to help generate the Reports faster and fast search on the user application
  • Worked on performance improvement and tuning of number of SQL queries for which users were getting time-outs, Deadlocks etc.
  • Established the Best Practices and Standards for SQL query performance in application
  • Design and develop the processes for metadata management and master data management
  • Design and builds the data processing jobs to load the data into various data marts
  • Logical data modeling using Erwin and Microsoft Visio
  • Designed and developed the internet application in ASP .NET, C called Code-Mapper to map the codes between Legacy database and Configuration Application database during data conversion
  • Wrote complex queries using CTEs, etc. , stored procedures, Triggers, Views, and Cursors using SQL Server.
  • Design and developed UI interface by developing .NET C screens and web interface using ASP .NET for the ETL tool kit

Environment: SS Integration Services SSIS , SSAS, SS Reporting Services SSRS , SS Analysis Services SSAS , TFS, SQL Server 2008r2/2012, ApexSQL Doc, Microsoft Visio, Erwin , MongoDB, Visual Studio 2008/2010/2013, VB .NET, ASP.Net, C .Net, VB Script, XML, SOAP, REST, HTML

Confidential

Sr. Technical Consultant/BI Consultant

Accomplishments:

  • Managed multiple clients at the same time - projects ranging from 1 million to 3 million
  • Implemented the TMA Resource flagship enterprise product Personify for multiple customers.
  • Data Migration and data conversion using SAP Business Objects Data Integrator/Data Services 3.2/4.0
  • Involved in Logical and Physical Data modeling for different modules of complex CRM/ERP system for Professional Societies and Trade Associations using Erwin tool.
  • Designed and Developed Complex application for ETL Extract Transform Load into Data Warehouse and Transactional databases using SSIS.
  • Led the estimation efforts in Discovery phase, Design and Development phase along with a complex data migration project and managed the scope, time and quality of the project in all phases of the project
  • Designed and developed complex data migration tools to migrate data from different data sources.
  • Worked on Business Objects Universe design, Webi Reports
  • Designed and created data warehouse data model star schema with fact and dimension tables using SSAS.
  • Provided trouble shooting in Data profiling, Data Cleansing, Data Auditing, performance tuning.
  • Designed and developed the processes for metadata management and master data management
  • Designed and developed number of reports using Crystal reports and SSRS
  • Created planning governance process for multiple clients Several clients 4 had multiple systems which needed effective governance solution I helped put together a plan to reduce their cost, increase efficiencies and improve consistency.
  • Managed overseas development teams
  • Knowledge of Financial Accounting / Accounts Receivable systems
  • Prepared program design and Functional specifications and preparing test cases for QA team as well as UAT.
  • Maintained source code in TFS and preparing program design specifications.
  • Wrote complex queries using CTEs, etc. , stored procedures, Triggers, Views, and Cursors using SQL Server.

Environment: Visual Studio 2005/2008/2010, Crystal Reports, SS Reporting Services SSRS , SSAS, TFS, SQL Server 2005/2008, Oracle 9i/10g/11g, TOAD, BO Data Integrator and Data Services 3.2/4.0, Business Objects XI r2, SSIS, Microsoft Visio, Erwin, ASP.Net, VB.Net, C .Net, C , WCF, SOAP, XML, HTML

Confidential

Team Lead/ Solution Architect

Accomplishments:

  • Managed multiple clients at the same time
  • Implemented enterprise solutions for the multiple clients
  • Created the project plans, scheduling and resource management
  • Implemented the quality processes in projects as per CMMI methodology
  • Involved in Logical and Physical Data modeling for different modules of complex CRM/ERP system
  • Data migration from legacy systems to Oracle and SQL Server databases
  • Wrote functional/technical specs for the ETL process to load data from various data sources into the Data Warehouse using DTS/SSIS.
  • Extensive development in Oracle and SQL Server using PL/SQL
  • Developed batch processes in Pro C and VC , VB .NET
  • Developed number of Oracle Reports and Crystal Reports
  • Interacted with users for collecting the requirements
  • Analyzed business requirements and based on that writing Functional requirements and design specifications
  • Wrote Queries, Stored Procedures, and Triggers using SQL Server.
  • Prepared test plan for QAT, UAT and handled unit testing, regression testing.

Environment: Visual Studio 2003/2008, Oracle Reports, Crystal Reports, Impromptu Cognos Reports, Visual SourceSafe, TFS, SQL Server 7.0/2000/2005, Oracle 7.x/8.x/9i/10g, DTS, SSIS, Pro C, C , C , VB.NET, ADO, ADO .NET, Windows, UNIX.

Confidential

System Analyst

Accomplishments:

  • Interacted with users for collecting the requirements.
  • Wrote the application using C/C on AIX and written many UNIX shell scripts programs
  • Development of a Standards Auditor tool for PONL applications. It was a Parsing tool. It was developed by using Lex Lexical Analyzer , YACC Parser Generator and in C on AIX UNIX. It is written for to check the programming quality standards of the COBOL programs and to report the coding discrepancies, as per standards.
  • Enhancement and maintenance support for different modules and tools Written in Shell scripts, AWK, SED and Perl and prepared test plan for QAT, UAT and handled unit testing, regression testing
  • Involved in QA processes, Project Monitoring Reviews/Audits PMR
  • Wrote Queries, Stored Procedures, and Triggers using Oracle

Environment: C, Shell scripts, AWK, SED, PERL, Pro C, Oracle PL/SQL, LEX Lexical Analyzer , YACC Parser Generator , AIX 4.2 UNIX, ClearCase tool, Oracle 8.0, Oracle7.3.4, Forms3.0, Oracle Designer 2000

Confidential

System Analyst

Accomplishments:

  • Interacting with users for collecting the requirements
  • Analyzing business requirements and based on that writing Functional requirements and design specifications
  • Involved in supporting the existing system and developing new enhancements
  • Coded stored procedures, triggers and views using Oracle 7.
  • Developed reports in Oracle reports
  • Involved in implementing the system in test and production environment.

Environment: Oracle Reports, Oracle Forms, PL/SQL, Oracle 7.

Hire Now