Sql Server Developer

Gayatri Pande **** Preachers Hollow Trail, COS, CO

80924

****************@*****.*** Home: 719-***-****

EDUCATION & CERTIFICATIONS

•Masters in Systems & Engineering Management, Texas Tech University, Texas

2006 (GPA 3.1)

• Bachelors in Electrical Engineering, University of Pune, India 2002 (GPA 3.0)

• Certified Cognos report developer

• Pursuing Management Certification from UCCS, Colorado spring.

• Pursuing Certification In Microsoft technologies.

SOFTWARE SKILLS

BI Tools IBM Certified report developer - Cognos 8 BI Reports

Cognos BI series 8, Cognos BI series 7.3,SSRS,BIRT report,

Crystal reports, Microsoft Sql server report builder 2.0

Software Languages SQL, PL/SQL,Java, C#

Operating Systems Windows XP/2000/NT/98/95, UNIX

Databases Oracle 11g/10g/9i/8i, MS SQL Server 2005/2008, MS Access

Web Technologies HTML,CSS,PHP

XML Technologies XML, XSD, Web Services

Others UML, Agile,Microsoft Office, Microsoft Excel, Microsoft

project, Microsoft power point, Microsoft word,Jira(a project

tracking tool)

EXPERIENCE

Analyst at GAD Telecom April 2012 to June 2012

Worked on file send in fixed length, delimited and variable length formats

Knowledge & understanding in writing SQL quires with given file layout.

Loaded leads from different client/campaign on different dialer

Created parent & child on different dialer linked them by using query plus

Worked with MS access database (& quires) in different phases of loading leads ( i.e

phone append,update, NC scrub..etc) on dialer .

Report developer analyst at Denver Fedrel Center (Lakewood) Dec. 2011 to

March.2012

Designed, built, and tested Impromptu reports, crystal reports, BIRT reports and sql

server report builder reports, SSRS.

Hands on experience in writing Cognos Impromptu report - Developed new report as

well as modified existing report according to customer requirement, migrated

reports from oracle 9g to oracle 11g.

Created task in Jira(a project tracking tool) according to customer requirements.

Completed & updated tasks assigned in Jira in an efficient and timely manner.

Well versed in project life cycle.

Hands on experience in writing understanding complex SQL queries against Oracle

9g/11g and SQL Server 2005/2008 databases

Hands on experience in gathering & documenting requirement from the customer in

agile environment.

SSRS Report developer at Pueblo Schools,Colorado Oct. 2011 to

Nov.2011

Hands on experience in writing complex & Simple reports in SSRS.

Good experience in writing SQL queries for the SSRS reports datasets.

Updated existing SSRS reports according to change in requirements.

Generated SSRS Reports using Global Variables, parameters, Expressions and

Functions.

Developed Custom Reports using SSRS/SQL server BI studio.

Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary

reports by

Using SSRS.

Created Reports in SSRS with different type of properties like Chart, filters, sorting,

SQL parameters etc.

Applied conditional formatting in SSRS to highlight key areas in the report data

Volunteer at Pikes Peak United Way,Colorado June 2011 to Oct. 2011

Database management for individual accounts.

Run retrieve queries to find database solutions on problematic accounts.

Provide technical support to Director & donor care specialist.

Database record clean-up, review & maintain record of incoming donor information.

Assist in training interns

Support a multi-tiered, computer system and perform enhancements as required.

Testing and implementing new business solutions in an IT system.

IT Architect, Worldleaderz, Colorado October 2009 –

October 2010

Created e-commerce functionality & necessary BI functions around e-commerce web-

site.

Created seamless integration between mightycardz.com & distributor sites.

Managed IT web development & databases, created customer databases according to zip

code.

Works closely with CEO to understand business requirements that drive the analysis and

design of technical solutions.

Clearly translated requirements and dissect complex work flows into intuitive and

simple designs.

Participated in user testing, rollout and production support.

Identify and implement better work and business processes.

Develop requirements for software programs and implement automated methods and

systems to track workflow and performance efficiencies.

Developer & Business Analyst - Verticalis, Texas

January 2007- July 2009

Developed & Published framework models in Cognos Connection

Developed models & multi-dimensional cubes in Power Play Transformer using

Impromptu Query Definition (.iqd) files to generate Customer Billing Reports.

Defined dimensions, levels & measures to generate models and cubes in Power Play

Transformer.

Developed reports in report studio, query studio

Assisted in aligning business strategy to IT strategy, in ways that adhere to the IT

maxims.

Aligned IT solutions with business functions to improve flexibility, facilitate large scale

reuse, improve comprehensibility and visibility of IT’s value to the business.

Define and develop performance metrics; analyze and recommend data collection

process improvements and ensure data integrity as it relates to reporting and

analytics.

Continuously improved processes, technologies, applications to provide best value to

business.

Researched and wrote financial, and feasibility reports concerning new business

products and pricing strategies.

Translated the business needs into system requirements.

Documented the Functional Specifications.

Collected & analyzed data for parameterization & distribution, using statistical analysis

methods.

Enterprise budgeting, break-even analysis, planning, decision making & financial

analysis for engineering.

Used crystal ball & Advanced Excel technology to develop models for problem

formulation, solution & analysis, sampling models & accuracy.

Communicated issues and recommended solutions to management as identified

work with IT developers to design, build, test, and deploy solution that meets customer

needs.

Effectively managed multiple project packages through a defined process via delegation

of work tasks to team members.

Contact this candidate