SUMMARY

• 6+ years of experience in Database Analysis, Design, Modeling and Developing in the areas of Business Intelligence and Data Warehousing applications utilizing the MS SQL Server 2000/2005/2008/R2 BI stack (SSIS, SSAS, SSRS) and latest tools and technologies in a wide variety of fast-paced enterprise settings for Banking, Networking and Insurance industries.
• Excellent Experience interacting with Business Users to analyze the business process and requirements, writing Business Requirement Documents, HLD and Technical/Functional Specification Documents.
• Proficient in using ERWin and MS Visio Data modeling tools to design and implement Logical and Physical models of various Relational Databases and drawing up the Process Flow charts, DFD's and ERD's.
• Experience in Forward and Reverse Engineering Data models between ERWin and Microsoft SQL server.
• Created data models for relational schemas (OLTP) and dimensional schemas (OLAP) with proper normalization and de-normalization techniques.
• Excellent in Analysis, Data profiling and Source to target Mappings.
• Experience with full development cycle of OLTP and Data Warehouse (OLAP) architectures.
• Strong experience working with SQL Server using T-SQL in constructing Tables, Stored Procedure, Triggers, Views, Indexes, Relational Database Models and Data Integrity and frequently used Joins, Sub Query, CTE, Coalesce, Ranking and Aggregate Functions.
• Expert in Extract, Transform and Load (ETL) data from different sources to final tables/dimensions using DTS and SSIS 2005 and 2008.
• Skilled in designing high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, tables and relationships, data dictionary and Metadata
• Designed and developed multiple ETL packages and Cubes using SSIS\\DTS and SSAS application.
• Strong knowledge in reporting Services life cycle right from Authoring, Management to the Delivery phase.

TECHNICAL SKILLS

Programming Languages : T-SQL, C, SAS 9.1
Databases : MS SQL Server 2005/2008/R2, Oracle 9i/10g, MS Access 2000/2003
Operating System : Windows server 2003, Windows NT/2000/XP, Windows 98
Reporting Tool : SSRS, Business Objects,Tableau 7.0
Data Modeling Tool : Erwin, Microsoft Visio 2000/2003
Backup Tools : Lite Speed

RELEVANT EXPERIENCE

Confidential, Milpitas, CA
Data architect\\ BI Developer (July 2011 - Till Date)

Confidential, designs, manufactures, and sells Internet protocol (IP)-based networking and other products related to the communications and information technology (IT) industry and provide services associated with these products and their use. It provides a line of products for transporting data, voice, and video within buildings, across campuses, and around the world.

Project description:
My project initiated redesigning existing system for a common data repository for worldwide distribution department to capture their Inventory, Backlog, Pos and Booking's data. Data use to come from different countries in the form of flat files, Excel and DB2 tables and refreshed tables and reports daily for Business analysis.

Responsibilities:

• Actively participated in gathering System Specification Requirements for the project and was involved in creating BRD, DRD, Data models and flow diagrams.
• Captured and documented data business rules and definitions.
• Worked closely with (internal) customers to understand their needs and to explore opportunities for data improvements.
• Involved in data profiling and cleanup process after requirement analysis for the Data Mart.
• Generating scripts and schemas by using reverse engineering through Erwin Data Modeler.
• Worked extensively with T-SQL for creating objects like Table, Stored Procedures, User Defined functions, Views and Temp Tables etc.
• Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle11g, text files and Excel files.
• Used SSIS Packages to transform and load staging and reporting tables with the help of Data flow task, Execute SQL task, Sequence container and Data flow transformations like conditional split, row count, derived column and aggregate.
• Designed and developed SSAS Cube with multiple Fact, dimension, hierarchies, calculated members, action, partitions and aggregations.
• Supported users in building excel based macro enabled report from the Cubes.
• Scheduled SQL Jobs and trigger files to initiate report generation.
• Ensure all change activities are completed in accordance with project plans and time.
• Created adhoc reports to users in Tableau 7.0 by connecting toSSAS.
• Worked on Business objects reports to pull the data into SQL.

Confidential, San Leandro, CA
Database analyst\\ SQL Server BI Developer (Jan 2010 - Jun 2011)

Confidential, is a diversified financial services company with operations around the world. Wells Fargo is the fourth largest bank in the US by assets and the second largest bank by market capitalization. Wells Fargo is the second largest bank in deposits, home mortgage servicing, and debit card.

Project description:
As part of merger between Wellsfargo and Wachovia we developed new application for business to monitor the revenue and made Enhancement to existing system to integrate data between east and west data. Developed maintined and supported two applications TMR and ITRAC for ETL and reporting which are used to report revenue for east and west data.

Responsibilities:

• Gathered business requirements and prepared FSD's which included the technical changes related to the ETL scripts and backend tables.
• Designed system's process flow, Logical and E-R diagrams with the help of MS Visio.
• Performed consistent data entry into the database by developing stored procedures and triggers.
• Created T-SQL objects like Table, Stored Procedures, Views and UDF, making frequent use of While/For Loop, If/Else, Case, Coalesce, Sub Query, Joins, Dynamic Query, CTE, Temp Tables etc in order to build ETL scripts to transform the data according to the company standards.
• Created SQL server job, troubleshoot SSIS packages and configured them according to the servers.
• Used SSIS Packages and the batch process to extract, transform and load data from multiple input sources like Oracle databases, DB2, flat files and excel sheets into SQL Server 2008 Staging Database.
• Created Hierarchies and Attribute Relationships to force SSAS to create more Aggregation Objects.
• Generated on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Scheduled delivery of several reports to multiple users through the use of subscriptions in several different formats like Excel, PDF and Text.
• Participated in BCP fail over and fail back process which included the log shipping of production server to the BCP server.
• Was responsible for Preparing and Deploying the Game plan for Business Continuity Process for various Production and Development Servers which included Replication of the Databases, Migration of Packages & Scripts.
• Worked with Change Management Team for proper approvals and auditing for Deployment and Production changes.

Confidential, Atlanta, GEORGIA
Database Developer (Dec 2007 - Dec 2009)

Project description:

The project started with the new feed coming in and the main objective was to automate the entire sales and marketing activities of a company. It is used to enhance the efficiency of the sales force of the organization. It caters to all functionalities of the sales and marketing departments including, Contact Management, Customer Call Management, Inventory Management, Order Management, Sales and Marketing, and Reporting.

Responsibilities:

• Documented and analyzed business rules, data analysis and modeling, relational and dimensional database design within data warehouse reporting and transaction processing environments.
• Developed stored procedures to retrieve customer information from as required to evaluate eligibility for loan requests, account status etc.
• Fine tuning of database objects and server to ensure efficient data retrieval by refining code replacing long joins with effective sub queries and refining the indexes in place.
• Created various views and materialized views that will be accesses buy both the end users and the database administrators.
• Created SSIS packages for populating the data marts, cleaning data and loading data from various sources.
• Configured and Deployed SSIS packages for the data transformation that included Aggregate, Sort, Lookup, Derived Column and Data Conversion.
• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
• Created cubes with usage based aggregations and set-count aggregations and advocated appropriate storage mode like MOLAP, HOLAP and ROLAP depending upon how important the data is how frequently it needs to be fetched from the DW.
• Generated report models to aid the creation of ad hoc reports using SSRS.
• Developed documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Confidential, Hyderabad, INDIA
SQL Developer/Data Modeler (May 2006 - Oct 2007)

Visual Soft is a provider of information technology (IT) services. The Company delivers a range of IT services through globally integrated onsite and offshore delivery locations primarily in India. It offers its services to customers through industry-focused practices, including insurance, manufacturing, financial services, healthcare and telecommunications, and through technology-focused practices.

Responsibilities:

• Involved in the Data modeling using the ERwin tool and forward engineered the design to SQL server 2000.
• Involved in the Normalization of the database ensuring the implementations of design concepts of the first, 2nd and 3rd normal form.
• Created various queries and stored procedures for several purposes like profiling, maintenance, ETL, retrieval and audit of data from several sources.
• Involved in the Database optimization by partitioning tables, rearranging indexes, creating indexes on heap tables, creating non clustered indexes on some tables for faster query response.
• Created several materialized view to support real-time computing and accessibility by front end applications and reports.
• Created several roles, and logon triggers that will configure the database and conduct several procedures before the user accesses the database.
• Created several scripts that included joins, outer joins, sub queries and correlated queries.
• Responsible for documenting Data Dictionaries and versioning them.
• Perform the tasks in a timely fashion and in line with the Project Plan defined by the Project Manager.
• Debug Procedures and Triggers in case of bugs.

EDUCATION

B.Tech in Computer Science