Sql Server Manager
Resume:
SACHITHA C.S EAD: WAC**********
Apt :***
Rancho Cucamonga,
CA 91730
: **********@*****.***
Phone : 909-***-****
SUMMARY:
• Over 5 years of IT experience with extensive Experience in all the phases of Data warehouse
life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Demonstrated expertise utilizing ETL tool Informatica, RDBM systems Oracle, Sybase, SQl
Server
• Work experience in Informatica Powercenter 8.6 (Development,Maintenance and testing)
• Proficient with Warehouse Modules like Informatica Server and Client tools like Designer,
Workflow Manager, and Repository manager.
• Worked on various Domains like Health and Welfare, Financial and Telecommunications.
• Experienced in complete Software Development Life Cycle (SDLC), Software Testing Life
Cycle
(STLC) and Bug Life Cycle (BLC)
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database
Schemas like Star flake schema and Snowflake schema
• Strong leader with experience training developers and advising technical groups on ETL best
practices.
• Prepared the Requirement Analysis Document including test cases, test data, data modeling
diagrams, and sample workflows for development and testing
• Relational sources used like Oracle, MS Access and SQL Server
• Proficient with PL/SQL programming,SQL scripts, UNIX and mainframe
• Extensive Backend testing Experience on Database.
• Involved in preparation of Test data to test the functionality of ETL Sources Mappings and
Targets.
• Knowledge on RDBMS, C, C++, C#, ASP.NET.
• Experience in maintaining Requirement Analysis Documents and Maintaining Weekly Status
Reports.
TECHNICAL SKILLS:
Data Modeling Dimensional Data Modeling, Data Modeling, Star Schema Modeling,
Snow-Flake Modeling, FACT and Dimensions Tables, Physical / Logical
Data Modeling, Erwin 4/3
Databases Oracle 9i/8i, SQL Server 2000, DB2, MS Access 2000.
ETL Informatica Power Center 8.X/7.x/6.2
Environment Windows95/98/2000/XP/2003, Unix 5.2/4.3,Sun Solaris7, WinNT4.0
Testing tool Quality Center
EDUCATION:
Master Of Computer Application from College Of Applied Science, India
PROFESSIONAL EXPERIENCE:
Client : Riverside County Office Of Education (Feb 2011 –Till Date)
ETL Developer
Project Handling:
End User Reporting:
The End User Reporting is used to have a daily snapshot of all the Account Balances,Financial
Transaction Details and the General Ledger Balances.
The ETL loads all the fact tables with all these information and which can be used for reporting.
Responsibilities:
• Prepared the Technical Design Document for development and the Source-Target mapping
document
• Verified and validated data model structure and E-R modeling with all related entities and
relationship with each entity based on the rules using Erwin as per the business requirements.
• Develop ETL mappings which were designed to load data from Oracle sources into the Oracle
Staging/Target Area
• Used SQL Queries to extract data from the Oracle and MS SQL Server databases
• Performed backend testing using SQL queries and analyzed the server performance on UNIX
• Developed transformations such as Expression transformation, Filter transformation,
Lookup transformation, Joiner transformation, Aggregator transformation, and Update
strategy transformation.
• Executed Informatica work flows, verified the error logs
• Extensively used Informatica Debugger to validate maps and to gain troubleshooting
information about data and error conditions.
• Interacted with client user personnel to ensure continuing adherence to requirements and user
standards.
• Involved in formal review meetings with project teams and developers to report, demonstrate,
prioritize and suggest resolution of issues discovered during testing
• Actively participated in System testing, integration testing and coordinated UAT
• Worked in lead role to take decision regarding the environments
Environment: Informatica Power Center 9.0.1, Workflow Designer, Power center Designer,
Repository Manager, SQL server 2005, Oracle 10g, SQL, PL/SQL, UNIX Shell Scripting, Windows
NT/2000/XP, Erwin 3.5.2
Client : COX Communication (Apr 2010 –Oct 2010)
ETL Analyst
Projects Handled:
Informatica Upgrade:
Migration of all the informatica mappings and workflows from informatica version 7 to version 8. And
make the code runnable in informatica 8 environment along with reducing the performance issues.
Fist Call Resolution:
The First Call Resolution report tracks the non-repeat rate of authenticated callers using the caller’s
account number within a defined period (1day, 7 day, 30 day or 45 day). This report can be used to
measure the resolution of a caller’s requests with one customer placed phone call.
Previously the reporting needs were being met from the SQL server tables loaded through DTS. The new
proposed design will have ETL built to load the data into the target and will be sourced from existing
FACTS.There was a modification to existing fact to include additional columns. New facts were built to
support reporting needs of FCR.
Responsibilities:
• Develop ETL mappings which were designed to load data from Oracle and SQL Server sources
into the Oracle Staging/Target Area
• Prepared the Technical Design Document for development.
• Verified and validated data model structure and E-R modeling with all related entities and
relationship with each entity based on the rules using Erwin as per the business requirements.
• Used SQL Queries to extract data from the Oracle and MS SQL Server databases
• Performed backend testing using SQL queries and analyzed the server performance on UNIX
• Developed transformations such as Expression transformation, Filter transformation,
Lookup transformation, Joiner transformation, Aggregator transformation, and Update
strategy transformation.
• Executed Informatica work flows, verified the error logs
• Extensively used Informatica Debugger to validate maps and to gain troubleshooting
information about data and error conditions.
• Interacted with client user personnel to ensure continuing adherence to requirements and user
standards.
• Involved in formal review meetings with project teams and developers to report, demonstrate,
prioritize and suggest resolution of issues discovered during testing
• Actively participated in System testing, integration testing and coordinated UAT
• Worked in lead role to take decision regarding the environments
Environment: Informatica Power Center 8.6/8.1.1, Workflow Designer, Power center Designer,
Repository Manager, SQL server 2005, Oracle 10g, SQL, PL/SQL, UNIX Shell Scripting, Windows
NT/2000/XP, Erwin 3.5.2
Client: ACS, A Xerox Company (Apr 2008 - March 2010)
ETL programmer
Projects Handled:
Health & Welfare (HW) Process:
This project comes under H&W module of the total HR Outsourcing Project. This process can be
monthly, biweekly, weekly, or daily process, depending on the requirement. Flat files are the outputs in
this project. The process starts with the collating of data related to the employees and their dependents.
This data resides in some flat files called the client extracts. This collation of data also encompasses some
validation and cleaning up routines. This is the client process and is carried out by the client workflow.
The collated data at the end of this process is dumped into a table called the client table.
From the client table, we pick up the records which are applicable for this particular vendor, and produce
flat files containing this data.
Annuity Pension Process:
Annuity is one of the processes of Pension Payroll which pays the amount in specific frequency for
specified period of time. We take all the payment information, tax information, deduction information and
bank information of all the SSNs applying the selection criteria, specific to that client. By sorting we get
the most recent record based on the keys given in the top most position. Base table is created by joining
cbElectionBase and PMAS tables.
Normally the PMAS tables that we join are EMPLT, ADDRT and TERMT.Then a Full File is created
which contains different transactions containing deduction records, payment records and tax records
based on many rules specifying Business logic. Tempff is an intermediate table where we compare
Current FF and Previous FF.
In case of retro payments the amount also will be calculated there based on the specified time.Once the
flagging is completed,the new or changed records are moved to the ‘Changes Only File’. After which
Reports are generated based on client Requirement.
Responsibilities:
• Extensively worked on developing the ETL mappings which were designed to load data from
Oracle and SQL Server sources into the Oracle Staging/Target Area
• Writing technical design Document and Test Data.
• Used SQL Queries to import data from source of mapping like the Oracle and MS SQL Server
databases
• Performed backend testing using SQL queries and analyzed the server performance on UNIX
• Extensively worked on Relational and Flat files as Sources and Target.
• Tested mappings and SQL queries in transformations such as Expression transformation,
Filter transformation, Lookup transformation, Joiner transformation, Aggregator
transformation, and Update strategy transformation.
• Executed Informatica work flows, verified the error logs
• Extensively used Informatica Debugger to validate maps and to gain troubleshooting
information about data and error conditions.
• Involved in formal review meetings with project teams and developers to report, demonstrate,
prioritize and suggest resolution of issues discovered during testing
• Actively participated in System testing, integration testing and coordinated UAT
Environment: Informatica Power Center 8.6/8.1.1, Workflow Designer, Power center Designer,
Repository Manager, SQL server 2005, Oracle 10g, SQL, PL/SQL, UNIX Shell Scripting, Windows
NT/2000/XP, Erwin 3.5.2
Jawahar Navodaya Vidyalaya, India (Feb 2007 –Sep 2007)
Worked as a FCSA(Faculty Cum System Administrator) from February, 2007 to September 2007 .
Responsibilities:
Management and maintenance of School Management Software which includes the grade
tracking system, lession planning and keeping attendance records
Management and maintenance of School Library Management Software which is responsible
for transaction of books, issues,returns and renewal for members.
Environment: VB.Net,SQL server
SRM Software, India (Jan 2006 – Jan 2007)
Worked as Software Engineer Trainee from Jan 2006 - Jan 2007
Project Handled:
Distant education over net is about taking courses via the Internet.
The system involves two modules User or student module and Administration module
The students are users who have registered for particular course. Administration is an entity, which keeps
tracks of the proceedings of the university.
The system consists of these functionalities:
Information about course that user can undergo should be provided
User can register interested courses on line
Registered student can download syllabus and order study materials
The student can attend virtual class room
Students can chat with staff
Provision for enquires general, FAQs and information provided through e mail
Each student can attend online exam
An administrator should administer the whole module
Environment: c#.Net,SQL server
Contact this candidate