SUMMARY

• Highly qualified Business Intelligence Developer with over 7 years of IT experience in Database development and maintenance for Retirement Plan Services, Financial Services and Manufacturing industries.
• Extensive experience with multiple development environments including SQL Server 2005/2008/2008 R2/2012/2014, Visual Studio 2005/2008/2010 , Team Foundation Server (TFS) 2008/2010, and SharePoint 2010
• Proficient in different ETL tools such as SSIS and Informatica and job schedule tools like Autosys.
• Flexible, proactive and project oriented team player with excellent written, verbal communication and leadership skills under waterfall and agile models
• 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
• 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
• Proficient in Data Cleansing, data validation checks during Staging, before loading the data into the Data warehouse.
• Adept in Data Conversion, Normalization and Multi-Dimensional Modeling in Enterprise Data Warehouse design.
• Leading experience in staging data, cleansing data, and transforming data using transformations
• Skilled in implementing initial data load using Bulk Insert Task and Fast Loadas well as incremental data load using techniques such as Slowly Changing Dimensions (SCDs)
• 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
• Leading experience in using Tableau to create well-formatted dashboards using existing data-warehouse
• Proficient in designing Alteryx working flow for data blending summarize as source for Tableau dashboard data source.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R2/2008/2005
• Transact-SQL (T-SQL)
• SQL Server Management Studio
• Tableau
• Informatica power center
• Autosys workflow automation
• MS Visual Studio
• MS SQL Server Integration Service (SSIS)
• MS SQL Server Reporting Service (SSRS)
• MS SQL Server Analysis Services (SSAS)
• Database Engine Tuning Advisor
• MS Office Suite
• MS SharePoint
• MS Windows OS
• MDX
• Power Pivot
• SQL Server Migration Assistant (SSMA)
• MS Visio
• C#

PROFESSIONAL EXPERIENCE

Confidential, Radnor, PA

SQL/ETL developer (SSMS, INFORMATICA, SSIS)

Responsibilities:

• Providing data support to Salesforce to support retirement manager, retirement consultant, internal phone team and third party administration to target and service retirement plan sponsor and participant.
• Extracting data from more than 20 sources systems to ODS and apply logic to providing data support to consumers such as compensation department, analytic department and financial department
• In charge of generating micro design for part of the DOL project which is changing campaign logic and the data feed to IBM Unica campaign team.
• Walk through micro design with business analysts, project manager and tester to ensure that all the business/functional requirements have been met.
• Rigidly follow the project road map, time line and allocated working hours for each activity to make sure every deliverable is on time.
• Meet with QA testers and BA to ensure there is minimum data issue for their QAT and UAT scripts since data in different environment is not sync.
• Perform unit test or peer review before moving objects from DEV to QA. Creating validation script to verify the change implemented in PROD.
• Check defects assigned to the team and work with team to figure out solutions.
• Come up with questions, concerns and obstacles in the daily standup meeting and work
• Work on hot fix and PCRs to fix issues that out of the scope of the project.
• Creating batch files to schedule jobs through Autosys on daily or weekly basis.
• Document data feed into the data warehouse and Informatica workflows used to pull the data for team reference to quick react to upstream data change.
• Involved in tuning store procedure performance when upgrading from SQL server 2008 to SQL server 2012.
• Work on ad hoc request and enhancement request assigned to our department
• Meet with master data management team on corporate level to consolidate and integrate data in our data warehouse.
• Put job on hold and off hold in Autosys when there were upgrade for SQL Server and Informatica to ensure production data is accurate and up to date.

Environment: Informatica 10, Autosys, SQL Server Integration Services (SSIS), SQL developer, SQL Server Management Studio (SSMS), T-SQL, DB2

Confidential, New York, NY

BI Developer (SSMS/SSIS/SSRS/SSAS/Tableau)

Responsibilities:

• Participated in gathering requirements and discuss details with team lead
• Involved in all phases of System Development Life Cycle (SDLC)
• Analyzed the source data and figured out correct data mapping to staging tables, data warehouse and data marts.
• Created complex Stored Procedures, Triggers, User Defined Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Used execution plan and tuning advisor to solve performance issues of query and followed instructions to improve query performance
• Performed data cleansing and validation to figure out reportable data based on the requirements
• Designed, developed and implemented ETL procedures using SSIS
• Created packages to validate, extract, transform and load data to a centralized SQL server staging database
• Applied various data transformations like SCD (Slowly Changing Dimension) to maintain the history of the data, Aggregate, Sort, Multicasting, Conditional Split, Derived column and Row Countto transform data and validate data
• Applied various tasks like execute SQL tasks to apply stored procedure into the package, script task and Containers like Sequence Container/Foreach Loop Container to well organize the package
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Used data viewer, check point and break point in development for debugging
• Set dynamic connection string to facility the configuration when packages are deployed to different environment
• Deployed SSIS Package into Production and scheduled SSIS jobs through SQL Server Agent
• Develop rich interactive visualizations integrating various reporting components from multiple data source
• UsedSQL to pull complex data from data marts with a goal of presenting and visualizing them in Tableau, SSRS.
• Created drill down, drill through report to facility the usability of reports and applied custom expression in defining properties in reports.
• Applied parameters and calculated fields in creating the dashboard to satisfy different user requirements.
• Wrote and maintained technical documentation based on business and functional requirements

Environment: MS SQL Server 2014, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Tableau, SQL Server Management Studio (SSMS), T-SQL

Confidential, New York, NY

BI Developer (SSMS, SSIS, SSRS, Tableau)

Responsibilities:

• Analyzed and review business requirements and interact with Project Manager.
• Important role in team to have quick response to urgent requirements and problems, based on the ability to quickly root problem and find solutions.
• Important role in team to fast learning new technology if needed in development and improvement process and apply it in project to meet business requirements.
• Developed and implemented Stored Procedures, Indexes, Views, Temp Table on SQL Server 2012.
• Performed data cleansing and data validation according to business requirement.
• Applied complicated stored procedures in SSIS
• Designed and implemented SSIS package to migrate data from multiple data sources to data mart for data analysis, deployment and dynamic configuration of SSIS packages
• Coordinated database implementations and changes for transaction analysis department (Created, modified and delivered trouble shooting to T-SQL stored procedures, designed and implemented tables/data structures and performed code reviews)
• Worked with staff from multiple departments to design and build reporting using SSRS that helped streamline the business and make reporting, analyzing, planning and forecasting more efficient
• Developed Ad-hoc reports and modified them by using Tableau.
• Use action and parameter in Tableau to fulfill the requirements
• Created reporting documentation based on best practices and company standards and diagnosed and resolved reporting issues and recommended process improvements

Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Tableau, SQL Server Management Studio (SSMS), T-SQL, SharePoint

Confidential, New York, NY

BI Developer (SSMS/SSIS/SSAS/SSRS)

Responsibilities:

• Designed ER Diagram for the new database according to business requirements
• Performed SQL Database Development tasks - Creating database, tables, views, storedprocedures, triggers, user defined functions, index and other database objects, based on business requirements and provided documentation
• Created SSIS Packages to migrate data into new database from various data sources, for example flat file, excel file, SQL Server
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Generated rich graphic visualized report using Tableau
• Created Data Source, Data Source View to create a logical view of the data to be placed in OLAP Cubes using SQL Server Analysis Services (SSAS) projects

Environment: MS Visio 2010, SQL Server 2008/2008R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), Visual Studio 2008/2010, T-SQL

Confidential, New York, NY

BI Developer(SSMS/SSIS/SSRS)

Responsibilities:

• Created SSIS packages to extract data from OLTP to OLAP system and created alerts for successful and unsuccessful completion of schedule jobs
• Designed and developed SSIS packages to extract data from different source files
• Created complex Stored Procedures, Functions, Views, Indexes for increasing performances
• Responsible for performance checks and performed index tuning and query optimization
• Generated Drill-down, Drill-through, and Parameterized Reports using SSRS
• Constructed technical documents for the stored procedure and SSIS packages

Environment: MS Visio 2010, SQL Server 2008/2008R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS), Visual Studio 2008/2010, T-SQL

Confidential

BI 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 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

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