Kindly find the details of my consultant available for your direct client project. Reply with complete Job description at sadath@mutexsystems.com
Consultant"s info:-
Name: Mareeswaran Kathiresan
Total exp: 11+ years
Current location: Wilmington DE
Relocation: Open
Visa: H1b
Availability: 2 week notice
Resume Summary
Æ Microsoft Certified IT Professional with more than 11.5 years of IT experience.
Æ I have worked primarily in the domain of Manufacturing/Retail/Banking for the clients Microsoft/Target/JPMC as a Developer/Senior Developer/Scrum Member/Technology Analyst/Technical lead/Technical Architect. My Current Role in Cognizant is Technical Architect/Senior ETL Tech Lead.
Æ Strong experience in SQL Server with Business Intelligence(SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)).
Æ Proficient experience in POWER BI and AZURE.
Æ My technological forte is SQL Server,SSIS,SSRS,SSAS,POWER-BI,AZURE,BIGDATA,Hadoop, ,QC,HIVE,PIG,MAPREDUCE,SPARK,SCALA,PYTHON,MAPREDUCE.
Æ Hands-on experience with Azure Service Bus and ASE, App Insights.
Æ Extensive knowledge of relational and multi-dimensional data design and development techniques including star schema, snowflake schema, cube design, ETL and others.
Æ Highly proficient in translating business requirements to technical requirements.
Æ Expertise in writing complex SQL and MDX queries, creating Stored Procedures
Æ Proficient Experience in Hadoop data ingestion
Æ Proficient experience in design and development of SSIS (ETL) packages
Æ Worked in Big Data and Hadoop projects and used HIVE\SQOOP\HDFS for data processing and ETL operations. Completed training in Hadoop.
Æ Extensively worked on Data Extractions, Transformations and Loading from various data sources like MS-Excel, Flat files,Oracle, Teradata, DB2 to MS SQL Server using Microsoft SSIS.
Æ Thorough Knowledge of Various SSIS objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers etc.
Æ Experience in SSIS script task using C sharp, look up transformations and data flow tasks.
Æ Used Configuration Files in SSIS to ease the process of moving the packages across servers.
Æ Experience in providing Logging, Error handling by using Event Handler for SSIS Packages.
Æ Created SSIS packages to load various Dimensions and Fact tables based on complex business requirements.
Æ Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.
Æ Configured Send Mail Task for sending automatic emails when a SSIS package is failed or succeed.
Æ Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
Æ DeployedSSIS Packages in the Testing, Staging Server, Production Servers.
Æ Updated existing SSIS packages according to business requirement changes.
Æ Extensively worked on performance tuning of the ETL process.
Æ Expertise in generating tabular reports, Matrix reports, Ad hoc reports, Drill-down reports, Cascaded reports, List reports, Parameterized reports, Sub reports using SSRS.
Æ Created SSRS subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.
Æ Deployed reports in the Testing, Staging Server, Production Servers.
Æ Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
Æ Experience in Performance tuning of Queries.
Æ Extensive experience in Data Integration and Data Architecture and Modeling.
Æ Extensive experience in Relational Data modelling, creation of logical and physical design for databases and proficient in creating E-R diagram using Erwin and Visio.
Æ Strong concepts of Data Warehousing, strategies for ETL, identifying metrics, dimensions, hierarchies and design dimensional schema (Star, Snowflake) and implementing slowly changing dimension etc.
Æ Excellent T-SQL development skills to query complex relational databases with the development of Stored Procedures, User Defined Functions (UDF), Cursors, Views and Triggers
Æ Involved in troubleshooting issues in Production and UAT environmentsests from WW users
Æ Proficient in extraction, transformation, cleansing, and loading data from heterogeneous data sources of Oracle, MS Access and flat files
Æ Executed few projects in agile methodology and possess detailed information about agile and scrum working model.
Æ Adapt to new tools and technologies in traditional BI space, Microsoft Azure and Hadoop ecosystem
Technical Expertise:
| Category | Details |
| Data warehousing: | SSIS (SQL Server Integration Services) SSRS (SQL Server Reporting Services) SSAS (SQL Server Analysis Services) Power BI AZURE |
| Databases | SQL Server 2005, 2008 and 2012 , SQL Azure Oracle Teradata |
| Datamodelling tool | Erwin |
| Big Data/Hadoop | Hive ,Sqoop ,Oozie ,HDFS, PIG , MapReduce, SPARK |
| Programming Languages | C sharp.net , Python , R , Java |
| Operating System | Windows XP; Windows NT/Server 2003. Windows Server 2008 |
| Tools/Utilities | SQL Server Management Studio Visual Studio - Team foundation Server, GITHUB, HIPCHAT,QC,VISIO |
| System Development | Requirements analysis,Design, Analysis; Coding and Testing |
| Scheduling Tool | Control-M, SQL Server Agent |
| Methodologies | Agile, Waterfall |
Thanks,
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 