Skills Summary

Information Technology professional, proven experience including roles as a team lead, project manager, BSA manager, business/data analyst, data architect and software developer of systems using Windows, UNIX, C, SQL, Shell and SQL Server. Experienced in all stages of software development life cycle, from requirements gathering through support. Successfully managed numerous projects and led teams in system & vendor selection, project management, process management, analysis of business requirements, vendor/resource management, system development, QA/UAT, implementation and maintenance & support management. Good educational background and excellent communication skills. Strengths include:

Technical Skills
Certification: PMP Certification
Project Management Software: MS-Project, MS-Visio, Word, Excel, SDLC Methodologies
Technical Courses: HP 9000/800 Sys. Administration, InterMediatE (Mediation) programming, Advanced Business Analysis
Prog/Scripting Languages: UNIX KSH, Perl, C, MS SQL, AWK, SED, TROFF, TOAD
Software: Rational ClearQuest, HP ServiceDesk, SQLServer2005, Oracle, SQL Server - Enterprise Manager, SSIS, Query Analyzer and DTS
Operating Systems: HP-UX, MS-Windows, Unix/Linux

Work Experience

Confidential,Princeton, NJ
2007 to Present

Confidential,
Lead/Senior Business Systems Analyst (5 yrs)

Business Systems Analysis Lead for the organization’s Application & Maintenance Support (AMS) group. Played a key role in laying the foundation to form the new support organization. Brought effective leadership, order & predictability to the BSA team at a crucial time in the project, by developing the initiation & transition project plans for the formation of group, through multiple iterations & review process.

• Led the systems analysis team efforts, with hands-on ownership of data/systems analysis of the project, including data management, detailed business requirements gathering and documentation and performing in-depth analysis of the solution to ensure that the requirements/design is complete & traceable.
• Hands on data analysis to validate quality of data published from content authors, data integrity checks, data archival & retrieval process/procedures to support legal/regulatory requirements using MS SQL and Excel.
• Served as a liaison to the testing team, providing guidance on relevant test cases/scenarios and assisting in the development of system integration test scripts to ensure that the testing results correspond to business expectations.
• Defined the defects management process for the new organization in collaboration with the PMO, including defects triage procedures, in-depth analysis of application issues, root cause analysis, resolution/workaround identification methodologies & ticket closure guidelines.
• Defined & streamlined the support team specific processes & procedures, collaborating with multiple cross-functional teams, leading to smooth end to end flow of support tickets, from ticket entry to successful ticket closure. Detected & addressed gaps in the support processes, working with the program stakeholders to gain agreement.
• Played a key role in defining the high level objectives of the team and helped hiring the resources to form the team. Full ownership of knowledge transition to the team, from KT planning to "certification to serve".
• Change Control (scope creep) & Release management for Maintenance Releases in the newly formed support organization.
• Facilitated the solution design with the architecture & development/ETL teams, by analyzing impact of proposed solution on existing technology platforms and validating that the solution/design meets business and functional requirements.
• Resource allocation analysis, Hardware/VM requirements & configuration planning and implementation - ensuring efficient use of resources within the newly formed team.
• Define, formulate and manage the 24x7 on call support strategy for the maintenance organization.
• Management of a small team of BSAs, both onshore & offshore - goal setting, mid-year reviews, performance reviews, mentoring and guidance with day to day analysis efforts
• Status reporting to leadership using MS SQL Reports, including risks & issues management.

Confidential,Princeton, NJ
1999 to 2007

Leading provider of wholesale VoIP (Voice over IP) telecommunication services worldwide.

Team Lead (3 yrs)
Responsible for overall project development and delivery, working closely with peers, vendors and the management team, following SDLC methodologies, leading a development team of consultants both on-shore and offshore. Responsible to provide a client focused (24 x 7) production support.

• Data Management, including intensive data crunching of huge volumes of data, using UNIX utilities and Kshell scripts, data storage/archival and efficient retrieval to support legal requirements - spanning multiple technologies like Cisco Gateways, ISOS switches and Radius servers,
• Stabilized and scaled the system through a series of hardware and software upgrades and performance tuning techniques – scaled to about 60 million records per day vs. one million records per day.
• Managed various development projects to meet the company’s growth requirements and new product/service releases - meeting budget and timeline constraints.

Sr. Data Architect/Developer (5 yrs)
Process owner, responsible for the design, development and maintenance of CDR (Call Detail Record) mediation system for the organization. The system is built using a HP RP8400 serviceguard clustered environment, running HP-UX version 11.11, on a flat file based database and programming code similar to C. Mediated data is fed into a data warehouse (SQL Server 2000 database), which serves as the repository for several user applications including Crystal Reports, Microsoft OLAP/cubes and real-time alarming/monitoring tools.

• Analyzed several vendors to select the most robust, scalable and stable solution - supporting the startup company’s dynamic growth potential.
• Played a key role in architecting the system, gathering detailed requirements, working closely with business user groups and the vendor. Developed hands-on coding using UNIX shell scripting and C, customizing the product for user-specific needs.
• Led the QA efforts, working closely with users and the vendor with various levels of testing - unit, integration, volume and UAT – delivering a 100% accurate solution.
• Designed and developed various support functionalities like audit/usage reports, resource monitoring tools and revenue assurance tasks using shell scripts, and several UNIX tools like AWK, grep, sed etc. – guaranteeing no revenue loss.
• Played a key role in analysis, design and development of the data warehouse in MS SQL Server 2000, using stored procedures, SQL Reports, DTS packages, scheduled jobs and TOAD– supporting various downstream data needs.
• Participated in the planning stage of a RDBMS migration project initiative from MS SQL Server 2000 to SQL Server 2005.

Confidential,Cranbury, NJ
1994 to 1999

Leading cosmetics & fragrance manufacturer in US and France.
Sr. Programmer Analyst, Sr. Systems Analyst (5 years)

Responsible for the analysis, design, development, maintenance and user support of sales information systems including SAMI (Sales and Marketing Information system) and MARS (Marketing Analysis and Reporting System). These client server systems were implemented on HP9000 servers, networked via Novell LAN, with Ingres (similar to Oracle/SQL Server) as the database server.

• Developed solutions to provide the company\'s sales force with POS (Point Of Sale) information, sales analysis data/methodologies and comparison of sales over historical data.
• Responsible for the study and analysis of sales information in order to assist corporate and marketing managers to launch special programs, using Unix shell scripting.

Confidential,Murray Hills, NJ
1992 to 1994

Confidential,supporting high volume data analysis studies.
Programmer Analyst (2 years)

Helped develop and maintain a Product Management Information System for the management and analysis of AT&T Middle Market Services. The system was developed on UNIX Platform using Ingres, ESQLC, and Ingres Terminal Monitor.

• Managed and administered the database, performing various tuning techniques like indexing, normalization, development of DDLs, and view maintenance.
• Designed and developed several strategic Pricing and Re-pricing Models for various Middle Market customers, using KSH, C, AWK, S, TROFF, TBL and SQL.

Confidential,Hoboken, NJ
1990 to 1992

Water Conservation Laboratory, managing research projects for companies like Kohler and American Standard.

Programmer Analyst (2 years)

• Developed a system in C pursuing the applicability of queuing theory to estimate design flow rates in commercial buildings using an experimental setup in an International airport in Western United States. Used several UNIX utilities including AWK, MAKE, TOUCH, GREP and SED for data processing and analysis.
• Designed, developed and implemented a Failure Analysis Information system using ORACLE RDBMS to correlate failure of the client\'s products to the water quality in regions throughout United States.

Education

BS, Mathematics
MS, Computer Science