SUMMARY

• 7+ years of IT industry experience in using Microsoft SQL Server 2005/2008/2008 R2/2012 for Database Design, Development, Database Administration, Data Migration and Business Intelligence Reporting.
• Expert in using Microsoft Business Intelligence tools namely Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Worked with Organizations in diversified domains like Gas Trading, Banking, Airlines, Retail, Insurance, Construction and Medical.
• Strong analytical and problem - solving skills coupled with excellent documentation, verbal and inter-personnel communication skills including the ability to acquaint to fast changing environments.
• Excellent understanding of Relational Database Systems, Normalization, Logical/Physical Data Modeling and Data Warehousing.
• Hands on Experience in Installation, Configuration, Managing, Monitoring and Troubleshooting of SQL Server 2005/2008 on different Windows Environments.
• Excellent T-SQL programming skills in writing complex queries to Create and Update Database objects such as Tables, Views, Stored procedures, Triggers and User-Defined Functions.
• Good understanding of Database Architecture concepts related to Pages, Extents, Files, File-Groups, Transaction Logs, Tables and Indexes.
• Experienced in using SQL Server Management studio tools namely Profiler, Database Tuning Advisor and Performance Monitor for Query Optimization and Performance Tuning.
• Experience in Database Administration work such as setting SQL Server Agent jobs for Backups, developing high availability solutions through Replication and Database Mirroring, creating Maintenance Plans, Maintaining Database Security etc.
• Experience in building Data Integration and Workflow Solutions for Extracting, Transforming, and Loading data with SSIS packages, DTS and BCP utility.
• Experienced in implementing Incremental Data Load from an OLTP to a staging database for further Analysis.
• Experience in Implementing various SSIS features like Event Handling, Precedence Constraints, Break Points, Check Points, and Logging for Complex SSIS Packages
• Experienced in using VBScript in Integration Services Packages while performing various ETL Operations.
• Experienced in using multiple Control flow and Data flow tasks to build complex SSIS Packages.
• Experience in implementing Transactions, Logging, Error handlers and XML configuration files to SSIS Packages.
• Experience in developing Custom Reports and Various types of Tabular, Matrix, Ad-hoc, Drill-down, Lists, Charts, Parameterized and Cascading Reports with multiple formatting using SQL Server Reporting Services (SSRS).
• Good understanding of Other Reporting Service (SSRS) aspects such as Report Authoring, Report Management, Report Delivery and Report Security.
• Good understanding of Data Warehouse Design aspects like Kimball model, Inman model, Star-schema, snow flake schema.
• Good Expertise in developing and extending SSAS cubes, Dimensions, Data source views, SSAS- data mining models including deploying and processing of SSAS objects.
• Experienced in MDX Scripting and Performance Optimization of SSAS cubes.
• Experienced in Designing Scorecards, Dashboard reports using Performance Point Server and Publishing them to Microsoft SharePoint Portals.
• Good Expertise in using Source Control Tools such as Team Foundation Server (TFS) and Visual source safe (VSS) and Subversion (SVN)

TECHNICAL SKILLS

RDBMS: Microsoft SQL Server 2005/2008/2008 R2/2012, MS Access, Oracle 10g, IBM iSeries AS400, KB-SQL

LANGUAGES/SCRIPTS: C, C++, T-SQL, PL-SQL, MDX, VB Script

MICROSOFT TECHNOLOGIES: MS Office, Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, Visual Studio, SharePoint Server, Performance Point Server, Power Pivot

OPERATING SYSTEMS: Win 95/NT/2000/XP/Vista, MS-DOS, Windows Server 2008/R2 Enterprise

TOOLS: AND UTILITIES: Crystal Reports, DTS, SSRS, SSIS, SSAS, Visual Source Safe, TFS, Performance point Server, SQL Profiler, Database Engine Tuning Advisor, Index Tuning Wizard, SQL Agent, Maintenance Plans, Security, Replication, OPEN LINK, SVN.

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Microsoft SQL/BI Developer

Responsibilities:

• Primarily Build a Data Mart to collect customer information related to Subscriptions, Shop Orders, Job Fairs and Surveys from various legacy systems.
• Gather requirements from marketing and sales departments to identify data elements, create mapping documents and analyze business data.
• Design and build a data warehouse model with dimensions, facts, staging tables, entity relationships and Indexes.
• Create complex stored procedures using temp-tables, joins and CTEs to extract customer personal information from various legacy systems to staging tables.
• Create and SSIS Package using MERGE, DATA CONVERSION, LOOKUP, DERIVED COLUMN, DATAFLOW tasks to load customer personal information from staging database to Fact Tables.
• Create Stored procedures to INSERT and UPDATE data from MYSQL databases to Fact Tables on the new data warehouse.
• Create SSIS Package with multiple SEQUENCE CONTAINERS to INSERT and UPDATE the dimension tables using type 2 slowly changing dimension methodology.
• Create VIEWS to de-normalize Fact data using multiple dimensions and lookups tables so as to use these VIEWS in generating business Reports.
• Create BCP extract scripts with XP CMDSHELL utility to dynamically generate flat files from the VIEWS and other dimension tables.
• Create SSIS Package to export/import the Flat Files to an external Server through SFTP using WINSCP. This is accomplished using EXECUTE PROCESS TASK and BATCH files as Parameters.
• Create stored procedures comprising of dynamic scripts using BULK INSERT, INSERT and UPDATE tasks to copy data from multiple flat files to SQL SERVER staging tables.
• Create 2-3 tabular SSRS Reports from VIEWS and other FACT Tables using cascading parameters, drill downs, and other conditional formatting styles.
• Create SQL Server Agent Jobs with multiple TSQL and SSIS steps and setup EMAIL NOTIFICATIONS in case of Job Failure.
• Generate DB scripts for tables, views, stored procedures and Agent Jobs and create batch scripts to run scripts for production deployment process.
• Build T-SQL scripts within TABLE VALUED FUNCTIONS to validate data between source legacy systems and the new Data Warehouse.
• Deploy objects and process to production systems, setup CMD LINE automation with software necessary to SFTP files, convert text file encodings, convert file formats and zip file folders.

Confidential, Philadelphia, PA

Microsoft BI Developer

Responsibilities:

• Analyzing the Source Database servers, data profiling and generating Database ER Diagrams.
• Creating a Data model for a centralized data warehouse using ERWIN and Microsoft VIZIO.
• Generating T-SQL Scripts to Create Schemas, Tables and Views for the Centralized data warehouse.
• Using Import/Export Wizard to generate SSIS packages that migrate data from various sources to a Staging database.
• Creating a Dynamic Stored Procedure using MERGE Statements to incrementally load data from three database servers to the centralized data warehouse.
• Creating SSIS Packages to move data from staging database to the centralized data warehouse.
• Implementing Error Handling, Data Conversions, Dynamic Connections and Stored Procedures within the SSIS Package.
• Create SSIS Package to run T-SQL Scripts and other stored procedures that load data from Source systems to the Centralized Data Warehouse.
• Creating a Data Migration Audit Process to validate row counts between Source and target after every Load.
• Creating views on the centralized data warehouse that collapse several dimensions to be used in cube modeling.
• Building a model SSRS report from the cube that uses several Facts and Dimensions from the Centralized Data Warehouse.
• Build SSIS Package Configurations to dynamically set database connections and other parameters during the production deployment process.

Confidential, Philadelphia, PA

Microsoft BI Developer

Responsibilities:

• Analyzing the legacy systems to create Data profile documents containing table schema, row counts, primary keys, foreign key relationships and virtual columns.
• Building SSIS Packages with OLEDB and ADO.NET database connections, PL-SQL/KB-SQL Source Scripts, Data conversions, Auditing, and Data Validation features incorporated.
• Design and Create new databases, tables, Schemas and other objects on SQL Server 2012 to migrate data from Oracle and KB-SQL database systems.
• Building reports to validate data migrated from the source systems to target systems using T-SQL, KB-SQL and PL-SQL scripts embedded in an SSIS Package.
• Establish relationships, constraints and integrity on the target SQL Server database system.
• Building stored procedures and user defined functions with complex T-SQL Scripts.
• Optimizing Complex SQL Queries with indexing and other optimization techniques to improve the Reports performance.
• Building 4-5 SSRS Reports using stored procedures, custom SQL Scripts and User Defined Functions with SQL Server Reporting Services 2012
• Implement various Reporting Functionalities such as Drill Down, cascading parameters, sub-reports, Linked Reports, and conditional formatting.
• Building 2 SSAS Cubes, one with HealthCare Financial Data Views and the other for HealthCare Clinical Data Views.
• Implementing additional SSAS Cube features such as hierarchies, Calculations and dimension relationships.
• Implementing few optimization techniques such as partitioning, dimension indexing and processing on the Cubes.
• Establishing Database Connections, Report Security and Standard subscriptions on the SSRS Report Manager.

Confidential, Richmond, VA

Microsoft BI Developer

Responsibilities:

• Collecting information about the business rules from various business process analysts and converting this into new reporting requirements.
• Analyzing a huge number of existing reports so as to understand the logical and interface design changes to be applied accordingly.
• Designing a data structure with multiple facts and dimension tables to hold the source data to be used for building new reports with SSRS.
• Establishing referential integrity, data consistency, and indexing and data cleanup procedures to maintain high quality data that can be used for reporting.
• Writing lengthy stored procedures to import data from various SQL Server legacy systems into a single data Warehouse with multiple data transformations.
• Designing an SSIS Package that runs multiple stored procedures and Dataflow tasks to populate and cleanup the Data Warehouse tables.
• Designing a Master SSIS Package that runs multiple SQL Server Agent Jobs on various Servers in a sequence with failure notifications at each section.
• Designing an SSIS Package with multiple control flow task such as For Loop, For Each Loop, File System, Database Backup, Sequence Container, Execute Process and Data Flow to export from Warehouse to SAP through an SFTP.
• Converting 5 - 6 MS Access version of reports to SSRS RDL versions by importing procedures from access which pull SQL Server data for this reports.
• Creating 10 - 12 new SSRS Reports with functionalities such as conditional formatting and visibility, parameterization and dynamic SQL.
• Building lengthy and complex user defined Table Valued functions to design Report Data from the Warehouse using tables variables, CTEs, Rank, PIVOT, Grouping, Date formatting etc.
• Building a single complex report for employee payroll using multiple tablix, multiple sub reports, dynamic grouping, filtering, conditional formatting, pagination etc.
• Working with MS SharePoint to integrate SSRS Reports by creating new pages to a site and adding report viewers with appropriate navigation.
• Writing TSQL scripts to validate the SSRS Reports data against the Data Warehouse and other source systems.
• Troubleshooting and maintaining the existing SSRS version of reports with changes in the Data Warehouse.
• Providing Production Support for the existing SSIS Packages and Reports including the implementation of change control aspects.
• Providing Database administration support with Backups, restores, Security, Report Server Security and data cleanup.
• Made Changes to existing Analysis Services Cubes to add new attributes, dimensions and properties to a cube.

Confidential, Voorhees, NJ

Microsoft BI Developer

Responsibilities:

• Worked with the Business users to gather requirements for developing reports on Customer Service/ Call Center Data from various sections of the organization.
• Created Stored Procedures to process Data loaded onto SQL Server from IBM AS400 database and CSV files generated from AS400 Queries.
• Developed a few individual ETL Packages to load data from AS400 databases/CSV files based on the business requirements to develop a report.
• Worked with mostly with Data Flow Task, For Each Loop, Execute SQL Task, Analysis Services Process Task and Configuration files in SQL Server Integration Services.
• Built SSAS Cubes for a few reports which required Data browsing in a 3-dimensional way on Microsoft Excel for the business users.
• Developed around 8-10 less complex reports and 2-3 complex reports with SSRS R2 on top of a relational database and also SSAS Cubes.
• Developed Cubes with multiple Fact/Dimension tables, Attributes, Hierarchies, Calculations, Roles and built configurations to deploy to different Servers
• Used various new features provided with BIDS R2 edition in SQL Server Reporting Services to provide additional functionalities and easy navigation for the end users.
• Designed a Dynamic Report Menu, which is specific to the business user browsing the report on the Company’s report server using a back-end model on SQL Database Engine.
• Involved in trouble shooting issues with report manager security and settings during the reports deployment onto QA and Production environments.
• Written documents those provide steps to Deploy Database Scripts, ETL Packages, SQL Server Agent Jobs, SSAS Cubes and also Reporting Solutions pertaining to an individual business report onto QA/Production.
• Built reports, which were combination of Drill through, Drill Down, Sub-Reports, Charts, Matrix, Tabular, and Cascaded Parameterized functions.
• Provided Production support for major deployment of ETL Packages, Cubes and SSRS Reports.

Confidential, Pittsburgh, PA

SQL Data Integration/Reporting Specialist

Responsibilities:

• Involved in analyzing the business rules for data conversion in order to build a high level architecture of database objects in MS SQL Server 2008.
• Created and Altered Tables, User-Defined Functions, Stored-Procedures and triggers to support the Data Conversion Process.
• Created packages with PL/SQL Scripts in SQL Integration Services to import record sets from different oracle systems into SQL Server as staging database.
• Applied various Data Transformations like conditional split, data conversion, derived columns and lookups to source data.
• Implemented various Control Flow Tasks such as For Loops, For Each Loops, Execute SQL tasks and Scripts tasks to support the Data Conversion process as per the business rules.
• Implemented different Error handlers and Event handlers to debug issues related to data transformation.
• Built a post-conversion Data Verification Process in SQL Server staging dB to generate and compare counts by different grouping methods on gas trading deals between source and target oracle systems.
• Built Tabular Reports with data sets imported from source/target oracle systems in SQL Reporting Services to compare various attributes of physical and financial gas trading records.
• Deployed packages from MS SQL staging dB to different test environments for testing and then to production.
• Written complex stored procedures with Temp tables, CTEs and Table-Valued Functions to filter out records from source systems based on the business rules.
• Created User-Defined Functions with multiple string, row, and rank and date functions to be used as derived columns while building Reports.
• Created SQL Integration packages with T-SQL Scripts and VBScripts to validate data between source, staging and target systems before the Conversion process.
• Implemented Query optimization techniques to improve the performance of Data Validation, Data Conversion and Data Verification processes.
• Created PL/SQL Scripts to support a process that compares configuration data between different oracle test environments before gas deals are loaded.

Confidential, Atlanta, GA

MS SQL/BI Developer

Responsibilities:

• Identified, tested, and resolved Database performance issues (monitoring and tuning) to ensure Query optimization.
• Analyzed the Business Requirement Document (BRD) to design a conceptual model to be implemented with T-SQL, SSIS, SSAS and SSRS to develop a solution.
• Administered SQL Server 2008 Management Studio tools including SQL Profiler and Database Engine Tuning Advisor.
• Worked with design, development, implementation and support of ETL processusing SSIS Packages in SQL Server 2008.
• Involved in Incremental Data Load from various sources into SQL Server Database Engine with ETL Operations.
• Worked with different Control flow tasks in creating SSIS packages especially For Loop and For Each Loop containers with Execute SQL and Script Tasks.
• Worked with a combination of multiple Dataflow Transformations to build packages in SSIS.
• Troubleshooting of processes, issues and errors in SSIS Packages to improve their performance.
• Worked with Master SSIS packages to execute a set of packages that load data from various sources onto the Data Warehouse on a timely basis.
• Scheduling and Monitoring SQL Server Agent Jobs to run various SSIS packages in SQL Management Studio.
• Understanding the OLAP processing for changing and maintaining the Data Warehouse, Optimizing Dimensions and adding new Aggregations to the Cube.
• Involved in generating Parameterized Tabular and Matrix Reports on data sets imported from SQL server Database Engine and also Analysis Services cubes.
• Worked with Report Manager to configure Web URLs, E-mail and also Databases for reports.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them onto the organization’s Microsoft Office Share point Server (MOSS).

Confidential, Chicago, IL

MS SQL/BI Developer

Responsibilities:

• Designing and creating new Database objects like Tables, Views, Indexes, Stored- Procedures, User-Defined Functions and Triggers.
• Written and executed complex T-SQL queries using SQL Management Studio for back- end data validation and testing.
• Implemented Partitions on large Tables and Indexes in SQL Server Database Engine.
• Extensively worked on managing ETL process by pulling large volume of data from OLTP to a staging Database using SSIS for data transformation.
• Implemented Various Error handling and Event Handling Techniques in SSIS to ensure efficient package execution.
• Worked on various SSIS Packages involving multiple Data flow Transformations like Fuzzy Lookup, Merge Join, Aggregate and Pivot as per the requirement.
• Implemented Lookup, Conditional Split and Derived Column tasks while loading Data from Staging to a Data Ware House.
• Involved in Building a data-warehouse with Dimensions and Fact Tables based on the Business requirements.
• Implemented Different Slowly Changing Dimension methodologies to maintain and update historical data corresponding to Dimension tables in the Data warehouse.
• Developed SSAS Cubes on selected data sources with multiple calculated members using MDX Scripting.
• Generated KPIs with different Measures and Calculated Members by applying business conditions.

Confidential, Atlanta, GA

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Developed DML scripts to Insert, Update and Delete data in MSSQL database tables with SQL Server Management Studio.
• Created Views to facilitate easy user interface on database tables, and created Triggers to facilitate consistent data entry into the database tables.
• Involved in maintaining Data consistency and Data Integrity with various constraints like Unique, Check, Primary Key and Default.
• Done Performance Tuning of T-SQL Statements effectively with SQL Profiler and Database Tuning Advisor.
• Effectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages and VBScript.
• Worked with various Dataflow tasks like Character Map, Aggregate, ODE Command and Conditional Split while designing SSIS Packages.
• Designed and created Report templates with Constant Header information like Company logo, Department Name etc. for Weekly, Monthly reports.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad-hoc and Sub-Reports using Report Designer and Report Builder based on the business requirements.
• Designed Charts with lines, Bar Graphs and Columns to generate reports with cumulative totals.

Confidential

Junior SQL Server Developer

Responsibilities:

• Troubleshooting problems concerned with SQL Server 2000 Installation, Configuration and Maintenance.
• Writing T-SQL Queries using DML Commands to retrieve Customer information, Update Customer Information and also delete information in few cases.
• Involved in fine-tuning complex T-SQL Queries to decrease the query processing time using few Performance Tuning techniques and also SQL Profiler.
• Developed less complex Stored-Procedures with multiple input/output parameters, Pre-defined Functions, Aggregations and Data filters.
• Creating and managing Schema Objects such as Tables, Views, Indexes and Constraints.
• Implemented different joins to retrieve data from multiple tables with Referential Integrity.
• Created Triggers with error messages so as to ensure consistency during data entry.