SUMMARY

• (8+) years of IT experience in Database Administration, System Analysis, Design, Development and Support of MS SQL Server 2012,2008,2005 in Production, UAT, Development, Replication & Cluster Server Environments in Windows Environment.
• Experience in SQL Server Suite of products (SSRS/SSIS/SSAS) and involved in all phases of Software Development Life Cycle from gathering requirement, development, implementation, testing and support.
• Over 8 years of IT experience in the Data analysis, ETL Development and Data Modeling experience.
• Around 6+ years of experience in Data Warehousing, Enterprise Data Warehousing(EDW) - star schema, snow flake schema, Data Modeling and relational database experience including MS SQL Server, MS Access and Oracle.
• Proficient in creating ETL packages using SQL Server 2008/2005 Integration Services (SSIS).
• Experience in High Level Design of ETL Packages for integrating data using OLE DB connection from heterogeneous sources by using multiple transformations.
• Experience in incremental data migration from various data sources (Flat Files, Excel, MS Access, oracle) using ETL.
• Proficient in developing and deciding the data conversion strategies
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Expertise in using Transformations like Aggregate, Lookup, Merge Join, SCD, Fuzzy Lookup etc.
• Worked on SSIS configurations - XML, SQL, windows variables etc.
• Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creatingDatabase Objectslike tables, Constraints (Primary key, Foreign Key, Unique, Default), Indexes.
• Proficient in design and development of enterprise reports using SQL Server Reporting Services (SSRS)
• Specialized in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports, Charts using SQL Server Reporting Services.
• Generated Report Models using Model Designer, to enable the business users to build ad-hoc reports using Report Builder(2.0,3.0).
• Extensive Knowledge in email subscriptions for data driven reports by using Report Manager.
• Created SSAS cubes with multiple Fact tables and Cube calculations and cube localization, KPI’s, Cube partitions.
• SSAS Cube security using NT authentication, created cube roles and membership.
• Good understanding of master data management(MDM),Operational data source(ODS) and also concepts behind development, build and support of EDW(Enterprise Datawarehouse).
• Expertise in designing/creating several reporting services reports that have been formatted specifically for dashboard displays, i.e. with charts, KPIS, tables, etc
• Expertise in creating dimensional models (data warehouse, data marts, dimension and fact tables ).
• Expert in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Experience in creating indexed views, Complex Queries, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Extensive experience working in both Agile development environmentand scrum methodologies.
• Experience in T-SQL and Tuning T-SQL queries and improving the performance of the Database.
• Expertise in Transact-SQL (DDL, DML, DCL)and in Design and Normalization of the database tables.
• Expertise in using tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Performed operations like Datareconciliation(using Script Task, SSIS control flow and data flow tasks), validation and error handling after Extracting data into SQL Server.
• Have hands on experience in Performance Tuning and Query Optimization using tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Proficient in creating SQL jobs, batch scripts, SQL Proxy accounts, also using BMC, BTEQ NT security and knowledge in working with Linked Servers.
• Dealt with huge amount of data with data ranging up to TB and millions of rows.
• Experience working with a complex, large Enterprise data, distributed multi-database environments.
• Worked on scripts using Fast-Load, Multi- Load to load data in the Teradata data warehouse
• Experience working with FLOAD, MLOAD, FEXP of Teradata.
• Experience in working with table partitions on very large tables and data archival process.
• Experience in Requirement Gathering and Documentation.

TECHNICAL SKILLS

RDBMS: SQL Server 2012/20, 7.0, MS-Access, Oracle Database 11g/10g/9i, DB2, My Sql, and Teradata V2RX.

SQL Tools: SQL Server Management Studio, DTS, SSIS, SSRS/QNXT, SSAS, SQL Server Business Intelligent studio (BIDS), DTS, Enterprise Manager, Erwin, SSMA,SQL Profiler, Index Tuning Wizard, Query Analyzer, Visual Studio .NET

Languages: MS Visual Basics 6.0 T-SQL, Oracle PL/SQL, MDX, C, ASP.net, Excel VBA, VB.net, C# (.NET), Unix Scripting.

Web Technologies: HTML, XML, JavaScript, PHP, ShellScripting.

Version Controlling Tools: Visual Source Safe, Clear Case, TFS(Team foundation server)

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Business Intelligence Development Studio, SSIS, SSAS, SSRS, Data Transformation Services(DTS), EDI.

Web Server Technologies: IIS 5.1/6.0.

Data Modeling Tool: ERwin r7.3/7x/4.0, MS Office Visio 2003/2007

Operating System: Windows 2000, Windows Server 2003, Windows NT, Windows 95/98/2000 XP/Vista/7, Unix.

Methodologies: Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization.

PROFESSIONAL EXPERIENCE

Confidential, Hickory, NC

Sr. SQL Server BI Developer

Responsibilities:

• Involved in requirement gathering and involved in Data warehouse schema design (star schema and snowflake schema for multiple projects).
• In depthexperienceof working with large data sets and ETL Data Conversion
• Layout design plan for ETL process to populate dimensions and fact tables.
• Good experience in Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin(9.5,9.2).
• Experience in database modeling and development of Entity Relationship Diagrams (ERD).
• Assisting in the decision making and development of the data conversion strategies for different projects.
• Managed the project in breaking down the existing EDW(Enterprise Datawarehouse) to manageable data marts.
• Used SSIS 2008 created various packages to bring data into the staging area from various sources like text files, Excel and SQL Server databases.
• Extensively used VB, C# coding in SSIS script task.
• Deploy and maintain SSIS packages both by using SQL and File system deployment.
• Contribute, and write technical, functional requirements as a part of SRS(software requirement specifications).
• Developed ETL process using SQL server integration services (SSIS) with data from various sources.
• Created SSIS packages using Conditional Split, Data Conversion, Fuzzy Logic and C#.
• SSIS configurations using XML, SQL run tables and various dynamic expressions.
• SSIS logging using both traditional SSIS logging via tool as well as use the system variables to take log
• Developed SSAS Cubes and build KPI’s, create translations, cube calculations, cube partitions in SSAS cubes and cube localization concepts.
• Created hierarchies and pseudo relations in SSAS cubes, Fact less fact table concept, utilize various property parameters in SSAS
• Concepts of show and hide cube members and ignore unrelated dimensions when more than one fact table exists.
• Write extensive MDX code to generate SSRS reports out of cube.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Experience with the Share point 2007/2010 to upload the SSRS reports to Web portal.
• Developed complex stored procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Involved in performing data conversions from flat files into a normalized database structure.
• Create Dashboards using cube data to display various metrics like OEE, FPY via PerformancePoint.
• Worked on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with VB.NET in SSIS.
• User access and permissions at various report levels and reports subscription, SharePoint user access.
• Automate and schedule daily, weekly and monthly SSIS, SQL jobs using SQL server job agent.
• Train users on how to use SSAS cubes using pivot table and reporting training of drill down reports.
• Debugging reports performance (SSRS) using error log and provide recommendations upon identifying the issues.
• Follow standard naming conventions in SSIS packages and best practices in creating cubes using SSAS.
• Proper change documentation for stored procedures and design documents etc.
• Deployed the generated various reports using SSRS, data driven report subscription.
• Involve in entire cycle of BI process right from requirement gathering, design stage, ETL (SSIS), Building cubes, Reporting (SSRS).
• Involved in creating documentation for requirements towards replication of production database which would be stating for data warehouse.

Environment: Microsoft SQL Server 2012/2008/2005, SSIS, SSRS, MS Access, Tableau, MS IIS, VB.net, C#, SQL source Control, Agile, SharePoint, Performance Point, Power Pivot.

Confidential, Chicago, IL

SQL BI Developer

Responsibilities:

• Documented and delivered functional specification document to the project team. Assisted the Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the insurance data from various source systems feeds using SSIS.
• Worked on migrating daily shipment data from Oracle database (Enterprise Data Warehouse) to Teradata database (Operational Data Source).
• Experience with web forms inASP.NET 2.0&C# .NETusing .NET Framework 2.0
• Implemented SQL Server SSIS packages for ETL methodologies
• Installed, configured and maintained SQL Server Integration Services (SSIS).
• Created packages using Integration Services (SSIS) for data extraction from Flat Files, Excel Files OLEDB, Access etc
• Experience with the Share point 2007 to upload the SSIS packages in to Web portal.
• Used ERwin for data modeling.
• Developed reports using Cognos and experience working with report studio, query studio and framework manager.
• Developed custom selection of reports ordering using SQL Server Reporting Services(SSRS).
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Deployed reports in to Report Manager.
• Created Ad-Hoc reports using Report Builder.
• Create dashboards, scorecards, drill down, sub reports, cross tab and other complex reports and publish using SharePoint.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Implemented SQL Server OLAP services (SSAS) for building the data cubes.
• Create prototype SQL Server 2005 Analysis Services (SSAS) cubes using the Unified Dimensional Model (UDM).
• Import the data from tables from Teradata database using SSIS.
• Worked on Analysis services (SSAS 2005) to create multidimensional cubes to slice and dice the data.
• Created the star schema for OLAPreporting data archiving and data marts
• Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Responsible for database design, including optimizing the database schema and coding database procedures/queries.

Environment: Microsoft SQL Server 2008/2005,SSIS, SSRS, SSAS, Agile, Linux, Redgate Tools, Teradata, Cognos, ERWIN,VB.net, C#,TFS,MS IIS, SQL source Control, Oracle 10g/11g, SharePoint.

Confidential, Gurnee, IL

Sr. BI Developer

Responsibilities:

• Involved in requirement gathering by directly interacting with clients.
• Designed logical and physical Database structure for analysis of data.
• Used SSIS 2008 to develop several packages to import data from different types of sources, and staged the data to apply several transformations before loading the data into the database.
• Used several transformations like Data Conversion, Lookup, Merge, Conditional split on data for manipulation using SSIS. Also widely used tasks like Execute SQL task, Execute Process Task etc.
• Deploy and maintain SSIS packages both by using SQL and File system deployment
• Experience with the Share point 2007 to upload the SSRS reports to Web portal.
• Performed data cleansing in the database by using transformations like Fuzzy Lookup in SSIS.
• Extensively generated and deployed parameterized reports, Drill-down reports, sub reports, dashboards using SSRS
• Created automated jobs using SQL server agent and scheduled subscriptions for reports on server to the targeted users daily, weekly, monthly.
• Imported data and re developed reports from access database into SQL server db.
• Granted user access and permissions to various roles at different report levels.
• Extensively wrote complex SQL code to generate several reports for the sales, marketing and business office departments.
• Participated in design reviews, performance tuning and documentation.
• Re-designed and developed back-end SQL Server database, wrote queries, and stored procedures.
• Involved in phases of BI process -requirement gathering, design stage, ETL (SSIS), Reporting (SSRS).

Environment: Microsoft SQL Server 2008/2005, SSIS, SSRS, TFS, SQL source Control, Power Pivot SharePoint,EPICOR Prophet 21.

Confidential, Hartford, CT

ETL/ BI Developer

Responsibilities:

• Involved in installation and configuration of SQL Server 2005 and SQL Server 2008 with latest Service Packs
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data loads and transformations.
• Created various database objects such as tables, indexes and views based on the requirements.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Developed the packages with monitoring features and logging so that information of the packages and their execution results are loaded into the designed error table.
• Experience in integration of various data sources like SQL Server, Oracle, DB2 UDB and Flat Files.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries, Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
• Created and worked with drill down reports and identified the report parameters.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules And integrated reports in MOSS 2007 using web parts
• Involved in setting up Performance Point Server and creating dashboards and scorecards in the PPS.

Environment: SQL Server 2008/2005, SSIS, SSRS,SSAS, Query Analyzer, Index Tuning Wizard-SQL MS Access, MS Excel, Cognos, ERWIN, T-SQL, PL/SQL, MDX, DB2, VS2008/2005, XML, HTML

Confidential, Minneapolis, MN

Sr.SQL Server Developer

Responsibilities:

• Gather and define reporting requirements, document reporting specifications and complete analysis and design on new reports.
• Knowledge of capital markets including fixed income, OTC derivatives, MBS(Mortgage Bank Securities).
• Extensive knowledge of GAAP, financial accounting, investment banking, fixed income products and financial statements.
• Generated finance data marts with the data from wealth management domain, very good understanding of wealth management domain to write ETL using SSIS.
• Design data marts for general ledger(GL) and account ledger, account payable(AP) and other finance domain with data from ERP (oracle and end Database).
• Analyze, design, develop and document reports using Microsoft SQL Server 2008 and SSRS against proprietary and packaged application databases
• Create operational reports, parameterized, dashboards, drill down, sub reports, cross tab and other complex reports and publish using SharePoint.
• Write complex SQL queries and stored procedures to meet business requirements
• Unit test reports to identify defects and data issues and to ensure an accurate, high quality end product for delivery to reporting users
• Analyze, troubleshoot and resolve bugs as identified by users.
• Upload SSRS reports to Web portal using Sharepoint.
• Work with application development teams to update existing SSIS packages and reports as underlying application design is enhanced/changed
• Establish and follow standards for request processes, catalog definition, and architecture of a project.
• Create SSIS packages with different data sources and applied several transformations to manipulate data into required form.
• Schedule SSIS, SQL jobs using SQL server job agent.
• Test and manage the SSIS packages.
• Build several multi dimension cubes using SQL Server Analysis Services (SSAS).

Environment: MS SQL Server 2008/2005, VS2008/2005, SSRS 2008/2005, SSAS, SSIS, Business Intelligence Development Studio (BIDS), T-SQL, PL/SQL, MDX, Microsoft Office SharePoint Server (MOSS ) 2007, Performance Point Server 2007.

Confidential, Manchester, NH

SQL BI Consultant(IS,RS,AS)

Responsibilities:

• Tested and installed SQL Server 2005 SP2
• Migrate DTS packages from SQL Server 2000 to SQL Server 2005 Integration Services (SSIS)
• Developed SSIS (SQL Server Integration Services) Packages for data extraction, transfer, and loading (ETL).
• Extensively made reports using report builder (SSRS).
• Experience in writing efficient SQL queries and SQL queries to generate results to be consumed by SSRS (SQL Server Reporting Service) in 2005
• Query optimization, performance monitoring and index tuning
• Created jobs and alerts for monthly and weekly maintenance
• Used SQL Server 2005 Management Studio (SSMS) to develop, deploy and troubleshoot databases.
• Data migration from other data storage like Oracle and Sybase using SSIS
• Migrated Access, Sybase and Oracle databases to SQL Server.
• Tested and implemented Database Mirroring solution for Production critical application.
• Ensure that SQL Server databases are updated accurately and regularly
• Implemented transactional replication for populating reporting database.
• Assisted development staff with application design
• Reviewed SQL code, including stored procedures and DTS packages, to ensure performance, integrity, and other project standards are met
• Identified and resolved user login and permission problems.
• Created new databases, tables, and fields for data entry, performing database capacity planning.

Environment: Windows 2000 Advanced Server, Windows Server 2003 EE, MS SQL Server 2000, Microsoft SQL Server 2008/2005,SSIS,SSRS,SSAS,DTS, Redgate Tools

Confidential 

SQL Developer

Responsibilities:

• Interfaced with the client as part of the Requirements engineering team to finalize the project scope.
• Designed the migration plan in accordance with the business standards and practices and addressing the incompatibility and inconsistencies of the existing application.
• Worked closely with Database Architects in designing Data marts and Data warehouse.
• Created cubes using SSAS as per business requirement.
• Involved in extracting the data from transaction system to staging area from various sources like MS Excel, MS Access, and Oracle using ETL (SSIS).
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Used various transformations while mapping the data from staging to destination and then deployed the packages to production.
• Tested and managed the SSIS packages.
• Used SQL Server Agent to automate the SSIS package execution
• Configured and maintained Report Manager and Report Server for SSRS
• Identified the requirements for generating dynamic and ad-hoc reports (Cross-Tab, Drill-down and Sub-Report) using SSRS
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Work with various SAS products SAS/BASE, SAS/GRID, SAS/STAT, SAS/GRAPH, and SAS MACROS to develop required solutions.
• Generated Reports using Global Variables, Expressions and Functions
• Created Crystal Reports as per business requirements.
• Wrote Complex Stored Procedures, Triggers, Views and Queries
• Used SQL Server Profiler and Performance Monitor, stored procedures, triggers, and functions to monitor and improve the performance of the database servers.

Environment: MS SQL Server 2008, SSRS, SSIS, SSAS, T- SQL, MDX, Erwin, SAS, MS Excel 2003, Visual Studio 2005