MANOJ KUMAR

abgw7p@r.postjobfree.com

201-***-****

Summary

. 10+ years of experience in BI development, data warehouse designing

and maintenance, custom application development and maintenance with

industry standards. Worked in verticals such as banking, exchange

companies and Semiconductor foundry.

. Proven knowledge and experience with all aspects of data management

like data modeling, data transferring, data analysis, and data

reporting.

. Solid experience in implementing data warehouse, data mart, analysis

cubes and reports solutions

. Extensive work experience on system analysis, design, development,

testing and implementation of projects with full SDLC

. Extensive experience in converting raw data to meaningful data( data

cleansing, enrichment, data integration, and analytics solutions)

. Solid experience in generating reports using Excel Pivot, Power Pivot,

Power View

. Extensive experience in TSQL to write: stored procedures, triggers,

functions, tables, views, indexes and relational database models

. Extensive knowledge in Tuning TSQL queries (DDL and DML) to improve

database performance and availability

. Excellent knowledge of Data warehousing, Operational Data Store (ODS),

OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake

Modeling, Lookup, Dimensions and FACT Tables

. Good knowledge of Data Marts, FACT and Dimensions Tables using MS

Analysis Services

. Extensive experience in data migration between homogeneous &

heterogeneous systems using various tools (DTS Import Export Data, DTS

Packages, Bulk Insert and BCP, SSIS)

. Experience in Database build, Migration and upgrade from SQL 2000 to

SQL 2005 and SQL 2005 to SQL 2008 R2.

. Experience in Application Development Analysis, Requirement Analysis,

Scoping, Developing, Testing and Documentation of various phases in a

project life cycle of Client/Server Applications

. Experience in RDBMS Designing, Data Modeling (Logical and Physical

Design of Databases), Normalization and building Referential Integrity

Constraints. Designed schemas. Built tables, FKs, PKs, etc. by

providing a structure that meets the business needs

. Expertise in building and migration of DTS packages.

. 3+ year of experience with application development in Java and C#

. Extensive experience in migrating data from Oracle / DB2 / Informix

systems to SQL Server environment

. Strong interpersonal, organizational and problem solving skills

. Excellent written and verbal communication skills

Technical Skill

DATABASES: SQL Server 2012/2008 R2/ 2008 / 2005/2000,

Microsoft Access, Oracle

SQL SERVER TOOLS: Enterprise Manager, SQL Profiler, Query Analyzer, SQL

Server Management Studio, DTS, SSRS, SSIS, SSAS, SQL

Profiler, Performance Monitor, Database Tuning

Advisor

LANGUAGES: T-SQL, ANSI-SQL, C#, Java

REPORTING TOOLS: SQL Server Reporting Services (SSRS), PROCLARITY,

Microsoft Performance Point Server, QlikView

SOFTWARE: Microsoft Office Suite, Erwin, Toad Data Modeler,

IntelliJidea, SQLDeveloper

Version Control Team Foundation Server (TFS), Visual

SourceSafe (VSS).

Web Application Development: JSP, EJB, HTML, JavaScript, XML, XSD, CSS

OPERATING SYSTEMS: Windows Server 2003/2008, Windows 7/Vista/XP, Unix.

Other Tools: RedGate, Suite (DATA compare, schema Compare,

SQL Prompt)

Work Experience

Company: Global Foundries, CA

APR 2014-

Till Date

Position: BI SME

Responsibilities.

. Identifying Business/Data warehouse consumer needs based on the

consumer requirements design and develop data warehouse Model.

. Designed Lookup tables, Slowly Changing Dimensions, Conformed

Dimensions, Fact less Fact tables based on the business needs

. Responsible for creating Analytical and Operational Report, Analytical

reports using Excel Power Pivot Operational Report using SSRS.

. Created Perspectives of the cube to simplify the process of browsing

for the end users.

. Optimizing slow performing query/ETLs(DTA, Query Execution planning,

Index, Filtered index, covering index, Column store index, Statistics,

Query hints)

. Managing and maintaining very complex ETL for the Data warehouse

refresh

. ETL configuration management with XML and SQL Server configuration

tables

. Troubleshooting and monitoring cube performances/refreshes

. Creating Functional specifications and related documents for the

business requirements

Company: Core(Es)

Oct 2008 - JAN

2014

Position: System Analyst

ODS Development.

In enterprise environment where multiple data sources exist it creates the

need of centralized store which should act as data hub/data provider for

all other systems. In order to achieve this ODS model was implemented in a

bank where the data from different systems were loaded in ODS to create a

centralized repository which acts as data provider for reporting and data

marts. Batch Mode ODS design were implemented for bank, most of the data

load was one time daily except few cases where data in ODS was near real

time.

Responsibilities.

. Designed logical and physical database structure to facilitate

analysis of data from both operational and customer perspectives.

. Defined the ETL development standards (naming convention,

Configuration Design, Deployment and TFS Structure).

. designed Lookup tables, Slowly Changing Dimensions, Conformed

Dimensions based on the business needs

. Designed and implemented database objects repository management

through TFS

. Architected frame work for managing incremental ODS data load on daily

transaction data tables

. Created ETL packages using Heterogeneous data sources (SQL Server,

ORACLE, Flat Files, Excel source files, XML files etc.) and then

loaded the data into destination tables by performing different kinds

of transformations using SSIS

. Developed the packages with monitoring features and logging so that

audit information of the packages and their execution results are

loaded in to the audit table.

. Used Event Handlers for Custom Logging using Complex Store Procedures

for various events (On Warning, On Pre and Post Execution, On Task

Failed etc.)

. Created SSIS packages for data Importing, Cleansing and Parsing.

Extracted, cleaned and validated data from XML file into database

using XML source.

. Set SQL Server configurations for SSIS packages and configured logging

including windows event log and XML logging.

. Created SSIS Packages using Pivot Transformation, Fuzzy Lookup,

Derived Columns, Condition Split, Term extraction, Aggregate, Execute

SQL Task, Data Flow Task, and Execute Package Task etc. to generate

underlying data for the reports and to export data from Excel

Spreadsheets, Text file, MS Access and CSV files.

. Creating dynamic stored procedure for extracting and loading unpivoted

data from CRM logical database

. Created Stored Procedures, Triggers, Functions (UDF), Indexes, Tables,

Views, Joins and other T-SQL code for applications following SQL code

standards

. Extensively used Joins and sub-queries for complex queries involving

multiple tables from different databases.

. Deployed the packages on staging and production.

. Performed Performance Tuning by using unblocking Transformations and

row transformations for better Performance of SSIS packages.

. Created jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL

Server Agent.

. Performed unit and system testing, troubleshooting and bug fixing in

development and QA environments

. Coding Expressions in SSIS, SSRS and unit testing

. Created ODS Documentation for support and helpdesk team.

Environment: SQL Server 2012, T-SQL, Power Pivot, Integration Services

(SSIS),Analysis Services (SSAS), Reporting Services (SSRS), SQL Profiler,

Windows 2008 Server R2, Toad Data Modeler.

Company: Core(Es)

Oct 2008 - JAN

2014

Position: System Analyst

Channel Integration Services

Channel integration services was built to service In house Built CRM,

channel integration services were based on centralized repository mart to

facilitate CRM. Integration services mainly were built to bring customer

information, product information and financial transaction information.

Responsibilities

. Designed and developed Data Mart Structure.

. Designed and developed ETL packages.

. Developed stored procedure to return data in XML, integration services

interface was built to accept XML data only.

. Generated complex stored procedures and functions for better

performance and flexibility.

. Created indexes for the quick retrieval of the data from the database.

. Used Execution Plan, SQL Profiler and database engine tuning advisor

to optimize queries and enhance the performance of databases.

. Created database maintenance planner for the performance of SQL

Server, which covers Database integrity checks and re-indexing.

. Defined constraints, rules, indexes and views based on business

requirements.

. Developed business logic layer in stored procedures and views.

. Developed service interfacing stored procedures.

. Performed unit and system testing, troubleshooting and bug fixing.

. Optimizing slow performing query/ETLs(DTA, Query Execution planning,

Index, Filtered index, covering index, Column store index, Statistics,

Query hints)

. Proactively identifying and resolving application performance issues

. Responsible for developing, monitoring and deploying T-SQL Code and

SSIS packages in production

. Communicating with both technical and non-technical staff to support

analysis, design, testing, and troubleshooting of project issues

. Created Documentation for support and development team.

Environment: SQL Server 2008, T-SQL, Integration Services (SSIS), XML,

Windows 2008 Server.

Company: Core(Es)

Oct 2008 - JAN

2014

Position: System Analyst

IVR Data.

IVR data Mart was developed to facilitate customer service center to give

insight to IVR data so management can take informed decisions to improve

the efficiency of the system. This Mart was built on top of the data

interface provided by host system. This Mart was designed on IVR data

integrating with customer information to help management to slice and dice

data on customer segmentation dimension as well.

Responsibilities

. Identifying Business/Data warehouse consumer needs and architected the

snowflake model data warehouse

. Designed Lookup tables, Slowly Changing Dimensions, Conformed

Dimensions, Fact less Fact tables based on the business needs

. Design and maintain data archival methodologies(SCD Type 1, SCD Type

2& SCD Type 3)

. Design and maintain data partitioning methodologies(Sliding Window)

. Created Perspectives of the cube to simplify the process of browsing

for the end users.

. Used MDX to create calculated members in the cube.

. Responsible for creating the reports based on the requirements using

SSRS 2008.

. Created Drill-through, Drill-down, Linked Reports and Sub-Report using

RDL.

. Built effective queries for high-performance reporting and rendered

them to HTML, XML, PDF and Excel formats using Reporting Services

(SSRS).

. Created queries for generating drill down reports in SSRS 2008.

. Formatted the reports using the Global variables, expressions and

Functions

. Optimizing slow performing query/ETLs(DTA, Query Execution planning,

Index, Filtered index, covering index, Column store index, Statistics,

Query hints)

. Designed, created and implemented multi-threaded partitioned data load

to transfer very large volume of data

. Set up different kinds of transformations like Derived Column,

Conditional Split, Lookup, Merge, Row Count, Data Conversion etc, in

SSIS Packages

. Writing highly complex queries with Left Joins, Self Joins, Full Outer

Joins

. Data de-duplications with Common Table Expressions, Rank, group by

clause

. Managing and maintaining very complex ETL for the Data warehouse

refresh

. ETL configuration management with XML and SQL Server configuration

tables

. Troubleshooting and monitoring cube performances/refreshes

. Creating Functional specifications and related documents for the

business requirements

. Creating extensive database documentations such as Data Flow Diagram

and Data Dictionary

. Scheduled Daily and weekly Jobs and Alerting using SQL Server Agent.

Environment: SQL Server 2008 R2, T-SQL, DTA, Code Flow, Analysis

Integration Services (SSIS), Services (SSAS), Reporting Services (SSRS),

Management Studio (SSMS), ERWIN, Microsoft Visio, SQL Profiler, Windows

2008 Server R2.

Company: Core(Es)

Oct 2008 - JAN

2014

Position: System Analyst

ATM Reconciliation Reports

ATM reconciliation report was designed to help Consumer banking department

to reconcile ATM BALANCE with GL. These report were built to reconcile ATM

information available in three systems I journal, Base24, BANCS with Oracle

GL

Responsibilities

. Designed, Implemented and maintained Database Schema, Entity

relationship diagrams, Data modeling, Tables, Stored procedures,

Functions and Triggers, Constraints, Indexes, Schemas, Functions,

Views, Rules, Defaults and complex SQL statements.

. Maintained the database schema in source code control (MS Team Suite

Database Edition preferred).

. Coordinated with front-end for implementing logic in stored procedures

and functions.

. Developed ETL packages to load IJOURNAL data in Centralized

Repository.

. Developed ETL package to Load ATM Switch (BASE 24) data into

centralized repository.

. Developed routines to interpret ATM Hopper Information into meaningful

way.

. Developed routines to translate IJOURNAL data into meaningful way.

. Developed GL data load routines to Load Oracle GL information in

centralized repository

. Created routines to generate retrieve ATM Cash Balance and Deposit

Balance in case if ATM is Cash Deposit Machine as well.

. Developed reconciliation stored procedure to compare data between

systems.

. Developed tables, stored procedures, triggers, cursors, views and

indexes for the design specifications

. Implemented Common Table Expressions (CTE).

. Troubleshooting performance issues and fine-tuning (Performance

Tuning) queries and stored procedures.

. Implemented failure alerts using email in SSIS.

. Designed and developed parameterized reports, linked reports,

matrix and tabular reports with drill down, drill through using

SSRS.

. Created Documentation for support and helpdesk tea

Environment: SQL Server 2005, T-SQL, Integration Services (SSIS), SSRS,

Windows 2003 Server.

Company: National Bank Of Kuwait

MAR 2007 -

Sep 2008

Position: SQL BI Developer

Central Bank Mart.

In banking environment apart from the daily operational reports bank needs

to generate and share financial information to compliance and regulatory

authorities, Central Bank Mart was aimed to facilitate the Financial

Control Division of Bank to generate such reports. Central Bank Mart had

consolidated information from all financial systems of each and every

product of the bank.

Responsibilities.

. Worked with Business Analysts in gathering requirements and

translating them to technical specifications.

. Worked on the Reports module of the project as a developer on MS SQL

Server 2008 R2(using SSRS, T-SQL, scripts, stored procedures and

views).

. Created Tables, Views, and triggers and stored Procedures using T-SQL.

. Created SSIS packages for data load into Central Bank Mart from

different Sources and formats of files ( Excel, Access, SQL and DB2).

. Designed and developed SSIS Packages to pull data from Access, Excel

and Flat files to SQL server 2008 R2.

. Reported and tracked the status of the bugs per project, resolved

defects based on project severity of the defects using TFS.

. Coordinated with QA and Release management for projects and bug fixes

to be released to production environment

. Concurrently managed multiple projects and minor releases within SQL

BI ETL team.

. Extensively involved in designing the SSIS packages to export data

from flat file source to SQL Server database.

. Created tabular, matrix, chart, drilldown reports, and parameterized,

cascaded reports according to business requirement.

Environment: SQL Server 2005, T-SQL, Integration Services (SSIS), Analysis

Services (SSAS), Reporting Services (SSRS), SQL Profiler, Windows 2003

Server.

Company: National Bank Of Kuwait

MAR 2007 -

Sep 2008

Position: SQL BI Developer

CI-Net Data Feed

In recognizing the importance of consumer lending and in order to enhance

the monitoring of such a market the Central Bank of Kuwait have introduced

a number of measures to prevent consumers from becoming seriously in debt.

Part of this initiative was to allow a credit bureau to be established and

operated by Ci-Net. This company use state of the art technology to provide

accurate and secure information on line to the lending community in Kuwait.

Responsibilities

. Designed ETL data Load Architecture.

. Co-ordinate and liaised with Ci-Net technical team for requirement

clarification.

. Designed and developed ETL packages.

. Developed stored procedure views to implement data cleansing rules.

. Developed stored procedure for data quality checks and auto data

update where ever required as per the specification of CI-Net.

. Created daily, monthly Reconciliation reports to align feed data

accuracy and fix data issues.

. Wrote Stored Procedures and triggers to capture inserted, deleted and

updated data from OLTP systems.

. Created Triggers to enforce data and referential integrity.

. Created interface for business to force update / force delete records

in Ci-Net.

. Created Documentation for support and helpdesk team.

Environment: SQL Server 2005, T-SQL, Integration Services (SSIS), Reporting

Services (SSRS), Windows 2003 Server.

Company: National Bank Of Kuwait

MAR 2007 -

SEP 2008

Position: SQL BI Developer

Debt Manager

Debt Manager System help recovery and collection team to easily manage,

monitor and track delinquent customers for timely collection and reduce bed

debts and legal cases.

We developed the interface (ETL programs) to feed the information to debt

manager, all the required data for debt manager to function was through

this interface.

Responsibilities

. Requirement gathering and transformation of requirement to technical

specification

. Design ETL Data Load Architecture, designed data load in phases

(source load packages and destination data load packages).

. Developed stored procedure and views for transformation of data.

. Developed ETL packages for data load and from source systems.

. Developed ETL packages for reconciliation of source System with

internal State of Debt Manager.

. Created data reconciliation reports using SSRS.

. Coordinated with QA and Release management for projects and bug fixes

to be released to production environment

. Create, document and implement unit test plans and scripts.

. Create and maintain technical documentation using standard templates.

Environment: SQL Server 2005, T-SQL, Integration Services (SSIS), Analysis

Services (SSAS), Reporting Services (SSRS), SQL Profiler, Windows 2003

Server.

Company: Kalsoft Pvt Ltd

Jan 2004 - MAR 2007

Position: Senior Software Engineer

. Requirement Gathering and Application Analysis

. Project Planning, Costing, Resource Allocation

. Software Design and Development

. Database Design and Development

. Client Interaction and Software Deployment

Project : SmartERP (ERP for Marbel and Garment Industry).

Project : ExhangePlus (Software to automate Exchange Company business).

Education

Karachi University

MCS, Computer Science

2003 - 2004

Shah Abdul Latif University, Khairpur

BCS, Computer Science

1997 - 1999

Contact this candidate