Summary

• Professional individual with over 16 years of IT experience in manufacture, insurance, mortgage/banking, sales marketing industries with both technical and business analyst experience reviewing and analyzing the effectiveness and efficiency of existing systems and developing strategies for improving or further leveraging the systems which require liaison between business client and IT departments. Demonstrate the ability to manage multiple projects with tireless energy and dedication.
• Extensive experience in data analysis, data quality, data migration, extraction, transformation, load, data integration, data enrichment, data warehousing, data modeling, designing, coding, reporting, testing and supporting next - generation database solutions on client/server platforms.
• Expertise in building business intelligence and corporate performance management solutions including interactive dashboards, mobile dashboards, kpi, score cards, ad-hoc query, interactive chart reporting, and analysis grid reports with drill through, and drill down capabilities utilizing LogiXML, Tableau, QlikView, Crystal Reports, SSRS, and Nevron Charts.
• Strong experience as a Business Liaison/Business Analyst Responsible for gathering requirements, gap analysis, coordinating business requirements discussion with business and technical teams, prioritizing issues and tasks, ensuring technical team delivers applications according to business requirements within deadline and with quality. Monitor technical team performance and estimations on critical issue resolution and project delivery.
• Strong experience with SDLC and Agile Approach to project work and delivery. Utilize Waterfall-Agile approach to getting projects completed quickly with documentation.
• Exceptional analytical problem solver with great communication skills capable to support customers in and technical teams internal and offshore India .
• Consistently recognized for technical troubleshooting skills used to rapidly and cost-effectively resolve challenging technical data issues.
• Quickly learn and master new technology equally successful in both team and self-directed settings and proficient in a range of computer systems, languages, tools and testing methodologies.

Database/Business Intelligence Experience

Skills

Years of Hands-On Experience

Database Size

Last Used

SSRS, Nevron Charts

Tableau, QlikView, LogiXML

JavaScript, HTML, CSS

SQL Server 7/2000/2005/2008/2012

• ETL SSIS
• Reporting SSRS
• Data Warehousing SSAS
• RedGate Bundle
• Backup/Mirroring/Log Shipping
• Optimization and Indexing
• SQL Agent
• System Privileges
• Team Foundation Server 2012
• IIS 2012
• T-SQL/Triggers/Stored Procedures

Technology Summary

Business Analyst:

Write Business Case, Gather Requirements, Perform Gap Analysis, Research, Mockup Design, Write Functional and Technical Specifications, Write Test Case Plans and Scripts, Bus Matrix, Traceability, Change Control, Coordinate Peer, Business and UAT Testing

Helpdesk Management:

Perform trend analysis on issues and resolution timeframe, Delegate calls to Tier1 Tier3 support, Write Helpdesk Scripts, Meet with business to identify solutions

Systems:

SAP CRM Server, SAP OLTP R3 Server, CICS/ISPF/Mainframe, UNIX, Windows 9X/NT/2000/XP/2K3/Vista/7, VMware, Mac OS Leopard

Business Intelligence:

Databases:

LogiXML 11.3 049 Sp2, QlikView, Tableau 8.2, SSRS, Nevron Charts, Crystal Report, BRIO Query, SAP Crystal Report, Brio Query Report, SAS Reporting

MS SQL Server 7/2000/2005/2008/2012 ETL/DTS/SSIS/SSRS, RedGate, Team Foundation Server 2012, Oracle 8/9i/10i PLSQL, Toad, IBM DB2, MySQL Workbench 6.1 CE, PostgresSQL

Integration Software:

DATAFLUX dfPower Studio Server, Group1 Suite, ERWIN, Entity Modeler

Languages:

SAP CRM Mobile Workbench, SAS 9.2, SAS/STAT, SAS/Access, SAS EG 4.2, Visual Basic/VBScript/Excel VBA/VB.NET, SQL, ASP, C, C . NET, JavaScript, PHP, COBOL/JCL, QMF, PowerBuilder

Source/Test:

Software:

Test Director, SeaPine Software Surround Control, Tortoise Source Control, Team Foundation Server 2012, RedGate Bundle

MS Project, MS Visio, MS Office, Corel WordPerfect

Web Development:

WordPress, Joomla, CMS, XML, HTML 5, CSS, JavaScript, VBScript, ASP.Net, PHP, Macromedia Flash, Dreamweaver, Artisteer 3, Edit Plus, NotePad, Microsoft IIS 6/7/8/2012, Apache Web Server, TomCat

IT Experience

Confidential

Business Intelligence Consultant

Duties included:

• Utilized Logi Analytics LogiXML tools, JavaScript, VBScript, HTML, and CSS to develop and deliver the presentation layer of the solution as outlined in the statement of work from various clients.
• Created advanced interactive reports and charts, drill-down and drill-through reporting, real time dashboards, mobile dashboards, disclosure, and base views for advanced statistical analysis.
• Developed Analysis and OLAP Cube Grids for use by clients to analysis their data.
• Developed prototypes for prospects using LogiXML Studio, HTML, DHTML, JavaScript, and .NET.
• Utilized SQL Server and MySQL to develop queries, stored procedures, and indexed tables for faster delivery of data in the presentation layer.
• Wrote MDX queries as part of creating dashboard reporting for clients with data warehouses.
• Utilized Microsoft IIS, Apache, and Tomcat web servers to deliver .NET and JAVA web applications.
• Analyzed data for reporting and dashboard creation.
• Meet with various customers to gather reporting and data requirements and turn those requirements into LogiXML and QlikView web applications.
• Defined site navigation and created interaction models for both internal and external clients.
• Worked independently or within a small team with a focus on helping clients formulate proper business concepts, interface design, and content presentation.

Confidential

Contractor Database Developer/Business Intelligence

• Implement server and software upgrades and continuous improvements to Manufacturing Execution Systems MES . Responsibilities include following an Agile, Software Development Lifecycle SDLC, and emulating reusable Component-Based Designs within a database. Domain includes disaster recovery and performance standards and audit procedures, new application testing, training, and creating Microsoft SQL queries, SSIS SQL Server Integration System packages, SSRS SQL Server Reporting Services reports and stored procedures. Recommending and implementing an efficient and reliable infrastructure to maximize transactional efficiency when collecting data and warehouse techniques for reporting performance. Understand and support the KRS architecture and software and support the continued evolution of the system throughout Kaisers' plants. Duties included:
• Developed solutions using MS-SQL Server, Transact SQL T-SQL, SSIS, SSRS Nevron Charts, and SSAS
• Utilized RedGate, Team Foundation Server and Seapine Test Track to test and track defects and database changes and queries. Setup Team Foundation Server and Redgate Source Control to track changes to the database, tables, stored procedure, functions, and views.
• Developed PEEKS application to help plant operator perform their daily task by providing work order and recipe information.
• Created SQL objects to support data warehouse/data mart infrastructure
• Practiced agile software development in a collaborative team environment to include documentation of proposed business story, design approach and plan for testing for peer review at strategic development phases
• Created data models and manage tasks and projects in support of software application development
• Coordinated implementation of new software and accompanying processes with other departments
• Tracked software test results and report status to management
• Created and validated factory knowledge reports and underlying data quality to support the incremental spiral development model
• Deployed factory floor interfaces to present and record machine and operator input
• Synchronized lessons learned and software components between plant deployments
• Identified continuous improvement opportunities through site visits that will have measurable business impact within the manufacturing process
• Defined opportunities for application development and functional extensibility
• Recommended new applications and platforms, support the hardware and software infrastructure of the Kaiser Recipe System
• Proposed and implemented database enhancements to support process knowledge
• Optimized software configuration and establish proactive automated performance metrics and validation reports to identify potential N-Tier discrepancy or malfunction and opportunities for improvement
• Utilized skills to troubleshoot and propose creative yet simple solutions
• Identified best practices to address operational risk, fault tolerance, security and disaster recovery solutions
• Established, debug, demonstrated, and mistake-proof database administration, recovery and audit procedures for new and existing software applications
• Created technical specification and test plan documentation.

Confidential

Contractor BI Report Developer

• Provide development, system analysis, technical support, reporting, and peer troubleshooting assistance to help improve Mid-Atlantic's decision making, optimize performance, and achieve reporting requirements. Work with team of CIO, Operations Manager, Analysts to build highly performing database system and business intelligence reporting:
• Developed reports, forms, and dashboard using LogiXML, HTML, CSS, JavaScript, and SQL Server 2008 database.
• Provide support of daily SQL Server jobs and troubleshoot issues with data.
• Analyze complex source system data. Prove calculations/algorithms.
• Critically evaluate information gathered from multiple sources and reconcile potential conflicts of data/calculations.
• Create technical specification and test plan documentation.