SUMMARY

• A Microsoft Certified software professional with 7+ years of experience as SQL Server BI Developer (SSIS/SSRS/SSAS) including writing T - SQL Programming.
• Very good hands-on experience in development and implementation of Data Warehouse applications.
• Designing, constructing, and testing of ETL processes. Created SSIS packages to extract data from the transactional and/or operational databases, transforming the data according to analytical / reporting business needs, and loading the data into a Data Warehouse or Data mart.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Designing and Development of Reporting Solutions using tools like SSRS, Crystal and other BI Reporting products in the market.
• Extensive experience in MS SQL Server 2012/2008R 2/2008/2005/2000 , BI tools like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• Expertise in creating Dashboards, Metrics, Rules and Goals, corporate/personal dashboards, Alerts.
• Worked in Data modeling, creating star and snowflake schemas in SSAS.
• Experience in maintaining Error Logging using Exceptional Handling in T-SQL and MS SQL Server Integration Services (SSIS).
• Highly Proficient in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources such as Oracle, DB2, MS Excel, MS Access, CSV, Oracle, flat file.
• Proficient in creating, configuring and fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Proficient with creating Modules and Macros with Excel VBA in different business environments.
• Strong experience in designing and developing large number of enterprise reports (SSRS/Business Objects) using the data from ETL loads, SSAS Cubes and various data sources.
• Expertise in creating cubes with dimensions and facts tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
• Support the Capital Markets Technology Applications specifically application related pricing, hedging and securitization of Mortgages as well as applications related to income forecasting.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports and deploying SSRS reports on the portal for user accessibility.
• Expert in writing parameterized queries for generating tabular reports, formatting report layout, sub-reports using global variables, subtotals, expressions, functions, sorting the data, defining data sources for the reports using SSRS.
• Strong experience in logical and physical database design and development using Erwin and MS Visio.
• Knowledge of working with Shell scripts in a UNIXenvironment.
• Worked on end-to-end projects.
• Worked in collaborative team environment with other developers, business analysts, and a project management team.
• Effective interpersonal, conflict resolution and communication skills. Team oriented, technically motivated.

TECHNICAL SKILLS

Databases: SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, Access, Oracle 9i/10g/11/11g, MySql, data warehouse.

Database Tools: SS Management Studio, Query Analyzer, SQL Profiler, Index Tuning Wizard, Upgrade Wizard, Databases Maintenance Plan Wizard, Data Transformation Services (DTS), Business Intelligence Development Studio, SQL CMD, SQL Server DBA Dashboard, Toad for SQL.

Languages: T-SQL, C, VB 6.0, VB.NET, PL/SQL, ASP.NET 2.0, Java, HTML, UML, XML, XMLA, JavaScript, MS SharePoint, MS windows

BI Tools: SQL Server Reporting Services (SSRS), Crystal Reports 9.0/8.5,OLAP, Cognos, Tableau

Operating Systems: Windows NT Server, Windows Server 2003, Windows XP, UNIX, Agile, Linux

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

SQL BI developer

Responsibilities:

• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports.
• Excellent experience in the areas of Design, Analysis and Development of Software Applications using Access and Excel VBA.
• Worked with Data Management team to analyze Reinsurance Data using tools like SQL, Access, Excel (Lookups, Pivot tables) and predicting any future impacts on business.
• Expertise in Client-Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADandSQL*LOADER.
• Work on to generate on-demand/daily reports using COMPASS POINT software, used by the Traders in the Mortgage Industry.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services (SSRS), Report Builder.
• Extracted data from SQL Server 2008 into data marts, views, and/or flat files for Tableau workbook consumption using T-SQL.
• Generated VBA/Excel modules to recalculate portfolio duration for any interest rate change and compared the same Excel with the duration of liabilities.
• Excellent Documentation skills in producing Solution Designs, Technical Design Documents, HDDs and LDDs after translating BRDs, FRDs and creating mapping documents with the required Transformation logic, Sources and Targets for Facts and Dimension using Data Modeling tools like ErWin.
• Developed and executed UNIX scripts to schedule loads, through wrapper shell scripts for calling Informatica workflows using PMCMD command.
• Generated Reports using Global Variables, Expressions and Functions for the reports in SSRS.
• Responsible for scheduling the subscription reports with Data Driven Subscription Windows File share and Email Delivery using SSRS.
• Designed and developed Informatica Logics and DMExpress tasks and jobs based on the business requirements.
• Generated various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the web front end.
• Created the Data source connections, Data Source Views, Relationships, Named Query for customized analysis in SSAS.
• Worked on Data Driven Subscription Tables for Quarterly Reports, Monthly Reports as well as Daily Reports.
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS).
• Knowledge of financial instruments such as Mortgage, bonds, MBS etc
• Design and implemented automated process using C# and SQL server 2014, SSIS and Data Quality Services (DQS)
• Created very complex SSIS Packages with considering all the best practice like error handling, logging, configurations, deployments, maintenance.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2012/2008.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
• Produced daily risk report encompassing VAR assessment, scenario analysis and stress testing using Excel and VBA.
• Configure TCP Protocol, Transport Level Security in WCF Service
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Calculated measures and dimension members using multi-dimensional expression (MDX).
• Involved extensively in designing of OLTP database.
• Created schemas, keys and indexes considering the granularity of the data.
• Implemented service oriented component (SOA) Layer using C# and WCF to decouple the Web application with Business logic layer.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
• Designed Data flows, Workflows and jobs to load data from source to target in BO Data Integrator.
• Schedule Data Integrator jobs using Data Integrator Administrator. Develop data staging tables and create indexes in the destination table in order to make the ETL process faster than expected.
• Deploy the packages in Production server ad schedule the packages according to the requirements.
• Deployed SSIS packages and Reports to Production Servers.

Environment: MS SQL Server 2008 R2, MS SQL Server 2012, Tableau, Enterprise manager, Query Analyzer, SSIS, SSRS, SSAS, * Plus, TOAD,DTS, SQL profiler, Query Optimizer, T-SQL, Share Point 2010, MDX, ETL, Power Point,C#,.NET,VB Microsoft Visio 2003, MS Visual Studio 2008.

Confidential, NYC, NY

MS SQL SSIS/SSRS Developer

Responsibilities:

• Worked on SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects.
• Created flexible forms and reports using SQL and VBA to read, update and append records to the Oracle tables.
• Created automated tasks and jobs in DMExpress so as to run according to daily or weekly based on refresh rate weekly based on refresh rate
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Worked on other packages of the SQL server 2008 Edition SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services).
• Extracting Incremental data (Change Data Capture) from Source Systems using Informatica Power Exchange.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Involved in Installation, Configuration of Share Point Form in Cluster Environment.
• Designed and developed Star and Snow Flake Schema as a data analyst.
• Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information using SSAS
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2008 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Created Cubes with multiple dimensions, measures, hierarchy, complex MDX queries, Key Performance Indicators as well as slowly changing dimensions.
• Performed tune to optimize SQL queries using SQL profiler and query analyzer.
• Created reports with Analysis Services Cube as the data source using SQL Server 2005/2008 Reporting Services.
• Involved in providing information to functional segments of the organization using Data marts.
• Involved in developing and modifying VB and XML reports for exporting the reports to web application.

Environment: SQL Server Reporting Services 2008/20012, SSAS, Informatica, Agile, MDX, MS SQL Server 2008/20012, SSIS, Front Office 10.2 / 10.3, C#,.NET, Windows XP, MS Office 2007.

Confidential, Johns Creek, GA

Sr. SQL BI Developer (SSIS, SSRS, SSAS)

Responsibilities:

• Developed SSIS packages to conduct simple and complex transformations, and executed these packages using the execution package.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Conducted data migration processes in the SQL Server environment using SQL Server Integration Services 2005/2008.
• Designed and deployed Reports with Drop Down menu option and Linked reports.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Wrote complex Stored Procedures, coding and triggers to capture updated and deleted data from OLTP systems.
• Experienced in implementation of strong referential integrity and auditing by the use of triggers.
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
• Created new cubes and modified existing cubes using SSAS 2008 to make data available for the decision makers.
• Deployed and processed SSIS Packages and SSRS Reports weekly to update information (As per business logic) by using SQL Server Agent and windows Scheduler.
• Created jobs, alerts to run SSIS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSIS, SSRS Packages run sequentially using SQLServer Agent job and windows Scheduler.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2008 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Performance tuning MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
• Worked with Transactional and Snap-shot Fact-Tables.
• Optimized existing stored procedures to achieve improved performance
• Developed advanced correlated and un-correlated sub-queries in T-SQL to develop complex reports.
• Developed Cross-Tabbed and Sub-Reports in SSRS 2008.
• Generated reports using the Crystal Reports and Reporting Services 2008Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2008.
• Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment
• Designed user defined hierarchies in SSAS including parent-child hierarchy.
• Created complex SSIS packages using various transformations.

Environment: MS SQL Server 2008, Windows Server 2003, Informatica, Enterprise manager, MDX, Query Analyzer, SSIS, SSAS, SSRS,DTS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, Agile, Share Point Portal Server 2007 (MOSS 2007), IIS 6.0, .XML, ETL, Microsoft Visio 2003, MS Visual Studio 2008.

Confidential, Boston, MA

SSRS/BI Developer

Responsibilities:

• Successfully migrated data between different heterogeneous sources such as InfoPath forms, flat file, Excel, Access Database and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Worked with T-SQL, DDL, DML and DCL.
• Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g,Infopath files, text files and Excel files.
• Encapsulated frequently used SQL Statements into stored procedures and coding thereby reducing the execution time.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Dealt with huge amount of data and used SSAS in order to retrieve the data
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• 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 requirements.
• Designed OLAP Star and Snow-flake schemas and then Dimension and Fact Tables
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Developed Query for generating drill down reports in SSRS 2008.Prepared AD HOC reports through report builders.
• Used OLAP Processing Tasks for automatic processing of OLAP Databases
• Involved in taking backups of SSAS database and restoring them when needed.
• Created data driven subscriptions for different users using Report Manager.
• Designed and implemented stored procedures and triggers for automating tasks.
• Created and Designed Data Source and Data Source Views Using SQLServer Analysis Services 2008 (SSAS).
• Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
• Identified the measures, dimensions and defined cubes to enable decision makers to drill through the detail data
• Developed Access and SQL Database and wrote queries for data migration and Reporting Services. (SSRS).
• Developing backup/restore and recovery procedures, performing weekly backup databases by using SQL Server 2005 and restoring these databases in different server.
• Created cubes and defined the dimensions

Environment: SQL Server 2008 Enterprise, MDX,WindowsEnterpriseServer2003, SSAS, SSIS, SSRS, InfoPath, Access, Agile, Share Point Portal Server 2007 (MOSS 2007), IIS 6.0, .XML, ETL, Microsoft Visio 2003, MS Visual Studio 2008, C#, ASP.Net 3.5, VB.Net.

Confidential

SQL developer

Responsibilities:

• Worked with Implementation team and closely moved with end users to implement manufacturing solutions.
• Worked closely with developers, end users and Administrators in designing and creating databases and other objects.
• Actively involved in designing databases for the system.
• Developed several database objects such as tables, triggers and views and also stored procedures.
• Created Snapshot Replication for the Development and Testing Databases across different Servers.
• Created and scheduled jobs and alerts.
• Studied the existing environments and accumulated the requirements by interaction with various aspects.
• Successfully loaded data from an EXCEL, Access, Flat files into a SQL Server database.
• Developed & executed several optimized queries.
• Written several stored procedures to achieve various functionalities of the system.
• Created packages using DTS for moving data from MS Access to SQL Server.
• Assisted the Application team in data modeling and T- SQL coding.

Environment: SQL Server 2008, Visual Basic 6.0, Windows NT, T- SQL, EXCEL, Access

Confidential

SQL Server Developer

Responsibilities:

• Installing and Configuring of SQL Server 2000/7.0 0n windows 2000/NT OS.
• Created tables, indexes, sequences, constraints, triggers and procedures.
• Managing of databases objects like Tables, views, indexes etc.
• Implementing Backups and restoring when necessary.
• Used BCP utility to publish table output to text files.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Developed scripts for maintaining administration tasks.
• Developed DTS Packages to transfer the data between SQL server database and files.
• Creation and management of database maintenance plan for various database consistency checks.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries
• 24x7 Production support.

Environment: Windows 2000, SQL Server 7.0/2000, Enterprise Manager, SQL Profiler, DTS, T-SQL, BCP, Replication