SUMMARY

• 8+ years of experience in IT as MS SQL Server 2008R 2/ 2008/2005/2000 Database Developer in Windows Environment.
• 6 years of extensive experience in T - SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
• Experienced in Design, Development, Testing, Implementation and Production, support SDLC of Data Warehouse, Client/Server, RDBMS and Web Based Application.
• Expertise in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Data Transform Services (DTS), Bulk Insert, BCP.
• Experience in building robust Architecture to organize Data flow from heterogeneous/homogeneous system using SQL Server Integration Services (SSIS) and Data Transform Services (DTS).
• Expertise in upgrading/migrating from DTS to SSIS packages, resolving complex issues and Error Handling in SSIS.
• Extensive knowledge in Tuning SQL queries and improving the query performance.
• Proficient in creating Index, Views, Complex Stored Procedures, appropriate functions, and effective experienced in implementation of strong referential integrity and auditing by the use of triggers and SQL Scripts.
• In-depth knowledge of Transact-SQL (DDL and DML).
• Experience in optimizing the database by creating various Clustered, Non-clustered indexes.
• Expert in creating Chart reports, Drill down and Drill through Reports by passing parameters in SQL Server Reporting Services (SSRS).
• Expert in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduled DTS and SSIS Packages.
• Good knowledge in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Experience in designing, creating, Processing of cubes using SSAS.
• Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Experience in creating reports using SSRS (SQL Server Reporting Services), Crystal Reports, SSAS (SQL Server Analytical Services) objects and OLAP including Interfaces with BIDS (Business Intelligence Development Studio).
• Experience in designing Database Models using MS Visio and ER-win.
• Knowledgeable in planning and implementing MS SQL Server Security and database Permissions.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS

RDBMS / Databases: MS SQL Server 2012, 2008/2005/2000 , Oracle 8i, MS-Access 97-2007

Languages: T-SQL, PL/SQL, .NET, Visual Basic 6.0, HTML, C, C++

Operating Systems: Windows Server 2003/XP/2000/NT/98/95, MS DOS 6.2

Modeling Tools: Microsoft Visio 2003, Erwin 3.x

Reporting Tools: Crystal Reports 8/10, SQL Server Reporting Services ( SSRS )

Integration Services: SQL Server Integration Services ( SSIS ),Data Transformation Services ( DTS )

Analysis Service: SQL Server Analysis Services (SSAS)

Database Tools: MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, OLTP, DBCC, BCP, OLAP, ADO.NET, Database Engine Tuning Advisor ( DTA )

Internet Tools: Internet Information Server ( IIS 5.0 / 6.0 ), FTP, TCP/IP

Other Tools: Microsoft Office 2003/2007

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

MS SQL Developer/BI/SSIS/SSRS/SSAS Developer

Responsibilities:

• Extensively worked with Business Users gathering their requirements and actively cataloging and supporting various issues and providing their solution.
• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds such as CLS (commercial Mtg Accounting System), MSAS ( Agricultural Mtg Accounting System), LMW (Loan Management Workstation), TEBOW (Internal Asset Transfers), SBO ( Residential Mtg Accounting System), CLINK, TANGO, MLHL using SSIS.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel Spreadsheet, Flat Files and OLEDB Sources.
• Performed Data cleansing by creating tables to eliminate the dirty data using SSIS.
• Involved in performing incremental loads while transferring the data OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Used various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Use ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.
• Created packages in SSIS with error handling
• Worked with different methods of logging in SSIS.
• Designed & Supported daily, weekly, monthly batch processes using Maestro job scheduler
• Responsible for creating database objects like table, views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized table, established joins and created Clustered, Non-Clustered indexes whenever necessary.
• Generated multiple GAAP and STAT 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.
• Created different Parameterized Reports which consist of report criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Created Subscription of reports in different formats like pdf, excel etc. to be executed automatically on daily, weekly and monthly basis.
• Deployed and configured the reports in the Report Server.
• Created Position and Transaction OLAP Cubes for mortgages Loans for various measure groups and dimensions (Loan Position, Loan, Commitment Schedule, Loan Journal Entry, Loan journal Entry Period Zero, Time Period, Loan, Account, Portfolio, Property, Business Unit, Borrower, Journal Entry Demographic, Journal Entry Line Item etc. ) to meet the business answers for the customers using SSAS
• Involved in identifying and creating Data Sources and Data Source Views (DSV) in SSAS.
• Involved in creating relationships and hierarchies between attributes and measure groups and defined granularity within the measure group and drill through action using SSAS.
• Designing and implementing dimensional data structure like star and snowflake schemas and virtual fact tables and constructing the dimensional hierarchies, calculated members and measures, actions and MDX using SSAS based on the OLAP reporting needs.
• Created calculated fields with MDX code to meet additional measure needs that are calculated from existing measures.
• Created and managed users, roles and groups and handled cube security.
• Designed and Developed efficient SSIS packages for processing fact and dimension tables with complex transformation as well as done with dynamic creation yearly partition and processing cube using SSIS package.
• Designed dynamic creation yearly partition and processing cube based on adjustment occur using SSIS package for improvement in performance while browsing the data from cube.
• Designed, developed, created and tested Excel Pivot Table / Power Pivot reports based on OLAP cubes and offline cube files for business analysts.
• Provided documentation about database /data warehouse structures and updated functional specification and technical design documents for cubes, reports and SSIS Packages.

Environment: MS SQL Server 2008R2/2008/2005, T- SQL, MS Excel 2010/2007/2003 , Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), SQL Server Business Intelligence Development Studio, Star Team Version Control tool) .

Confidential, New York, NY

SQL Developer/SSRS Developer/SSIS Developer

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of Water Fall SDLC model system.
• Perform all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and SQL Server T-SQL stored procedures within MS SQL Server 2005 and 2008 environments.
• Developed T-SQL Dynamic and Static Stored Procedures and Queries to develop Decision Engine.
• Developed User Defined Functions for giving Scores and views for the application.
• Created SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Developed, monitored and deployed SSIS packages.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server. Created Stored Procedures for that.
• Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers opened account details and profits using SSRS.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Recognized the fact and dimension tables in the OLAP database and created cubes using MS SQL Server Analysis Services (SSAS).
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SSAS.
• Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future reference.

Environment: MS SQL Server 2008/2005, T- SQL, MS Excel 2007/2003, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS), SQL Server Business Intelligence Development Studio, Team Foundation Server (TFS), Visual source safe (VSS).

Confidential, Agoura Hills, CA

SQL Developer/SSIS Developer/SSRS Developer

Responsibilities:

• Actively Participated in weekly team meeting with business analyst and project team to discuss projects, issues and best practices.
• Efficiently used Microsoft SQL server 2008/2005, SQL server management studio and Business Intelligent Development Studio.
• Responsible for the design of the SSIS package to load data into the data mart from OLTP database using ETL tools.
• Created SSIS packages to Extract/Transform/Load multiple sources data such as AS400LS, Oracle and DB2 to staging and staging to data mart by reducing level of effort in generating routine reports.
• Used BRD’s documents which include the Business requirements for Base Population as well as give the details of calculated and non calculated fields to support the project and allow for efficient use of resources for creation of Data Marts and other core activities.
• Used multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, Lookup, Multicast, Derived Column, union all, Source, Excel Source, Flat File Source, OLEDB Destination, Flat file destination.
• To achieve business requirements, used For-Each Loop Container, Sequence Container, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task.
• Use Data Viewers in SSIS Packages to see whether the data flow properly or not.
• Provided Dynamic Configuration, Custom Package Logging, and Error Handling to SSIS template package.
• Created deployment utility to deploy SSIS Packages.
• Created various database objects including Tables, User Defined Functions, Procedures, Packages, Triggers, Indexes and Views based on user requirements.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Developed SQL Queries to fetch complex data from different tables in remote databases using Inner/Outer joins, sub-queries, accommodating complex filters and database links.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Tuned SQL queries using Show Plans and Execution Plans for better performance.
• Build the T-SQL scripts based on SQL Server Coding Standard, rules and templates based on business requirement.
• Provide fields mapping document, refreshed table/packages data load to UAT after delivery up on the completed data mart.
• Developed and maintained enterprise reporting (SSRS Reporting Service) based on specifications and business needs and modified existing reports as needed.
• Enhanced the old Excel Reports to new SQL Server Reports fit new business requirement, and implemented into SQL Server 2008.
• Use temporary table to reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Created complex stored procedures to generate reports using SSRS
• Designed Reports in SSRS, using Shared data source and specified data source.
• Identified and defined the Datasets for the report generation.
• Defined the report layouts and formatted the reports using the Global Variables and Expressions.
• Developed several detail and summary reports including Parameterized report, Sub-reports, Drill-down reports, Matrix or Crosstab reports according to business requirements using SSRS.

Environment: MS SQL Server 2008/2005, T- SQL, MS Excel 2007/2003, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), SQL Server Business Intelligence Development Studio.

Confidential, Columbus, OH

SQL Developer/SSRS Developer/SSIS Developer

Responsibilities:

• Actively participated in gathering business requirements and system specification from business users and business analyst.
• Efficiently used Microsoft SQL server 2008/2005, SQL server management studio and BIDS. And participated in designing a data warehouse to store all the information from OLTP to Staging and Staging to Enterprise data warehouse at the center to do better analysis.
• Actively participated in designing the SSIS Package Model for initial load and incremental load for extracting, transforming, and loading data from various RDBMS and Non-RDBMS systems.
• Designed configurations, logging/auditing, package error handling, data error logging and checkpoint in SSIS Package model.
• Used SSIS Package Model to load master data from CSV, XLS/XLSX and pipe delimiter files.
• Created SSIS Packages to load data from transactional system DB2 (SYSTEM21), SQL Server 2005/2000(Gateway System, D2L) to staging (ODS) and staging to Enterprise Data-warehouse.
• Parameterized Control flow and Data Flow using variables and expressions in SSIS Package to achieve business needs and business requirement.
• Used OLEDB Source, Excel Source, Flat File Source, ADO. NET Source, Pivot, Un-pivot, Look-up, Conditional Spit, Merge Join, Multicast, Union All, Derived Column, Data Conversion, OLEDB Destination, Flat file destination in data flow.
• Used For Loop, For Each Loop, Sequence Container, Execute SQL Task, Send Mail Task, Package Events, Precedence Constraint to achieve business requirement.
• Created deployment utility to deploy SSIS packages over Production, QA and Local System.
• Created ad-hoc packages and used Import/Export utility to load data from QA to Dev Server, Dev to QA Server and Prod to QA for proper packages testing and data validation.
• Used complex T-SQL queries for data extraction. Applied various business logic to scrub/clean/validate/convert/allocate the data using string manipulations, analytical functions, cast functions, CTE, user defined functions, stored procedures and ad-hoc queries.
• Defined parent and child relationship by using common table expression for certain Dimension Load.
• Design SSIS package to load data in to DW along with dimensions & facts with the use of slowly changing dimension and maintain the historical data too.
• Created/edited sales job module in SQL Agent in development and participated in production deployment.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs using other tools such as event handler, Logging information etc.
• Use Analysis service processing task to process the analysis cube in SSAS after DW run.
• Designed the usage summary, performance, AUDIT/LOG, Job Status and detailed reports for ETL users in SSRS.
• Created parameterized, drill-down and drill-through for sales module for business users in SSRS 2008.
• Created Chart and Gauge reports for weekly, monthly, quarterly and yearly sales for DSS system. Ran unit test on SSIS Package and Data validation to check business needs.
• Identified and defined the Datasets for the report generation.
• Managed various reports through Report Manager.
• Created Report Model project, specially designed for end business users so that they can create new and modify the existing ad-hoc reports using Report Builder.
• Created release notes/documents for Mapping, Staging Packages, EDW Packages and EXT Packages, and Deployment Procedure.

Environment: MS SQL Server 2008, Windows server 2003, ER-Win, MS Excel 2007/2003, SQL Server Business Intelligent Development Studio, Team Server 2008.

Confidential, Calabasas, CA

SSIS Developer/SSRS Developer

Responsibilities:

• Interact with Development Teams and Managers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• Actively participated in gathering Business Requirements and System Specification. Participated in implementing the logical design to the physical design by creating tables.
• Analyzed the existing data and performed the appropriate changes from SQL Server 2005 to SQL Server 2008 by following the Normalization standards to maintain data consistency and by performing data validation.
• Designed SSIS packages to load the data from SQL Server 2000/2005 to the ETL tier.
• Transferred Flat files from different sources to the ETL tier by using BCP and SSIS Packages.
• Created SSIS Packages by using advance tools (i.e. pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate).
• Involved in writing scripts to check for duplicate records, delete/modify them depending on the business rule.
• Tested, Cleaned and Standardized Data to meet the business standards using Fuzzy /exact lookups and String manipulations.
• Enforced the Business Rules to filtered bad data from system by using Complex T-SQL Statement, and implemented various Constraints and Triggers for Data Consistency.
• Created and scheduled Microsoft SQL Integration Services (SSIS) packages which monitors the jobs and sends the notification when the job fails.
• Designed SSAS cube based on DW data. Designed different hierarchy on time and geography dimension. Used parent child hierarchy on GL (general ledger) dimension.
• Standardized company reports by implementing SQL Server Reporting Services.
• Created different type of reports including: A Cross-tab, Conditional, Sub report, Drill-down and Parameter prompts, Linked reports and deployed and scheduled Reports in Report Manager using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Generated the various kinds of reports using Graphs and Images
• Develop Functional/Technical specifications for SQL Server Reporting Services reports.
• Monitoring performance and optimizing SQL queries for maximum efficiency.
• Defined the sequence for the tables involved in import based on foreign key constraints.
• Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.

Environment: Microsoft Windows Server 2003 Enterprise Edition, Microsoft SQL Server 2008/2005, Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Integration Services (SSIS), XML, SQL Server Business Intelligence Development Studio.