Sql Server Management
Resume:
Minni Patnaik
[pic]
Voice: 339-***-****(h) Email: ablysc@r.postjobfree.com
5.5 years of total experience in software engineering including design,
development, quality assurance, testing, implementation, and maintenance of
multi-tier application architectures that support future enterprise and web
application development. During the last 5 years, have been working in
business intelligence and data warehousing applications involving Business
Objects, Oracle and SQL Server. With sound professional knowledge,
creativeness and teamwork, I aspire to serve an organization with sincerity
and determination to succeed with outstanding client service and
communications skills.
SKILLS
. 5.5 years of Business Objects (BOXI3.1, BOXI R2) Designer, BO
Reports, Web Intelligence reports, Supervisor or CMC, Analytics and
Dashboard, Crystal, Xcelsius
. 3+ Years of Database technology, SQL programming
. 1 year of Web development in Java Script, SQL, HTML
. 3+ years of all stages of Software Development Life Cycle (SDLC)
. 2+ Years of Data warehouse, ETL using SQL server DTS, Access,
Stored procedure and Triggers
. PM Smart, MS PowerPoint, VSS, JIRA & Infra Defect tracking Tool
. 2+ years of Software Testing
. Databases: MS-SQL Server (v 2000, 7, 6.5), MS Access, DB2, Oracle
(v 9i, 10g)
EXPERIENCE
Employer: HCL Technologies
Nov 2009 - Present
Client: International Business Systems (IBS) and its customers
HCL has tie up with IBS to provide BI development and support for IBS and
its customers worldwide. IBS is a world leading provider of distribution
software and other services to distribution and Manufacturing companies.
While most international software companies are only focused on internal
processes such as Distribution and Supply Chain Management. IBS is the only
worldwide software company to come from the distribution side of the supply
chain.
Responsibilities Includes:
. Gathered the requirements and subsequently translate it into
Functional specifications for Universe and report development
. Created Prototypes of reports for initial user presentation in the
process of designing Functional Specifications.
. Designed and developed Business Objects universes (Reporting Universe)
by capturing all the reporting attributes and measurable metrics,
along with any predefined conditions, functions and resolved the join
path problems using Aliases and Contexts
. Worked extensively with @functions (@aggregate aware, @select,
@prompt, @where) to overcome the problems with database when
integrating with BO.
. Created Cascading List of Values (LOV's) and set up Custom Hierarchies
to enable drilling
functionality in reports for in depth analysis.
. Designed, developed and tested business object reports, both full
Client and WebI reports.
. Used drill down functionality such as Drill Up, Drill Down and Drill
Across to show the data at different Hierarchical levels
. Organized data in the Deski reports by inserting Filters, Sorting,
Ranking and highlighting data
. Used the formatting options like cross tab representation, section
breaks, data sort options, calculations, font, colors, etc.
. Applied the restrictions for the users by adding the Security Table
into the Universe from the database
. Worked extensively with Business Objects CMC (Central Management
Console) module in the process for creating users, groups, controlling
universe, restricting objects.
. Created detail and summary reports, used to fold/unfold sections
corresponding to breaks in current blocks.
. Involved in moving the universe and reports from development to DEV to
QA and QA to Prod environment using import wizard.
Environment: Business Objects XI 3.0, Business Objects XI 3.1, Business
Objects 6.5, Web Intelligence report, Designer, Crystal Report, Central
management console, Xcelsius,live office, Desktop Intelligence, Windows
Employer: HCL Technologies
Sept 2008 - Oct 2009
Client: Toys R US
Toys 'R' US is the world's largest baby products company.Toysrus.com is the
leading online specialty store for toys, video games and merchandise for
babies providing moms, dads and other toy-buying adult access to the
world's largest toy store at their fingertips.
Responsibilities includes:
. Worked with multiple tools, such as Excel, MS Access, SQL*Loader and
DBF Manager to perform Extraction, Transformation and Load (ETL)
activities
. Interacted with Business Users, Business Owners to know their Business
views in developing and modifying Universes and Reports accordingly.
. Involved in gathering, analyzing, and documenting business
requirements, functional requirements and data specifications for
Business Objects Universes and Reports.
. Involved in the designing and building of Universes, Classes and
Objects.
. Created Preliminary Design Requirement, System Design Documents and
user manuals
. Used aggregate awareness in universes.
. Created different test cases for testing purpose.
. Created views and derived table to accommodate user parameters and get
rid of database complexities.
. Involved in full life cycle of Business Objects reporting Application
. Installed and configured Business object.
. Created Dashboards and Speedo meters for detail analysis
. Customized the dashboards and KPI's for better manageability of
overall performance
. Worked extensively with Business Objects Central Management Console
(CMC) in the process of managing business objects users and groups,
controlling access levels, managing securities, restricting objects
and data to universes.
. Created Auditor reports and tracked user access of reports and
Universes
. Developed dashboards used with Xcelsius 2008
. Scheduled the reports to be emailed to end users daily in PDF and TXT
formats from Info view
Environment: Web Intelligence report, Xcelsius, Desktop Intelligence,
Business Objects XI 3.0, Windows, Central management console (CMC),SQL
server 2000,Oracle 9i
Employer: HCL Technologies Aug
2007 - Sep 2008
Client: Station Casinos Management System
Casino Management System is system provides for employee management and
information storage and retrieval for a significant number of casino
operations. The system includes an attendance controller that receives
stores and displays attendance information for casino personnel. Casino
personnel are issued cards that uniquely identify them and monitor them in
the fulfilment of their roles. Players may also receive these types of
cards, which can be used to record their casino activity and reward them
for playing. The system provides for dealer rotation so that dealer
rotation information may be received, stored and displayed.
Responsibilities includes:
. Involved in gathering, analyzing, and documenting business
requirements, functional requirements and data specifications for
Business Objects Universes and Reports.
. Involved in the designing and Building of Universes, Classes and
objects and applied Hierarchies based on Business logic.
. Worked in creation of multiple Universe and Involved in deploying the
universe and reports from development to QA and prod environment
. Created Derived tables to reduce the complexity of the universes and
also created prompts to force the users to restrict the data in the
process of building the universes.
. Created Contexts and Aliases for resolving loops and checked the
Integrity of the Universes
. Suggested changes to existing Universes, to resolve issues like
multiplied results or repeating rows for the detail levels, Fan Traps,
and Chasm Traps.
. Involved in UAT and provided training to the user
. Communicate test results, as well as any errors or issues discovered
during testing, to QA team and developers.
. Created several graphical reports using pie charts, bar graphs and
line graphs.
. Used multiple Data Providers, complex formulae, functions, Drill,
Slice and Dice, Filters and Hierarchies.
. Created Graphical and Statistical reports of different Natures and
Types.
. Set Alerter to enable exception highlighting in the reports for
business conditions.
. Worked extensively with Business Objects Central Management Console
(CMC) in the process of managing business objects users and groups,
controlling access levels, managing securities, restricting objects
and data to universes.
. Working with various database connectivity and configuration in
Crystal Enterprise.
. Responsible for setting up the Users/Groups, Database connections,
assigning privileges to the Users.
. Implemented Security Features of Business Objects like row level,
object level and report level to make the data secure.
. Used multiple sub reports, pass through parameters and pass by
parameter linking for generating complex reports for management
. Published and scheduled Business Objects Reports to users
Environment: Business Objects Designer XIR2, Web Intelligence, Rich-
client, Info View, Oracle 9i, SQL Server 7/2000, Windows XP Server
Employer: HCL Technologies
April 2006-Aug 2007
Client: National Institute of Health (NIH): Division National Institute Of
Child and Family Care (NICHD)
NICHD Clinical Program: the collection of scientific data, the analysis of
the data collected, and the publishing of the results of important public
health issues in scientific journals.
Responsibilities includes:
. Involved in requirement analysis, design, development, testing,
implementation and maintenance.
. Designed, implemented, tested and maintained a data warehouse front-
end system insight to capture the information like Members, Providers,
Claims (Hospital, Researcher and Pharmacy).
. Responsible for the Designing the universes by creating the Business
Objects data model selecting/joining tables, indicating cardinalities,
creating aliases to resolve the loops, subdividing into contexts and
. Involved in design, development and maintenance of Clinical Tried Data
Mart (CTDB) and universes.
. Imposed several Joins, Filters, and Alerters to restrict the unwanted
data and highlight the required data.
. Created Daily, Weekly, Biweekly and Monthly reports
. Created complex variables, multiple breaks, sorts in the reports.
. Aided in setting up Multi-Dimensional Analysis, the Slice/Dice & Drill
using the Hierarchies Editor
. Created various LOVs and Filter objects for ease of Ad-hoc reporting
. Designed, developed and tested business objects reports, both full
client (BO) and WebI reports
. Involved in UAT and provided training to the users.
. Provide the NICHD Clinical Program with IT services and support for
the design, data collection, analysis and reporting of clinical trials
data
. Worked extensively with Business Objects CMC module in the process of
managing business objects users and groups, controlling access levels,
managing securities, restricting objects and data to universes.
. Published Documents on the World Wide Web for access to authenticated
users via Info View.
. Installation and configuration and maintenance of Business Objects
Servers on Unix/Sun Solaris environments
. Installation of Business Objects Desktop products for customers
. Upgrading the system into Business Objects XI R2
. Migrating from 6.5.x to Business Objects XI R2
Environment: Business Objects Designer XI R2, Web Intelligence, Info View,
Oracle 9i, SQL Server 7/2000, Windows 2000 Server
Employer: Odisys Technologies Services pvt ltd
Mar 2005-April 2006
Project: Skill Management system
The project is prepared for the development of an Online Skill Management
system for the sourcing and HR department to enable sourcing and placing
human resources effectively. This product maintains
details of all employees and associates. It maintains a database lookup of
all skills required by the organization and is updated time to time. A
database lookup is of experience history of all the employees/associates.
Responsibilities includes:
. Interacted with Business Users and End Users to know their Business
views in developing and modifying Universes and Reports accordingly.
. Analyzed the existing database and designed the Universes using the
Business Objects Designer Module.
. Created Classes, Objects and Conditions. Tested the Universe by
writing various queries and checking the results.
. Resolved Loops in Universe by creating Aliases and Contexts.
. Suggested changes to existing Universes, to resolve issues like
multiplied results or repeating rows for the detail levels, Fan Traps,
and Chasm Traps.
. Created several graphical reports using pie charts, bar graphs and
line graphs.
. Used multiple Data Providers, complex formulae, functions, Drill,
Slice and Dice, Filters and Hierarchies.
. Set Alerter to enable exception highlighting in the reports for
business conditions.
. Created reports for end-users to access and navigate reports over web
using Info View.
. Maintained BO repository using Business Objects Supervisor by
enable/disable command restrictions, reset passwords and for creating
different Categories.
. Used Broadcast Agent to schedule the reports depending on the user
profile.
Environment: Business Objects Designer 6.5, Business Objects, Full client,
Info view, Oracle 9i, SQL Server 7/2000, Windows 2000 Server
EDUCATION
. B. Tech. Computer Science
. Oracle Certified Associate(OCA) from ORACLE
. Merit Scholarship (From Standard VII to B.Tech Degree)
TRAINING
. Business Objects Enterprise XIR2, Designer, Web Intelligence, Crystal
Reporting, Xcelsius
. Business Objects Enterprise 6.5 Administering Servers - Windows
training
. CCNA
. PMSmart (Ticket tracking system)
. ORACLE
. Working By Values, overview on applying integrity, cost effectiveness,
excellence, and innovation to software development
Contact this candidate