SUMMARY:

• Over 7 years of professional experience as a MS SQL Server/ETL/Business Intelligence developer, responsible for designing and developing T - SQL queries, ETL packages, and business reports using SQL Server Management Studio(SSMS), MS BI Suite and Tableau
• Extensive experience with multiple development environments including SQL Server 2008/2008 R2/2012, Visual Studio 2008/2010, SharePoint 2010/2013, Windows Server 2012 R2
• Adept in developing Stored Procedures, User-defined Functions(UDFs), CTEs, Triggers, Indexes, Indexed views, Transactions, and queries using T-SQL
• Expert in query optimization and performance tuning using performance monitoring tools such as SQL Server Profiler, Database Engine Tuning Advisor, as well as analyzing Execution Plans, creating Indexes and implementing Horizontal Table Partitioning
• High proficiency in creating, documenting and deploying ETL packages to Integration Service Server under both Package Deployment Model and Project Deployment Model to load data from homogenous and heterogeneous data sources into data warehouses and data marts
• Leading experience in data cleansing, data validation in staging zone to ensure data quality, as well as loading and transforming data using transformations including Sort, Lookup, Fuzzy Lookup, Conditional Split, and Cache Transform to remove duplicates and apply business rules
• Highly skilled in implementing initial data loading using Bulk Insert Task, Fast Load, as well as incremental data loading using techniques such as Slowly Changing Dimensions(SCDs), Change Data Capture(CDC) to extract data from staging tables to destination
• Proficient in designing and developing on-demand and scheduled reports including Sub-Reports, Parameterized Reports, Drill-Down Reports, Drill-Through Reports, and Snapshot Reports in SQL Server Reporting Services(SSRS) and deploying to end users through Data-Driven subscriptions and SharePoint Server per business requirements
• Solid Experience working with Tableau to meet clients’ requirements, including creating visualizations, building dashboards and customizing reports
• Profound understanding of Enterprise Data Warehouse(EDW)/Operational Data Store(ODS) modeling concepts including OLTP/OLAP systems, Dimension/Fact tables, Ralph Kimball/Bill Inmon models and Star/Snowflake schemas
• Comprehensive knowledge of various Software Development Lifecycle(SDLC) methods such as Waterfall, Agile and Scrum
• Outstanding skills of analysis, problem solving and effective communication to accomplish projects either independently or with other team members in a fast-paced environment

TECHNICAL SKILLSET:

RDBMS/OLTP: MS SQL Server 2008/2008R2/2012

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

Reporting: SQL Server Reporting Services(SSRS), SQL Server Report Builder 1.0/2.0/3.0, Tableau 8/9/10

Performance Tuning: Execution Plan Analysis, SQL Server Profiler, Database Engine Tuning Advisor, Index Design, Table Partitioning

Languages: T-SQL, C++, MatLab

Development Platforms: Visual Studio 2008/2010, SharePoint 2010/2013, Windows Server 2012 R2, Team Foundation Server(TFS) 2008/2010

PROFESSIONAL EXPERIENCE:

Confidential, Wayne, NJ

MS SQL Developer/BI Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Worked closely with managers and end-users to create and evaluate business requirements to implement delivery of effective business intelligence and reporting solutions
• Determined operational objectives by studying business rules, gathering information, evaluating output, and clarifying requirements and formats
• Used T-SQL in SQL Server 2012 to develop Stored Procedures, Triggers, Clustered & Non-clustered Indexes, Views, Indexed Views, and User-Defined Functions (UDFs)
• Improved the performance on existing stored procedures and queries by analyzing execution plans, logs, and using SQL Server Profiler and Database Engine Tuning Advisor
• Developed and Deployed SQL Server Integration Services (SSIS) ETL Packages and other back-end processes to maintain the system integration and ETL processes to facilitate the creation and population of the Enterprise Data Warehouse (EDW)
• Assisted in design and data modeling efforts of Data Marts and Enterprise Data Warehouse
• Used SQL Server Reporting Services (SSRS) and Tableau to design and develop solutions to create business reports and dashboards including sub-reports, snapshot reports, parameterized reports, drill-down reports, and drill through reports per the business requirements
• Created technical and functional documentation for SQL Server development and SSIS package development/deployment
• Reviewed documentation with developers, clarified any questions or issues, and presented to the managers for approval and implementation

Environment: SQL Server 2012, SQL Server Management Studio(SSMS), MS BI Suite(SSIS/SSRS), SQL Server Data Tools (SSDT), Report Builder, Windows Server 2012 R2, SharePoint 2013, Visual Studio 2010, MS Office Suite (Excel, PowerPoint, Word) 2013, Tableau 10

Confidential, NYC, NY

Business Intelligence (SSIS/SSRS) Developer

Responsibilities:

• Replaced Oracle legacy system with SQL Server; created SSIS packages to migrate data from Oracle legacy system to MS SQL Server database
• Maintained data delivery from legacy system to ODS daily (truncated and loaded) and then loaded data into Oracle DW
• Translated and simplified business requirements as well as identified and analyzed Key Indicator (KI) for the project reports
• Reviewed business requirements to ensure they have been well-defined and cover the scope of the project
• Attended and participated in user and project meetings and teamed to expand knowledge
• Performed Data mapping, Business Unit mapping, and verified data structure by using SQL queries
• Designed ETL packages to load data from data source to the destination and performed different kinds of transformations such as Conditional Split, Derived Column, Data Conversion, Look Up, Merge Join as required using SQL Server Integration Services (SSIS) 
• Prepared technical documentation for the ETL implementation and adjusted stored procedures for report generation
• Created Report-Models for ad-hoc reporting and analysis
• Created drill-down, parameterized reports using SQL Server Reporting Services (SSRS)
• Deployed reports to reporting server and created snapshot for certain reports; scheduled to run on weekly basis

Environment: SQL Server 2008 R2/2012, SQL Server Management Studio(SSMS), MS BI Suite(SSIS/SSRS), SQL Server Data Tools (SSDT), Report Builder 3.0, Team Foundation Server(TFS) 2010, Visual Studio 2010, MS Office Suite (Excel, PowerPoint, Word)2013, Tableau 8/9

Confidential, Columbus, OH

BI Developer(SSMS/SSIS/SSRS/Tableau)

Responsibilities:

• Used T-SQL in SQL Server Management Studio (SSMS) to develop Stored Procedures, User-Defined Functions (UDFs) and Views
• Integrated and extracted source data using SSIS ETL tool and stored procedures created in SQL Server Management Studio (SSMS), and developed transformation logic and designed ETL packages
• Optimized the performance of pre-existing ETL packages; used XML configuration, SQL Server table, as well as Environment Variable configuration to prepare deployment-ready packages
• Deployed & configured ETL packages, scheduled the package using SQL Server Agent to run the packages on weekly basis and run reconciliation queries to cross-check the data
• Involved in improving the performance of Stored Procedures and queries in SQL Server Management Studio (SSMS)
• Developed & implemented Financial Analysis Reports/Dashboards using SSRS/Tableau (i.e. P&L reports, EBIT, EBITDA reports), created Trailing Twelve Months (TTM) for all these reports.
• Developed dynamic GL reports: (a) Gross Margin (b) Net Revenue (c) Operating Expenses (d) Summarized Reports based on the Profit Center (Location) etc., using SSRS/Tableau, scheduled the reports to run every month and distributed them to users through mailing server subscriptions and SharePoint server
• Translated and simplified business requirements as well as identified and analyzed Key Indicator (KI) for the project reports
• Reviewed business requirements to ensure they have been well-defined and cover the scope of the project
• Attended and participated in user and project meetings and teamed to expand knowledge
• Prepared technical write up for the ETL implementation and adjusted stored procedures for report generation
• Worked with the QA team to test various dashboard changes within new and existing models as well as monitored and address data quality

Environment: SQL Server 2008 R2, SQL Server Management Studio (SSMS), MS BI Suite(SSIS/SSRS), SQL Server Data Tools (SSDT), Report Builder, Team Foundation Server(TFS) 2008, SharePoint 2010, Visual Studio 2010, MS Office Suite (Excel, PowerPoint, Word)2010, Tableau 8.0

Confidential, Cleveland, OH

MS SQL Developer(SSMS/SSIS/SSRS)

Responsibilities:

• Developed Stored Procedures, User-Defined Functions(UDFs), Indexed Views, and DMLs to facilitate ETL processes
• Developed ETL packages in SSIS to ensure data quality and data consistency using Lookup, Execute SQL Task, Sequence Container, etc
• Performed data migration from PCG/PCW APP to data warehouse & data marts using a combination of techniques such as T-SQL/Stored Procedures (Merge Statement/Checksum Function) and Change Data Capture (CDC)
• Designed a highly effective naming convention for all SSIS/SSRS packages (i.e. Businees Scope Name.Solution Name.ETL Type Name.ETL Task Name)
• Created SSIS Log Tracking database in SQL Server Management Studio (SSMS) containing multiple tables including Execution Status, Business Scope, Processing Log, Error Log, etc.
• Created an ETL Template to be attached on all other packages as parent package to track Package ID, LOG ID, Database Name, and Server Name
• Included Execute SQL Task in the Template to call pre-coded Stored Procedures, integrated Audit Transformation in data flow, and set event handler on OnPostExecute, OnPreExecute, and OnError events
• Filtered hundreds of packages belonging to multiple categories in SQL Server Configuration Table according to naming convention in Configuration Filter
• Prepared ETL Log Reports and ETL Audit Reports in SQL Server Reporting Services (SSRS) for project manager to check run status of ETL packages such as ETL name, data flow type, start time, execution time, status, and error message

Environment: SQL Server 2008, SQL Server Management Studio(SSMS), MS BI Suite(SSIS/SSRS), SQL Server Data Tools (SSDT), Team Foundation Server(TFS) 2008, Visual Studio 2010, MS Office Suite (Excel, PowerPoint, Word) 2010

Confidential

MS SQL Developer(SSMS/SSIS/SSRS)

Responsibilities:

• Involved in gathering requirements from business and IT managers and created documentation template and documented project requirements
• Used T-SQL to develop Stored Procedures, User-Defined Functions (UDFs), Indexed Views, and DML Triggers to facilitate ETL processes in SQL Server 2005
• Integrated data from different departments (i.e. Marketing, Sales, Accounting, etc), implemented data cleansing and loaded the processed data into the destination using SSIS ETL tools
• Involved in developing initial data loading/incremental data loading ETL packages, Staging Data ETL packages, Report Requirements Document and Synchronized these packages/documents onto SharePoint Server
• Created SSIS ETL packages configuration files (XML configuration and SQL Server table configuration) for DBAs to monitor the package execution using SQL Server Agent
• Provided reporting solutions to handle information related to revenue and cost in different regions on weekly basis using SQL Server Reporting Services (SSRS)
• Increased the performance necessary for statistical reporting by 5% by implementing performance monitoring, tuning and optimizing indexes

Environment: SQL Server 2005, SQL Server Management Studio(SSMS), MS BI Suite(SSIS/SSRS), SQL Server Data Tools (SSDT), Visual Studio 2008, MS Office Suite (Excel, PowerPoint, Word)2007