Summary

• 7 Years of extensive IT experience as a Microsoft SQL Server 2000 /2005/2008/2008R2/2012 Developer in creating Business Intelligence Solutions like SSIS, SSAS, SSRS and expertise in designing and implementing Relational Database model as per business needs.
• 7 years of IT experience in Microsoft Database Technologies with various Industry verticals as a Database developer, BI Developer in MS SQL server 2012/2008/2005/2000 databases.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User define data types, Cursors and Indexes using T-SQL.
• Experience in writing complex T-SQL queries using Inner, Outer and Cross Joins.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Foreign Keys.
• Excellent in High Level Design of ETL DTS Packages SSIS Packages for integrating data using OLE DB connection from heterogeneous sources Excel, CSV, Oracle, flat file, Text file, Teradata by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union all.
• Experience in migrating DTS Packages from 2000 to 2005 and 2000 to 2008.
• Experience with ETL framework standards, including error processing, validation and data reconciliation.
• Proven ability in generating Drill down and Drill through reports with Drop down option, sorting the data and defining subtotals in SSRS 2012/2008/2005.
• Good experience on Qlikview Business Intelligence reporting tool for developing dynamic reports.
• Hands on experience in developing QlikView Dashboards using Chart Box Drill Down, Drill up Cyclic Grouping , List, Input Field, Table Box and Calendar etc.
• Created Parameterized reports, Sub reports and thorough knowledge of reporting server architecture. Table, chart and matrix reports .
• Experience in administrating the reports and assigning permissions to the valid users for executing the reports.
• Hands on experience in installing, configuring, managing, upgrading, monitoring and troubleshooting SQL Server 2012/2008/2005/2000.
• Experience in upgrading SQL Server software to newer versions and applying service packs and hot fixes and unattended Installation.
• Experience in migrating from SQL Server 2000 to SQL Server 2005, SQL Server 2005 to SQL Server 2008 and from SQL Server 2008 to SQL Server 2012.
• Extensive experience in monitoring and tuning SQL Server database performance using tools like SQL Profiler, Index Tuning Wizard, Database Engine Tuning Advisor, Windows Performance Wizard.
• Experience defining and building audits and controls to ensure the accuracy of the data.
• Worked with Database migration Testing experience in different versions of Informatica
• Experience in Analyzing Execution Plan, managing indexes and troubleshooting deadlocks.
• Experience in Data Modeling, Multi-Dimensional Modeling and involved in creation of Star Schema and Snowflake dimensional schema using Erwin Tool and Microsoft Visio.
• Good knowledge of Software Development Life Cycle SDLC .
• Expert in Database Normalization, designing and creating Indexes, planning and implementing Server Security and authentication, Develop Queries and T-SQL Scripts in MS SQL 2008/2005/2000.
• Experience in Creating Roles and Assigning Permissions to the users.

Responsibilities:

• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Designed Data Mapping documents, DDL scripts, Data Dictionary and meta data of the models and maintained them.
• Developed SQL scripts for administration task.
• Maintained SQL scripts, indexes, complex queries for data analysis and extraction.
• Implemented data vitualization layer with Composite softwares/Tools
• Used .NET provider Data Reader Source Task to Read from RDBMS sources.
• Worked in ASP.NET Web forms, State management and Caching feature.
• Maintained WCF services across the enterprise and integrating UI using MVC pattern
• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule DTS/SSIS Packages.
• Involved in developing database objects such as procedures, triggers, constraints, indexes and views. Used T-SQL to build dynamic stored procedures.
• Developed SSIS packages for File Transfer from one location to the other using FTP task
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using Business Object and Crystal reports.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS. Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Experienced in creating SSAS OLAP Cubes and Partitioning Cubes.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Identified Key Performance Indicators KPI and Metrics for Business needs in SSAS
• Created Multi Dimensional Cubes using SSAS for the Data Warehouse.
• Created Production Deployment Scripts for SSAS Cube Roles
• Developing OLAP cubes by identifying tables fact and dimension , data source and data source views attributes and dimension members using SQL Server Analysis Services SSAS .Created SSAS storage and partitions, and Aggregations, calculation of queries with MDX.
• Developed many MDX queries for creating measures that fits business logic.
• Defined Calculated members, named sets, and executed other script commands using MDX expressions.
• Conducted weekly Crystal Reports training session for the reports team.
• Developed a dashboard solution for analyzing STD statistics by building SSAS 2008 cubes and Tableau
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients, and managers
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications by using T-SQL.
• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Involved in De-Normalization of existing tables for faster query retrieval.
• Involved in development, enhancement, testing and performance tuning of the application.
• Developed Multi dimensional Objects Cubes, Dimensions using MS Analysis services SSAS .
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Created and modified Unix Shell Scripts.

Environment: Windows 2003 Server/XP, SQL Server 2008/2005, Informatica, SQL Integration Services SSIS , SQL Reporting SSRS , Business Intelligence Studio, Visual Studio 2008/2005, OLE DB, DTS Package, SharePoint MOSS 2007, Crystal Reports, Erwin 4.0, Composite, VB.Net, HTML.

Confidential

Responsibilities:

• Upgraded MS SQL Server 2005 database to MS SQL Server 2008, by using Detach/Attach, Back up Recovery.
• Incorporated the DTS Packages into MS SQL Server 2005 Integration Services by using Package Migration Wizard and Execute DTS 2000 Package task.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Monitored the Informatica workflows using Power Center monitor. Checked session logs in case of aborted/failed sessions
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule DTS/SSIS Packages.
• Involved in developing database objects such as procedures, triggers, constraints, indexes and views. Used T-SQL to build dynamic stored procedures.
• Developed SSIS packages for File Transfer from one location to the other using FTP task
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Checking the job flows in Informatica.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS. Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients, and managers
• Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications by using T-SQL.
• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.
• Design and implementation of stored procedures and triggers for automating tasks.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Created Views to reduce database complexities for the end users.
• Created Provided assistance to development teams on Tuning Data, Indexes and Queries.
• Worked on troubleshooting and maintaining large terabyte-size clustered databases.
• Created Functions, Stored Procedures, Database Triggers
• Created checks and constraints to maintain data integrity.
• Involved in De-Normalization of existing tables for faster query retrieval.
• Involved in development, enhancement, testing and performance tuning of the application.
• Developed Multi dimensional Objects Cubes, Dimensions using MS Analysis services SSAS .
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment:

• Windows 2003 Server/XP, SQL Server 2008/2005, Informatica, SQL Integration Services SSIS , SQL Reporting SSRS , Business Intelligence Studio, Visual Studio 2008/2005, OLE DB, DTS Package, SharePoint MOSS 2007, Crystal Reports, Erwin 4.0, VB.Net, HTML.
• State Farm Insurance is a group of insurance and financial services companies that together serve tens of millions of customers in the confidential
• Goal of this project is to design loads the input files into the database and creating Output files for those files loaded. This process also creates the output files directly from the input files for pass thru input files. Daily scheduled process loads files from auto data folder into the Custom ODS database. User can request Output Files using front-end application. The output files are posted on the FTP site and a backup is stored on the production delivery folder

Responsibilities:

• Involved in complete software development life cycle - Requirements gathering, Conceptual Design, Analysis, and Detail design, Development and System Testing
• Involved in database Schema design and development.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Created tables, indexes and designing constraints and wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL Queries and Stored Procedures.
• Used Batch Files to Import Data from other Data Base.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
• Created ETL SSIS packages both design and code to process data to target databases.
• Worked in enhancing and deploying, and scheduling the SSIS Packages from development server to production server.
• Wrote the ETL scripts to load the data into database from various source files. Experienced in error handling and troubleshooting the scripts in failure to load the data into database.
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
• Responsible for creating parameterized reports in SSRS.
• Deployed the generated reports on to the Report server and fine-tuned the database objects and server to ensure efficient data retrieval.
• Developed Sub Reports, Matrix Reports, charts, Ad hoc, Drilldown reports, using SQL Server Reporting Services SSRS .
• Scheduled reports to run the reports Hourly, Daily, Monthly according to client requirements for the periodic analysis.
• Wrote queries to generate reports for analysis of data using SSRS.
• Created and deployed the dimensions and cubes with star and snowflake schemas using SQL Server Analysis Services SSAS .
• Built SSAS OLAP cubes that used the built-in SSAS features for the time dimension.

Environment:

• MS SQL Server 2005/ 2008/2008R2, MS Access, Informatica, Query Analyzer, Oracle 10g/11i, DTS, Windows 2000 Server, SSIS, SSRS, SSAS, T-SQL, PL/SQL, Microsoft Visio 2007, MS Excel, C , C , Windows7, ETL, MS Access, Microsoft Visual Source Safe 6.0
• confidential is the largest independent community bank in Riverside County. Provident Bank is committed to the belief that our communities are better served when decisions about Investment banking financial products and services are made locally by people who know the markets.

Responsibilities:

• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems
• Extract Transform and Load ETL source data into respective target tables to build the required data marts
• Created SSIS packages to load data into Sql Server using various transformations in SSIS.
• Analyzed the existing tool and participated in meetings with the business users to gather
• requirements and design goals of data warehouse.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Deployed and processed OLAP Cubes.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Defined appropriate measure groups and KPIs deployed cubes.
• Created Parameterized reports, Cross-Tab reports, Drill down reports Summary reports by using SSRS and designed reports using Crystal Reports.
• Created report snapshots to improve the performance of SSRS.
• Designed Analytical Cubes by setting direct referenced relationships between Dimension Fact Tables, resembling Star Schema.
• Created Perspectives on SSAS Cubes as per user requirements.
• Created Partitions Aggregations to improve the performance of SSAS Cube.
• Created Calculated Members Scope Statements in Cube using MDX Script.
• Creation of Roles in Cube to define the User Security in SSAS Cube.
• Deployment and End-to-End testing of Cubes.
• Developed new objects i.e. Tables, Views, and Stored Procedures in SQL server 2005 database and performed tuning on it.
• Migrated database from SQL server 2000 to SQL server 2005 using utilities i.e. exp/imp and attach/detach for SQL servers 2005 futures.

Environment:

• SQL Server 2005, Windows 2000/2003,T-SQL, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, MS Excel 2003, MSIIS,Visual Studio 2005, Visual Team Foundation Server, Crystal Reports.
• Confidential through its subsidiaries, provides retail, commercial, and corporate banking services principally in the United States. The company operates through three segments: Community Banking: Wholesale Banking: and Wealth, Brokerage, and Retirement. The company was founded in 1929 and is headquartered in San Francisco, California.

Responsibilities:

• Modification of database object such as addition of triggers, modification of table, stored procedure to meet new customer's requirements.
• Database performance tuning, monitoring, scalability and Testing. This includes optimization of slow running stored procedures, deployment of locking mechanism to increase concurrency.
• Created DTS SSIS packages to get data from various sources mainframe, Informix, Oracle .
• Administer, maintain, develop and implement policies and procedures for ensuring the security and integrity of the department database.
• Performed Weekly Application Builds, including some troubleshooting and debugging of Multi-tier financial applications.
• Automation of monitoring all the failed jobs in the database using DTS SSIS and SQL mail.
• Prepared patch and upgrade scripts for service packs and new releases
• Index optimization, Performance, Disk management, Disk partitions and optimizing.
• Worked on locking strategy which is used for various batch Programming structures Transactions.
• Memory management, data storage, user connections and load balance.
• Prepare and set up environment for disaster recovery.
• Transformation of data from one server to other servers using tools like bulk copy program BCP , data transformation services, data conversions from legacy systems to SQL server.

Environment: SQL Server 2005, Enterprise Manager, SQL Profiler, Data Model, T-SQL, SQL Query Analyzer, Replication, Backup/ Recovery, DTS/SSIS, Windows 2000/Advanced server.