*Hi,*
*Hope this mail finds you well.*
This is *kishore *from *DVARIT Resources*. We have consultants available
immediately for your job openings; Feel free to contact kishore @
520-282-5846; 520-282-5806 for any of those resumes.
* Name*
* Primary Skills*
* *
* Visa*
*Total/US Exp*
* Rate*
SASITH
SQL Server developer
H1B
8 Yrs
Negotiable
REDDY
SQL Server developer
H1B
9 Yrs
Negotiable
*Satish profile summary**:*
- Over 8 Years of IT experience which includes Data Analysis, Design,
Development & Support of *MS SQL Server 2008, 2005 and 2000* in
Warehouse, Query and Server Performance Tuning in Production, QA and
Development Environments.
- Hands on experience in creating database objects such as Tables,
Constraints, Indexes, Views, Indexed Views, Stored Procedures, Triggers and
Cursors.
- Experience in Enterprise Data Modeling (Dimensional & Relational) with
a good understanding of the Data modeling concepts like Star-Schema
Modeling, Snowflakes modeling, Conceptual, Logical and Physical design.
- Experience with SQL Server DTS/SSIS packages which include designing
and implementing ETL packages that involves data extraction from different
sources such as CSV, MS Excel, SQL Server and Oracle.
- Utilized the *fuzzy* *logic* transformations like *fuzzy* *grouping*and
*fuzzy* *lookup* for cleansing techniques and also have excellent
knowledge of other transformations like *derived* *columns*, *lookups*, *
SCDs* and conditional splits.
- ·Experience in creating *Master* *Child* *Packages* and Worked with XML
and SQL Table configurations for modifying the SSIS packages from a
test/development environment to the production servers for day to day
operation.
- Expertise in *error* *handling* and *debugging* *packages* using *
checkpoints*, *data* *viewers*, *breakpoints*, *event* *handlers* and *
Loggings*.
- *Tested* and *deployed* *packages* into production servers by creating
*package* *configurations*.
- Created *Cubes* using the *SQL Server Analysis Services* in support of
front end applications and cube objects such as *Partitions,
Aggregations,* *Translations, and Perspectives*.
- Excellent experience managing and optimizing very large cubes by
*partitioning
the cubes* and working with different storage modes like *MOLAP, ROLAP
and HOLAP*.
- Created basic *MDX statements*
- Experience in creating *Ad Hoc* Reports using SQL server 2005/2008
Reporting Services.
- Forward Engineering and Reverse Engineering using *ER-Win Case tool*
- Designing and implementing *Backup/Restore Strategies* for the *SQL
databases.*
- *Configured and Implemented SQL SERVER Mirroring High Available
Solutions.*
- Implementation of *MS SQL database Replications methodologies including
Peer to Peer Replication*.
- Experience in setting up the disaster recovery Database sites using SQL
SERVER *Log shipping.*
- Good experience using third party DB tools like *Red Gate* and *Quest.*
- Excellent *communication *and *verbal skills*.
- Highly *motivated* with excellent *analytical skills* and an ability to
learn new systems and business procedures.
*Reddy Profile Summary:*
- *Over 9* years of IT Professional experience in Planning, Development,
Client Analysis, Database Design, and Presentation using SQL Server
2008/2005/2000.OBIEE,Hyperion Essbase 9.3
- Strong understanding and experience over Business Intelligence, And
Data warehousing.
- Vertical industry experience includes Financial Services, Insurance,
Retail, Mortgage and Banking.
- Experienced in using tools like Data Transformation Services (DTS) and
SSIS with MS SQL Server 2000/2005/2008.
- Good knowledge of Normalization/De-normalization, data design
methodology and building Referential Integrity.
- Experienced in TSQL (DDL,DML), documenting, coding, programming,
modifying and implementing Business Intelligence solutions using SQL
Server 2000/2005/2008.
- Expertise in creating Complex Stored Procedures, Queries for the
application team and for the end users based on the business requirement.
- T-SQL coding and testing: functions, views, triggers, cursors,
dictionary, stored procedures, etc.
- Good Knowledge in system tables and stored procedures using T-SQL.
- Creation such as Tables, Views, User Created Data Types, Indexes,
Stored Procedures, Cursors, Triggers and more.
- Experienced in SQL Server Reporting Services (SSRS), SQL Server
Integration Services (SSIS), Data Transform Services (DTS) and SQL Server
Analysis Services (SSAS).
- Expertise in SQL Server 2005 Analysis Services (SSAS) delivers online
analytical processing (OLAP) and data mining functionality for business
intelligence applications
- Involved in creating MDX queries, With OLEDB.
- Experienced in transforming complex business logic into Database
design and maintaining it by using SQL functionality such as Stored
Procedures, User Defined Functions, Views, and DTS.
- Experienced in Data Extraction, Transforming and Loading (ETL) between
Homogenous and Heterogeneous System using SQL tools like SSIS, Data
Transformation Services (DTS), Bulk Insert, BCP, and XML.
- Developed skills in stored procedures, Ad-Hoc SQL Queries, triggers,
UDF, custom DTS packages using Visual Basic.
- Reviewed, analyzed, and modified programming systems including
encoding, testing, debugging and installing to support an organization's
client/server software applications.
- Knowledge in analyzing Data warehouse by building cubes using SQL
Server Analysis Services (SSAS).
- Experienced in generating reports like matrix, parameterized and drill
through reports using SSRS and developed stored procedures using functions
to generate various kinds of reports using SSRS.
With regards,
Kishore||kish...@dvarit.com <kal...@dvarit.com>||
Ph : 520-282-5806|| E-Fax : 888-893-5332
DAVAR IT Services Inc || 5428 , Century plaza way,
San Jose, CA-95111,USA.
*Davar IT Services Inc* is specialized in excellent consultants working on
various technologies like *Java, .Net, SQL Server, Websphere, Oracle and
Oracle APPS.* If you have any requirements on above mentioned technologies,
send us the requirement and we would be happy to share our consultant
details with you.
"Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail
cannot be considered Spam as long as we include contact information . In
case you do not wish to receive this email, please send an e-mail to
kish...@dvarit.com with subject "REMOVE".
--
You received this message because you are subscribed to the Google Groups
"Powerbuilder Assignments" group.
To post to this group, send email to powerbuilder-assignme...@googlegroups.com.
To unsubscribe from this group, send email to
powerbuilder-assignments+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/powerbuilder-assignments?hl=en.
