SUMMARY:

• Lead Teams of various sizes, Business Analysis, Business Intelligence, reporting and performed data transformation work.
• Programming work includes gathering and translating requirements into functional specifications for Entertainment, Cable, automobile manufacturing, HealthCare, Restaurants, Service oriented and Retail Industries.
• Recent experience includes Data, Business and Systems Analysis and Subject Matter Expertise, performed Analysis, training and presentations.
• Well versed with 3 - Tier design patterns architecture for application development efforts and application development methodologies.

TECHNICAL SKILLS:

Management skills: Strong Communication, project management, presentation Information gathering

Databases: SQL Server 2012/2008/2005, Oracle 10, DB2, ACCESS

Business Intelligence: Microsoft BI Stack - SQL, SSRS, SSIS, SSAS

Visual Programming: C#, VB.Net, Visual Basic 6, VBA

Version Control: Visual Source Safe and PVCS

Report Writer: Tableau 9.2, SQL Reporting Services, Business Objects, Crystal Reports XI, 10.0/9.0/8.5

Productivity Tools: Excel, Visio, Access, PowerPoint, OutlookOther: INFORMATICA, SAS Programming, Business Intelligence Development studio, Database Studio, DTS, SSIS and conceptual knowledge of Cubes and SSAS

Internet Programming: ASP.NET with C#, ASP.net, Visual Studio 2008, ADO.Net, HTML, VBScript, JavaScript, IIS (MS Internet Information Server) 6.0/7.0

WORK EXPERIENCE:

Confidential, Ewing, NJ

Senior Systems Analyst and Tableau reporting Consultant

Responsibilities:

• Lead development team to create a New/Existing Reporting Systems of Risk incident tracking system with Confidential ’s compliance and policies. Enhanced and streamlined operational issues of Data stores and Data-warehouse. Established Close Business and technical communication with stake holders to analyze reporting and documentation requirements. Areas of Quality Control and Customer support was provided for technical issues. Optimize extract, translate and load processes. Responsible for Solution and database architecture and maintenance.

Tools: /Technologies: Tableau, SSIS, SQL, Visio, ETL, Solution Architect

Confidential, Little Rock, AR

Senior Consultant/Systems Analyst

Responsibilities:

• For Affordable HealthCare project of Worked in a Service-Oriented Architecture (SOA)-driven organizational framework and provided information systems expertise to support the technology base for State business operations. This role is responsible for identifying, understanding, documenting and conveying systems architecture enterprise-wide. Worked with the Business Architecture team to extract systems and process data to determine needs for reengineered processes and served as a primary point of contact for system specifications, behaviors and technical requirements. Partnered with Business Analysts (BA) and Business Process Management (BPM) modelers to extract, define and document business rules. Trained Interns on the applications and assigned work, Presented management on the progresses. Leveraged the Microsoft SQL 2014 Business Intelligence stack to create a BI environment that seamlessly integrates into business unit specific applications

Tools: /Technologies: INFORMATICA, SQL, Visio, Oracle, Toad

Confidential, Mount Laurel, NJ

Consultant for Capacity Planning Division

Responsibilities:

• Worked Independently on Weekly and Monthly Video-On-demand, Scorecards, Data-Center, Outbound Call blocking, KPIs, Dashboard and other Engineering related reports, which are produced for Senior Engineering Management and key personnel’s of Capacity Planning division. Routinely Gather, organizing, stage, maintain and manipulate Data from various databases and ware-houses. Use scripting languages like VB Script to automate data collection and aggregation from hundreds of Video devices sources and files. Report automation included Tableau, Excel and SQL database tools. Managed and scale weekly and monthly data on a SQL database to as the size and complexity of Video capacity utilization reports grew. Ensured Video data is managed in accordance with the best practices outlined by the Capacity Planning team.

Tools: /Technologies: SSIS, SQL 2008, Tableau, VBA, Excel

Confidential, Orlando, FL

Systems Analyst, Subject Matter Expert

Responsibilities:

• Work with business analysts, SMEs, team members and application sustainment team to understand business requirements that determined the analysis and design of quality technical solutions for Risk-Management and Assessment division of Disney-world and Disney-Land for Data Conversion to new platform in accordance to the ITIL Service Lifecycle. Identify Business requirements into systems requirement. Identify Data conversion and interface mappings in preparation for the Claims Administration Replacement project.
• Risk assessment and Claims Administration data was gathered from Disney’s cruises, US Disney theme parks, and international Disney resorts for analytical uses. Requirements elicitation, data mining and code review (specifically extraction of business rules from .NET and PowerBuilder 6 legacy applications). Delivered interfaces to the new packaged solution using ETL/Middleware solution. Verbal and written communication based on the audience. Documentation on technical solutions was produced. Areas of insurance, risk management and worker’s compensation were involved.

Tools: /Technologies: SSIS, SQL, Visio, Oracle, Toad, INFORMATICA

Confidential, Philadelphia, PA

Analyst/Database developer

Responsibilities:

• Responsible for running and monitoring daily routine Data transfer jobs from servers to Databases making sure the source data is ready for reporting and analytics through the intranet company web sites. Data consists of daily call volumes (Billing, Retention, Sales, Service, SIK Activation) coming in from various regions and divisions quality check and data staging. Source data received in the form of text files and tables from different servers. Data manipulation, quality assurance, and scripts maintaining and manipulation, writing Stored procedure, functions, and data analytics is a daily routine for this job. Developed stored procedures, functions, triggers, Developed reports, KPIs, scorecards, and dashboards.

Tools: /Technologies: DTS and SSIS for ETL Services, SQL 2008

Confidential, NY

Project Manager and a Systems Analyst

Responsibilities:

• Developed and maintained agency wide applications. Facilitated Data and reporting requirements for Commissioner, Deputy Commissioner and Department Directors using SQL Reporting Services. Routine jobs consisted of ETL processes of monitoring, debugging and supporting Data Transformation Services (DTS) and SSIS Packages. Importing and transforming data from Oracle Data-Warehouses and Databases utilizing stored procedures, views and queries. Web Applications utilized extracted data by web application written in ASP.Net and C#. It acts like a reporting engine for entire department. Application integrates with Crystal reports. System generates management and quality assurance reports on periodical basis. These reports for analysis and accountability purposes gets created on periodical basis

Tools: /Technologies: ASP.Net, C#, Crystal Reports, SQL Reporting Services (SSRS), Oracle Client App and SQL Server 2000/2005, WMS Mainframe Interface, DB Studio

Confidential, Metuchen, NJ

Application Developer/ Consultant Business Analyst/Report Manager

Responsibilities:

• Web applications Consultant, designed and developed applications using Visual Studio 2005 ASP.net with C# and SQL Server 2005. Data Analysis was performed for Ford Motors assembly plants based on data extraction from Auto-Crib "point of use", dispensing Hardware systems with local SQL database were utilized to develop patterns and usage trends on the manufacturing tools. The processes facilitated supply chain management for plants’ solutions to customize for their clients. The Auto-Crib process provides automated inventory control of direct and indirect materials, tools and safety products. Dispensing machines provide secure access and usage tracking while automate the re-ordering process. Crystal reports and Excel were developed and automated based on the study utilizing Excel and SQL 2005 Management Studio and SQL Reporting Services tools. Microsoft’s SharePoint Server, applications for team management was utilized.
• Design implementation of Microsoft Reporting Services in Vertis’s DPS Group for their client (MEDCO). Gathered Business Reporting requirements, documented and converting them into report designs. Design and developed multi-dimensional reports. Perform Analysis for IT division. Microsoft Reporting Service's controls and features as Tables, Charts, grouping and expressions to provide report layout look and feel. Stored procedures used to provide data for relational and dynamic reports.
• As a team member, Coded, integrated and implemented, Active Server Pages and Crystal Reports of Agency web site, Portal utilized by various levels of management, Sales Consultants and Agents of the organization. This Web Portal provides the Management and various agency users with the Reporting capabilities for the Sales activities, Regional/District, Periodic and Compensation Reports with the sophisticated report formatting and report drill down functionality. Crystal Report Active X Control, Internet information Server 4.0, COM (Visual Basic 6.0), SQL Server 2000, Site Server, Seagate Crystal Reports 10.0, were used for the application development
• As a team member of the quality control department created and coded Reports Using Crystal Reports 9.0.
• These reports integrated in Active Server Pages. These reports consisted of daily activities performed by the agents of GNOC Center, which receive trouble tickets through Remedy Database. These reports were also available on the company’s internal web site. HTML and JavaScript was utilized.

Tools: /Technologies: ASP.Net, C#, Crystal Reports, SQL Server 2000/2005, Access/ACCESS/ VBA/HTML/JavaScript VBScript