Project Sql Server

Professional Summary

. *+ Years of IT Experience as a Senior Data Analyst with broad based

experience in the education domain

. Possess a comprehensive background in project management and software

development life cycle (SDLC) methodologies

. Database experience includes in-depth data architecture, data

modeling, database performance and SQL development

. Experienced in working in environments with sophisticated

infrastructure, which has combination of state of the art

technologies.

. Experience in performing business process reengineering and gap

analysis

. Proficiency in use case identification and documentation

. Experience in gathering BRD,FRD and technical requirements

. Expertise on SQL Server implementation on Windows platforms

. Proficiency in creating Project Scope and Execution Plan Documents

. Hands on knowledge of automation of manual processes using SQL Agent

. Experience in managing SharePoint/MOSS environments

. Hands on experience in creating and maintaining project repositories

using SharePoint

. Experience in creating workflows for change management using

SharePoint

. Experience in developing KPI/metrics using SharePoint

. Knowledge of data interoperability templates and standards

. Experience in incident resolution and problem determination and root

cause analysis

. Expertise in programming with SQL, PL/SQL and T-SQL

. Proficient in translating functional/non-functional requirements to

system requirements

. Hands on knowledge of Unit testing, System testing and User Acceptance

testing

. Experience in secure data practices

. Experience in creating Test Plans, Test cases and testing with a high

attention to detail

. Experience in leading development & testing teams

. Experience in motivating and resolving conflicts in diverse team

setting

Education and Certifications

Master of Science, in Computer Sciences, Northern Illinois University

Bachelor of Technology, in Computer Sciences, JNT University, India.

IT Project Management, Northwestern University (Earned 36 PDUs required for

PMP)

Technical Skills

Operating Systems Windows 9.x / 2000/03/08/12/ XP/ NT

Languages SQL, PL/SQL, C, C++, VB Script

Databases MS Access, MS SQL Server, Oracle7.x/8i/9i

Web/Internet HTML, DHTML, XML

Scripting Languages Java Script, VB Script

Testing Tools Win-Runner, Quality Center, Load runner,

Remedy

Content Management SharePoint/MOSS/2010/2013

Work Experience

Northern Illinois University, De Kalb, IL September 2005-

Present

Project # 1: Illinois Interactive Report Card Project

Role: Senior Data Analyst

Illinois Interactive Report Card (IIRC) is a project funded by Illinois

State Board of Education. IIRC is a platform to securely host state-wide

student results and reports, available to the school and district

administrators. It hosts the interactive school report cards. Also, manages

a secure portal for educators to make their plans electronically and have

them reviewed and authorized by the State Board. This is a collaborative

project with the Illinois State Board of Education to design a Parent

friendly School Report Card on a 2-page dynamic PDF. Additionally, expand

and remodel the existing IIRC (iirc.niu.edu) site to Illinois Report Card

Site (Illinoisreportcard.com). Worked with and managed Large Dataset with

nearly 11000 data points per year and a historical timeline of 15 years.

Responsibilities:

. Conduct detailed data usage and data meaning analysis to support

governance recommendations.

. Measure and track data quality. Conduct analysis of adherence

of data to business rules and compliance with laws and regulations

(e.g. FERPA requirements, industry standards.).

. Conduct data quality audits to ensure compliance to established

business rules and legal/regulatory requirements.

. Identify data quality issues and perform root cause analysis.

. Perform data profiling and other data investigation activities.

. Provide source system data quality measurements and feedback.

. Use data quality tools and methods to identify and correct data

anomalies (e.g., data profiling, including data gaps, incorrect

usage, data out of range, invalid values, etc.).

. Collect and maintain business and technical metadata for operational

and analytical repositories and processes.

. Develop and maintain data policies and standard based on management

directives.

. Support data governance issue/resolution processes.

Environment: SSIS, SQL Server 2012, SharePoint, Visio, SPSS.

Project # 2: Illinois Shared Learning Environment

Role: Business Analyst, Data Modeling

The Project is a state initiative to provide longitudinal data system on a

shared platform for all the schools and districts of Illinois State. The

project focuses on centrally managing the schools needs and enabling

educators to manage their student information systems real-time. The

project is funded by Race-To-The-Top Dollars. The Project is a pilot

development for the inBloom (National Project by Gates Foundation)

Responsibilities

. Created and maintained a project schedule using SharePoint showing all

target dates for deliverables.

. Physical data modeling (table definitions, primary/secondary key

identification, identification of indexes, etc.)

. Automated creation of reports and extracts from database for delivery

to clients.

. Performed data modeling and integration of new processes into existing

workflows.

. Captured and analyzed requirements through interactions with

stakeholders.

. Finalized and documented the Business Requirements for the application

with business heads through proper communication channels.

. Interacted closely with both designers and software developers, to

explain the full functionality of the application and navigational

flow, while keeping them closely updated about Business User's

sentiments.

. Involved in writing a winning RFP for IIRC to compete as a vendor for

the technical aspect of the project.

. Prepared a total cost evaluation was as to hardware, software, space,

personnel and development effort required in order to accomplish this

task. Estimated timelines were also included.

. Estimated project plan defining critical path for required tasks to

get minimum duration and manpower needed to get to production

. Documented functional and technical specifications and BRDs and

communicated the requirements to development teams.

. Worked with SMEs to acquire inputs and document the technical

solutions.

. Worked in tandem with internal and external users to define

requirements and coordinated user, management, and developer

expectations.

. Conducted JAD sessions with project partners, business partners and

technical teams.

. Developed Use Case diagrams with MS Visio and also created Business

Flow Diagrams, Activity/State diagrams, and Sequence diagrams, which

enabled developers and other stakeholders to understand the business

process.

. Worked through Software Development Life Cycle (SDLC) from

Requirements, Analysis, Design, and Implementation through Testing.

. Conducted iterations and communicated results and milestone

achievements to the stakeholders while keeping the developers closely

updated on all documented refinements

. Collaborated with offsite partners at multiple data centers across the

state.

Environment: Microsoft Visio, MS PowerPoint, Windows Server, SQL Server

Project # 3: Student Data Remodel

Senior DB Analyst/Manager

The Project was to build a data warehouse to store the 30 TB of 10 years'

worth data of the 1.6 million Students' results across the state. The

project required working with individual school districts and implementing

their custom requirements on a secure portal. The site was to host at least

15 assessments including State and Shelf assessments. The design had to

closely match the SIF standards for alignment with State Databases. Handle

various formats of flat files from various vendors like Pearson and ACT.

Responsibilities:

. Architected Databases for Data Warehouse project, which was

implemented using the star schema approach on a SQL Server 2008

platform.

. Designed daily, weekly and monthly packages to maintain the warehouse

and cubes. Implemented these packages using SSIS

. Responsible for data modeling, schema-analysis and leading the DB team

. Understanding the report card project process and building business

process models.

. Preparing As-is to-be diagrams for discussions with Cross functional

teams.

. Defining and documenting business requirements

. Assisted in the design and development of a framework to manage the

delivery of data and reports that included creation of SQL stored

procedures and functions

. Performing data analysis and documented source target mapping

. Performing GAP Analysis to analyze the current system and worked with

internal users to help define system requirements

. Analyzing and prioritizing user and business requirements as system

requirements that must be included while developing the software

. Scheduling meetings with users and stakeholders to identify problems,

resolve issues and improve the process to ensure a stable and accurate

solution

. Working collaboratively with the Focus Group, User Experience

Analysts, and System Analysts to help document custom and system

modifications

. Creating Business Requirement documents (BRD) for Business end user

review and communicating with the business on a non-technical level

. Involved in on-going Report development using SSRS and the reporting

server for web retrieval.

Environment: SQL Server 2008, SSAS, SSRS, SSIS

Project # 4: Educator Dashboard:

Role: Business Analyst, Data Modeling

The educator dashboard is a host to a number of information systems all

managed centrally at the data center hosted offsite. The systems are

required to be in sync at all times with real-time feeds from the clients'

data stores. The Student Information and School Information of real-time

lunch counts, attendance and bus schedules is read from the cloud and

presented on a web interface.

Responsibilities:

. Gathered user and business requirements through interviews, surveys

and prototypes

. Stored and modified requirements in SharePoint

. Analyzed and prioritized user and business requirements prior to the

development cycle

. Prepared Logical Data Models that contained diagrams, Business

Requirement Documents, and descriptions of the relationships between

the actors.

. Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams in MS

Visio.

. Worked on Wire frames during the Elaboration Phase

. Conducted JAD sessions with management, SME, vendors, users and other

stakeholders for open and pending issues.

. Authored progress and completion reports, which were then submitted to

project management on a weekly basis.

. Created test cases and test scripts to check the functionality of

application (UAT).

. Performed manual front-end testing to check all functionalities of

different modules.

. Suggested measures and recommendations to improve the current

application performance.

. Documented lessons learnt and voice of the customers

. Organized feedback sessions and workshops with end users and creating

user manuals

Environment: Windows Server 2008, SQL Server 2008R2\2012, Visual Studio

2010, Team Foundation System, Microsoft Visio 2007.

Project # 5: Network Topology Remodeling

Role: Project Manager

Remodel the existing two-environment network topology to a scalable and

manageable multi-environment layout for cross-functional teams. Also,

separate the Data layer from the application layer.

Responsibilities:

. Initiated the project and acquired approval of senior management

. Led a team of 5, and delivered the end-to-end solution

. Used Visio and PowerPoint to map the physical and virtual machines and

present the current and the end states

. Made cost estimates to discuss budget and timelines with the director.

. Worked with technical teams and senior management with analysis

. Prepared FSD to facilitate the developers and network administrators

understand the requirements.

. Provided PERT charts to the management and the developers to

effectively work within realistic timelines.

. Led the design of tiered network environments according to industry

standards

. Monitored through the process of execution of the project

. Conducted bi-weekly project progress meetings and prepared reports for

status monitoring

. Used SharePoint for collaboration with the stakeholders.

. Worked with Information Technology Services for procurement and

sourcing

. Collaborated with cross-functional teams and supervised the execution

of the project.

. Acted as liaison between functional work groups and management.

. Guided QA team in preparing Test Plans based on Requirements Document

and prepared the Test cases

. With teams on going responsibilities and varying lead and lag times,

adjusted the critical path per project pace.

. Trained project teams on the newer architecture and providing

necessary documentation and manuals.

Environment: Microsoft Visio, MS PowerPoint, Windows Server, SQL Server

Project # 6: ETL Process Development

Role: Database Team Lead/ Developer

Manage and process flat files from various vendor sources. Manipulate and

standardize the data formats per database design requirements. Store and

retrieve them from fully normalized database to generate reports for the

clients and UI. Automate manual processes to expedite turnaround and

minimize errors.

Responsibilities:

. Managing a team of part-time and fulltime developers to set up

processes to improve efficiencies in processing large data files.

. Documenting and streamlining processes repeatedly performed.

. Using ETL tools to debug and maintain the current applications.

. Leading the team implementation and adoption of SSIS and SQL Server

Data Tools in Visual Studio 2005, 2008R2 and 2010

. Troubleshooting issues of junior developers working with flat files

with columns more than 11,000

. Writing scripts to parse through the huge set of variables

. Implementing custom needs for high profile clients using complex

protocols.

Environment: SQL Server, DTS, SSIS, SQL Server Data Tools, Visual Studio,

Visual Source Safe, Team Foundation System

Nikitha Web Services, Hyderabad, India June 2002 -

June 2004

Role: Developer/Web Designer

Create and deploy websites for clients per their requirements. Analyze

client's data to suitably present on their website.

Responsibilities:

. Actively involved in the analysis of the needs and requirements,

database.

. Developed commonly used user controls.

. Designing workflow of project.

. Code behind is developed using VB

. Effective validation and formatting of user input data.

. Technical Team member

. Design the Sequence Diagram for the e Admission module.

. Developed User Interface using Win Forms to display the patient/

doctor information

. Design and development of menu driven user interfaces.

. Implementing Object Oriented Features (OOPS).

. Implemented Structured & Un-Structured exception handling.

. Heavily worked on the disconnected data using Typed dataset object.

. Involved in sending Dataset through Web Services.

. Implemented Stored Procedures, Views and Triggers.

. Designed and Generated Reports with Crystal Reports

. Designed the Class & Sequence Diagrams for the Report Module.

. Implemented the design for the three different users.

. Used Web Services using Http-Get and Http-Post.

. Created a Customized XML-Web Service for the project obtained from the

Database.

. Used Web controls, Rich controls and Validation controls.

Environment: SQL Server, Visual Studio, XML, Web services

Contact this candidate