11+ years of extensive information technology experiences in MSBI Tools (SSIS, SSRS & SSAS, and Power BI), Crystal Reports and Tableau. * Expert in using T-SQL to Create Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, SQL Joins, Data Integrity, Cursors and Indexes. * Experienced in Extracting, Transforming and Loading (ETL) from heterogenous Data sources like Oracle, Flat file, Raw file, XML, Excel and OLE DB to Flat file, XML, Excel, OLE DB Destinations using various Connection managers. * Performed Various SSIS control flow tasks and Data transformation tasks like Data conversion, Derived column, Script task, Look-up, Merge, Bulk Insert, Fuzzy Look-up. * Worked with configuring Check points, Data viewers, Break points, providing logging, Debugging and Error handling for the SSIS packages created. * Created SQL Server jobs to automate the execution of SSIS packages at desired time according to business needs. * Very good at Project deployment model, Package deployment model, creating environments, SSIS Catalog, in creating configuration files to deploy the SSIS packages across all environments. * Good Knowledge in Informatica Client Tools - Designer, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor. * Experience in developing custom reports and creating various types of reports like on demand, drill down, Drill-through, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Sub Reports, Ad hoc Reports, dynamic grouping, Cross-Tab, graphical, distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) and Business Intelligence Development Studio (BIDS). * Good knowledge of Data Marts, Data warehousing, OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, FACT and Dimensions Tables using SQL Server Analysis Services. * Created Relationships, Calculations, KPI's, Actions, Partitions, Aggregations, Perspectives, Hierarchies and Translations * Strong understanding in installing MS SQL SERVER on both AWS and Azure environments. Good understanding on AWS services like EC2, Cloud Front, and Cloud Formation templates etc. * Basic Knowledge of Hadoop Development and various components such as HDFS, Job Tracker, Task Tracker, Data Node, Name Node and Map Reduce concepts. * Extensive experience using Tableau Server, Tableau Desktop and Tableau Public. * Proficient in Configuring and Administration of Tableau Server. * Experience in implementing Data blending, Replace references, Customized queries and advanced visualizations in Tableau. * Experience designing and developing various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Highlights:

• Structured Query Language
• Microsoft Excel
• Microsoft SQL Server
• ETL
• Stored Procedures
• Microsoft
• Triggers
• Management
• Software
• Business Requirements