SUMMARY

• Over 8 years of extensive experience in database development and IT Solutions that include experience in design, development and implementation of complex data delivery systems using MS SQL Server 2012, MS SQL Server 2008R2, MS SQL Server 2008, MS SQL Server 2005 in production, Test, Development and Cluster Server Environments.
• Hands - on experience with Erwin, MS Visio modeling tools and strong knowledge of Relational Database modeling and Dimensional modeling concepts.
• Worked on Normalization and De-Normalization techniques for both OLTP and OLAP systems.
• Analyze business and technical requirements data warehouse data models (SSIS, SSAS, SSRS), to understand the detailed data management requirements.
• Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL).
• Experience in T-SQL programming skills like creating Stored Procedures, Functions, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, and Cursors.
• Experience in implementing CTE, anchor Recursive CTE and temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Strong experience with SSIS ETL tool in Mapping, Transformations, Expressions, lookups and Aggregations.
• Migrating data from oracle to SQL server using PL/SQL queries.
• Excellent in High Level Design of ETL DTS Packages & SSIS (DTSX) Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and union all.
• Experience in creating Jobs, Alerts, SQL Server Agent, and scheduled SSIS Packages.
• Designed and created cubes in SSAS. Created sophisticated calculated members using MDX queries; designed and created aggregations to speed up queries and improve performance in SSAS.
• Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
• Proficient in developing multi-dimensional cubes, Dimensions, Facts using SSAS, SSAS - Data Mining Models, Deploying and Processing SSAS objects.
• Skillful in Creating, Managing, Delivering SQL Server Reports using SSRS 2005/2008/2012
• Experience in Migration of SSRS reports from SQL 2008 to SQL 2012.
• Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS 2005/2008/2012
• Experience in developing Custom Report and different types of Chat Reports, Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server 2005/2008/2012 Reporting Services (SSRS).
• Versatile in BIDS (Business Intelligence Development Studio), Query Analyzer, Profiler, SQL Server Management Studio, SQL Server Integration/Analysis/ Reporting Services etc.
• Good knowledge on C, C++, C #, ASP.net, VB.net, IIS, HTML, VBScript, JavaScript, XML.
• Hands on experience in SDLC (Software Development Life Cycle) like gathering requirements, design, development, implementation and testing of projects before moving to production.
• As a key player in the team with strong interpersonal and communication skills, explored and contributed the technical expertise as and when needed by the team.

TECHNICAL SKILLS

SQL Server Database Tools: Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Analysis Services, OLAP (Online Analytical Processing)-Cubes, Storage, Data Mining Models, Visual Source Safe, BCP, Enterprise Manager, Profiler and Data Transformation Services.

RDBMS: MS SQL Server 2008R 2/2008/2005/2000/7.0 , Oracle 11g/10g/9i/8i, MS Access, DB2, Teradata V2R6/V2R5

Languages: MDX/DMX, VB.NET, VB Script, Transact-SQL, PL/SQL, HTML, DHTML, XML, ASP, C and C++.

ETL Tools: SQL Server Integration Services (SSIS), DTS

Reporting Packages: SQL Server Reporting Services (SSRS), Import Export Data, Bulk Insert, Business Objects 6.5/XI/XIR2, Crystal reports, MS Excel.

Data Modeling Configuration Tools: ERwin, MS Visio

Methodologies: RUP (Rational Unified Process), Agile, SCRUM, Waterfall

Testing Tools: Quick Test Pro, Mercury Quality Center, TOAD (Tool for Application Developers).

Operating Systems: Windows Server 2000, 2003, 2008 & 2008R2. Unix, MS Windows (95,98, NT,2000, XP)

PROFESSIONAL EXPERIENCE

Confidential, Winston, Salem, NC

SQL BI Developer (Consultant)

Responsibilities:

• Customized and optimized existing PL/SQL packages, procedures and functions to accommodate change in functionality and better performance.
• Developed PL/SQL Packages, Stored Procedures, and Functions in TOAD and SQL Developer.
• Used Toad and SQL developer extensively to create procedures for the Oracle forms 11g.
• Carried out Form Personalization in 11g for both conventional Forms and Self-Service Pages.
• Designed and developed front end applications using Oracle forms 11g.
• Developed Procedures, Record groups, LOV's, and Triggers for Oracle forms 11g.
• Maintained several customized reports using Oracle Reports 11g.
• Used WEBLOGIC Server for Oracle Forms and Reports 11g.
• Worked on Korn shell scripts on UNIX platform.
• Involved in developing and scheduling jobs to load the data into the database and export/import mechanism for data migration for bulk upload.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• As Report Writer, Created reports by generating data models and also generated Ad hoc reports.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Utilized ETL functions; for importing datainstagingserver, prepare datato load; Loaded into SQL Server/Oracle from Excel, CSV, TXT and Access files.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using Multidimensional Expression MDX & DAX.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Created Family of stars using dimensional modeling concepts of Degenerated dimension, Fact less fact table, Aggregate fact tables in multi-dimensional model.
• Used TKPROF and Explain Plan utilities to analyze the performance of the PL/SQL Stored Procedures and Packages.
• Used BULK COLLECT approach for pulling records faster.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Modified several program structures to introduce Performance Tuning techniques like Global Temporary Tables, Bulk Processing and Parallel Execution Methods to improve the performance.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Table space.
• Developed data conversion procedures in PL/SQL. Involved in maintaining batch processing PL/SQL procedures for data extraction for feed creation.
• Involve in the continuous enhancements and fixing of production problems.
• Actively involved in day-to-day support activities by troubleshooting, providing solutions and communicating with the users through CA tickets.

Environment: SQL Server 2014, Informatica, Oracle 10G, Unix, TOAD, SQL Developer, SQL Plus, SQL*Loader, Korn Shell Scripting, PUTTY, Core FTP

Confidential, Texas

Sr. SQL BI Developer (Consultant)

Responsibilities:

• Responsible for the design and development of the A. I. Credit Corp. ( Confidential ) Leasing System
• Analyze, design, develop, implement and maintain different processes/jobs by using Pervasive Data Integrator and SSIS.
• Assist with implementation of new business, products or contracts by the analysis of business requirements.
• Apply in-depth knowledge of systems and business to the development of technical design for large complex processes and projects.
• Prepared complex analyses with respect to several complex Logistic activities, equipment Leasing
• Responsible for the design and development of the A. I. Credit Corp. ( Confidential ) Leasing System (Sybase, PowerBuilder) The purpose of the system is to create and monitor requisitions and purchase orders, and track equipment allotted for lease.
• Designed, engineered and implemented a SQL Server database for a Mortgage Banking and Consumer Loan application.
• Developed an application that allowed external data sources to post Loan application data in real time over the internet into our system.
• Creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
• Troubleshooted test scripts, SQL queries, ETL jobs,datawarehouse/datamart/datastore models.
• Created the test environment forStagingarea, loading theStagingarea withdatafrom multiple sources.
• Maintain detailed documentation and process flows of all data integration and EDI processes. Created new and existing processes are appropriately documented, including both technical and user documentation.
• Create and Modify Processes and maps, According to the business. Performing the ETL operations to support the data loads and transformations for EDI Processes.
• Create Datasets, Maps, also and Process using Pervasive Data Integrator. Handled pipe delimited files, fixed format files in pervasive data integrator.
• Proficient in usage of SSIS Control Flow items (For Loop, execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files and loading into SQL server.
• Created Data Flows for Aggregate, sort, lookup, merge, union all and fuzzy lookups and Used containers for repetitive control flow tasks.
• Worked with production support team for a while to handle high priority issues.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Monitoring of processes to automate the process of loading data into data targets and assist the team to schedule daily/weekly/monthly jobs.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Configured Reporting Services in SQL Server 2008R2.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Created different Power Pivot reports as per the client requirement.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Experience working in formal life cycle methodologies i.e., agile.
• Capable of functioning in an agile development environment, at times extracting data to enable discovery to help refine report specifications.
• Effectively used TFS to update user stories and tasks to show the performance.

Environment: Microsoft SQL Server 2012/2008 R2, Actian Pervasive Data Integrator (V.10), Visual Studio Team Foundation Server (TFS) 2013, Microsoft Data tools, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Windows Server 2008R2.

Confidential, Rochester, NY

SQL Server/SSIS/SSRS/SSAS Developer (Consultant)

Responsibilities:

• Worked with various business groups while developing their applications, assisting in Database design, creating E-R diagrams.
• Worked with installing, designing and managing MS SQL Server 2012.
• Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Administered MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Created SSIS packages to populate data from various data sources like oracle using PL/SQL queries.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Designed Scorecards and Dash board reports using Micro Strategy, Performance Point.
• Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.
• Developed Tabular Reports, ad-hoc reports using SSRS Report Designer.
• Designed and developed various custom defined reports using SQL Server Reporting Services (SSRS) and deployed them on SharePoint 2007 Portal.
• Hands-on report writing scripts altering the colors and backgrounds needed.
• Ran DBCC consistency checks and fixing data corruption in application databases
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.
• Migrated SSIS Packages from SQL Server 2008 to SQL Server 2012.
• Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Created custom SQL Server Reporting Services (SSRS) Reports to be displayed in a Microsoft SharePoint 2010 web application.
• Skilled in Developing SSAS Cubes, Dimensions, Facts and data source view in SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Using MDX created calculated members for customized calculated measures.
• Used Open Query from SQL Server and Analysis Server to combine data from the cube and Data Warehouse.
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS).
• Used BCP command and T-SQL command to bulk copy the data from Text files to SQL Server and vice versa.
• Work with project teams for upgrading SQL Server 2008 to SQL Server 2012.
• Involved in fine Tuning, Performance and Query optimization of the Database as required by the application
• Conducted data import and export operations using the DTS wizard.
• Database and Transaction log backups & restoration, backing up user databases and restoring them whenever necessary.

Environment: MS SQL Server 2012/2008R2/2008/2005, SQL Server Reporting Services (SSRS 2012/2008 R2/ 2008/2005), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), OLAP, XSLT, XML, VB.Net, ASP.Net, MDX, DTS, MS Visio, ERwin

Confidential, Omaha, NE

SQL Server BI Developer (Consultant)

Responsibilities:

• Designed and developed Database Objects Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle).
• Created Data Flows for Aggregate, sort, lookup, merge, union all and fuzzy lookups and Used containers for repetitive control flow tasks.
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS and Scheduled package execution in SSIS and Installing packages on multiple servers in SSIS
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load. Created extensive reports using SSRS (Tabular, Matrix)
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources and load into various Business Entities.
• Created the DTS, SSIS packages to import the data from different data source like MS Access/Excel/ Oracle/Sybase/My SQL server to SQL Servers.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle)
• Created Data Flows for Aggregate, sort, lookup, merge, union all and fuzzy lookups and Used containers for repetitive control flow tasks.
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS.
• Proficient in Installing SQL Server 2000/2005/2008 and 2008R2 configuration of their tools.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.
• Created Views and table for specific columns on a table to maintain privacy of a customer data. Created Indexes to get the high level performance.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Responsible for gathering Business Requirements and System Specification from users.
• Created Various Sparkline reports, Chart and Map reports using SQL Reporting Services. Created various Tabular and Matrix Reports using SSRS. Created various drill down reports using SSRS. Involved in the post deployment maintenance of reports.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Designed SSIS packages for synchronizing the data between two different servers.
• Expert in Creating and scheduling SSIS and SQL server jobs for various tasks.

Environment: Microsoft SQL Server 2012, Microsoft SQL Server 2008 (R2), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Business Intelligence Development Studio (BIDS), Report Builder, T-SQL, Oracle 11g/10g, MS Excel.

Confidential

SQL Server BI Developer (Consultant)

Responsibilities:

• Designed Database Objects like Tables, Stored Procedures, Triggers, user defined functions and as per the project requirement.
• Created Cluster and Non- Cluster Indexes for table and database to get the high level performance.
• Modified the database by removing unwanted columns and also adding proper constraints, rules and defaults to tables.
• Implemented Constraints (Primary Key, Foreign Keys Check and Not Null/Null) and fine tune Indexes on Tables.
• Create and Modify Stored Procedures, According to the business. Fine Tuning of Stored Procedures and SQL Queries. Worked with Control Flow tasks, Data flow tasks and Data flow transformations using SSIS 2005.
• Developed various reports to validate the data between source and the target systems. Involved in providing security to the reports by restricting various users through Roles.
• Experience in writing and debugging Stored Procedures and triggers. Designed, Developed and managed the reports using Reporting Services.
• Expert in creating the MDX cubes and dimensions (SSAS).
• Experience with ad-hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• Extensive use of DTS in SQL Server, Performance Tuning & Application Design, Backups, Disaster Recovery Planning, Security Management, Managing server and clients, T-SQL, Stored Procedures, Functions and Cursors and Triggers etc.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Responsible for gathering Business Requirements and System Specification from users.
• Designed numerous ad-hoc, crystal reports and custom reports using SQL Reporting Services.
• Extensive experience in data migration between homogenous and heterogeneous system using various tools (Data Transformation Services (DTS), SSIS, BCP, Bulk Insert, ActiveX).
• Implemented logical design into Physical design. Involved in the normalization of databases in the OLAP.

Environment: Microsoft SQL Server 2008(R2), SQL Server Reporting Services (SSRS), Management studio, SQL Server Business Intelligence Development Studio(BIDS), T-SQL, Oracle 10g, MS Excel.

Confidential

SQL Server BI Developer (Consultant)

Responsibilities:

• Installed SQL Server 2005 on development and production servers setting up databases, users, roles and permissions.
• Upgraded all SQL Server 2000 to SQL Server 2005 without any service interruption.
• Involved in the all the stages of Software Development Life Cycle (SDLC).
• Involved in the normalization and de-normalization of the databases.
• Created and Modified tables, views, triggers, Indexes, User Defined Functions, Stored Procedures, cursors in SQL Server 2005.
• Wrote the complex queries using Joins, Sub-queries, common table expressions (CTE) in T-SQL-2005.
• Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor.
• Created SSIS packages to transfer data from different data sources load it to data warehouse.
• Configured SSRS 2008 with MOSS 2007 for directly deploying the report in SharePoint 2007.
• Used SSIS features like event handlers, property expressions, and package configurations, transaction option, checkpoints and protection levels in the packages.
• Used MDX expressions to define calculated members in cubes to calculate values at run time.
• Created copies of operational Databases using the Import/Export Wizard
• Migrated DTS packages to SSIS packages using package migration wizard.
• Used containers, Execute SQL task, Execute package task, Script task etc. for transformation of data in the SQL Server Integration Services packages from OLTP to OLAP.
• Created efficient SSIS packages for processing fact and dimension tables with complex transformations.
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS). Created jobs and scheduled jobs using SQL Server Agent.
• Developed parameterized reports through Reporting Services (SSRS) from a variety of data sources including Analysis Services Cubes and prepare for Web publishing.
• Responsible for monitoring the progress of a SSIS packages and logging progress to a text file, SQL Tables and windows event log.
• Created cubes for Dimension and fact tables for future and current reporting using SQL server Analysis Services (SSAS).
• Analyze historical trends, identify issues and analyze root cause on ProClarity Dashboard.
• Created business critical key performance indicators (KPIs) using SQL Server Analysis Services.
• Wrote MDX queries according to the business requirements.
• Designed and crated distributed reports in multiple formats such as Excel, PDF, XML, HTML and CVS using SQL Server 2005 Reporting Services (SSRS).
• Developed drill down and drill through reports from multi-dimensional objects like star schema and snow flake schema using SSRS and performance point server.
• Designed and Implemented Comprehensive Backup plans and disaster recovery strategies.

Environment: Microsoft SQL Server 2005, Microsoft SQL Server 2008(R2), SQL Server Reporting Services (SSRS), Management studio, SQL Server Analysis Services 2005, SQL Server Integration Services (SSIS), SQL Server Business Intelligence Development Studio(BIDS), T-SQL, Oracle 9i, Erwin 7.3, MS Excel, MS Access, ASP.Net, Oracle, Teradata

Confidential

SQL Server BI Developer

Responsibilities:

• As a Database Developer responsible for new functionality and support for Banking Product Data Warehouse (BPDW) from different banking source system to provide a timely and adequate understanding of the Banking Product business. BPDW data warehouse was initially designed as a platform that combines all Banking Products to hold current and historical data for Resource Managed accounts, associated Credit/Debit Cards details, money in/out flows into accounts, including Mortgage and Loan data from Data Warehouses.
• Installation of SQL Server on Development and Production Servers, setting up databases, users, roles and permissions.
• Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Created Indexes to get the high level performance. Developed Cubes using SQL Analysis Services (SSAS).
• Modified the database by removing unwanted columns and also adding proper constraints, rules and defaults to tables.
• Performing the ETL operations to support the data loads and transformations using SSIS.
• Designed ETL strategy to transferdatafrom source to landing,staging and destination in thedatawarehouse using SSIS and DTS (DataTransformation Service).
• Deployment of SSAS Cubes to the production server.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• SSAS storage and partitions, and Aggregations, Data Mining Models, developing reports using SQL.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS - Data Mining Models and Deploying and Processing SSAS objects.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Implemented automated backup and database maintenance / cleanup jobs.
• Managing Logins, Users, Roles and User permissions.
• Running Trace from the Profiler to trouble shoot database and running DBCC consistency checks for other database maintenance aspects.
• Designed numerous ad-hoc, crystal reports and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.

Environment: Microsoft SQL Server 2005, Microsoft SQL Server 2008(R2), SQL Server Reporting Services (SSRS), Management studio, SQL Server Analysis Services 2005, SQL Server Integration Services (SSIS), SQL Server Business Intelligence Development Studio (BIDS), T-SQL, Oracle 9i/8i, MS Excel.