PROFESSIONAL SUMMARY:

• Around 8 years of experience in Database Design, Development and maintenance of database applications on SQL Server 2005/2008/2012 in OLTP/OLAP environment.
• As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Involved in T - SQL programming and creating complex stored procedures - reusing of code over and over again instead of having to write the query each time, triggers - Type of stored procedure that can act on a table action such as an INSERT, UPDATE, or DELETE, views - a virtual table based on the result set of an SQL statement. It contains rows and columns like a real table and user defined functions - can call user defined function in a where clause or can be used in a join on SQL 2014/2012/2008 and 2008 R2 Servers to meet the requirement of the applications.
• Excellent Experience in monitoring SQL Server Performance tuning in SQL Server 2000/ /2012 using SQL Profiler - capturing and saving data about each event to a file or table to analyze later, Query Analyzer - graphical tool to create queries and SQL scripts and execute them against SQL server databases, Enterprise Manager - set of web based tools for managing software and hardware produced by Oracle, Index Tuning Wizard - used to select and create an optimal set of indexes and statistics for SQL server.
• Monitored, Optimized and Tune complex T-SQL scripts and Stored Procedures based on the execution plans.
• Excellent in high level design of ETL DTS packages and SSIS packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, text format data) by using multiple transformations.
• Excellent experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Bulk Insert - inserting data from a text file into a SQL table and BCP.
• Expertise in Data Conversion, converted the data from mainframe legacy to STG environment.
• Implemented various SSIS Transformations such as Slowly Changing Dimension - data changes slowly. type 1 overwrites old data with new data where as type 2 tracks historical data and type 3 has limited history preservation, Aggregate-to perform operations or functions on group in a dataset and the functions used are count, count distinct, sum, average, minimum and maximum, Data Conversion-for changing the data type of a column, Derived Column-for deriving new columns, Lookup-performs lookups by joining data in input columns with columns in a reference dataset, Fuzzy Group - allows to identify similar items within a dataset, Multicast-it has one input and many outputs and it will replicate the same input what it takes and returns many copies of the same data, etc.
• Developed SSIS packages with various tasks like - FTP-used to download and upload data files to and from an FTP location, file system-used to perform different types of operations on files and directories such as create, move, delete, for-each-loop-defines a repeating control flow in a package, execute package-can call another SSIS package. Package with the execute package task is called the parent and the package started by the execute package task is called the child, data flow task-only task to have its own tab in the integrated development environment, execute SQL task-used for returning result sets that can be used by other components in package, custom script task-to write custom code that perform tasks which cannot be performed with the built in components, analysis services task-used to create, modify, delete and process analysis services objects, data mining task-used to run prediction queries.
• Optimized the performance of SSIS packages using features like Auditing, Checkpoints-if package fails at a certain point it can be configured to start from the point of failure or from an earlier step when the package is rerun, Transactions, Loggings - to capture run time information about a package which helps for troubleshooting and Event-Handlers-reacts appropriately to error conditions and allows monitoring SSIS packages.
• Designed Reports using SQL Server Reporting Services (SSRS). Included graphical structures using charts, tables, matrices, parameters and conditional formatting.
• Created Parameterized Reports, Sub Reports, Drill Through, Drill down Reports in SSRS and Ad-hoc reports using Report Builder.
• Good experience in writing MDX queries while creating and customizing cubes using SSAS.
• Knowledge in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Administered report execution based on Caching and Snapshot as well as managed report delivery using standard and data driven subscriptions.
• Capable of handling all phases of a project cycle, from planning and design through deployment and support.
• Good Knowledge in Agile scrum software development framework and in V model of SDLC.
• Knowledge in UAT and Integration Testing.
• Good understanding of different domains data like Insurance domain and Banking domain.
• Highly accomplished at organizing and facilitating one-to-one discussions, workshops, and requirement elicitation sessions.
• Strong individual contributor and a good team player with proven ability and excellent verbal and written communication skills to interact with clients and peers.
• Ability to learn the emerging technologies and to associate with an organization where I can share, contribute and upgrade my knowledge for the development of the organization.

TECHNICAL SKILLS:

Databases: SQL SERVER 2000/2005, Oracle 11g/10g/9i/8.0/7.x, MySQL and MS-Access.

SQL Server Tools: DTS, BIDS (SSIS, SSRS, SSAS), Query Analyzer, Enterprise manager Integration and reporting

Tools: SSIS, SSRS

Operating Systems: MS-DOS, Windows 95/98/2000/2003/ NT, UNIX.

Programming Languages: T-SQL, PL/SQL, HTML, C, Java Script, VB.NET, Manual Testing, QA

Microsoft Office Tools: Microsoft Excel, Access and Visio

Modeling: Star-Schema modeling, Snowflake Schema modeling, Fact and Dimension Tables.

Data Modeling Tools: Erwin, ER Model.

Graphics Editing Program: Adobe Photoshop.

PROFESSIONAL EXPERIENCE:

Confidential, Oregon

DC/ SSIS Developer

Responsibilities:

• Interacted with the business users for rewriting the mapping document and developed ETL packages based on it.
• Involved in conversion of data from legacy systems to staging environment.
• Performed index analysis for tables and came up with more efficient solutions to use clustered and non-clustered indexes for significant performance boost.
• Creating Database objects - Tables, Views, and Functions and developing Procedures for implementing application functionality at the database side for performance improvement.
• 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.
• Sourced data from various types of relational databases, flat files, excel files.
• Developed SSIS packages with various tasks like - FTP, file system, for each loop, execute package, data flow task, execute SQL task, custom script task, data mining task.
• Made use of Event Handlers, Loggings, Breakpoints and Data Viewers for effective debugging of packages.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
• Designed, developed, debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
• Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.
• Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs.
• Optimized SSIS packages by using various techniques such as use of non-blocking, synchronous communication nature transformations, optimizing sources as well executing packages in parallel.
• Designed SSIS package templates as base code for package development incorporating package configuration, connection managers and logging in it.
• Written SQL queries to perform Data Integrity testing on a SQL Server Database to validate and test data using SSMS.
• Fine-tuned SSRS reports, SSIS packages and stored procedures that take long time for execution.
• Created requirement documents, technical design documents and knowledge sharing documents.
• Developed chart reports, parameterized reports, drill down report, drill through report, matrix report and master detail reports.
• Generated reports using SSRS which were send to different Primary Vendors, Clients, and managers.
• Created reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services.
• Designed and delivered dynamic reporting solutions using MS SQL Server Reporting Services.
• Created expressions in SSRS to provide flexibility to users by providing them with variety of options for seeing the business information in tables/charts etc.
• Creating data sources and subscriptions for SSRS reports

Environment: SQL Server 2012/2008R2, BIDS, SSIS, SSAS, SSRS, Erwin, Power Pivot.

Confidential, Agoura Hills, CA

BI Developer

Responsibilities:

• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Created Triggers to implement the User defined integrity to authenticate the transactions as per the business logics.
• Wrote complex TSQL stored procedures for generating data sets from UI for better latency performance.
• Created T-SQL scripts and stored procedures for data validation and data process tables.
• Enhanced the functionality and performance of various SQL scripts and stored procedures by using UDFs, CTEs and system stored procedures along with usage SQL Profiler.
• Analyzed different heterogeneous sources like DB2, Excel, Flat Files and SQL Server for ETL strategy that needs to be implemented with the help of SSIS packages.
• Involved with data cleansing operations using SSIS transformations and T-SQL scripts to normalize the data and remove and identify potential problem points when moving information into a data warehouse.
• Implemented proper package configuration features and finally securing the packages by using password and encryption methods.
• Responsible for the management and migration of SSIS packages in the staging and pre-production environments.
• Converted Data transformation Services(DTS) application to SSIS as assigned.
• Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.
• Scheduled the delivery of reports in different formats such as PDF, Excel, using standard and data driven subscriptions in SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Created Sub-Reports, Drilldown-Reports, Summary reports, parameterized reports, cascaded reports in SSRS by linking aggregate data to support summarized view as well as detailed view.
• Used different layout such as Matrix, tabular, chart, tablix to display data in a grid format, with layout possibilities ranging from simple tables to advanced matrices.
• Enhanced the old Excel files and Crystal Reports to new SQL Server Reports to fit new business requirement and implemented into SQL Server.
• Created different schedules for report delivery to e-mails and shared directories; enabled snapshots, subscriptions, caching to improve the response times and reduce traffic to the report server.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Generated reports using SSRS which were send to different Primary Vendors, Clients, and managers.
• Created reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services.
• Designed and delivered dynamic reporting solutions using MS SQL Server Reporting Services.
• Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.
• Used Report Manager for setting up roles and security on the reports.

Environment: SQL Server 2008R2, BIDS, SSIS, SSAS, SSRS, Erwin, DB2, Flat Files, Excel, DTA, SharePoint.

Confidential

BI Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis.
• Lead a team of 4 members; taught them how to write optimized SQL to have the report created within minimum time frame. Using BI Developer 2012, TFS and SQL Server 2012.
• Involved in the design of data marts using star schema and Kimball Methodology.
• Written SQL script to analyze the historical data and extract required data to support the management decisions.
• Creating Database objects - Tables, Views, and Functions and developing Procedures for implementing application functionality at the database side for performance improvement.
• Created complex stored procedures to perform Index maintenance, data profiling, metadata search (DB2 and Oracle), critical staging procedures for loading data marts and reporting database.
• Created SSIS process design architecting the flow of data from various sources to target.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access and Excel.
• Written basic VB.Net scripts to implement Type 1 and Type 2 Slowly Changing Dimensions for incremental load.
• Implemented SSIS packages to perform ETL Operations from multiple data sources including excel and text files.
• Implemented the Master Child package technique to manage big ETL projects efficiently.
• Incorporated error reduction during ETL load in SSIS packages.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of performance tuning operations.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, recovery and Disaster recovery procedures. Planned the complete Back-up of various databases for disaster recovery scenarios.
• Designed cubes with star schema using SSAS.
• Involved in Analyzing, Designing, building and Testing of OLAP cubes with SSAS and in adding calculations using MDX.
• Generated parameterized reports, sub reports, tabular reports using SSRS.
• Created SQL Server Drill down, Drill through, Adhoc, Cross tab report using SSRS to fit business requirements.
• Designed and created report templates, bar graphs and pie charts based on the financial data.
• Created reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services.
• Used DBCC to check database conditions, fix database corruption, rebuild indexes and stability.

Environment: MS SQL Server 2005/2008, SSIS, SSAS, SSRS, BIDS, TFS, SQL Profiler, Windows Server, Microsoft Access.

Confidential

BI Developer

Responsibilities:

• Gathered system requirements through end-user collaboration.
• Created functional specification of the requirements as listed in the product requirement documents.
• Developed and created Logical and Physical database architecture using Erwin Data Modeler.
• Facilitated data retrieval and manipulation through implementation of views, procedures, triggers and cursors.
• Created database objects like User Defined Stored Procedures, Triggers and UDFs to be used for ETL, Audit and Maintenance tasks.
• Analyzed and tuned complex queries/stored procedures in SQL Server 2008 for faster execution and developed database structures.
• Designed, developed and implemented ETL framework using SSIS, stored procedures, functions for extractions into SQL Server 2008.
• Imported data from MS Access, MS Excel and Text Files to SQL Server 2008 using SSIS.
• Provided back-end support for functional testing and performance testing.
• Created several dashboards and scorecards with key performance indicators in SSAS.
• Created time dimensions on OLAP cubes.
• Designed SSIS Packages to extract, transfer, load(ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Understanding OLAP process for changing and maintaining the warehouse, optimizing dimensions, hierarchies and adding the aggregations to the cube.
• Performed documentation for all kinds of reports and DTS and SSIS packages.
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
• Drafted all system documentation along with user manual, flowcharts, and source code.
• Enhanced the performance of the cubes by creating perspectives, KPI's, Translations and Calculated members.
• Scheduled delivery of several reports to multiple users through the use of subscriptions in several different formats like Excel, PDF and Text.
• Accountable for data quality & analysis using & excel data parsing using macros, lookup functions and pivot tables.

Environment: SQL Server 2005/2008, SSIS, SSAS, BIDS, Erwin, Visual Studio 2008, Profiler, Excel, Power Pivot.

Confidential

BI Developer

Responsibilities:

• Implemented triggers and stored procedures and enforced business rules via checks and constraints.
• Created indexes on selective columns to speed up queries and analysis in SQL Server Management Studio.
• Built efficient SSIS packages for processing fact and dimension tables with complex transformations and type 1 and type 2 changes.
• Defined the logging process for all the packages, populated it with entries like inserted records, updated record and error record.
• Created SSIS packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Conditional 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 cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Performed data transfers using BCP and BULK INSERT utilities.
• Designed dimensional modeling using SSAS packages for end user and creates hierarchies in dimensional modeling.
• Enhanced the performance of the cubes by creating perspectives, KPI's, Translations and Calculated members.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, data mining models, developing reports using MDX and SQL.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Developed complex stored procedures and views to generate various Drill-through reports, Parameterized reports and linked reports using SSRS.
• Created Cross-Tab, Drill-down and Sub-Reports using RDL. Promoted RDLs to reporting service server.

Environment: SQL Server, BIDS, SSIS, T-SQL, SSRS.

Confidential

SQL/ Report Developer

Responsibilities:

• Created complex Stored Procedure, Triggers, and Cursors, Tables, Views and other T-SQL JOIN techniques.
• Developed complex SQL code using complex Joins, Group By, Having, Sub Queries, Correlated Sub Queries, Functions, User Defined Functions.
• Involved in creating the constraints, rules, defaults, and triggers to maintain the data and referential integrity.
• Created database objects - tables, indexes, views, user defined functions, cursors, triggers and indexes.
• Extensively involved in knowledge transfer for the documentation team for the development activities carried out by team.
• Responsible for SSIS activities to move data from text files to SQL Server.
• Scheduled SSIS packages daily and weekly basis.
• Generated Daily, Weekly, and Monthly reports as per the customer requirements using subscriptions and created Tabular Reports, Cross Tab Reports, Sub Reports.
• Created drill down and drill through reports.
• Created AD-Hoc reports using report builder and maintained report manager for SSRS.
• Extensively involved with the development team in carrying out the Unit testing of the applications and tuning of complex procedures.
• Involved in Planning, Development, and Testing of disaster recovery strategies and procedures to restore the production environment to a production state.

Environment: SQL Server 2000/2005, windows XP/2000, Excel, SSIS, SSRS.