PROFESSIONAL SUMMARY:

• Around 8 years of professional experience as a MS SQL Server/ETL/Business Intelligence developer in designing and developing T - SQL queries, ETL packages, and business reports using SQL Server Management Studio (SSMS), Microsoft BI Stack (SSIS/SSRS/SSAS), and Tableau
• MCSE (Microsoft Certified Solutions Expert) - Business Intelligence and CPA (Certified Public Accountant) with strong business acumen and exposure to financial services (banking) industry and manufacturing (electronics) industry
• Extensive experience with multiple development environments including SQL Server 2005/2008/2008 R2/2012/2014, Visual Studio 2005/2008/2010 , Windows Server 2003 R2/2008/2008 R2/2012, Team Foundation Server (TFS) 2008/2010, and SharePoint 2010
• Outstanding programming skills including UNIX Shell Scripting (bash), C#, and Java
• Highly knowledgeable of various Software Development Lifecycle (SDLC) methodologies such as Waterfall, Agile, and Scrum and deployment environments including DEV, QA, and PROD
• Adept in developing and debugging Stored Procedures, User-defined Functions (UDFs), Triggers, Indexes, Constraints, Transactions, and Queries using Transact-SQL (T-SQL)
• Expert in query optimization and performance tuning using performance monitoring tools such as SQL Server Profiler and Database Engine Tuning Advisor, as well as analyzing Execution Plans, creating Clustered and Non-Clustered Indexes, and performing Horizontal Table Partitioning
• High proficiency in creating, documenting, and deploying ETL packages under both Package Deployment Model and Project Deployment Model using SQL Server Integration Services (SSIS) to load data from homogenous and heterogeneous data sources into data warehouses and data marts
• Leading experience in staging data, cleansing data, and transforming data using transformations including Sort, Lookup, Fuzzy Logic, Execute SQL Task, and Data Quality Services (DQS) to remove duplicates, ensure data quality, and apply business rules
• Skilled in implementing initial data load using Bulk Insert Task, Fast Load, and Bulk Copy Program (BCP) as well as incremental data load using techniques such as Slowly Changing Dimensions (SCDs), Change Tracking, Change Data Capture (CDC), and Transactional Replication
• Expertise in designing and developing Dimensions, Hierarchies, KPIs, and Cubes in SQL Server Data Tools (SSDT) and deploying to SQL Server Analysis Services (SSAS) Server
• Profound understanding of Enterprise Data Warehouse (EDW)/Operational Data Store (ODS) modeling concepts including OLTP/OLAP, Dimension/Fact tables, Top-down/Bottom-up models, Star/Snowflake schemas
• Proficient in designing and developing complex reports such as 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

TECHNICAL SKILLS:

RDBMS/OLTP: SQL Server 2005/2008/2008 R2/2012/2014, Oracle 9i/10g/11g

SQL: T-SQL, PL/SQL

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

ETL: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), SQL Server Data Tools (SSDT), Business Intelligence Development Studio (BIDS), Data Quality Services (DQS), Data Profile Viewer

Data Warehousing/OLAP: SQL Server Analysis Services (SSAS), Multidimensional Expressions (MDX) queries

Reporting Tools: SQL Server Reporting Services (SSRS), Report Builder 1.0/2.0/3.0, QlikView, Tableau

ERP: Microsoft Dynamics GP, SAP FICO, Oracle E-Business Suite (Financials)

Platforms: Visual Studio 2005/2008/2010 , Team Foundation Server (TFS) 2008/2010, SharePoint 2010

Data Modeling Tools: Visio, Erwin, PowerDesigner

Programming Languages: UNIX shell scripting (korn, bash), C#, Java, Python

PROFESSIONAL EXPERIENCE:

Confidential, White Plains, NY

Business Intelligence Consultant (T-SQL/Tableau/SSIS/SSRS)

Responsibilities:

• Created SSIS packages to automate ADW ETL processes with Version Control, Package Logging functionalities.
• Developed Jar Framework for automating ADW processes using Java, Oracle, and UNIX Shell Scripting (bash)
• Created Main Wrapper, Data Loading Wrapper, and Java Wrapper in bash shell scripts
• Developed Java code to connect to Oracle database and execute ETL scripts
• Created Control Table, Log Table, and Raw File Lookup Table for monitoring the ETL process
• Developed Zoot Application Analysis Repository, which is a dataset of credit card pre-application data
• Responsible for tracking FDR (First Data Research) data and generating monthly business reports and validation/custodial reports for credit card transactions including month end and cycle end
• Performed data validation and PCI/PII fields identificationInteracted with business analysts to analyze and review business processes and business requirements
• Collaborated with project manager in reporting project updates and fulfilling project deliverables
• Worked together with senior software developers in data modeling and technical design
• Designed, implemented, and tested reporting solutions using Tableau, SSRS, and T-SQL
• Developed automation codes/packages for reporting ETL processes using SSIS
• Fixed UAT issues/enhancements found/proposed by business analysts and end users
• Wrote business requirements documents and data lineage mapping documents
• Worked with Data Operation Team to hand over data applications in production
• Developed data quality checks on data warehouse, data mart, and reporting data mart levels

Environment: SQL Server 2008 R2, SQL Server Management Studio (SSMS), MS BI Stack (SSIS/SSRS), Windows Server 2008 R2, Visual Studio 2008, MS Office Suite 2010 (Excel, PowerPoint, Word), SVN Version Control, Tableau 9, Tableau Server

Confidential, New York, NY

MS SQL Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Developed Stored Procedures, User-Defined Functions (UDFs), Indexed Views, and DML Triggers to facilitate ETL processes using T-SQL
• Developed 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)
• Designed a highly effective naming convention for all SSIS/SSRS packages (i.e. Business Scope Name.Solution Name.ETL Type Name.ETL Task Name)
• Created an SSIS Log Tracking database in SQL Server containing 8 tables including Business Scope, Solution, Solution ETL, Data Flow Type, Process Log, Error Log, Execute Status, and SSIS Config
• Built Stored Procedures to insert and update Start Log Number and End Log Number and insert package execution information into Process Log and Error Log
• Created an ETL Template to be attached on all other packages as parent package including parameters to track ETL ID, LOG ID, Package Owner Name, 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, finish time, status, and error message

Environment: SQL Server 2008 R2/2012, Oracle 11g, SQL Server Management Studio (SSMS), MS BI Suite (SSIS/SSRS), SQL Server Data Tools (SSDT), Report Builder 3.0, Windows Server 2008 R2, Team Foundation Server (TFS) 2010, SharePoint 2010, Visual Studio 2010, MS Office Suite 2013 (Excel, PowerPoint, Word), Visio

Confidential, Denver, CO

MS SQL Developer (SSMS/SSIS/SSAS/SSRS/Tableau)

Responsibilities:

• Used T-SQL in SQL Server 2012 to develop Stored Procedures, User-Defined Functions (UDFs), Indexed Views, and DML Triggers to support incremental loading packages
• Integrated & Extracted Source Data using SSIS ETL tool and stored procedures from SQL Server and Oracle E-business Suite. Developed transformation logic and designed various ETL packages
• Troubleshot and debugged pre-existing ETL packages using breakpoint and checkpoint to facilitate stability and reusability; used XML configuration and SQL Server table configuration to prepare deployment-ready packages
• 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
• Involved in fine-tuning the code of Stored Procedures in SQL Server to obtain optimal performance
• Prepared Data Sources, Data Source Views, Dimensions, Measures, KPIs, Hierarchies, and Cubes in the OLAP database
• Developed & implemented Financial Analysis Reports using SSRS/Tableau (i.e. P& L reports, Account-wise reports, EBIT, EBITDA, ROIC 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. Ran the reports every month and distributed them to respective users through mailing server subscriptions and SharePoint server
• Developed Invoices Reports, Expenditure Trend Analysis Reports, and Asset Depreciation reports using SSRS and deployed to the Enterprise Dashboard for top management
• Developed Operational Financial Reports/Dashboards (i.e. operational income & expenditure trend analysis, AR/AP, inventory turnover reports) using SSRS/Tableau

Environment: SQL Server 2008 R2/2012, Oracle 10g, Oracle E-Business Suite (Financials), SQL Server Management Studio (SSMS), MS BI Suite (SSIS/SSRS), SQL Server Data Tools (SSDT), SQL Server Analysis Services (SSAS), Multidimensional Expressions (MDX), Report Builder 3.0, Windows Server 2008 R2, Team Foundation Server (TFS) 2008, SharePoint 2010, Visual Studio 2010, MS Office Suite (Excel, PowerPoint, Word) 2010, Tableau 7/8

Confidential, Denver, CO

MS SQL Developer (SSMS/SSIS/SSAS/SSRS/QlikView)

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 2008 R2
• Integrated data from different departments (i.e. Countrywide, Merrill Lynch, & Confidential ) into staging database using SSIS ETL tools and cleansed and loaded the processed data into target data warehouse/data marts
• Involved in developing initial load/incremental load ETL packages, Staging Data ETL packages, Package Test Script, and Report Requirements/Unit Testing Document and synchronized these packages/documents onto Team Foundation Server (TFS) and SharePoint Server
• Created SSIS ETL packages configuration files (XML configuration and SQL Server table configuration) for DBAs to deploy in SQL Server Agent
• Built new configurable parameters in existing packages as per user requirements by identifying the required information from tables from data marts
• Created complex reports stating revenue generation per year using cascading parameters and Tablix structure to create summarized reports in SSRS
• Exported the data mart data to the SQL Server Analysis Services (SSAS) server to make resources available to the users for ad hoc report needs and created reports containing all the information regarding the publishers, distributors and retailers using SSRS/Tableau for internal and external use
• Created complicated reports including sub-reports, graphical reports, drill-down/through report, and formula-based/well-formatted reports according user requirements
• Implemented new columns to existing reporting packages including Mortgage, Fraud and Prevention measures using MTD, YTD, PYTD columns

Environment: SQL Server 2008/2008 R2, Oracle 10g, Oracle E-Business Suite (Financials), MS BI Suite (SSIS/SSRS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), Multidimensional Expressions (MDX), Report Builder 3.0, Windows Server 2008 R2, Visual Studio 2008, MS Office Suite 2007 (Excel, PowerPoint, Word), QlikView

Confidential, Irvine, CA

MS SQL Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Worked closely with management and end-users to create and evaluate business requirements to support delivery of effective business intelligence and reporting solutions
• Determined operational objectives by studying business functions, gathering information, evaluating output, and specifying requirements and formats
• Used Transact-SQL (T-SQL) in SQL Server 2008 to develop complex Stored Procedures, Triggers, Clustered & Non-Clustered Indexes, Views, and User-Defined Functions (UDFs)
• Performed performance tuning on existing stored procedures/queries by analyzing execution plans, logs/statistics, and traces in SQL Server Profiler/Database Engine Tuning Advisor
• Developed 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 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) to design and develop solutions to support business intelligence reports and dashboards including Sub-Reports, Snapshot Reports, Parameterized Reports, Drill-down Reports, and Drill-through Reports
• 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 stakeholders for approval and implementation

Environment: SQL Server 2005/2008, Oracle 9i, Microsoft Dynamics GP, SQL Server Management Studio (SSMS), MS BI Suite (SSIS/SSRS), Business Intelligence Development Studio (BIDS), Data Transformation Services (DTS), Report Builder 2.0, Windows Server 2008, Visual Studio 2008, MS Office Suite 2003 (Excel, PowerPoint, Word), ERwin

Confidential

MS SQL Developer (SSMS/SSIS/SSRS)

Responsibilities:

• Developed Stored Procedures, User-Defined Functions (UDFs), Indexed Views, and DML Triggers to maintain database operations, meet operational requirements, and facilitate ETL processes
• Created Clustered/Non-Clustered Index on multiple tables to improve performance of complex queries and stored procedures
• Set up SQL Server Profiler traces for long-running queries/stored procedures and analyzed the traces using Database Engine Tuning Advisor for performance/index recommendations
• Created and maintained all types of database backup and recovery strategies and set up jobs to automate maintenance jobs to run on a daily basis
• Configured SQL Server Integration Services (SSIS) ETL packages to load data from heterogeneous sources such as SAP FICO and XML/Excel/Flat/CSV files
• Created ETL packages to perform incremental loading to Enterprise Data Warehouse (EDW) using Sequence Container, Execute SQL Task, Bulk Insert Task, Lookup, and OLE DB Command
• Developed detailed and summarized financial reports in SQL Server Reporting Services (SSRS) and deployed these reports onto Enterprise Reporting Server
• Generated weekly, monthly, quarterly, and yearly parametric, drill-down/drill-through and chart reports using SQL Server Reporting Services (SSRS)
• Built ad-hoc reports using SQL Server Reporting Services (SSRS) and Excel and created dashboards that include these reports

Environment: SQL Server 2005, SAP FICO, SQL Server Management Studio (SSMS), MS BI Suite (SSIS/SSRS), Business Intelligence Development Studio (BIDS), Data Transformation Services (DTS), Report Builder 1.0, Windows Server 2003 R2, Visual Studio 2005, MS Office Suite 2003 (Excel, PowerPoint, Word)