MOHAN

Email: omxipk@r.postjobfree.com

Phone: 408-***-****

SUMMARY:

A Microsoft Certified professional with around 7 years of experience in database design, database programming, ETL development, administration and testing of SQL server 2000/2005/2008 and implementation of data warehousing solutions.

Extensive Financial Domain experience with fortune clients like Wells fargo,Prudential ,State

Street financials for various applications.

Extensive work experience as a SQL Server Developer and in depth proficient experience in OLTP, Operational Data Source (ODS), and Dimension Modeling, Data warehouse, OLAP and Database technologies.

Experience in Microsoft SQL 2008 R2 Server migration from SQL Server 2005, Integration Service (SSIS), Reporting Service 2005(SSRS’05), Analysis Service 2005 (SSAS’05)

Very Good Knowledge & Real time working experience in:

Understanding existing data models, data flows and data dictionaries

Creating new data models, data flows and data dictionaries

Normalization and De-Normalization techniques

Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc)

Writing Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.

Extensive experience in writing Stored Procedures, Functions, Triggers ,Cursors ,Views and other database objects using SQL and PL/SQL.

Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.

Creating SQL Scripts for data loads and Upgrades for data migrations and data validations

Implementing SQL Server Indexing and Query optimization using Indexes

Creating and Managing users, roles and assigning necessary permissions

Data migrating (using ETL tools like DTS,SSIS,BULK_INSERT, BCP) between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance

Expert in creating SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.

Expert in usage of various SSIS components like Forloop, Foreachloop, Sequence Container, Variables and Error Handling etc.

Expert in Scheduling and Monitoring ETL Processes using DTSExec utilities and batch files.

Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes.

Creating large enterprise reports, sub reports using charts, report parameters, dropdowns and images using SSRS 2000/2005/2008.

Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.

Experience in SSAS (SQL Server Analysis Services) in SQL 2005 and SQL Server 2008

Expert in Creating and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2005/2008 Analysis Services and created various user roles.

Experienced in creating calculated members, named sets, actions and perspectives.

Expert in writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.

Experienced in Physical & Logical Data Modeling- Relational, Multi-Dimensional Modeling such as Star Schema, Snowflake Schema, ERWIN tool and SQL Diagrams.

Installation and Configuration of Performance Point Server and ProClarity ,Implementation of Dashboards, Views, Cubes,KPIs and scorecards using the tools

Extensive experience in creating different types of reports including: Ad hoc reports, Cross-tab, Conditional, Drill down, Top N, Summary, OLAP, Sub reports and Parameter prompts.

Experience in Integrating SQL Server Reporting Services (SSRS) with Microsoft Office Share Point Server (MOSS 2007), delivering them using Email Links and PDFs etc.

Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.

Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages

Exposure in using Team Foundation Server (TFS 2005/2008/2010) and visual source safe as a source control, source repository and project tracking solution.

Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design,

Testing, Implementation and Maintenance.

EDUCATION

B. Tech in Computer Science – JNTU, Hyderabad, Andhra Pradesh, INDIA

MICROSOFT CERTIFICATION

Business Intelligence Implementation and Maintenance with Microsoft SQL Server 2005 Enterprise Edition (Exam 70-445)

TECHNICAL SKILLS

Operating Systems Windows XP/2000/2003/NT 4.0/9x/Vista and MS-DOS,UNIX.

Programming Languages SQL, T-SQL, PL/SQL Dynamic SQL, MDX, SQL*Plus 3.3/8.0,

HTML, XML, DHTML, C, C++, VB Script, Shell Scripting, C# .NET,VB

NET, ASP .NET, ADO .NET, Visual Studio, XML, HTTP, MS Access

RDBMS Microsoft SQL Server 2008/2005, MS SQL, SQL*Plus,

Oracle 10g/9i/8i, Sybase Server, SQL, PL/SQL, MS Visual Source Safe,

Team Foundation Server.

Data warehousing SQL Server Reporting Services (SSRS), SQL Server Analysis

Business Intelligence Tools Services (SSAS), SQL Server Integration Services (SSIS), Business

Intelligence Development Studio (BIDS), Visual Studio, Crystal

Reports, Hyperion. Performance Point Server, ProClarity, OBIEE

SharePoint Server (MOSS) 2007.

Database Design Tools MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema

and Data Modeling modeling, FACT& Dimensions tables, Physical & logical data

Modeling and De-normalization techniques, Kimball & Inman

Methodologies, MSX, MS Access, MS Project.

Version Control Clear Case, Clear Quest, Visual SourceSafe 6.0/2005, Remedy

and Configurations Change Management.

Tools and Utilities SQL Server Profiler, Import & Export Wizard, Visual Studio .Net,

MMC, DTS, Spot Light, Lite Speed, Web Services, SOAP.

Portal SharePoint Portal Server 2003/2007.

Wells Fargo, San Leandro, California Feb 2010 – Current

Wholesale Data Solutions (Scoreboard) & Business Banking group/Wellsfargo Equity Finance

(BBG/WFEFI Applications)

Sr ETL (SSIS/SSAS/SSRS) Developer

Wholesale Banking serves large corporations, middle-market businesses, governments, and institutions worldwide. It has more than 50 business lines organized under 11 groups. Some groups manage relationships with specific customer segments, while other groups manage the products and services that Wholesale relationship managers offer customers .Wholesale Banking develops long-term relationships with customers. Primary objectives are to: Attract new customers that match our business model, Deepen our customer relationships through cross-sell, Retain customers by supporting them throughout the entire economic and business cycle and carefully manage the balance between risk and reward.

Responsibilities:

Responsible for analysis, requirements gathering, documentation of functional/technical

Specifications, data mapping, development and testing.

Wrote complex queries, CTE’s (Common table expressions), stored procedures, functions and views to ensure data integrity, data consistency and to meet the business rules.

Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle, and SQL 2005).

Created SSIS packages to transfer data from ESSBASE, NDM files, Oracle (Profit Max, IBCM Data LOAD, CDS, RMTools) to SQL server using different SSIS components and used configuration files and variables and maintained the same on Test and Production Environments.

Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task, Executing Analysis Services Processing Task(for processing SSAS cubes) etc to achieve business needs.

Build efficient SSIS packages for processing fact and dimension tables with complex data flow transforms like Lookup, Derived Columns, Condition Split , OLEDB command , Merge Join , Union all and Slowly Changing Dimension type 1 and type 2 changes.

Created Configurations to make package portable and created Event handlers and logging for handling package errors.

Created the cubes using the respective facts and dimension tables, performed the processing and deployed the cubes to SQL server analysis services database (SSAS).

Created data sources and data source views (DSVs), named calculations and named queries calculated members, named sets, KPIs, drill through, report actions and perspectives as per the business requirement.

Involved in Heavy MDX scripting for writing business calculations

Created rigid and regular hierarchies to meet the business rules.

Worked in Creating partitions and Designing storage modes (MOLAP) to increase the performance of a cube using SSAS.

Developed multiple Enterprise reports Using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.

Designed and developed 30+ reports in scoreboard application like: Business Group reports, Incremental Reports, Indirect Reports, and Penetration Reports etc and 25+ reports in Business banking group and wells Fargo Equity finance (BBG/WFEFI) like Organization level reports , Regional reports and Territory reports etc.

Developed Yearly, quarterly, monthly and LTM (Last Twelve months) reports for indirect, incremental, business group and penetration reports on top OLTP and OLAP Cubes.

Integrate custom .Net assemblies into Reporting Services Reports for outside the box solutions.

Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.

Created batch files (.bat) for deploying all the reports on the production/UAT servers.

Migrated 2005 SSIS/SSRS/SSAS to SSIS/SSRS/SSAS 2008 R2 accordingly to the new features of SQL Server 2008 R2.

Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.

Used Team foundation server (version control system) to check in and check out the database scripts, stored procedures, packages and other code files.

Provide on-call support to production system to resolve any issues.

Performed optimization of existing SQL statements and stored procedures to improve the performance.

Tools and Technologies: MS SQL Server 2008 R2/2005, Oracle 10g, Visual Studio 2005/2008, Reporting Services (SSRS 2005/2008), MS Office 2007, MS Access, SQL Server Analysis Services (SSAS), MDX, Team foundation server (TFS), Toad, MS Excel,.NET Framework ,VB, C#,ASP.NET, ADO.NET.

Sound Transit, Seattle, WA May 2009 – Jan 2010

U-Link Project Cost Management System

Sr ETL (SSAS/SSIS/SSRS/PPS/SharePoint) Developer

Sound Transit was created by the state legislature to build a mass transit system that connects major regional job and housing centers in King, Pierce and Snohomish counties. Sound Transit generates Revenue by running transit shuttles and trains. My project here was U-link Project Cost Management System which is related to Budget and Finance Of Sound Transit, During this I developed SSAS Databases which consists of Several Cubes and Developed reports related to the above project on a daily basis using SSRS2008, PPS and Publish them With MOSS 2007.

Responsibilities:

Collected business requirements from users and translated them as technical specs and design docs for development.

Wrote complex queries, stored procedures, functions and views to ensure data integrity, data consistency and to meet the business rules.

Created SSIS packages to transfer data from Contingency Cost Management System (CCMS), Enterprise One (Eone) and various types of sources files (Excel, Flat files, CSVs) to SQL server using different SSIS components and used configuration files and variables and maintained the same on Test and Production Environments.

Extensively used various Transformations in SSIS Data flow, Control Flow using for loop Containers, For Each Loop Container, Sequence Container, FTP, Bulk insert task, Transfer job task ,Execute Agent Job Task ,Execute Sql Task etc.

Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Fuzzy Lookups, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.

Created SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data etc.

Used the SSIS Configuration files to make the packages connections, variable values etc configurable and maintained the same on Test and Production Environments.

Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure

Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.

Created the cubes using the respective fact and dimension tables, performed the processing and deployed the cubes to SQL server analysis services database (SSAS).

Involved in Heavy MDX scripting for writing business calculations

Performed Various Complex Calculations Using MDX queries.

Worked in Creating partitions and Designing storage modes (MOLAP) to increase the performance of a cube using SSAS.

Expert to create the hierarchies (ex: Year to date) in Cube to meet the business req.

Expert to create the Actions like Drill through and Report action with parameters in cube.

Created many Perspectives for a cube based on users request.

Developed Complex SSRS reports with drilldowns, drill-through, hyperlink, calculated members, and dropdowns from the cubes by connecting to Analysis server and SQL Server from SSRS.

Expert to use various SSRS properties like Group by, Interactive Sorting, Expressions, Go to report, Go to URL etc.

Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint

Creating Dash Boards and Score Boards Using Performance Point Server 2007 and published them with MOSS 2007

Created Scorecards based on Key Performance Indicators (KPI’s), and generate KPI Score-card dashboard and pivot tables/charts for decision making.

Created various parameterized Charts in Performance Point Server using custom MDX queries to meet the User rules.

Responsible for maintaining Security Role and Database Users.

Used Visual Source Safe (version control system) to check in and check out the database scripts, stored procedures and other code files.

Performed optimization of existing SQL statements and stored procedures to improve the performance.

Tools and Technologies: MSSQLServer 2008/2005/2000, Oracle 10g, Visual Studio 2005, Reporting Services (SSRS 2000/2005/2008), BIDS, MS Office 2007, MS Access, SQL Server Analysis Services (SSAS), MDX, Microsoft Office SharePoint Server (MOSS) 2007, Performance Point Server 2007, ProClarity, Visual Source Safe, Toad, MS Excel,.NET Framework ,VB, C#,ASP.NET, ADO.NET.

State Street Financials, Boston, MA Aug 2008 – April 2009

Global Markets – Trading & Research

SSAS/SSRS/SSIS/ProClarity Developer

State Street Global Markets provides specialized investment research and trading in foreign exchange, equities, fixed income and derivatives. From our unique position at the crossroads of the global markets, we create and unlock value for our clients with original flow-based research, innovative portfolio strategies, trade process optimization, and global connectivity across multiple asset classes and markets.

Responsibilities:

Worked on SSRS 2005 to generate about 70+ reports for various user groups and developer groups

Involved in Daily, weekly, and monthly production data processing, monitoring, and trouble-shooting in an environment of mission-critical operational systems, benchmark establishment

Worked on all types of report types like tables, matrix, charts, sub reports etc.

Created Linked reports, Ad-hoc reports and etc based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.

Created the cubes using the respective fact and dimension tables, performed the processing and deployed the cubes to SQL server analysis services database.

Involved in writing MDX queries and worked on creating calculated measures that fits business logic

Moving all the ecommerce reporting to centralized SSAS OLAP Cube and then the future plan would be joining the entire cube to convert it to a huge data mart.

Created view from the cubes built using SSAS in ProClarity.

Created different Data Layouts for the Business users depending on the requirement and providing them different Drill Down capabilities using ProClarity.

Created SSIS Packages to load the data in to the data mart on daily basis and involved in production support

Used For-Each Loop Container, For loop container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.

Build efficient SSIS packages for processing fact and dimension tables with complex transforms like Lookups, Derived Column, Merge Join, Fuzzy Lookup, Conditional Split, Union all, Script component and type 1 and type 2 changes etc

Performance tune SSIS using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X in SSIS.

Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.

Wrote complex queries, stored procedures, functions and views to ensure data integrity, data consistency and to meet the business rules.

Improved performance of the system by suggesting composite Indexes.

Tools and Technologies:MSSQLServer2005/2008, SQL Server Analysis Services (SSAS), Reporting Services (SSRS 2005), SQL Server Integration Services (SSIS), ETL, MDX, Microsoft Office SharePoint Server (MOSS) 2007, Performance Point Server 2007,Proclarity,.Net,C#, Visual Source Safe, PL/SQL Toad, Oracle 10g

Prudential Financials, Newark, New Jersey Mar 2007 – Jul 2008

SSRS/SSIS/SSAS/SQL Developer

Prudential Financial companies serve individual and institutional customers worldwide and include The Prudential Insurance Company of America, one of the largest life insurance companies in the U.S. These companies offer a variety of products and services, including mutual funds, annuities, real estate brokerage franchises, relocation services, and more. It also enables detailed analysis of business data, finding patterns and relationship in the data. The main of the project is to generate various reports and do ad-hoc analysis for Mutual Funds, Assets, Equities & Fixed Income.

Responsibilities:

Created reports by analyzing business data according to customer requirements.

Actively involved in designing the logical and physical architecture for REGIONS’s database.

Involved in analysis, design, development, and enhancement of the data warehousing application.

Installation and configuration of MS SQL Server 2005.

Created SSIS package to get data from different sources, consolidate and merge into one single source.

Developed custom reports using SSRS/SQL Server BI studio.

Created reports that call Sub reports in SSRS.

Implemented Extraction, Transformation and Load (ETL), Import, Export activities by DTS package

Created SSIS/DTS packages for Finance application that would transfer data among servers and perform other data transformations; scheduled the same SSIS packages by creating the corresponding job tasks.

Strong SQL Server database performance analysis and tuning skills.

Design and implementation of Replication solution for SQL Server 2000 using Enterprise Manager

Implemented replication using SQL 2005

Created custom and Ad hoc reports using SSRS.

Development of SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting

Performance tune SQL statements, queries, triggers and stored procedures

Modified the current stored procedures to meet current design

Created indexed views, and appropriate indexes to cut the complex query time.

Provided day-to-day administration tasks like space and log management.

Developed Backup and Recovery Strategies, and Disaster Recovery Plan

Database creation; database tuning, performance planning, backup planning and database administration.

Capacity planning in estimating and sizing of tables.

Environment:

MS SQL Server 2000/2005, SSIS,Informatica T-SQL, Enterprise Manager, Sybase, Oracle 9i, Crystal Reports, VSS, UNIX, Microsoft Visio 2003, MS-Access 2000 & Windows XP Professional, NT, 2K platform.

Wipro Systems, Bangalore, INDIA June 2004 – Aug 2006

MS SQL Server Developer

Responsibilities:

Involved in Designing database model using ER modeling for OLTP and Dimensional modeling for OLAP using Erwin tool.

Developed all the required stored procedures, user defined functions, triggers using T-SQL.

Created stored procedures to generate account statements for different types of accounts.

Designed DTS packages to transfer data from heterogeneous databases & different files formats (Text file, Spread sheet) to SQL Server.

Involved in performing Extraction, Transformation and Loading using DTS.

Performed optimization of existing SQL statements and stored procedures to improve the performance.

Used SQL server 2000/2005 reporting services for generating reports.

Created SQL server Reports using Report developer.

Identified and defined Data Sources for creating data source views

Wrote SQL queries for various reports.

Defined parameters for parameterized reports.

Formatted the report layout for various reports

Modified the Report Data Source Properties.

Created backup and recovery of the team members’ data.

Managed the security of the servers (Logins and Users).

Developed complex T-SQL code for the application.

Worked as a developer in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, views and other SQL joins and statements for applications.

Designed and implemented stored procedures and triggers for automating tasks

Worked on complex data loading (implemented the batch data cleansing and data loading).

Environment: MS SQL Server 7.0/2000, Unix, Oracle 8i, T-SQL, Enterprise Manager, Query Analyzer, MS Access, MS office 2000, DTS, Erwin 3.0., MS SQL Server Reporting service 2000, T-SQL, Windows 2003.

Contact this candidate