Post Job Free

Resume

Sign in

Project Manager Sql Server

Location:
Boise, ID, 83706
Posted:
March 09, 2010

Contact this candidate

Resume:

SPriya Gopalan

Boise, ID, USA

abng02@r.postjobfree.com M#: 1-208-***-**** & 2-208-***-****)

OBJECTIVE

A challenging Sr Business Analyst/Project Management position that requires a competent and analytical individual with superi

communication and interpersonal skills.

PROFESSIONAL SUMMARY

• A Senior IT Professional with 9 years of IT experience and 10.5 years of total work experience

• Experience with very large size critical projects and offshore/onsite type of projects

• A Project Coordinator and Project Manager 1 with about 2 years of Project leadership experience working on mid siz

projects that include offshore – onsite project coordination as well

• A Senior Business Analyst /Lead Business Analyst with 6 years of Business Analysis with diverse Industry

experience that includes Education, Pharmaceutical, Financial Services and HR/Payroll. Have Data

Analyst experience as well.

EDUCATION

Master of Science (MS), Computer Science - University of Akron, Ohio.

Bachelor of Engineering (BE), Computer Science and Engineering - Bangalore University, India

SKILLS

Functional Skills: Project and task Co-ordination, Meeting initiation and facilitation, Status Reporting,

Project Analysis including Resource allocation, Cost allocation and budgeting, Project Time estimation,

Task delineation, Issue Tracking, Business Analysis, Business Process Analysis, Systems Analysis

Dev.Water Fall.JAD session.BRD.,,UAT,DDM,DAM,AGILE. BI Reports;EDW.UML.SDLC

Industries: Technology, Financial Services, Pharmaceutical & Education.

Management and Business Analysis Tools: Microsoft Project, TeamTrack, UML, BPM,Rational

Rose, Rational ClearQuest, Visio 2000, DOORS, Microsoft Office Products (Word, Excel,

Powerpoint, Access )and Sharepoint,PMO Consulting Technology. SDLC, Some experience on

COGNOS.People soft Bundles.

Data Warehouse tools: Ab Initio (ETL), Microstrategy,OLAP Tools,BI Reports.SAS

Databases: Oracle (9i, 8i, 8.x, 7.x), MS Access 95/98/2000/2002,ETL.UDB.

Programming Languages: Java, C++, C, PL,SQL, Embedded SQL, Pascal, Fortran. XML.

Testing tools: Winrunner, Loadrunner, Rational Suite, Silk, Test Director. UAT,BETA systems .

EXPERIENCE

Business Analyst October 2008 – May 2009

Encore Capital Group, Inc, CA

Midland Credit Management

Encore Capital Group, Inc. is a systems-driven purchaser and manager of charged-off consumer receivable

portfolios. Our success is built upon developing mutually beneficial relationships with our customers, our debt

sellers and buyers, our business partners and our employees.

Environment: Microsoft sharepoint, MS Office, MS Visio

Roles and Responsibilities

• As a Business Analyst within the IT-PMO group at Encore, worked with different departments and groups

within the organization to help analyze business processes and systems

• Analyzed and documented Functional Specifications and requirements for systems that were undergoing

transformations or enhancements

• Analyzed a system created to allow the Call Center Operations department at Encore to collect payments

made on debt portfolios and accounts purchased or owned by the company.

• Worked with the Call Center Operations to document the System requirements and enhancements to be

included for the System. These additions allow more flexibility for the Call Center Account Managers,

Group Managers or Division Managers to use the system and save on cost to the organization while

increasing revenue and cash collections.

• Worked on 3 other small size Strategic Initiative projects that involved gathering requirements, analyzing

systems and business processes.

• Documented Functional Specifications for 4 different projects based on analysis that involved and impacted

enterprise-wide systems and business processes.

• Created Use Cases, Process Flow Diagrams, Test Cases and scenarios to elaborate on System requirements

• Contributed to the PMO team with ideas and analysis for how to manage, share and use MS Sharepoint and

other systems within the IT department used for information sharing and storage

• Met with Business teams and department personnel regularly to discuss systems and processes involved in

strategizing debt collection for Encore.

• Created Use Cases that describe the functional processes of the application

• Gathered requirements to document the Business Rules as part of each module of the application

• The User Manual includes Functional Specification details, UI details, Requirements and Business Rules for

the application.

• The intended readership is the employees or staff of the Carriers, Third Party Provider or CoPower, Brokers

belonging to Agencies, and Groups and Organizations who are interested subscribers to the Carrier’s plans.

Ceridian, PA March 2006 – November 2007 Sr Consultant

- Project Manager 1, Lead Business Analyst December 2004 – September 2008

Mascon Global Ltd, Illinois

Mascon is a global provider of IT services. They develop and implement end-to-end IT solutions for clients

ranging from Fortune 500 companies to start-ups, from diverse industry segments.

Client: CoPower, San Mateo, California January 2008 – May 2008

Project: MAGIC CPA is an application being developed for a Third Party Provider of Health Insurance Carriers

in the United States and abroad. This application provides Carriers, Third Party Providers and Organizations a

tool that allows them to create and select plans for insurance.

Plan Commissions and Overrides.

Environment: .NET Framework, Windows NT Server, SQL Server 2000

Roles and Responsibilities

• As Sr Business Analyst analyzed the existing application to document the Business Rules and

Requirements

• As the sole creator of the User Manual for the application, structured and designed the document into high

level modules that encapsulated all Functional modules of the application

• Gathered and documented Functional Specification details at a high level as well as at a Requirement and

Business Rules level

• Created Use Case (UML) diagrams as part of the High Level Business Use Case model

Project: Ceridian is a multinational human resources company serving over 110,000 customers and their 25

million employees worldwide.

Globally, Ceridian is recognized as one of the leading providers of human resource solutions and payroll

services.

The project team was assigned the task of gathering requirements and creating use cases and SRS documents

from the HR/Payroll application as well as from the source code made available for the application.

Environment: .NET Framwork, SQL Server 2000, ASP, Windows NT

Roles and Responsibilities:

• As the onsite Project Coordinator, interacted with Ceridian and the offshore Mascon team to ensure

completion of Use Case development for their HR/Payroll application.

• As the Support Project Manager, responsible for detailed review of Use Cases and Software Requirement

Specifications and delivery of the same to the client.

• As a Business Analyst for the same project gathered requirements and business rules from the existing

application and the code in order to create use cases and SRS documents for HR/Payroll modules in the

application

• Documented and/or communicated any issues raised as part of the requirement gathering process via

Rational ClearQuest.

• Used UML to create and display module design – created use case diagrams, class diagrams, data flow

diagrams as well.

Schawk Digital Imaging, IL November 2005 – March 2006

Project: Schawk is the world's largest and most experienced brand imaging solutions provider.

The PaRTS application, is a DAM and a Workflow management application. The expectation was to gather

requirements from the existing application and the legacy documentation to create new use cases/SRS

documents to help the development, QA and the business teams to maintain these for future releases.

Environment: Java, Java Script, Windows NT, SQL Server 2000

Roles and Responsibilities:

As Lead Business Analyst, was responsible for gathering requirements from the existing DAM (Digital

Asset Management) and Workflow application.

Participated in user training for the application, DOORS and Test Director.

Created use cases and SRS documents for the DAM and the Workflow modules of the application from

the application as well as from legacy documentation

Interacted by way of JAD sessions with the Schawk team and the Mascon team on a daily basis for the

requirement gathering and use case creation process

Documented the requirements gathered in the form of use cases in DOORS, a tool that efficiently stores and

links requirements

Participated and contributed in creating test cases from the use cases created in DOORS

Interacted with the Testing team and participated in UAT

• Participated in all design reviews as well as use case/documentation review meetings to ensure complete

understanding of the documentation and requirement gathering approach

Devry University, IL October 2005 – November 2005

Project: Devry is working towards offering its Game and Simulation Program (GSP) online to students aiming

at acquiring a Bachelors degree in Game and Simulation programming in order to equip themselves for the

Gaming industry. The game engines, games and other hardware, software packages and applications needed to

satisfy the course objectives identified in the curriculum for the outlined courses will be delivered online using

the Citrix Server Environment.

Environment: Citrix Server, Game Engines, Windows NT

Roles and Responsibilities:

• As a Business Analyst performed analysis of the various game engines and games identified for the set of

courses outlined as part of GSP to assess usability based on system requirements and functionalities.

• Analyzed the feasibility of running the open source as well as purchased applications and packages on the

proposed environment.

Chicago Public Schools, IL May 2005 – October 2005

Project: IMPACT is the Chicago Public Schools Instructional Management Program and Academic

Communication Tool! IMPACT will include a Framework for Business Intelligence that will provide a data

repository for long-term data storage and analysis.

Environment: SQL Server 2000, SQL/PL/SQL

Roles and Responsibilities:

• As a Data Analyst performed data analysis and data mapping using data warehousing concepts to and from

the ODS for a Data warehouse created to develop and maintain appropriate programs for students enrolled

in Chicago Public Schools.

• Interacted with business process and development teams in order to identify data requirements for the

crosswalk from individual systems to and from the ODS Stage.

Grainger Inc, IL January 2005 – May 2005

Project: Dynamic Deployment Module (DDM) is intended to simplify and automate the process of providing

relevant product and pricing information for Grainger customers. The software guides the user (either an

Internal Grainger employee or a Grainger Customer) through the process of product selection, choosing content

and style, and output and delivery.

Environment: .NET, ASP, SQL Server 2000

Roles and Responsibilities:

• As a Business Analyst gathered, created and updated software requirement specifications by interacting

with business units and individual users.

• Performed detailed Gap analysis by identifying and documenting gaps between current application, current

process and requirements.

• Used UML diagrams to document the business processes for the DDM

Business Analyst April 2004 – December 2004

In a start Up company, California--

The start-up company that helped businesses to secure and control their email and files. Built upon a proven,

patent-pending, and scalable secure application platform, This company’s applications were designed to

manage the digital assets of today's leading enterprises.

Environment: Java, Java Script, ASP, Windows NT

Roles & Responsibilities

• Created and maintained project plans, functional requirement documents, task lists and status reports to

track development tasks and individual tasks.

• Interacted with domestic and international customers to gather requirements, product feature requests &

customizations and to discuss deployment deadlines.

• Initiated and conducted team meetings to discuss product feature additions and enhancements.

• Created a system to track engineering, sales & marketing, recruiting and customer support tasks.

• Performed quality assurance tasks, created test templates, test cases and use cases, maintained bug and

issues lists to expedite and track the testing process.

• Contributed extensively to creating and distributing training materials and product documentation for IT

and sales & marketing teams as well as for product customers.

• Performed market research by maintaining and updating a competitive analysis matrix highlighting the

advantages and benefits of the company’s product suite over other competitors' products.

Data Warehouse Consultant February 2003 – January 2004

Capital One, Virginia

As a member of a data warehousing project team, successfully developed and implemented Phases 1, 2 & 3 of a

data warehousing project. This project received an award of excellence. The application provided the business

users important information regarding the scores of every customer with a credit card. These scores determine

whether a customer with a valid credit card can be given a better APR or not.

Environment: Ab Initio, Windows 2000, NT, MS SQL

Roles & Responsibilities:

• Worked with the Business Team on converting their Business models into Ab Initio processes

•Converted user defined functions of business process into Ab-Initio user defined functions.

•Designed Ab-Initio ETL graphs for the transition of a data warehouse that had been developed using SAS.

•Developed ETL processes for data movement in order to provide data to downstream interfaces as part of a

system integration process.

•Converted legacy ETL Processes (Oracle SQL PL-SQL, Shell scripts, SAS modules) into Ab-Initio graphs.

•Created Ab Initio graphs to perform data quality tests and to validate the data that was being loaded into the

target tables

.

Business Analyst – Data Warehousing February 2002 – December 2002

Schering Plough, New Jersey

Member of a data warehousing team that was involved in the transition of a data warehouse for the Business

Information Center of the corporation. The warehouse contained information and data from the various sales

force groups of the corporation.

Environment: Ab Initio, MS SQL, Windows NT, Unix

Roles & Responsibilities:

• Interacted with domain experts to understand external business requirements

• Documented the various steps involved in validating the ETL process.

•Created test cases to ensure that data originating from source is available in the target in the right format.

• Performed periodic Data Validation and Data Integration using SQL and Ab Initio.

• Used TOAD for the purpose of writing and executing SQL queries and scripts.

• Validated the ODS and DSS ETL processes by creating and executing Ab Initio graphs using the GDE .

• Executed Microstrategy reports in order to present the final data in the warehouse (DSS) to the Business

users.

Software Engineer January 2001 – August 2001

Codonics Inc., Ohio.

Codonics is a imaging company that manufactures imaging products for Medical, Microscopy, Forensics, CAD

and Aerospace markets.

Environment: Java, Swing, SQL Server 2000

Roles & Responsibilities

• Developed a GUI application/software package using the AWT and SWING components.

• Interfaced with a spectrophotometer using the Java Communications API and Java Runtime Classes and

methods.

• Used JDBC to access and query the database.

OTHER PROFESSIONAL EXPERIENCE

Master's Research Nov 2000 – August 2001

Department of Math and Computer Science, University of Akron, Ohio.

Surveyed and analyzed Data Warehousing case studies, technologies, Business Intelligence, and the uses of

XML for Meta-data Interchange in the Common Warehouse Meta-model (CWM) standard developed by the

OMG.

Graduate Teaching Assistant August 1999 - December 2000

Department of Math and Computer Science, University of Akron, Ohio.

Software Engineer September 1997 -September 1998

Aeronautical Development Agency (ADA), Bangalore, India.

Designed, developed, implemented and tested a “Software Cost Estimation Tool”(GUI based) for the purpose of

estimating costs of projects in the agency. Worked on many enhancements for this application.



Contact this candidate