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.