Project Sql Server

MOHIT PAHUJA

*** ****** ****** ********, ** ***** 847-***-****

***************@*****.***

SUMMARY

• Over 6 years of experience in IT (including software development) with last 3 years in eCommerce with

extensive Agile methodology experience and technical background in Microsoft development

• Expansive experience in creating use cases, functional requirements, and designing process flow, wire frames, and

screen shots

• In-depth knowledge of Rational Unified Process (RUP); Waterfall methodology, Spiral and Agile /Scrum

methodology.

• Expert in business process engineering and software development life cycle, including analysis, design,

development, testing and implementation of software applications.

• Ability to effectively document and communicate the business requirements and use cases.

• Process and workflow design and documentation. High level system architecture design.

• Use Case Modeling & Analysis using Visio. Translating the business requirements to technical specifications.

• Experience in conducting JAD sessions, GAP Analysis, Feasibility Analysis and ROI.

• Knowledge of Six Sigma, and Capability Maturity Model (CMMI).

• Expert at writing Use Cases, Storyboards, Dashboards and UML Diagrams.

• Experience working on SOX compliance and audit related projects.

• Data analysis, Database modeling, design. Data mapping between multiple systems. MIS reporting using various

reporting tools.

• Experience working with cross-functional teams within the Organization to define individual and team

accountabilities and manage to the desired outcomes.

• Defining the testing procedures and developing the system test cases.

• Expert at Project planning and budget/time tracking using MS Project and other budgeting tools.

• Defining and monitoring processes: Process Excellence, Security Standards, Quality Metrics, Change

Management and Configuration Management.

TECHNICAL SKILLS

OS: HP-UX, Windows 9x/2000, Windows NT

Languages: C, C++, VBA, XML, SQL and PL/SQL.

Scripting: UNIX Shell scripts, Excel macros.

Database: Oracle 8i and 9i, SQL Server 7.0, MS Access 2000.

Tools: MS Office, MS Project, Visio, Rational Requisite Pro, DOORS, Rational Rose, Clear Case, Clear

Quest, Mercury Quality Center, Test Director, SQL Navigator, SQL PLUS, SQL Server

Management Studio, SQL Loader

Reporting: Crystal Reports, Excel, SQL, SQL Server BI Studio, SQL Server reporting services,

W eb Apache, I-Planet, Web sphere, Tomcat (Tyger), HTML

PROFESSIONAL EXPERIENCE:

Role: Sr. Business Analyst

Company: Devix International, Exchange Place, NJ.

Project# 1 Senior Business System Analyst @ BeachCamera.Com March 2008- Aug 2009

• Acted as a facilitator and liaison between the business stakeholders and the development team, aligning each

others’ expectation of the final product, suggesting and visualizing the solution to the business team, and providing

technical insight that helps the business team to decide on achievable, realistic solutions.

• Categorized functions, business rules, and process flow of poorly documented pre-existing internal application that

was no longer well understood by the team.

• Interviewed business owners to capture business requirements for a very popular (over 32 million page views per

month) promotional eCommerce site that provides scholarship search service. Translated business requirements

into technical, functional requirements for Java and PLSQL developers including designing of UML diagrams,

screenshots, and process flow.

• Helped the business team to visualize solutions to poorly understood business problems by creating screen mock

ups, wireframe, process modeling, and hosting joint application development sessions.

• For complex and costly-to-develop features, designed several alternate solutions and proposed them to the

business team so to negotiate and choose the most economical solution that meets the business need.

• Performed system and regression tests to validate the software to functions specified in the requirements.

Prioritize, assigned, and monitored progress of defects with the most serious impacts. Defined user acceptance

test criteria and aligned business team’s expectation on how the UAT would proceed, and what criteria must pass

for the sign off.

• Initiated and promoted best practices in business analysis and estimating process. Pitched a new estimating

process that got the buy-ins from the business and development team that vastly improved the use case estimates

and ability to accurately plan workload.

• Authored and trained all end users on creating and maintaining ad campaigns on the new ad serving platform.

Project# 2 Agile Coach @ Ishopit.com Jan 2008 to March 2008 (Short term contract)

Responsibilities:

• Mentored the technology, PMO, and the business group in the Agile methodology.

• Interviewed the business stakeholders to identify the business requirements, converted these requirements into

user stories including wireframes for developers.

• Created the project plan, and tracked the project progress, created backlog of the business use stories, defined the

product roadmap, and lead iteration planning meetings.

Project# 3 Senior Business Analyst @ MyerEmco.Com - Aug 2006 to Dec 2007

Responsibilities:

• As a part of eCommerce start up, created user stories from interviewing business stakeholders to design complex

work process between home improvement experts and registered users.

• Working along with a user experience design expert, created wireframes and process flow for a new CRM tool that

was used to create and publish Q&A content for a site catering to home and garden enthusiasts.

• Managed all promotional email communications including newsletter and maintenance tips regularly sent out to

over 100000 registered users.

• Created in depth reporting on the site activities and registration rates by writing custom SQL modules to analyze

data and scheduled these reports to be sent automatically to the marketing group for a better insight into the user

behavior.

• Created and executed tested cases for completed code and validated the software against the user stories.

• Designed integration between data warehouse and the site that linked the purchase on www.myeremco.com to

www.managehome.com that dramatically increased site registration.

Role: Business/Security Analyst

Company: Bank of America (Formerly MBNA), DE

Duration: Mar 06-Aug 06

Project# 1 Database Security Monitoring and Support: To ensure the security compliance of all database

environments that includes Oracle, Sybase and Informix and supporting audit and various business manager requests.

Responsibilities:

• Responsible for day-to-day monitoring of database security reports, investigating the exceptions.

• Implementing a new dormancy process for the de-centralized Oracle and Sybase data servers to automatically

lock and drop the un-used accounts based on the security standards defined.

• Handled all the audit requests related to database extracts/reports, SOX compliance reports using Excel,

PL/SQL, Business Intelligence and SQL server reporting services.

Environment: HP-Unix, Oracle 11i, Informix, Sybase 12.1, DB Artisan, SQL, PERL, Excel, SQL server, SQL Server

Management Studio, SQL Server BI Dev. Studio, SQL Server reporting services.

Project# 2 Access Re-justification: To fulfill the security audit requirements to have a process in place for user /

generic application accounts administration.

Responsibilities:

• Responsible for data analysis of various environments and database instances using Excel reports.

• Perform detailed analysis of current administration process.

• Develop new automated process to get the accounts that are created outside of the security administration

process.

• Coordinate with business owners to re-justify the account access and coordinate with the database /

application owners to clean up the unused accounts.

• Define and implement a new process for account administration.

Environment: HP-Unix, Oracle 11i, Informix, Sybase 12.1, DB Artisan, SQL, UNIX, PERL, Excel.

Role: Business Analyst

Company: Bloomberg Financial LP (Trade book), New York, N.Y.

Duration: Aug 05 - Jan 06

Project# 1Tradebook: Trade book is an Electronic Crossing Network (ECN) that receives trade orders from customers

and then matches them internally or routes them to the marketplace for execution. The processing requirements of

these executed trades can be complex as they are determined by many factors. Trade book had outsourced their trade

processing for ten years prior to their decision to take much of this processing in-house. This was a mission critical, full

production cutover of a mature business that executes over 300,000 trades daily. The Trade book COO said that the

decision to hire me to guide them through this vital transition was “a no-brainer.” As a result of the success of this

project, Trade book now grosses an additional $100 million annually.

Responsibilities:

• Conveying trade processing and brokerage operations subject matter knowledge to business and

development units. This input served as the foundation for outlining comprehensive business requirements for

trading, compliance, clearing, settlement, accounting, billing and business intelligence.

• Proposing and executing solutions for business requirements including work flow diagrams, data feeds,

system processes and database table content specifications.

• Analyzing complicated trade data and constructing a “matrix based” solution which identified transaction types,

relevant data characteristics and associated processing requirements via an understandable set of source

documents.

• Designing prototypes and functional specifications for user group applications.

• Coordinating FIX messaging solutions with external partners including the new clearing broker (Calyon

Securities), the trade reporting facility and internal developers.

Role: System Analyst

Company: Dun and Bradstreet, PA

Duration: Jan 05 – July 05

Project# 1 Match Data Mart for Dun & Bradstreet: MDM is a search engine for the queries sent by the Dun n

Bradstreet clients to get various financial companies data through a website. All the queries come in a flat file at the end

of the day, which gets processed against the Match Database and the results are published on the website. It also

involves usage of third party tools such as Software Search America, for generating and matching the search keys, and

First Logic Name & Address Standardization tool, for name and address verification.

Sweep Module: This module is used to update the Match Database on regular intervals with the latest data from Global

Data warehouse, which gets updates from different countries everyday through MQ Series. The data is stored inside the

Global Data warehouse in the form of zipped XML String. The XML needs to be unzipped and parsed to update the

Match Database keeping the performance at minimum of 100k records per hr. The module also needs to interact with

third party tools, developed in C/C++, to generate the match keys that are used in query search processing.

Responsibilities:

• Involved in requirements analysis and technical feasibility study to meet the performance goals.

• Documenting technical specifications from the business requirements.

• Development and maintenance of sweep and search engine modules.

• Acted as a module lead, which involves tasks like planning, work allocation to team and status tracking.

• Involved in production support and performance test on production environment for various countries data.

• Involved in data reconciliation and quality testing.

Environment: Java 1.3, JDBC, JNI, Oracle, Pro*C, C++, UNIX Shell Scripts, HP UNIX, VSS, Bug Tracker, MS Project,

Excel Scripts, SQL, PL/SQL, Visio.

Role: Business Analyst

Company: TCS, India

Duration: Jul 04 – Dec 04

Project# 1 Order Processing System: OPS is a sub-module of the Wipro Infotech division’s B2B site

www.01markets.com. The main features of the project include execution and tracking of the orders from the logistics

agents. All the Orders logged on the site are exported to an excel file in regular intervals and then will be transferred to

OPS. For each customer order BOM is identified and an order will be logged to logistic agents. The system supports the

tracking of these orders till the materials are shipped to customer.

Responsibilities:

• Responsible for scope study and business requirements analysis.

• Documenting functional and technical specifications.

• Coordinating the GUI development outsourcing process.

• Planning, work allocation and coordination between IM team and business users.

• Project status tracking and status update to management.

• Code reviews, system testing and performance testing ensuring quality compliance of the system.

• Involved in Integration with 01markets site and production support.

Environment: Visual Basic 6.0, ADO, Crystal Reports 7.0, SQL Server 7.0, MS Project, Office and VSS

Role: Developer

Company: SKACT Ltd, India

Duration: Jul 03 – Jun 04

Project# 1 Field Information System for Marketing Business Ltd. (www.nfoindia.com):

This package is a client server application for storing & retrieving the field data gathered by the market researchers. The

data is fed in to the system from different branches and then will be transferred to branch office from where the field

officers can monitor the data from all the branches. The software is implemented in all the branches in India. The

software also generates various reports for field officers and top management, which includes Bar graphs and Charts,

which are developed using Crystal Reports.

Project# 2 Student Administration System for Vikas Educational Institutes (www.vikasonline.com): This product

is a comprehensive client/server application with integration with web-based reports for any educational institution. It

contains different modules namely Preadmission, Admission, Attendance, Fee Collection, Hostel Details, Weekly Tests,

MIS modules. MIS module shows the student performance levels on different subjects using crystal graphs and charts.

Project# 3 Sales Analysis System for Bharat Petroleum Corporation Ltd: This package is a client/server application

for analyzing the sales made by the major oil companies through various retail outlets in Visakha Territory. The package

generates various reports and graphs to know the performance of the retail outlets as well as the Oil Companies.

Responsibilities:

• Technical design, coding and unit testing.

• Participated in system testing, change management, implementation at client locations.

• I have taken some of the projects independently as a freelance programmer and implemented end-to-end

solution.

Environment: Visual Basic 6.0, RDO, Crystal Reports 7.0, Oracle 7.3, SQL, PL/SQL, VSS and MS Office.

ACADEMIC DETAILS

• Bachelors in Electronics, from Maharishi Dayanand University, India

• Masters Degree in Computer Applications, from Delhi University, India.

Contact this candidate