SUMMARY

• IT professional with extensive experience in database development, data warehousing and business intelligence application development specifically Microsoft SQL Server 2000/2005/2008/R2.
• Experience with data warehouse project planning, data modeling, maintenance, development, testing and enhancements.
• Proven ability in Data mart/Data warehouse design, dimensional modeling using Star/snowflake schemas, normalization, de-normalization.
• Expertise in creating, modifying and implementing database objects like Stored Procedure, User Defined Function, View, Index, Trigger and Constraint to facilitate efficient data manipulation and data consistency. Excellent in SQL programming.
• Proficiency in performance tuning and query optimization using indexing, defragmentation and proper query design as well as using SQL profiler.
• Extensive hands on work experience implementing ETL processes from various data sources using SSIS with Control flow, Data Flow tasks and stored procedures.
• Hands-on experience creating SSAS cubes using top-down and bottom-up approach and extended its functionality by implementing cube objects like KPI's, calculated members, perspectives.
• Extensive experience in creating, populating and processing of cubes using SSAS and management studio and cube optimization techniques such as Cube Partitioning, Aggregation Wizard and defining hierarchies. Made use of different roles in SSAS to assign security on different aspects of cubes including perspectives and translations.
• Proficient in developing parameterized reports, cascading reports, drill down reports, drill through reports, sub reports and ad-hoc reports in SSRS by pulling data from SSAS or relational database.

TECHNICAL SKILLS

• BI Tools: SSIS, SSAS, SSRS
• RDBMS: MS-SQL Server 2000/2005/2008/R2/2012, Teradata SQL, Oracle SQL 11g
• Programming: T-SQL, Teradata SQL Assistant 13.0, Oracle SQL, R, SAS
• Operating Systems: Windows Server 2003/2008
• OTHER SKILLS
• Languages spoken: English, Fukienese/Taiwanese, Mandarin, Cantonese limited ,Japanese limited , French limited

confidential

SQL SSIS SSAS/BI Developer II

• Worked with team on business requirements to implement data modeling, database design, data analysis, perform calculation/queries. Also responsible for all technical aspects of project delivery
• Executed various complex programming assignments, created complex stored procedures and functions using TSQL in generation of reports. Responsible for transforming business requirements into physical designs, used Erwin tool to perform logical and physical data modeling.
• Performed activities in database creation, performance tuning, backup planning and database administration.
• Designed and created database and database objects like tables, stored procedures, views, triggers, indexes, user-defined functions using SQL Server 2008R2 and Teradata SQL Assistant to load data into EDW and the cube.
• Used Profiler to find long running queries and deadlocks, tuned SQL queries using Show Plans and Execution Plans to improve execution time. Used Index implementation and Index Tuning Wizard for query optimization. Also, analyzed the requirements and fine-tuned the stored procedures to improve performance.

• Extensively worked on various SSIS packages to import and export from and to different data sources like Excel, Flat file, XML file, SQL database, Teradata SQL database to support efficient data storage and data manipulation.

• Developed SSIS packages using Transformations and tools under control flow and data flow task with error handling and TSQL stored procedures to perform data conversion, data manipulation.
• Tested SSIS packages in test environment, implemented and scheduled SSIS packages to run automatically in Production. Verified daily full and incremental batch loads.
• Created SSIS packages to process cubes and dimensions automatically.
• Worked in the creation and maintenance of SSAS objects such as Cube, Dimensions, dimension members, hierarchies and extended cube definition by creating named queries, named calculation, etc.
• Worked in writing MDX queries and expressions to create calculated measures to facilitate cube functionalities.
• Created SSIS package to do cube partition dynamically, transformations like, Execute SQL task, Script task, Analysis Service Execute DDL task, package variables etc were used.
• Participated in Weekly Test Build to test the database objects, scripts, SSIS and SSAS packages, Cognos reports, the team created to eliminate programming and system errors. Supported production releases and responsible for trouble shooting the problems clients found.
• Created documentation for coding standards, best practices for database design, database objects updates, ETL data flow charts, etc.

confidential

SQL SSAS /BI Developer

• Involved in gathering business requirements as endeavor that will facilitate the planning and the implementation phase of a data warehouse.
• Involved in calculating measures and dimension members using multi-dimensional expression MDX and user-defined functions.
• Worked in the creation and maintenance of Analysis Service objects such as Cube, Dimensions, MDX queries and KPI's.
• Excellent experience in pulling data from SSAS cubes and create interactive SSRS reports like drill-down, drill-through, parameterized reports etc.
• Involved in writing basic MDX queries and expressions for use in Front End BI Applications.
• Worked on basic MDX expressions to create name sets and calculated members.
• Created several tables, views, stored procedures, functions using T-SQL based upon the functional specification.
• Developed various T-SQL scripts that included joining multiple tables, sub-queries and aggregations.
• Used transformations like Aggregation and script task to model various standardized business processes.
• Developed stored procedures to implement business logic and included features like try/catch, error and transactions for error handling.
• Experience in creating and handling huge cubes by making use of top-down and bottom-up approaches on the top of Data Warehouse and Data Marts for better analysis purposes.
• Implemented pro-active caching at regular time intervals that would automatically grab data from underlying data source and refresh the cubes accordingly by setting silence interval and silence interval over-ride.
• Optimized the performance of cubes that slices and dices the data by using various different technologies like usage based optimization and appropriately making use of different storage modes.
• Applied different processing options like process full, process default, process structure and process index depending upon the business requirement.
• Good experience in creating various types of reports like drill down reports, drill through, parameterized and cascading parameterized as well as various other reports for graphical analysis purposes.
• Created various database objects and ETL documentations for all objects and ETL Packages involving the project and its phases.
• Generated several reports using SSRS like drill through reports, linked and sub reports, parameterized reports from EDW and cubes along with its deployment on Reporting Server with various security measures.
• Improved the performance of reports by optimizing data sets, making use of report caching and snapshots along with taking into consideration networking aspects.

confidential

SQL/BI Cubes Developer

• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specification.
• Designed, architected and deployed different cubes according to business needs onto SSAS Server and optimized them to the fullest depth by following Microsoft Best Practices.
• Designed reports from the Analysis Services by dragging data from cube and writing basic MDX scripts.
• Created MDX query or expression for retrieving and manipulating the multidimensional data stored in OLAP Cubes.
• Enhanced the performance of cubes using several methods like partitioning avoiding data explosion as well as including some aggregates and calculated members.
• Optimized and redesigned existing data marts.
• Created and modified stored procedures, triggers, cursors, and views in support of DBA day to day duties or reports.
• Implemented various types of SSIS Transformations in Packages including SCD, Aggregate, Fuzzy Lookup, Conditional Split, Row Count, Derived Column etc.
• Created views for each ETL Requirement so that all the data that has already been pulled from data sources are not pulled again into the staging database.
• Used SSIS Packages to extract, transform and load data from multiple input sources like flat files, Production SQL Servers 2000/2005 into SQL Server 2008 Staging Database.
• Mapped the created cubes in the reports built with SSRS as a front end.
• Created several report models that will enable junior developers to create reports from cubes with minimum coding.
• Created linked reports, drill down reports, ad-hoc reports, drill through reports and delivered them to subscribers as needed.
• Created balanced scorecards, dashboards, analytics, forecasting for performance management.
• Designed complex views and scripts to convert business logic for different reports.
• Produced reporting data models that are used by the new Report Builder ad-hoc reporting tool in Reporting Services.
• Created new reports using SQL Server Reporting Services SSRS .

confidential

Data Warehouse/SSRS Reports Developer

• Gathered requirements from the client, performed Gap Analysis and facilitated JAD Sessions.
• Transformed the Business Requirements into Functional and Non Functional Requirements.

• Participated in designing the logical model by using Erwin based on the business requirements.
• Created various complex SSAS cubes with usage based aggregations, KPIs and calculate members and used appropriate storage modes for them.
• Handled security of the reports by assigning the roles, and security at different levels like folder level, server level and report levels using Report Manager.
• Implemented and deployed dashboard reports to be displayed on native mode.
• Created several drill down, drill through, sub reports in support of the financial department as well as BI Group.
• Implemented the logical design to the physical design by creating tables, views and relationships.
• Maintained data integrity by creating various constraints and DML triggers the relational databases.
• Developed stored procedures and functions to implement necessary business logic for interfacing with parameterized reports.
• Created and modified indexes to optimize query performance of several stored procedures supporting front end applications and reports.
• Participated in the monitoring of the SQL server performance using tools like SQL profiler, database engine tuning adviser and command line tools.
• Created Pre-Staging and Staging Databases as intermediate stages for populating Data Warehouse to perform various ETL operations like data profiling, data cleansing and data verification.
• Created and optimized several complex SSIS packages to implement designed ETL Strategy.
• Efficiently managed SSIS packages by creating loggings, checkpoints, transactions, configurations and deployed it on the production server using deployment utility.
• Converted complex business logic into SQL Stored Procedures and user-defined functions to achieve functionality required by the UI team.
• Delivered report to business users using data driven subscriptions and standard subscriptions.

confidential

SQL Developer/Data Analyst

• Interacted with business users and managers and gathered the database needs from the business groups for reporting purposes.
• Created optimized views and stored procedures to generate information about the entities and attributes of various databases.
• Involved in various JAD sessions to generate User Views and Business Requirements.
• Performed data analysis and modeled the database in SQL Server 2005.
• Designed indexes and views on various entities of the databases in SQL server 2005.
• Implemented multiple stored procedures that return information about the Meta data.
• Created views to facilitate easy user interface implementation, and triggers that audit the data that is being inserted/updated/deleted from heterogeneous sources to facilitate consistent data entry into the database.
• Advised the creation of DML Triggers that enforce the business requirements of the users of the database.
• Created triggers Managed and architecture stored procedures that insert data from heterogeneous sources into the entities of databases.
• Formatted and extended SSRS reports by creating parameters within reports, multi value parameters and extended reports with expressions as well as embedding functions with expressions.
• Created and scheduled SQL Server Agent Services jobs that periodically extract data from multiple sources.