SUMMARY:

• Ninteen years of experience in Software Application Design & Development, BI Development, Quality Testing and Implementation.
• More than Ten Year Experience in Extracting Agency’s data from Florida FLAIR State Accounting System and building data warehouse. Knowledgeable in Grants, Budgets, Contracts, Invoices, Vendor Authorization, Vouchers, Warrants, Tier I and Tier II datasets.
• Skilled in Data Classification, Securing data, Access levels, data Encryption, backup encryption, Secure FTP. Obtained relevant security clearances and underwent background checks.
• Experience in Data Warehouse Development using SQL Server Enterprise edition 2012, MDX, SQL Server Analysis & Reporting Service, ETL Packages using SQL Server Integration Services, PerformancePoint Dashboards, Tableau, SharePoint Server 2013, Oracle (PL/SQL), Excel Power Pivot, DAX.
• Logical and Physical data modelling, Designed & implemented OLAP multidimensional databases, dimensional modelling using star schema, Fact tables, Partition tables, Measures and Staging databases. Performance Point dashboards with KPI’s, Score cards, Graphical reports & Charts.
• Experienced in architecting ETL SSIS Packages, Design ETL packages to load Staging, dimensional and Fact tables, Incremental data loads, Change data capture, Fuzzy lookup transformation, Slowly changing dimension, Partition processing. ETL data mapping, Data dictionary, Metadata management, data governance, implemented high volume data migration from Oracle/Teradata to SQL Server Databases. Configure the SQL Server for Transactional and snapshot replication, subscriber and publisher.
• Experienced in SQL Server Performance Tuning, using Dynamic management views, SQL Server Profiler,
• Database Engine Tuning wizard, generating Query plans and T - SQL Query/Procedure Optimization. Update Statistics for performance. Indexing for performance, column store index.
• Strong consulting experience in implementing RDBMS based Business Applications, using ASP.NET MVC Framework. C#, SQL Server 2012 OLTP database, JavaScript, Bootstrap v4.0, CSS and JS. Team foundation Server, Visual Studio 2015, Peter’s data entry suite, Scrum methodologies.
• Strong skills in .NET Framework 4.5/4.0, ASP.NET MVC Framework, C#, VB.NET, ASP.NET, Web Services, XML, XSL, Visual Basic 6.0, COM, MTS, ActiveX, ASP, DHTML, HTML/CSS, JavaScript, Cold Fusion 5.0/4.0, Crystal Reports 8.5/9.0, Crystal Enterprise Server, Visual SourceSafe.
• Extensive experience in Architecting Web, E-Payment & Windows applications using Microsoft ASP.NET, VB.NET & Cold Fusion Technologies with SQL Server & Oracle databases. Architect, Developed & Implemented the Web based Management Information Systems, Financial & Budgeting system using ASP.NET, web services, ADO.NET, AJAX & Microsoft Application Blocks with a multi-tier architecture.
• Provided Production support of the Financial, Budgeting System & Management Information System databases. Experienced in security administration, configuration management, performance tuning, and support.

TECHNICAL SKILLS:

Business Intelligence: SQL Server 2012 Enterprise Edition, SQL Server Analysis Service,SQL Server Reporting Services, SQL Server Integration Services,SharePoint Server 2013, PerformancePoint Server, Microsoft Office 2016/ 2013,Excel Power Pivot

ETL Tools: SQL Server Integration Service, DTS, Auto Sys,SQL Data Quality Services, SQL Master Data Services

Databases: SQL Server, Oracle 11g, Teradata 7.0, Access 2016, DB2

Data Modelling Tools: Erwin, Visio 2013

Performance Tools: SQL Server Profiler, Dynamic Management Views, Database Engine Tuning

Reports: SQL Server Reports / 2005, Crystal Reports 9.0/8.5, Crystal Enterprise Server

Dash Boards: Microsoft Office Performance Point Server, SharePoint Server, Tableau 10.3, Microsoft Power BI

Web Development: ASP.NET/ASP, XML, XSLT, Web Services, .NET Framework 4.5/ 4.0 / 3.5, Cold Fusion 5.0, CFML, JavaScript, CSS

Windows Development: Visual Studio Professional 2015/2012, Visual SourceSafe 2005Team Foundation Server 2013: Languages C#, VB, MDX, Transact SQL, PL/SQL, C++: Data Model

Multi: Dimensional modelling, Star Schema, OLTP, OLAP Databases: Middleware

SOAP, COM, MTS: Methodology & Tools

OOAD UML, Agile and Scrum: Development Packages Visual Studio Professional, SQL Server Data Tools, SQL Server Management Studio, PL/SQL Developer,: Cold Fusion Studio.

Servers: Windows Server Enterprise, SharePoint Server, Performance Point Server 2013/2010, IIS 7.0, Cold Fusion Application Server

PROFESSIONAL EXPERIENCE:

Confidential

Business Intelligence developer Consultant

Responsibilities:

• Architect the Multidimensional OLAP Database Design, Star schema and the ETL data flow.
• Create Dimensions, Fact Tables, Data Source Views, Cube Structure, Role and Security Management.
• Create Measure groups, KPI’s.
• Create SSIS Packages to incrementally load the Dimensional data, Slowly changing dimension, Fact tables and process the cube partition.
• Configure Change data capture.

Environment: Microsoft Visual Studio Professional 2012, Microsoft .NET Framework Version 4.7SQL Server 2012 Enterprise Edition, SQL Server Reporting Services, SQL Server Analysis ServicesSQL Server Integration Services, SQL Master Data Services, SQL Server Data Quality ServicesErwin Data Modeler r9.64, SharePoint Server 2013, PerformancePoint Server 2013Team Foundation Server 2012, Tableau Desktop 10.3., Microsoft Power BI Desktop, Microsoft Office 2016Windows Server 2012 Enterprise. IIS 7.0

Confidential

Responsibilities:

• Designed the Budget tracking system, gathered user requirements, created functional specifications.
• Designed and developed the SQL Server SSIS ETL packages to Load data from FLAIR data warehouse.
• Designed and developed the SQL Server Report Budget Analysis at Organizational Level, Drill down at Category level and Object Code Level.
• Designed and developed the Report Access control that allows the district admins to view only their budget.
• RSA2 SQL Server SSIS ETL Package year 2009,2010,2011 and 2016:
• Designed and developed the ETL package to extract data from AWARE and FLAIR to load the Schedule I Expenditures. Each line number consists of a data flow with extraction queries.
• RSA2 SQL Server Reports:
• Designed and developed the following RSA2 reports.
• Schedule I Expenditures and Sub reports for each line number
• Schedule II Expenditures and Sub reports for Aware contracts and Aware Authorizations.
• Schedule III Person years and Sub reports for details
• Schedule IV Carry over funds. 5) Totals by Grant and General Ledger 6) Totals by Grant number 7) Totals by Organization 8) Totals by General Ledger 9) Totals by Contract.
• Decision Matrix Documentation: Designed a Matrix spreadsheet to capture the specification parameters for each RSA2 line number that represents a type of expenditure. The parameters consist of a combination of Grant, ledger numbers, Category, Object codes and extraction strategies.

Confidential

Responsibilities:

• Designed and developed SQL Server SSIS ETL package to extract data for each of the 11 measures form the AWARE case management system
• Designed and develop Reports to display the measures and validate their totals through drill down detail reports.

Confidential

Responsibilities:

• Created Functional specifications and designed the proof of concept
• Designed and developed SQL Server reports to retrieve the audit records.
• Designed the Audit Trail database and its objects.
• Implemented the Audit logging features for the SVES Import / Export package

Confidential

Responsibilities:

• Convert the application to Visual Studio 2015
• Designed the Ticket to work tab
• Designed an ETL process to Export and Import data between SSA and SSRA Application
• Application design & .NET Programming using C#
• Designed the Purchase order \ Invoice module and reports.
• Developed wage extraction module.
• Designed entities, business access logic and data access logic.

Confidential

Responsibilities:

• Implemented the process to import warrant information from FLAIR.
• Designed and developed SQL Server ETL Packages to produce source files for the transformer.
• Update the XML templates as per FLAIR field position and length
• Redesign the Interface manager table objects to accommodate the vouchers and warrants.
• Developed load procedures to update the back logs

Environment: Microsoft Visual Studio Professional 2015, Microsoft .NET Framework Version 4.7VB.NET, SQL Server 2012 Enterprise Edition, Windows Server 2012 Enterprise. IIS 7.0, Peter’s Data Entry Suite 5.0, Telerik UI for ASP.NET AJAX.

Confidential

Responsibilities:

• Designed the ETL Flow to extract incremental data from the DOE Budget management server
• Developed the SQL Server SSIS package

Confidential

Responsibilities:

• Designed the ETL Flow to extract incremental data from the DOE Budget management server
• Developed the SQL Server SSIS package
• Manages Transactions, Vendor Invoices, Warrants, and Receipts, approvals /Cancellations.
• Manages Budget allocations, Fund Sources, tracks Expenditures & Encumbrances.
• Manages Cases, Transfers & Successful Closures.

Confidential

Responsibilities:

• Design and develop SQL Server reports as per specifications
• Create SQL Stored procedures, views and user defined functions
• Create web parts on Share point services and link the reports.
• Other SSIS ETL Packages Designed, Developed and Implemented:
• Case management Data warehouse Package - OLAP Cubes
• Salary Rate Package - datasets from People First
• Service Cost Package - Actual services cost, Authorizations and CRP Contracts.
• Data warehouse Maintenance jobs
• Performance Point Monitoring & Analytics:
• Design dashboards, analytic reports, KPI’s & Scorecards.
• Publish the dashboard to the SharePoint server.
• Design OLAP Cubes using SQL Server Analysis Services:
• Prepared the logical data model using Visio 2007.
• Design & developed cubes using the unified dimension model.
• Prepare the Bus matrix, Identify the dimensions, attributes, hierarchies & Fact data and design using Star schema.
• Develop calculations using Multi Dimensional expressions (MDX).
• Design partitions, aggregations, perspectives & apply roles. Create calculated members, KPI’s & URL Actions.
• ETL to load Data Warehouse using Microsoft SQL Server Integration Services:
• Design ETL Packages to Load Data warehouse from OLTP databases, Develop SSIS packages with audit log & error handling to extract, transform and load data from Mainframe environment to SQL Server Data Warehouse.
• Design dimension loading, slowly changing dimensions and partition processing.
• Used Scripting and components like Derived columns, lookups, split transformation & SCD.
• Configure and Schedule ETL packages.
• SQL Server Reporting Services:
• Developed reports like Budget allocation, Schedule of Allotment balances, Expenditure & Encumbrances trend analysis by categories, Salary Rate Projection, Return on Investment and Contract Costing.
• Used List, Group List, Cross Tab, and Drill down reports with Bar & line charts and published them to the share point server.
• Used MDX & Calculated Members to analyze the current trend & the past 5 Yr average for the State & Federal fiscal years.
• SQL Server Query tuning, Installation & Configuration:
• Tune SQL Queries, generate plans, read statistics, Cost based optimization.
• Installing & Configuring Reporting Services, Integration Services, Analysis Services, Performance Point Planning & Monitoring Services in a distributed topology.
• Databases: Managing File Groups, Configure Back Up, Maintain Partitioned tables & Transaction log shipping.

Confidential

Responsibilities:

• Application design & .NET Programming using C#
• Designed and constructed the Reconciliation module using ASP.Net, C#, ADO.NET
• Gather user requirements, business rules and logic.
• Develop Conceptual design, database design and logical flow.
• Generate technical specifications, mock up screen designs.
• Heavily involved in writing stored procedure, Dynamic SQL, Complex Queries using T-SQL.
• Created Tables, Synonyms, Relationships, Constraints, Stored Procedures, Views and Functions.
• Interacting with client for requirement gathering for the enhancements.
• Design User acceptance test plans and user manual documentation.

Environment: Visual Studio 2010/ 2008, SQL Server, SQL Server 2005 Reporting Services, Analysis Services, Integration Services, SharePoint Server 2007, PerformancePoint Server 2007, Visual Source Safe 2005, ASP.NET 4.0 / 3.5. IIS 7.0.

Confidential, Santa Clara CA

Business Intelligence developer Consultant

Responsibilities:

• Migrated the applications, Schemas, PL/SQL packages from Oracle to SQL Server 2005 using SQL Server Migration Assistant.
• Created Table schema with Constraints, Keys, Indexes and relationships.
• Created views, functions to generate XML output for applications & scheduled them on SQL scheduler.
• Created Stored Procedures, Functions, and Triggers & Prepared logical flow charts for procedures.
• Designed SQL Server Reports.
• Created SQL Batch jobs for applications to send workflow and batch emails.
• Used Quest comparison suite to synchronize schema changes in different environments. esigned SSIS Packages to migrate data from Oracle, Flat Files, and Teradata to SQL Server.
• SSIS Packages were developed for Parallel and serial execution with audit & error logging features using components like Lookups, Derived columns, Script Components and Sequences to load Staging and Fact tables.
• Prepared ETL Scripts for Data acquisition and Transformation.
• Created configuration files & command scripts to execute the packages on daily basis using Auto Sys.
• Created Procedures to Load Dimension Tables to support Hierarchies & Mappings
• SSIS Packages to load the Staging Tables and Procedures to Load Fact tables
• Fine tune the Procedures using execution plan and schedule them to refresh data.

Environment: Visual Studio 2005, SQL Server 2005, SSIS, SQL Server Migration Assistant, SQL Reporting SSRS, SSAS, Oracle 9i, PL/SQL Developer, Quest Comparison Suite, ASP.NET 2.0, ADO.NET 2.0, C#, Visual Source Safe 2005.

Confidential, San Jose, CA

Business Intelligence developer Consultant

Responsibilities:

• Designed Graphical SQL Server Reports with drill down features, bar charts, data points using SQL Server 2005 Reporting services.
• Created Stored Procedures, MDX queries and calculated members for reporting datasets.
• Enhanced the design of cubes, created dimensions, hierarchies & calculated measures.
• Created UI forms & integrated reports to the Web Application.

Environment: Visual Studio 2005, SQL Server 2005, SQL Server 2005 Reporting Services, SQL Server 2005 Analysis Services, OLAP, Eclipse Custom Controls

Confidential

Systems Analyst

Responsibilities:

• Interacted with functional team for functional specification validation and Use Case modeling for the system. Created Use Cases, Class Diagrams and Sequence Diagrams for the modules.
• Modeled business processes by automating transactions with Workflow.
• Developed the Policy Rule Engine Component. Designed and coded user interface and middle tier components using Object Oriented Programming (OOP) techniques in a multi-tier environment.
• Designed and constructed the application using ASP. Net, C#, ADO.NET
• Developed Web Forms, Assemblies, User Controls with Data Grid, User tags
• Used Microsoft Enterprise library for logging, caching, data and Exception handling.
• Created & Consumed web services, SOAP.
• Heavily involved in Designing Web Forms, User Controls, Sitemap, Custom Tags, Master
• Used Microsoft Application Blocks (SQL Helper Class) for executing the database calls.SQL Server 2000 Programming & Query Tuning:
• Heavily involved in writing stored procedure, Dynamic SQL, Complex Queries using T-SQL.
• Created Stored Procedures with Cursors, transactions & dynamic SQL, Functions, Views & Triggers.
• Identified performance bottlenecks, analyzed and improved the performance, using indexing techniques with Index tuning wizard, SQL Trace.
• Created functional and technical artifacts relevant to implementation. Performed code review for code standards, SQL code injection vulnerabilities & SQA compliance.
• Conducted product, POC demo for staff and made them productive in short span of time.
• Maintained SQL Server 2000 Fail over clustering services & Database Differential\Full backups.
• Performed a System study and Database analysis of the existing Information system and prepared the Database migration plan.
• Developed numerous SQL Server DTS packages using VB Script to clean & migrate the data from access databases to SQL Server 2000.
• Improved Performance of reporting tables using Indexing techniques with Index tuning wizard.Data warehouse Setup:
• Designed dimension & Fact tables for Data warehouse & Used Analysis Service, Star & Snow Flake schema model to design cubes for multi dimensional data model.
• Performed Replication, DB Shrinking, Transaction log shipping & SQL Server Backup / Recovery.
• Designed data model, flows and DTS packages to load data from production to Staging.
• Developed SQL Server DTS Packages with VB Script to load Fact data.
• Used Star schema model to design cubes for multi dimensional data model.
• Designed dimensions & procedures to load them systematically.

Environment: DTS, SQL Server 2000, VB Script, SQL Server Analysis Service, Access 2000, Windows 2000 Advanced Server. NET Framework 2.0/1.1

Confidential

Responsibilities:

• Prepared Functional Requirements and Specifications interviewed the financial Domain experts and documented the business processes.
• Developed middle-tier components, Assemblies for Aging & Analysis Process using C#.
• Designed the UI, Created Web Forms, Integrated the kiosks Card reader functionality.
• Used SQL Server stored procedures and Crystal Reports to generate Excel and PDF reports
• Designed the following reports: a). Sales Commission Claim b). Product Revenue Analysis c). Invoices created / balance payment d). Payment analysis using Crystal Reports.
• Analyzed the resulting data to ensure conformance with the SQA.
• Enhanced the product by load testing and increased performance.

Environment: C#, ASP.NET, ADO.NET, Web Services, XML, XSL, IIS 5.1, SQL Server 2000, Crystal Reports 9.0, Visual SourceSafe

Confidential

Responsibilities:

• Database design and UI Design for the leads tracker.
• Created a class library for Database access layer using ADO.NET.
• Developed numerous Win forms, Class libraries, Class Modules and User Controls.
• Integration, Testing, implementation with MIS Database.
• Enhanced the application’s performance by load testing and fine tuned performance by Indexing.
• Provided to the users.

Environment: VB.NET, ADO.NET, ASP.NET, Oracle 9i, Crystal Enterprise Server, Crystal Reports 8.5, IIS 5.0.

Confidential

Responsibilities:

• Designed data model, flows and DTS packages to load data.
• Developed SQL Server DTS Packages with VB Script.
• Developed conversion modules to remap the data fields and clean them.

Environment: VBScript, SQL Server 2000, DTS, Clarion, Novell Netware.

Confidential

Responsibilities:

• Developed the deferment, Revenue, Sales reporting modules.
• Developed middle tier Components using C# to Process Deferment.
• Developed deferment & Revenue projection report using Crystal reports.
• Designed product revenue analysis module.
• Handled POC demo to the internal Audit team and Risk mgt before implementation.

Environment: C#, ASP.NET, ADO.NET, Web Services, XML, XSL, Crystal Reports 9.0, SQL Server 2000 (Clustered), Crystal Enterprise Server, IIS 5.0, Visual SourceSafe

Confidential

Responsibilities:

• Initial study, design, implementation and documentation.
• Designed the Payment module based on the guidelines provided by CITI Bank.
• Coordinated with CITI Bank team to conduct production tests.
• Conducted the different Test Case Scenarios & verified the results with CITI Bank.

Environment: C#, ASP.NET, SQL Server 2000 (Clustered) Crystal Enterprise Server, IIS 5.0, SSL, and VeriSign Server Cert.

Confidential

Responsibilities:

• The Objective of the project is to migrate the merchant’s web storefront from Citibank’s SET payment gateway to SSL payment Gateway following Visa’s decision to phase out its SET Electronic Service by September 2002. This switch to SSL brings with it immediate apparent benefits to the Merchant. Namely, there is no longer a need to purchase or renew SET merchant s to conduct electronic credit card transactions and will also enable faster transmission of electronic transactions.

Environment: SQL Server 2000, Cold fusion 5.0, Crystal Reports 8.5, Crystal Enterprise Server, IIS 5.0.

Confidential

Responsibilities:

• Developed Assemblies to Execute the Transaction Component.
• Developed the Transaction \ Authentication flow based on CITI Banks specification to interact with

Environment: SQL Server 2000, Cold fusion 5.0, Crystal Reports 8.5, Crystal Enterprise Server, IIS 5.0.

Confidential

Responsibilities:

• Prepared Functional Requirements and Specifications. Documented business processes from domain experts.
• Database Design review, Normalization, Creating relationships and planning Index’s.
• Developed stored procedures, Views, Triggers, Complex SQL queries and Dynamic SQL.
• Developed modules such a Payment, Enrolment, Sales Commission, And Invoicing using C#.
• Unit testing, Integration & enhancement of application.
• Prepared Test Case Scenarios, Responsible for conducting User Acceptance test and sign off.

Environment: ASP.NET, ADO.NET, JavaScript, CSS, SQL Server 2000 (Clustered), Crystal Enterprise server, IIS 5.0

Confidential

Responsibilities:

• Designed, Developed Cold Fusion Templates, Custom Tags and Configured the Cold Fusion Application Server.
• Provided Customization based on user Requests.
• Provided Operational Support, Implementation and Enhancements.

Environment: Cold fusion 5.0, JavaScript, Crystal Reports 8.5, SQL Server 2000, IIS 5.0, Windows 2000 Server, Cold Fusion Application Server.

Confidential

Systems Analyst

Responsibilities:

• Performed Design Review and Documentation.
• Provided Offshore Operational Support for the Client in Germany.
• Provided Customization based on Client requests

Environment: PHP, HTML, DHTML, JavaScript, Windows NT

Confidential

Senior Programmer Analyst Consultant

Responsibilities:

• Designed, Developed, Unit Tested and Implemented the module at the Client Site in Singapore.
• Provided Enhancement & Customization based on clients request.
• Integrated the Module to the E-Learning System.
• Prepared Documentation and User Manual.
• Provided to the Consultants.
• Responsible for UAT and Sign Off.

Environment: ASP, ADO, Java Script, Crystal Reports 7, Oracle 8, Crystal Enterprise Server, IIS 4.0. On Windows Platform

Confidential

Responsibilities:

• Design, Development and Testing.
• Designed reports using Crystal Reports.
• Prepared Documentation and User Manuals.

Environment: Visual Basic 6.0, Cold fusion 4.0, Crystal Reports 7, Oracle 8, Windows NT, IIS 4.0

Confidential

Software Engineer

Responsibilities:

• The system involves in maintaining General / Sub Ledger Accounts. (Account categories include Asset, Liability, and Expenses & Income). (Receipt & Payments) from customer, suppliers & others.

Environment: Visual Basic 6.0, Crystal Reports 7.0, Far Point Spread Control, SQL Server 7.0, Windows NT

Confidential

Responsibilities:

• Designing Win forms, Class Modules, Creating Active X controls & Active X DLL’s and reports.

Environment: Visual Basic 6.0, Crystal Reports 7.0, SQL Server 7 on Windows N