| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name Kou
Contact no PHONE NUMBER AVAILABLE
Summary:
> Over 7 years of experience in working with Data Warehousing & Business
Intelligence solution Design, in the area of specifically related to
MS SQL server 2008/2008 R2/2012.
> Experienced in extracting, transforming and loading the data using
SSIS in SQL Server 2005/2008/R2/2012 and Data Transformation Services
in SQL Server 2000.
> Expert in data migration from OLEDB/EXCEL/FLAT file to SQL Server
2000/2005/2008/R2 and other destinations using SSIS.
> Developed database objects such as tables, views, stored procedures,
triggers, cursors, indexes, user-defined data-types, functions and
constraints.
> Experience in performance tuning in SSIS, error and event handling,
precedence constraints, break points, transactions, check points and
logging using SSIS.
> Knowledge in OLTP, OLAP and data warehouse design concepts,
experienced in relational, multi-dimensional (Star) and snowflake,
logical and physical data modeling and data mapping
> Knowledge in processing OLAP cube, creating KPIs, dimension usage,
calculated members, perspectives and hierarchies
> Extensive experience in reporting tabular forms, matrix (cross tab
report) form, conditional, list items, charts and sub reports
> Deploy reports, secure access, and schedule execution of reports and
deliver them to the Web using reporting manager, share Point, email
recipients, file shares, and more, on a scheduled basis
> Expertise in creating reports using SSRS (ad-hoc, drill-down, drill-
through, cross-tab, sub-reports, pivot, tabular and parameterized
reports)
> Experience in error and event handling, precedence constraints, break
point and logging
> Experience on framework manager modeling (Namespaces, Joins, Loops,
and Dimensions) and creating packages and deploying onto server
> Developed prompt pages and cascaded input prompts to display only the
selected entries in report studio
> Worked on administration tasks such as backup & recovery, upgrades,
creating databases/file groups/files/transactions logs
> Possess excellent management skills of outstanding decision making
with excellent verbal and written communication skills, Supervised in
preparing and assisting formal walkthroughs and presentations of
system designs for business analysts, stakeholders and clients
Education: M.S. in Applied Mathematics
Skillset:
Microsoft SQL Server 2005/2008/2008-R2/2012, SQL Server Management Studio
(SSMS), SQL Server Business Intelligence Development Studio(BIDS), SQL
Server Analysis Services (SSAS), SQL Server Integration Services (SSIS),
SQL Server Reporting Services (SSRS), Oracle 8i/9i/10g/11g, MySQL, MS-
Access, MS-Excel, SQL, T-SQL, Visual Studio 2005/2008, SQL Profiler, MS
Visio, Team Foundation Server, Sharepoint, Powerpivot, Powerview .
Projects Summary
Copart, Dallas, TX 8/2012 - Present
MS SQL BI /SSAS/SSIS/SSRS Developer
Copart, Inc. is a provider of online vehicle auction and remarketing
services providing vehicle sellers with a range of services to process and
sell salvage and clean title vehicles over the Internet using its patented
virtual auction technology. The aim of the project was to design and
develop Enterprise Data warehouse and migrate the data from different
sources into the databases using SSIS and generating customer transaction
reports using SSRS.
Responsibilities:
> Responsible for Deploying the SSIS packages and scheduling the package
through Jobs in all Tiers including Dev, UAT and Prod, Setting the
Configuration files which is done in the specified tables and created
technical specs documents for all the enhancements.
> Deploy SSIS Package into Production and used Package configuration to
export various package properties to make package environment
independent.
> Implemented Event Handlers and Error Handling in SSIS packages and
notified process results to various user communities.
> Tested, Cleaned and Standardized Data meeting the business standards
using Fuzzy /exact lookups using SSIS tasks.
> Imported data from text files and excel spread sheets into SQL Server
2008 R2/2012 database using SSIS package.
> Developed physical data models and created DDL scripts to create
database schema and database objects
> Wrote complex SQL queries using joins, sub queries and correlated sub
queries to retrieve data from the database.
> Created/Updated database objects like tables, views, stored
procedures, function, packages
> Generated Drill down, Drill through, Ad-hoc, Matrix Reports,
parameterized reports using SSRS.
> Involved in table and index partitioning for performance and
Manageability.
> Identified, tested, and resolved database performance issues
(monitoring and tuning) to ensure database optimization.
> Monitored the overall performance of the database to recommend and
initiate actions to improve/optimize Performance.
> Used SQL Server Profiler to trace the slow running queries and the
server activity.
> Automated and enhanced daily administrative tasks including database
backup and recovery.
> Involved in setting up SQL Server Agent Jobs for periodic Backups with
backup devices, database maintenance plans and recovery.
Environment: MS SQL Server 2008 R2/2012, T-SQL, SSIS, SSRS, SSAS, Windows
server 2008, SQL Profiler, Visual Studio 2012, Team Foundation Server
Societe Generale Corporate & Investment Banking, New York City, NY
5/2011-8/2012
MS SQL BI /SSIS/SSRS Developer
Societe Generale is a French multinational banking and financial services
company. The company is a universal bank split into three main divisions,
Retail Banking and Specialized Financial Services, Corporate and Investment
Banking and Global Investment Management and Services. The goal of this
project was to create business intelligence objects to analyze the data
acquired from the various applications and to create reports that help
higher management to make decision on budget management based on current
expenses.
Responsibilities:
> Involved in creating Tablix Reports, Matrix Reports, Parameterized
Reports, Sub reports using SQL Server Reporting Services 2008R2.
> Interacted with the Business Admin and gather the requirements and
analyzed.
> Interacted with the Project Managers and the Field Managers who would
be using the application the most.
> Created and updated complex Stored Procedures, Triggers and User
Defined Functions for logical T-SQL implementation.
> Created Views to facilitate easy user interface implementation and
Triggers on them to facilitate consistent data entry into the
database.
> Scheduled Jobs for executing the stored SSIS packages which were
developed to update the database on Daily basis.
> Developed various reports for managing various securities and assets
to meet specified investment goals.
> Involved in thinking about investing and asset allocation,
diversification, and correlation and generating various kinds of
reports.
> Created advanced objects like KPI's and Perspectives.
> Involved in SSAS storage and partitions, and Aggregations, calculation
of queries with MDX, Data Mining Models, developing reports using MDX
and SQL
> Used Performance Point Server to create interactive reports with an
ability to drill down into details.
> Actively participated in review meetings with Project Manager to
ensure that the development of projects meet business and system
requirements.
Environment: SQL Server 2008R2, Windows Server 2008, SQL Server Reporting
Services (SSRS), SQL Server Integration Services (SSIS), SQL Server
Analysis Services (SSAS), Oracle 9i, MS Visio
Juniper Networks, Sunnyvale, CA
2/2010 - 5/2011
MS SQL Server Developer/ SSRS, SSIS
Juniper Networks, Inc. is an American manufacturer of networking equipment.
The company designs and sells high-performance Internet Protocol network
products and services. Project is to develop different kinds of reports
based on different transactions and to extract data, performing various
transformations and then loading all the relevant data into a data mart and
generating reports on it.
Responsibilities:
> Used various SSIS tasks such as Conditional Split, Derived Column
etc., which did Data Scrubbing, including data validation checks
during Staging, before loading the data into the Data warehouse.
> Created reports to retrieve data using database code objects, such as
Stored Procedures, views, functions and multiple T-SQL queries.
> Included Report Design and Coding for Standard Tabular type reports,
including Drill down and Drill through functionality and Graphical
presentations such as Charts and Dashboard type metrics.
> Responsible for Monitoring and Tuning Report performance by analyzing
the execution plan of the report.
> Performed T-SQL tuning and optimization of queries for reports that
take longer execution time using MS SQL Profiler, Index Tuning Wizard
and SQL Query Analyzer in MS SQL Server 2008/2008R2.
> Created SSIS packages to extract data from OLTP to OLAP systems and
Scheduled Jobs to call the packages and Stored Procedures.
> Generated reports using SSRS that could be used to send information to
different Primary Vendors, Clients, and managers and used windows
security for security purposes.
> Designed and implemented complex SSIS package to migrate data from
multiple data sources for data analyzing.
> Performed extract, transform, and load data into the repository and
Created Complex Stored procedure, Functions, Views, and Indexes for
the Logic package.
> Developed data access queries/programs using SQL Query to run in
production on a regular basis and assists end users with development
of complex Ad Hoc queries.
> Created Error and Performance reports on SSIS Packages, Jobs, Stored
procedures and Triggers.
Environment: MS SQL Server 2008, MS SQL Server Analysis Service 2008, MS
SQL Server Integration Services 2008, MS SQL Server Reporting Services
2008, T-SQL.
MetLife, New York City, NY
9/2008 - 1/2010
MS SQL Server Developer/ SSRS, SSIS, SSAS
MetLife is a leading insuring firm is being involved in insuring the lives
of people. Project is about to migrate data from 2005 to 2008, format and
generate parameterized reports which contains the detail of the different
type of insurances, the sales agents and the customer for each. Deployed
the developed reports on the server for the managers and sales agents.
Responsibilities:
> Designed and implemented complex SSIS package to migrate data from
multiple data sources for data analyzing.
> Extensively involved in generating reports like matrix, parameterized
and drill through reports using SSRS and developed stored procedures
using functions to generate various kinds of reports using SSRS.
> Extensively used T-SQL statements and created multidimensional cubes
for the analyzer and used pivot table to help the end-user get
familiar with cube.
> Incorporated the DTS Packages into MS SQL Server 2008 Integration
Services by using Package Migration Wizard and Execute DTS 2000
Package task.
> Upgraded MS SQL Server 2005 databases to 2008, using Detach/Attach,
Back up & Recovery and by Replication.
> Created SSIS packages to extract data from OLTP to OLAP systems and
Scheduled Jobs to call the packages and Stored Procedures.
> Created the structure of the model and cube in SSAS and reviewed Cube
with end user and changed the cube and documentation according to
their requirements.
> Used linked server to access the objects from the Oracle data source
for the mapping of source tables to destination tables.
> Extensively involved in migration of data from MS SQL 2005 to MS SQL
2008.
> Monitored performance and optimized SQL queries for maximum efficiency
using SQL Profiler.
> Used indexes to enhance the performance of individual queries and
enhance the stored procedures.
Environment: MS SQL Server 2008, MS SQL Server Analysis Service 2008, MS
SQL Server Integration Services 2005/2008, MS SQL Server Reporting Services
2005/2008, T-SQL, MDX.
Citibank, Newark, New Jersey
10/2006 - 8/2008
MS SQL Server Developer/ SSRS, SSIS
Citibank is one of the largest full service banks in the world offering an
unparalleled range of products and service. Project objective was about to
gather requirements from end user, troubleshooting report failures, created
cubes, reviewed cube and prepared documents and according to it created
reports.
Responsibilities:
> Performed task at development environment, analyzing, testing, and
implementing systems. Designed User-Interface for the testing using
SSIS packages.
> Created Packages using ETL tool for the users to check the codes and
responsible for extracting data from huge database to manipulate and
analyze the data for the end users.
> Performed T-SQL tuning and optimization of queries for reports that
take longer execution time using MS SQL Profiler, Index Tuning Wizard
and SQL Query Analyzer in MS SQL Server 2005.
> Created Sub-Reports, Drilldown-Reports, Summary Reports, and
Parameterized Reports in SSRS.
> Migrated the entire schema as well as data into MS SQL Server 2008 and
also validated the migration process to ensure that it has been
successfully migrated.
> Created SSIS packages to extract data from OLTP to OLAP systems and
Scheduled Jobs to call the packages and Stored Procedures.
Environment:MS SQL Server 2005 , MS SQL Server Reporting service, MS SQL
Server Integration service, T-SQL,DTS, C#,.Net, SQL Query Analyzer, SQL
Server Index Tuning Wizard, Visual Studio 2005,MDX.
|
