SUMMARY:

• Over 7 years of IT experience in database design, development and administration using MS SQL Server 2012/2008R2/2005.
• Strong experience in designing Business Intelligence (BI) solutions using MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS) and MS SQL Server Analysis Services (SSAS).
• Experienced in all the stages of SDLC (Software Development Life Cycle) process.
• Extensive experience in creating Tables, Views, Triggers, Stored Procedures, User defined Functions, Indexes and Complex Queries in MS SQL Server using T - SQL.
• Extensive experience in creating Parameterized, Linked, Tabular, Matrix, Drilldown, Drill through, Sub reports, Geographic map as a sub report and Ad hoc reports using SSRS and deploying them onto report servers and SharePoint.
• Expert in creating SSIS Packages using various transformations like Fuzzy Lookup, Fuzzy Grouping, Derived Columns, Conditional Split, Pivot, SCD (Slowly Changing dimensions) based on enterprise data load requirements.
• Expert in designing and deploying ETL solutions using SSIS, DTS, BCP tools to perform data transfers from OLTP to OLAP, different server locations and heterogeneous sources like Oracle, DB2, MS Excel, XML, MS Access, CSV, flat file, Text Format Data.
• Expertise in Data Warehousing methodologies and concepts, including star schema, snowflake schema, dimensional modeling, Normalization and De-Normalization.
• Expert in performance tuning, query optimization, Index management, debugging, statistics sampling and working with SQL profiler, database engine tuning advisor to improve the database process performance.
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Recovery procedure and involved in the migration and upgrade of databases.
• Expert in working with various version of Tableau and building the story lines. Strong experience in blending the data for Tableau worksheets and expert in working with different show me tools.
• Expert in working on database scheduled processes using SQL Agent.
• Highly skilled working as an individual as well in a team. Excellent interpersonal communication, problem solving, documentation and business analytical skills with an ability to adapt new technology quickly and a strong team player.

TECHNICAL SKILLS

Skill set: MS SQL Server 2016/2014/2012/2008R2, Microsoft Reporting services(SSRS), Microsoft Integration Services(SSIS), Microsoft Analysis Services(SSAS), Tableau 8/ 9/10, Windows 2012/2008 /2003/2000 Advanced Server, Windows Exchange Server 2003, Windows9.x, Windows XP, Linux, Unix, C, MS Access, MS Excel, Oracle 9i, Windows PowerShell, IIS 6.0, C#, T-SQL, HTML, DHTML, ASP.Net, VB.Net, XML, Java Script and VB Script, MS Visual Studio 2005, Crystal Reports, Microsoft Visio 2003.

PROFESSIONAL EXPERIENCE

Confidential, Bridgewater, NJ

MS SQL Server Developer/SSRS/SSIS Developer

Responsibilities:

• Creating and modifyingstored procedures for order fulfilment processes
• Created tables, views, indexes, stored procedures, functions using T-SQL based upon the functional specifications and Business Requirement Documentation (BRD).
• Designed and developed SSIS/ETL packages to extract the data from various sources like Oracle, CSV, MS SQL Server and text files.
• Managing SQL Server SSIS/ETL packages for order import and order export processes.
• Loading data into Data warehouse using ETL for reporting and analysis purpose.
• Generating Drill down reports, Drill through reports and Parameterized reports using SSRS based on requirements.
• Designed and deployed reports using MS SQL Server Reporting services (SSRS).
• Automated the creation of monthly Report Snapshots of SSRS reports for auditing and to track the historical data.
• Identified the data sources and wrote stored procedures to load the data into tables for tableau.
• Created calculated fields and parameters using various inbuilt functions in Tableau.
• Deployed the dashboard on to the tableau server.
• Automated several ETL operations in SSIS and SSRS reports by replacing the T-SQL code with stored procedures and creating configuration files, environment variables.
• Maintaining order validation engine jobs through SQL server agent job scheduler
• Creating SSRS reports for client’s order inventory andorder tracking data

Environment: MS SQL Server 2012/2014, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), Tableau 10.1, Oracle, MS Excel, MS Access, Toad, Data Modeler, Windows XP/NT.

Confidential, Morristown, NJ

Data warehouse/ BI Developer

Responsibilities:

• Gathered requirements from business users and documented them based on functional specifications.
• Created and executed several SSIS packages to perform ETL operations of the data from OLTP to data warehouse, as well as from data warehouse to data mart
• Designed and automated various inbound and outbound ETL feeds using SSIS based on enterprise data warehouse data.
• Joined data from different data sources using merge, merge join, and lookup transform.
• Deployed packages in to SSIS catalog and used SQL Server Agent to schedule package execution.
• Set breakpoint to tasks and containers for debugging propose.
• Designed and deployed drill down, drill through, parameterized and sub reports using MS SQL Server Reporting services (SSRS).
• Created scheduled/ad hoc email subscriptions, windows file share (PDF, EXCEL, CSV, XML) subscriptions and data driven subscriptions for SSRS reports based on data representing requirements.
• Rewrote the existing T-SQL queries according to the changing business requirements.
• Adding Key Performance Indicator (KPI) to the cube to evaluate business performance.
• Performed database monitoring and tuning using DB Engine tuning advisor and SQL Profiler and optimized the databases to best performance.
• Created tables, views, indexes, stored procedures, functions using T-SQL based upon the functional specifications and Business Requirement Documentation (BRD).
• Performed unit testing, user acceptance testing of Reports, T-SQL scripts and database objects to test their functionality by creating comprehensive test plans.

Environment: MS SQL Server 2012/2008R2, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Tableau 9.0, Oracle, MS Excel, MS Access, Toad, Data Modeler, Windows XP/NT.

Confidential, Plano, TX

ETL/ SSRS/SSIS Developer

Responsibilities:

• Involved in gathering the requirements and defining various campaigns like DM, EM, IB and OB.
• Responsible to identify the leads to load into different campaigns considering various factors like Assets, Age, Tenure and other factors.
• Analyze the client’s behavior pre and post campaign by looking at the logins, conversation, assets.
• Responsible for analyzing the campaigns success by looking at the various measures that impact the client.
• Analyzed data quality, worked in conjunction with the data warehouse architect on the development of logical data models.
• Created and executed SSIS packages to perform ETL operations
• Used different transformations tools like SCD, Merge, Merge join, derived columns for the SSIS packages.
• Designed, developed and deployed reports in MS SQLServer environment using SSRS-2008 in Business Intelligence Development Studio (BIDS).
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Responsible for query optimization to improve the quality of software by using SQL Profiler.
• Wrote T-SQL queries, stored procedures and used them to build packages.
• Gathered business requirements, defined the tabs for the dashboard and filters for the tool.
• Built the tabs with various charts from show me tool bar like (line chart, pie chart, bar chart).
• Worked with tooltips, colors, sizes and angles for the worksheets to visualize the data.

Environment: MS SQL Server 2008R2, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), DTS, T-SQL, Oracle, MS Excel, MS Access, Windows NT / XP.