SUMMARY

• 7 years of professional experience as a MS SQL server/ETL/BI developer in designing and developing T - SQL queries, ETL package, and business reports using SSMS, SSIS and SSRS

• Strong understanding of logical and physical Database design and development, data conversion and Normalization concept
• Experienced in data Extraction, Transformation and Loading(ETL) between homogenous and Heterogeneous Systems using SSIS of MS SQL Server
• Expertise in creating, documenting, and deploying ETL package under both Package Deployment Model and Project Deployment Model using SQL Server Integration Services(SSIS) to load data from source to destination
• Professional experience in implementing initial data load using Bulk Insert Task, Fast Load, and Bulk Copy Program. Implementing incremental data load using Slowly Changing Dimension(SCDs), Change Tracking and Change Data Capture(CDC)
• Ability in Error Logging, Exception handling and Custom Logging for SSIS package, Performance tuning in SSIS package
• Profound understanding of Enterprise Data Warehouse(EDW) concepts including OLTP/OLAP, Dimension/Fact tale, Top-down/Bottom-Models, Star/Snowflake schemas
• Proficient in T-SQL, Query optimization, creation of Views, Triggers, User-defined functions, Store Procedures and Dynamic-queries and in using CTE, Temp table, Table Variable and View as well as Subquery and join
• Experienced in designing and deploying tabular reports, drill-down reports, drill through reports, multicolumn reports, linked reports and parameterized reports by using SQL SSRS
• Professional skill in Tableau visualization using Bubble Char, Tree Maps, Funnel Charts, Dual Axis, Box Plots, Waterfall Charts, Geographic visualization and local and global filter that meet client’s requirements
• Proficient in Developing Dashboards using Tableau and user stories to deliver insights and advanced visualization. Implementing Data blending, Replace references and customized queries in Tableau
• Passion for exploring new technology, strong social responsibility, outstanding interpersonal communication, problem solving, documentation and business analytical skills
• Familiar with Agile and Waterfall SDLC methodologies and worked with cross-functional team environments

TECHNICAL EXPERTISE

RDBMS/OLTP: SQL 2008/2008R2/2012/2014, Oracle 9i/10g, AccessData Warehouse/OLAP SQL Server Analysis Services(SSAS)

Reporting Tools: SQL Server Reporting Service(SSRS), Tableau 8/9/10, IBM Cognos, PowerBI

ETL: SQL Server Integration Service (SSIS), Data Transformation Services, SQL Server Data Tools(SSDT)

Project Management Tools: JIRA, SharePoint

Platform: Visual Studio 2005/2008/2010

Programming Language: C#, T-SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Edison, NJ

MS SQL/Business Intelligence Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Involved in gathering requirements from business and IT managers and created documentation template and documented project requirements

• Wrote T-SQL queries to create Store Procedures, User-Defined Functions, Indexed Views, and DML Trigger to facilitate ETL processes in SQL Server 2012
• Developed SQL Server Integration Services(SSIS) ETL Packages and other back-end processes to support system integration and ETL process to facilitate the creation and population of Enterprise Data Warehouse(EDW)
• Developed initial load/incremental load ETL packages, Staging Data ETL packages, Package Test Script, and Reports Requirements/Unit Testing Document and Synchronized these packages/document onto SharePoint Server
• Developed ETL packages in SSIS to ensure data quality and data consistency using Lookup, Execute SQL task, Sequence Container, Breakpoint, and Checkpoint
• Used SQL Server Reporting Services(SSRS) to design and develop solutions to support business intelligence reports including Sub-Reports, Snapshot Reports, Parameterized Reports, Drill-down Reports, and Drill through Reports
• Used Tableau to design and create tableau visualization using Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Chart, Box Plots, Waterfall Chart, Geographic Visualization and local and global filters regarding the business and client requirement
• Developed dynamic General Ledger(GL) Reports: Gross Margin, Net Revenue, Operating Expenses, Summarized Reports based on the Profit Center suing SSRS/Tableau. Run reports every month and distributed them to respective users through mailing server subscriptions and SharePoint server.
• Developed invoice reports, Expenditure Trend Analysis Reports, and Asset Depreciation report using SSRS and deployed to Enterprise Dashboard for management
• Developed Operational Financial Reports/ Dashboards (i.e. operational income & expenditure trend analysis, AR/AP, inventory turnover reports) using SSRS/Tableau
• Prepared ETL Log Reports and ETL Audit Reports in SQL Server Reporting Services (SSIS) for manager to check run status of ETL packages such as ETL name, data flow type, start time, finish time, status, and error message

Environment: SQL Server 2012, Oracle 10g, SQL Server management Studio (SSMS), SQL Server Integration Service(SSIS), SQL Server Report Service (SSRS), SQL Server Data Tool(SSDT), SQL Server Analytical Tool(SSAS), Visual Studio 2012, MS Office Suite (Excel, PowerPoint, Word) 2012, Tableau 8/9

Confidential, Piscataway, NJ

MS Business Intelligence Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Developed Store Procedures, User-Defined Functions, Indexed Views, and DML Triggers to facilitate ETL processes using T-SQL

• Integrated data from different departments into staging database using SSIS STL tools and cleansed and loaded the processed data into target data warehouse/data marts
• Implementing incremental loading from Source system into Data Warehouse & data mart using the techniques including T-SQL/Store Procedures (Merge statement/Checksum Functions), Slowly Changing Dimensions(SCDs) type 1/2/3, and Change Data Capture(CDC)
• Deployed & configured ETL package and coordinated with DBA to schedule the package in SQL server Agent to run the packaged every weekend and run reconciliation queries to cross-check the data
• Developed ETL packages in SSIS to ensure data quality and data consistency using Lookup, Execute SQL task, Sequence Container, Breakpoint, and Checkpoint
• Deployed& configured ETL packages and coordinated with DBAs to schedule the package in SQL server Agent to run the packages every weekend and run reconciliation queries to cross-check the data
• Creating complex report stating revenue generation per year using cascading parameter and Tablix structure to create summarized reports in SSRS
• Deployed& Implemented Financial Analysis Reports using SSRS/Tableau and Create Trailing Twelve Months for all these report
• Deployed Operational Financial Reports/Dashboards using SSRS/Tableau

Environment: SQL Server 2012, Service(SSIS), SQL Server Report Service (SSRS), SQL Server Data Tool(SSDT), Tableau 8/9, MS Access, MS Excel, MS Word, MS Outlook

Confidential, Dallas, TX

MS SQL Business Intelligence Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Gathering user requirements from IT, Human Resource, Venders and provided the functional and non-functional analysis regarding to the enterprise IT architecture, and business architecture

• Created Store Procedures, User-Defined Functions, Indexed Views, and DML Triggers to facilitate ETL processes using T-SQL
• Using T-SQL queries and dynamic queries in SQL server management Studio(SSMS) to create databases for quarterly HR Workforce Scorecard regarding to parameters and time frame
• Created SQL Server integration Services(SSIS) ETL packages and other back-end processes to support system integration and ETL processes to facilitate the creation and population of Enterprise Data Warehouse(EDW)
• Created SSIS packages to perform filtering operations and to import the data on daily basis from the OLTP system, Staging DB to Data Warehouse and Data Marts
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages
• Deployed SSRS monthly reports and applied business rules to maintain the data security and integrity prior to the disclosure of the workforce information
• Designed data visualizations and other KPI reports accordingly to HR scorecard and executive’s proposal
• Created Snapshot report, parameterized Reports, Drill-down reports and Drill-through Reports by using SQL Server Service(SSRS)

Environment: MS SQL Server 2008 R2, Service(SSIS), SQL Server Management Studio, SQL Server Report Service (SSRS), SQL Server Data Tool(SSDT), SQL Server Analytical Tool(SSAS), SQL Profiler, Visual studio 2008

Confidential, Dallas, TX

MS SQL Developer (T-SQL/SSIS)

Responsibilities:

• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server database SQL Server Integration Service(SSIS) to overcome transformation constraints

• Maintained databases, performed software installation and upgrades, monitored database performance, performed capacity planning on SQL Server 2008&2012
• Involved in designing and managing schema objects such as tables, views, clusters, indexes, procedures, triggers and maintained referential integrity using SQL Server
• Managed index, statistics and optimizing queries by using execution plan for tuning the database
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources
• Developed SSIS packages using different types of Error handling for various events
• Created ETL packages in SSIS to ensure data quality and data consistency using Lookup, Execute SQL task, Sequence Container, Breakpoint and Checkpoint
• Performed incremental loading from source systems (i.e. SQL Server, Oracle) into data warehouse & data marts using a combination of techniques including T-SQL/Stored Procedures (Merge Statement/Checksum Function), Slowly Changing Dimensions(SCDs) Type 1/2/3, and Change Data Capture(CDC)
• Work with business analyst to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI report and applications

Environment: MS SQL Server 2008, T-SQL, Microsoft Visual Studio(SSMS), Service(SSIS), SQL Server Report Service (SSRS), SQL Server Data Tool(SSDT), MS Outlook, MS Excel, MS Word

Confidential, Sherwood, AR

MS SQL/Business Intelligence Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Work closely with management and end-user to created and evaluate business requirements to support delivery of effective business intelligence and reporting solutions

• Creating ETL package to migrate data from various data source (Excel, CSV, SQL, Flat File) to the staging (SQL server 2012) and using T-SQL in SQL server 2012 to develop complex Stored Procedures, Triggers, Clustered & Non-Clustered index, Views, and User-Defined Functions(UDFs)
• Used ETL to implement the SCD transformation, to maintain historical data in data warehouse. Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages
• Performed performance tuning on existing stored procedures/queries by analyzing execution plans, logs/statistics, and traces in SQL Server Profiler/Database Engine Tuning Advisor
• Assisted in design and data modeling effort of Data Marts and Enterprise Data Warehouse
• Develop ETL packages in SQL Server integration Services(SSIS) to support system integration and ETL processes to facilitate the creation and population of Enterprise Data Warehouse(EDW)
• Designed and develop solutions to support business intelligence reports and dashboards including sup-report, Snapshot Report, Parameterized Reports, Drill-down Reports, and Drill-Through Reports by using SQL Server Reporting Services(SSRS)
• Created Snapshot report, parameterized Reports, Drill-down reports and Drill-through Reports by using SQL Server Service(SSRS)
• Reviewed documentation with developers, clarified any questions or issues, and presented to the stakeholders for approval and implementation

Environment: MS Access, MS Excel, MS Word, SQL Server management Studio (SSMS), SQL Server Integration Service(SSIS), SQL Server Report Service (SSRS), SQL Server Data Tool(SSDT)