SQL/SSIS/SSRS/SSAS Developer (Available on c2c)
Greetings of the day
Kindly find the details of my consultant available for your direct client requirement, on c2c. Kindly share the complete Job description at sadath@mutexsystems.com
Consultant"s info:-
Name: Sahithi K
Total exp: 7 years
Current location: Charlotte NC
Relocation: NC & SC Only
Availability: 2 week notice
SUMMARY OF EXPERIENCE:
ü 7 years of experience in analysis, design, development, implementation, testing, maintenance, and documentation of Database and Client Server applications.
ü Expert in Microsoft SQL Server 2012 and 2008 backend programming, Extensive experience in creating database objects on MS SQL Server 2012 and 2008.
ü Expertise in Microsoft Business Intelligence Services like SQL Server Integration Services, SQL Server Analysis Services and designing reports using SQL Server Reporting Services.
ü Strong experience in Implementing Stored Procedures, Triggers, Nested Queries, Joins, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models and T-SQL (DDL & DML).
ü Experience in optimizing the queries by creating various clustered, non-clustered indexes and Indexed views.
ü Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages to SSIS.
ü Created SSIS packages to Extract, Transform and load (ETL) data from Excel, Database, XML File and Flat file source by using different SSIS transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
ü Proficient in the SSAS storage and partitions, aggregations, defining hierarchies, calculation of queries and developing reports using MDX and T-SQL.
ü Excellent hands-on experience with data modeling tool like Erwin and strong knowledge of Relational and Dimensional database modeling concepts with star schema and snowflake schema"s design and implementation.
ü Implemented OLAP Cubes, Facts, and Dimensions for providing summarized views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
ü Excellent Knowledge in developing cubes using Partitions, KPI"s, and Perspectives, slow changing dimensions (SCD) etc. and created various user roles (SSAS).
ü Strong ability in defining query for generating drill through, drill down reports, ad-hoc reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS.
ü Excellent Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services (SSAS).
ü Good understanding of Retail, Health care and Financial Industry.
Technical skills:
RDBM/Databases : MSSQL Server Oracle 9i & 11g, Sybase, MS Access and MYSQL.
Programming Languages : T-SQL, PL/SQL, Dynamic SQL, C, JAVA, MDX, XML, HTML, DHTML, Shell
Scripting, JavaScript, Visual Basic 6.0, ASP .NET.
Data Modeling : MS Visio, ERWIN 4.5/4.0, FACT& Dimensions tables, Physical & Logical data
modeling, Star & Snowflake schema Relational, Dimensional and multidimensional modeling and De-normalization Techniques, MSAccess.
BI Tools : SQL, Tableau, SQL Server Integration Services (SSIS) SQL Server Reporting
Services (SSRS)SQL Server Analytical Services (SSAS) Data Transformation
Services (DTS), Visual Studio, BIDS, Power BI, Informatica.
Tools/Database Utilities : SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server
Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management
Console, Business Intelligence Development Studio (BIDS), Toad, IIS 6.0/7.0,
Business Objects, Crystal Reports 9.0, XML, Visual Source Safe, Visual Studio,
Team Foundation Server (TFS).
Application Packages : MS Office, Microsoft SharePoint Server.
Sadath Khan
MuTex Systems Inc
Ph: 908-777-8045 / 908-822-8515 Ex 20| F: 732-909-2191
E : sadath@mutexsystems.com / gmail: srecruiter.no1@gmail.com
Linked in id: https://in.linkedin.com/in/sadath-khan-a0510a81
DISCLAIMER:
Note: This is not an unsolicited mail. Under Bill 1618 Title III passed by the 105th USACongress this email cannot be considered as spam as long as we include our contact information and an option to be removed from our emailing list. If you have received this message in error or, are not interested in receiving our emails, please accept our apologies.To be removed from our mailing list, please reply with the subject line. All removal requests will be honored ASAP. We sincerely apologize for any inconvenience caused to you. Powered by Vultus
Comments
Post a Comment
Thanks