SUMMARY:

• Over 16+ years of IT experience using Project Management tools, BI Development, MS SQL Server, Java and Microsoft Technologies.
• Flexible and focused to drive alignment with strategic business objectives between executive management, teams, customers, and partners
• Proven expertise in managing multiple projects in parallel using methodologies such as SDLC, Waterfall, and Agile to meet aggressive goals and defined criteria
• Consistently recognized for technical delivery and superior focus Cross/Up Sell Opportunity, Customer Loyalty, Tech Refresh Strategy, Booking Reconciliation, Data Quality Management, and BI/EDW
• Experience as a scrum product owner and a scrum master managing cross - geographical project team
• Involved in all the phases of software development life cycle SDLC process (Design, Development and Unit Testing, System Integration Testing and Functional Testing).
• Performed CDC and Change tracking on OLTP systems, Power Pivots, XML file transfers.
• Designed high level ETL Architecture for overall data transfer from the OLTP to OLAP.
• Experienced in developing Custom Report and different types of Chat Reports, Tablix Reports, Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services.
• Deploy and manage the reports to a report server and securing and managing the reports with Reporting server.
• Experienced in creating Views, Stored Procedures, functions and Triggers using T-SQL.
• Created SSIS tasks to email output and log messages using Script task..
• Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• In depth exposure to a wide spectrum of functions along with management capabilities and exceptional organizational ability

TECHNICAL SKILLS:

SQL Server Tools: SSIS, SSRS,SSAS,Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server 2008R2,SQL Server 2008 Management Studio, DTS

Database: MS SQL Server 12, MS SQL Server 14, MS SQL Server 2008R2,2008, MS-Access, Informatica

Language: Java, J2EE, C, C++, T-SQL, VB.Net

Operating System: Windows XP/NT/2000, DOS, Windows Server 2003

Tools: Erwin, Microsoft Visual Studio 2008/2005,Share Point Server 2007, Microsoft Project Server 2007, ProClarity, Unix Shell Scripting

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Reporting Tools: SSRS (SQL Server Reporting Services), Crystal Reports, Power Pivot

ETL Tools: SSIS (SQL Server Integration Services), DTS, EDI

PROFESSIONAL EXPERIENCE:

Project Manager

Confidential, Miramar, FL

• Translated broad business strategies into structured plans for evolving Sales, Retention and Tech Support business capabilities with actionable insights
• Led cross-functional worldwide tech teams, kicked off programs, established schedules, ensured roadmap/requirements baseline and maintained IT/SOX compliance
• Developed BI phase review deliverable documents, scheduled timely executive review, and conformed with PMO's exit gate review, status report, cost benefit analysis and cost tracking
• Built an effective high performance technical team and provide ongoing business continuity support
• Managed major risks and issues through effective contingency planning and proper escalation
• Coordinated across multiple development sites and a team of 14 members on-shore and off-shore
• Successfully lead the development of project teams from Concept to Product release.
• Gather business requirements from customer and transform business requirement into technical and come up with proposed solution.
• Developed solutions to resolve organizational issues to improve services offering.
• Derive reasonable Scope, Resource requirement, time frame for E2E Design, Development, Integration, Testing, Deployment.
• Identify and plan for key Risks, Issues and Dependencies (Internal and External)
• Design delivery methodology. Quote cost as a Fixed bid project to be run on an Agile Project management - Scrum based - implementation
• Reviewed Business Requirement Documents, Software Requirement Documents and assisted in preparing Test Cases, Test scripts and Execution.
• Conducted Daily Stand Up meeting for the project and worked with Scrum Board for updates/issues related to project.
• Devise process for Change Requests outside agreed fixed cost scope
• Define Quality standards and definition of Done
• Identify resources, procure and ramp up
• Conduct Functional (Story Writing) and Architectural envisioning workshops
• Analyze and propose solution for SSRS, SSIS and SSAS as per requirements.

Project Manager

Confidential, Fort Lauderdale, FL

• Actively managed and interacted with users, Technical team lead, DBAs to fully understand the requirements of the system.
• Analyze and propose solution for CRM Salesforce (Veeva) as per requirements.
• Create design specification for SSRS, SSIS, SSAS, Informatica and CRM Salesforce (Veeva).
• Create Data model for proposed solution and design Oracle and SQL Server database diagram as per proposed solution.
• Administered a wide range of projects adhering to strategic goal in collaboration with the leadership team and business stakeholders.
• Work very closely with Product Managers to plan product features and future releases
• Managing multiple vendors offshore/onshore and internal IT team to various work streams
• Adept in risk management across multiple business functions and stakeholders in addition to conflict resolutions amongst teams.
• Developed and prepared status reports and projections.
• Redesigned, updated and implemented an innovative process for users to create on-demand reports for senior staff.
• Conducted staff development and training sessions teaching the new reporting system to mid- and senior-level management;
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Analyzed existing Stored Procedures & Triggers and took actions to increase the performance in modularization.
• Implemented database consistency and security by creating groups, roles, users, and triggers on views
• Work with the users to get the UAT done on all new and incident reports, get the sign off from the Users and QA and roll it out for production.

Project Manager

Confidential, Atlanta, GA

• Responsible for Initiating, Planning at - Roadmap, Release, and Sprint - levels, Estimating, Forecasting, Coordinating and delivering all activities
• Instituted project-management policies and procedures that created the PMO model with the primary objective to define, categorize, and track projects within a centralize portfolio that aligned with the business model, goals, strategic roadmap and objectives
• Developed and employed a sound repeatable process, which provided tangible return on investment in project management, solution design, engineering, integration, execution, monitor and control, implementation, documentation, and planning.
• Involved in meeting with Business users, Systems Analysts for project related enhancements
• Responsible for multiple high profile million dollar projects throughout various location within the continental US
• Corrected deficiencies by writing specific policies and procedures, which brought the department to a proficient, workable, organized unit
• Coordinate and conduct regular status meeting with client and business users at onsite.
• Prepare project estimation, planning and management documents
• Conduct or facilitate the Implementation Project Kick-off and Status meetings.
• Created and employed the PMO tracking and filing structure and the documentation s retention process for all projects and projected work efforts.
• Responsible for the conception, deployment, assignments, dependencies, milestones, tracking, base-lining and support of all IT Projects

Project Manager

Confidential, Austin, Texas

• Translated Enterprise bookings and discounts business requirements into functional design solutions, support development, testing and release activities.
• Managed the project lifecycle using SDLC and Agile/Scrum Methodology.
• Worked with Partner Operations stakeholders as IT SME/ETL Lead for building Partner Data Automation Project extracting data from Salesforce.com.
• Interacted with several distributors across the world in gathering the business requirements for ecommerce tools feed.
• Supported and maintained VMware compliance, HR inventory and Intellectual Property dashboards and reports.
• Developed OBIEE reports & dashboards for the Field Finance organization.
• Analyzed metrics for better understanding and formulated, presented relevant actionable recommendations to business.
• Provided support for the current reporting dashboard solutions, including data warehouse management, query modifications, improving the quality and timeliness of critical reports.
• Assisted business team in developing test cases and provide necessary subject matter support during integration testing cycle.
• Worked with various operations teams to understand processes and source systems underlying the data. Provided insights and recommendations for addressing data issues.
• Driven the application changes to support the evolving needs of a rapidly growing business.
• Provided data analysis support for data warehouse, ETL and OBIEE reporting layers.
• Created several Functional Specification Documents to articulate the business requirements for IT development.
• Handled the various aspects of end to end lifecycle related to complex data warehousing and business intelligence projects.
• Well versed with the onsite-offshore development model.
• Extensively involved in developing reports with inputs from the assigned Business Analysts.
• Worked in a cross functional environment engaging with Business, Development, QA and Operations team.
• Assisted business users in month end and quarter end audits.

Senior Business Analyst

Confidential, Austin, TX

• Worked in the agile development environment with frequently changing requirements and features set.
• Prepared standard operating procedures, work flow diagrams, flow charts, tables, reports and ad-hoc queries.
• Actively participated in gathering the requirements and reviewed functional specification documents, design documents, requirements traceability matrix, and involved in developing test plan document.
• Created a Test plan generator using XML.
• Communicate issues, risks and test status in a timely and detailed manner.
• Effectively collaborate with team members to achieve best results.
• Contribute to a culture of innovation and quality across the engineering organization.
• Performed user acceptance testing, ad-hoc testing, functional testing, compatibility testing, unit testing, integration testing, regression testing, system testing and load testing for the games.
• Analyzed the case management and trends for the system application.
• Actively participated in scrum meetings, reviews and developed test scenarios.
• Prepared the traceability matrices to fill the Gap between the requirements and the test cases covered.
• Worked closely with the developers to troubleshoot and reproduce the bugs.
• Interacted closely with management, business and system users to collect and analyze the business requirements, identify business processes and create detailed system design, scope and documents for both functional and technical specifications as well as propose enhancement.
• Created test scripts with the requirements using mercury Quality center
• Involved in release support by testing the release process
• Conduct survey's, investigations, internal audits to determine compliance with requirements, laws and policies
• Used QC to test GUI based applications.
• Performed Functional testing using Quality center (QC)
• Participated in extracting data from web based applications to create reports using QC reporting.

Jr. Project Manager

Confidential

• Transitioned/Migrated the Auto Finance process to HSBC HDPI
• Managed the migrations, training for Auto Finance.
• Got a certification on US FDCPA compliance.
• Effective communication with the Project Manager HDPI and the PM of the Host Company.
• Regular operations review with the management.
• Couch and guide the team members in enhancing their role within the organization
• Motivate and coach trainees to ensure that each individual performs to their potential.
• Ensure that the training courses are conducted as per the migration plans and the timelines/objectives are met.
• Handling a team of collectors who take live calls for collections.
• Take escalated calls along with the payment for promise.
• Ensure that the collectors follow the call model by remote monitoring of calls and updating the database.
• Weekly development plans for collectors based on their areas of development and ensure they work on the same to get the expected result.
• Provide feedback using the daily performance reports to ensure that collectors are aware of their performance
• Primavera Planning & scheduling management was utilized extensively along with Primavera Professional Project Management

Business Analyst

Confidential

• Pre Sales and Post Sales of the Software E-Trans and E-Log.
• Implemented the software at WT AIR Cargo, FLYJAC
• Liaison between the customer and the team and ensure we provide the technical solutions as requested.
• As a Business Analyst my main motive is to ensure that the implementations are completed on time.
• As a consultant, my responsibilities included listening to the customers’ expectations on the product, document every specification to the finest detail, communicating the same to the technical team and also training the end user on the product.
• I single handedly set up business center of FOUR SOFT in West Drayton UK in span of 11 months.
• Single handedly sold the product to 4 major logistics company in London.