Hi,
Greetings. Please find below the available consultant currently available for projects Nationwide unless specified. Your help support and coordination is highly appreciated.
Please let me know if you can consider for any of your open requirement.
Here is the summary of this consultant
Name : RASHMI(SQL)
Current Location : CA
Relocation : OPEN
Experience : 7+ years
SUMMARY:
-- · 7+ years of wide-ranging experience in Database Design, Development, Implementation, Debugging and Testing of software applications to support reporting and Business Intelligence initiatives in Healthcare, Insurance Academic and Finance industries etc.
· Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).
· Experience in integration of various data sources like SQL Server, Oracle, Access DB, DB2 and Flat File,Excel File.
· Highly proficient in packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations Data Conversion and Pivot tables.
· Extensively worked on Control Flow Tasks such as For each Loop Container, For Loop Container, Data Flow Task, File System Task, Script Task, Execute SQL Task, FTP Task, Execute Process Task, Send Mail Task.
· Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, Cleaning bad data, Validating data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, Record Set Destination of the integration services (SSIS).
· Experience in transforming unstructured data from various data sources using SSIS like ConditionalSplit, Lookup, Merge Join and Sort.
· Hands-on star schemas, snowflake schemas, dimensional modeling and reporting tools, operations Data Store concepts, Data Marts and OLAP technologies.
· Highly proficient in creating data sources, data source views, dimensions, measures, measure groups, perspectives, partition aggregations. Analysis and Reporting Services, MDX queries, OLAPCubes, and deployment and processing SSAS objects.
· Strong skills in writing MDX queries to access cubes in SSAS, and creating feeds from OLTP systems.
· Designed and implemented user defined hierarchies in SSAS including parent-child hierarchy.
· Expertise with SSRS (tabular reports, parameterized reports, drilldown, drill through, sub reports, charts etc).
· Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
· Highly proficient in the use of SQL for developing complex stored procedures, triggers, tables, user profiles, user functions, relational database models and data integrity, SQL joins and query writing.
· Extensively worked on Table Design creating Clustered Indexes, Non Clustered Indexes, Primary key Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
· Widely worked on to improve SQL Query performance, SQL Query analytics and highly complex joinsto populate the desired result set.
· Comprehensively worked on SQL scripts using local and Global Temp Tables, Variables and Table Variables, Common Table Expressions (CTE) as per the requirement and convenience.
· Worked on SQL scripts PLSQL, Creating Tables, Clustered/Non Clustered Indexes Joins, to get the desired result sets from the Oracle Database as per the requirement
Hands-on Deploying reports, creating report schedules and subscriptions. Managing and securing reports and Proficient in MS Office includes MS Excel, creating spread sheets, graphs and dashboard reports
-- To receive resume in word format kindly email to Swetha@keybusinessglobal.com
I would very much appreciate hearing from you and having opportunity to serve you on your needs. Looking forward to a fruitful interaction with you and your organization
Regards,
Swetha
Key Business Solutions, Inc.
|| Office: 916 514 6728 || Fax: 916 646 2081 || Email: swetha@keybusinessglobal.com || Website: www.keybusinessglobal.com ||
Note: This email is not intended to be a solicitation. Please accept our apologies and reply in the subject heading with REMOVE to be removed from our mailing list.
You received this message because you are subscribed to the Google Groups "Jobs for USA consultants (Citizen G.C and H1B)" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jobs-for-usa-consultants-citizen-gc-and-h1b+unsubscribe@googlegroups.com.
To post to this group, send email to jobs-for-usa-consultants-citizen-gc-and-h1b@googlegroups.com.
Visit this group at http://groups.google.com/group/jobs-for-usa-consultants-citizen-gc-and-h1b.
For more options, visit https://groups.google.com/d/optout.
0 comments:
Post a Comment