Over 6 years of Experience in SQL server databases and Data Loading and Reporting tools with SSIS, SSAS, SSRS, Power BI, SQL Server Integration Services (SSIS).
Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes (Clustered and Non Clustered), Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
Proficient in designing and deployment SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Conditional Split, Aggregate, Derived Column, Sort, Multi-Cast, Union, and Data Conversion Transformations. Experience in dealing with different source and target (like Oracle 11g, SQL Server 2008/2012, Hive, Tera Data, Cassandra, Sales Force, , CSV, flat file, Text Format Data) using different type of connection like ( OLE DB, ODBC, ADO .Net ).
Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management. Maintaining the Log and Audit information in SQL tables,
Experienced in providing Logging, Error Handling by using Event Handler for SSIS Packages Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
Hands on generating SSIS packages using Business Intelligence Markup Language (BIML) terminology. Experienced in developing Window Batch Script to execute SSIS package.
Configured Jobs using BMC product Control M 8.1. Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional , Table, Matrix, Chart and Sub Reports Developing reports on SSRS on SQL Server.
Understanding of SSAS, OLAP cube and Architecture. Knowledge of Storage Modes (MOLAP, ROLAP and HOLAP) and processing Cubes using SSIS and SSMS. Experience in writing expressions in SSRS and Expert in fine tuning the reports.
Created many Drill through and Drill Down reports using SSRS. Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
Worked on Power BI and prepared dashboards using Tableau to make it more attractive. Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX. Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.
Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2008 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files. Knowledge of SFDC standard Data structures and familiarity with designing Custom Objects and Force.com platform and Force.com Sites.
Experienced in working with SQL Query Analyzer, SQL Server Management Studio and Business Intelligence Development Studio, scheduling jobs with SQL Server Agent, SQL Server Storage Structures, Index (Clustered and non-Clustered) and SQL Profiler.
As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
Data Ware Housing tool : SQL Server Integration Services (SSIS), Informatica Power Center 9.1
Reporting Tool: SQL Server Reporting Services, Tableau 7.0, Power BI, Power Map, Report Builder
Data base: SQL Server 2008/ 2012, Oracle 11g, Hive, Tera Data, Cassandra
Cloud Services: Microsoft Azure, Sales Force
Programming Language :T-SQL, SQL SOAP
App Servers: IIS
IDEs/ Tools: Microsoft Visual Studio (Shell & BIDS), SQL Server Management Studio, Tera Data Studio, SQL Developer
Revision Controlling Systems: Borland StarTeam, IBM RTC
Scheduling Tool Control M
Methodologies: Agile (SCRUM)
to Current The children's Place Secaucus NJ – Secaucus,
The children's Place The Children's Place, the largest pure-play children's specialty apparel retailer in North America.
The Children's Place designs, contracts to manufacture and sells fashionable, high-quality merchandise at value prices and is the #1 brand recommended by moms.
The headquarters of Children's Place is at Secaucus, NJ.
Responsibilities: Managing the design and coding of Source Dependent Extracts, Source Independent Loads, and Post Load Processes from source to target systems Managing the design and implementation of user defined Dashboards and Reports Optimized the performance of queries in TSQL queries, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary Designed different kinds of reports like Linked, cascaded and parameterized reports and Worked on Drill Down and Drill-through Reports etc.
Expert in working on all activities related to the development, implementation, administration and support of ETL processes using Bulk Copy Process (BCP), Data Transformation Services (DTS) and Change Data Capture (CDC) Worked on Type 1 and Type 2 packages for incremental to load data from source to DataMart.
Wrote complex SQL queries for data analysis to build up reports for business users.
Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
Created different visualization in Power BI according to the requirements.
Responsible for deploying the SSIS packages and scheduling the package through jobs in all tiers Including dev, test and production.
Created different Facts and Dimension tables to increase the performance of complex SQL queries that are used in SSRS reporting.
Created packages with different control flow options and data flow transformations such as Conditional Split, Derived Column, Look up, Data Conversion, Merge, Merge Join Used SSIS and SQL Server stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
Extensively worked on production support that includes Deployment of SSIS Packages into Development, Production Servers, Creating, Scheduling and Managing the SQL Jobs.
Extensively worked on Design and development of SSIS (ETL) packages to extract, transform and load data from different Sources like Excel files, flat files to the Data warehouse using different tasks and transformations like File System Task, Data Flow Task, Derived Columns, and Execute SQL Task.
Worked on Execution of the paths depending on the success, failure or Completion of other tasks with precedence constraints and expressions to determine the workflow.
Environment: SQL Server 2014/2012/2008 R2/2008, T-SQL, PL/SQL, Excel, Power BI, TOAD, Visual Studio 2010/2012/2013.
to 08/2015 Black Hawk Networks – Pleasanton,
Black Hawk Networks in the United States is building toward the future with innovations spanning a growing spectrum of technologies.
Project is on Data storage media and data center services.
In this project I used SSIS Packages for ETL purpose, configure source, target mapping and transformation and finally loaded the data on SQL server tables.
SSRS reports were run on top of these tables created for the better visibility of data for Managers.
to 10/2013 Vision Comptech
Data digitalization and Migration services This is E-Government Project initiated as interface between government and end user to solve billing related complexity, customer management, secure payment, failed transaction management, customer messaging and error handling.
Company designed CSI solution to interact with this interface.
Under this effort DDMS is portfolio which is responsible to handling data captured by CSI channel, external government web services, or raw data received by third party vendor.
Bachelor of Technology: Computer Science and Engineering2012Rajasthan Technical University-