SUMMARY

• Extensive experience developing and working with diverse collection of applications and 6+ years of professional experience as Microsoft SQL server database BI Developer.
• Highly experienced in MS SQL Server 2012/2008R2/2008with Business Intelligence in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS).
• Excellent problem solving, analytical, technical, interpersonal and communication skills with strong leadership abilities and an extremely diligent strong team player with an ability to take new roles.
• Possessed Excellent T - SQL Programming skills and effectively used Advanced Programming concepts like CTE’s, Windows Functions, Table Partitioning, Apply Operators, Table Valued Parameters, Output Clause, Merge Statement, Pivot, XML, Dynamic SQL, Table Valued Functions etc.
• Highly experienced in creating complex Views, Stored Procedures, DDL/DML Triggers and User-Defined Functions (UDF) to implement Business Logic and Data Protection.
• Experienced with SQL Server and T-SQL in constructing triggers, tables, user defined functions (UDF), views, indexes, user profiles and relational database models with data integrity.
• Used SQL Profiler, Execution Plans, DMV’s, Database Engine Tuning Advisor (DTA) and Created Suitable Indexes for Query Performance Tuning and Optimization.
• Implemented Stored Procedures with TRY-CATCH Blocks, Database E-mail for Error Handling and Effectively Used Join Hints, Isolation Levels to reduce Locking and Blocking.
• Familiar with SCRUM and Agile process Knowledge of project management methodologies and best practices
• Used DMV’s and Locking Queries to find out Locks, Deadlocks and Long running Queries or Transactions.
• Written Scripts for deploying the code across various SDLC Environments like TEST, UAT and Production.
• Experience in implementing different types of Replication models like Snapshot, Transactional and Merge.
• Involved in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Involved in monitoring database maintenance plans for checking database Integrity, Rebuilding, Reorganizing Indexes, Shrinking Databases, updating statistics, Creating and Scheduling SQL Server Agent Jobs.
• Extremely dedicated, hardworking, strong team player with an ability to take new roles. Good communication and strong analytical skills. SSIS Experience (ETL):
• Designed ETL packages dealing with different data sources (SQL Server, Oracle, Flat Files, Excel Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Developed SSIS Packages with Custom error handling, Logging using event handlers, Send E-mail Task and Used Checkpoints to rerun Packages from Point of Failure.
• Experienced in working with different data sources like OLE-DB, flat files and Excel to source data in SSIS and proficient in creating SSIS packages from scratch and deploying them.
• Designed SSIS Packages with Dynamic Tasks and Connections Using Variables, Expressions and Packages Configurations and followed best practices to maintain Optimized performance.
• Loaded Data warehouse Fact Tables and Dimension tables of type 1 and type 2 attributes Using Transformations Lookup, Merge Join, Conditional Split and also Using T-SQL 2008 Merge Statement
• Debugged the Packages Using Break Points, Data Viewers, and Script Task, Deployed the Packages Using DTUtil Commands, Deployment Utility and Scheduled Packages with DTExec Commands. SSRS Experience:
• Designed and Deployed several SSRS reports such as Drill down reports, Drill through reports, Parameterized reports, Cascaded reports, Cached reports, Snapshot Reports, linked reports, Sub reports.
• Used Report Manager to assign roles, permissions and Created report schedules and Subscriptions.
• Expert in creating traditional as well as Web-based interactive reports using SSRS.
• Experienced in creating reports using SQL Server Reporting Services sourcing OLAP cubes and data warehouse, data marts as well as transactional systems. SSAS Experience (OLAP):
• Experienced in building Star schema and Snow Flake schema depending on business requirements.
• Defined Relationships between Dimensions and Measure Groups like Fact Relationship, Many-to-Many Relationship, and Defined Dimension Granularity within a Measure Group.
• Experienced in developing and modifying cubes and dimensions in cubes using SSAS.
• Skilled in developing Data Warehouses, Data marts using Star Schemas and Snow Flake Schema.
• Experienced in Developing, Deploying and Processing SSAS Cubes and writing MDX queries.

TECHNICAL SKILLS

Data Warehousing/BI Tools: MS SQL Server Business Intelligence (MSBI) Development - SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), SQL Server Management Studio(SSMS) 2008/2008R2/2012, Visual Studio (VS) 2005/ 2008/2010/2012

RDBMS/DBMS: MS SQL Server 2005/2008/2008 R2/2012, ORACLE 9i/10g, MS Access, DB2, Sybase

Tools: MS SQL Server Management Studio (SSMS), Performance Monitor, Power Pivot, SSIS Documenter, SQL Agent, SQL Mail, Erwin, Team Foundation Server (TFS) 2008/2010/2012 , Microsoft Visio 2007/2010/2013 , Visual SourceSafe (VSS), Import/Export Wizard.

Web Technologies: HTML, DHTML, XML, IIS, Apache.

Programming Languages: T-SQL, PL/SQL, C#.net, Core Java, C, Java Script, VB Script, XML, HTML, Shell scripting,MVC

Operating Systems: Windows 8/7/Vista/XP, Windows Server/2008/2012.

PROFESSIONAL EXPERIENCE

Confidential, Mount Laurel, NJ

BI Developer/SSIS/SSRS

Responsibilities:

• Worked effectively across functions and establish strong relationships with key functional stakeholders (Risk, Finance, IT and Compliance Units)
• Responsible for Risk Data collection processes that create monthly/quarterly/annual risk data reporting for regulatory reporting and monitor data accuracy and completeness to ensure data quality
• Installed, upgraded and migrated databases from MS SQL Server 2008 to MS SQL Server 2012
• Coded SQL and T-SQL for database access, database modifications, and construct database stored procedures. Adhere to company standards, concepts, practices, and procedures for database load
• Designed and Developed web pages using ASP.NET
• Used validations controls in ASP.NET for validating front end forms.
• Used data sets and ADO.NET to retrieve data from the database.
• Experienced in creating package dynamics by using SSIS expressions and variables.
• Created SSIS packages to extract data from OLTP to Data warehouse systems and scheduled Jobs to call the packages and Stored Procedures.
• Performed Documentation for all kind of SSIS packages.
• Identified data sources, constructed data decomposition diagrams, provided data flow diagrams and documented the process
• Created and designed the multiple dimensions and fact table for business report purpose
• Achieved analytical solutions using power BI.
• Designed and managed schema objects such as tables, views, indexes, stored procedures, triggers according to business rules using SQL server 2008.
• Responsible for the maintenance and support of the data warehouse, analysis services cubes, dashboards, and reporting needs.
• Extracted data from SQL Server 2008 into data marts, views, and/or flat files for Tableau workbook consumption using T-SQL.
• Designed reports using SQL server reporting services (SSRS) and Excel pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports
• Identified data quality issues and supported the data governance initiative by participating in necessary activities including data profiling
• Used SSRS for creating matrix and tabular, drill down, drill through, and parameterized reports based on requirements.
• Developed logging for ETL load at the package level and task level to log number of records processed by each package and each task in a package using SSIS
• Managed the security of the servers, creating the new logins and users, changing the roles of the users Manage Issues, Dependencies and Risks pertaining to Requirements Definition and Management Process
• Generated reports for end user requirements using SSRS.
• Developed SSRS web applications using .NET 4.5

Environment: MS SQL Server 2012/2008, SQL server Reporting Services(SSRS)2012/2008, SQL Integration Services(SSIS)2012/2008, ASP.NET, Microsoft Visual Studio 2010/2008, Tableu, Vb.net, SQL Server Management Studio, MS Excel, ADO.NET, T-SQL, Power BI, Visio.

Confidential, Boston, MA

MS SQL Server Developer/ SSRS, SSIS, SSAS

Responsibilities:

• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Scheduling Jobs and Alerting using SQL Server Agent
• Creating functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Generated reports using SSRS that could be used to send information to different Primary Vendors, Clients, and managers and used windows security for security purposes.
• Developed source login interfaces with ASP.NET server controls.
• Used ADO.NET extensively for data retrieving, querying, storing and manipulating.
• Implemented Extraction, Transformation and Load (ETL), Import, Export activities by DTS package
• Development of SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting
• Developed various reports for managing various securities and assets to meet specified investment goals.
• Worked Extensively with Business System Analysts who has drafted the requirements for me and helped me in testing the report results.
• Extensively involved in high level design of OLTP and OLAP based Databases.
• Used Extensively MS SQL Server Reporting Services 2008 to develop various kinds of reports and test them with users and finally deploy them.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Formatted the report layout for the requirement of the end users and deploy the developed reports on to the server for the end users.

Environment: MS SQL Server 2005/2008, MS SQL Server Integration Services 2005/2008, Vb.net, ADO.NET, ASP.NET, MS SQL Server Reporting Services 2005/2008, Tableu, Power BI, T-SQL

Confidential, Portland, Oregon

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Created User Defined Functions, Stored Procedures, and Triggers.
• Performed data conversions from Flat files into a normalized database structure.
• Developed, modified and optimized complex stored procedures, triggers to handle complex business rules.
• Created SSIS Packages, dimensions and cubes with star schema using SQL Server Integration and Analysis Services (SSIS, SSAS).
• Generated reports using Global Variables, Expressions and Functions using MSSQLServer Reporting Services.
• Migrated reports from SQL Server 2008 to SQL Server 2008 R2 and configured new data with the existing data.
• Implemented the concepts of incremental loading and slowly changing dimensions.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Configured Server for sending automatic mails to the respective people when a SSIS process fails or succeeds.
• Used MDX (Multi-dimensional Expressions) for the calculated members and the KPI (Key Performance Indicators).
• Implemented the Error logs through Event handlers for the existing packages.
• Created Drilldown, Cascade and parameterized reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the DashboardResponsible for Monitoring and Tuning Report performance.

Environment: SQL Server 2008 R2, T-SQL, Power BI, VB.net, MS Excel, MS Access, SSIS, and SSRS, SharePoint.

Confidential -Dallas, TX

SQL Server Developer / BI Developer

Responsibilities:

• Involved in planning, defining and designing data based on business requirements and provided documentation
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse
• Responsible for creating the reports based on the requirements using SSRS 2005.
• Gathered Requirements from the end user and created the structure of the schema and data for database tables
• Analyzed reports and fixed bugs in stored procedures using SSRS.
• Formatted reports for various Output formats as requested by the management using SSRS.
• Created technical requirements for low to moderate complexity projects
• Involved in gather requirements from Business Analysts for enhancements and created Cube
• Monitored, optimized and performance tuning of regression servers using Performance monitor, Activity Monitor.
• Deployed the generated reports created using SSRS 2005 on to the server.

Environment: MS SQL Server 2008/2005, Business Intelligence Development Studio, SSIS, SSAS, SSRS, T-SQL, Vb.net, MS Visual Studio 2010, MS Office.

Confidential

SQL Server Developer

Responsibilities:

• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Performed data conversions from flat files into a normalized database structure.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts using SSRS.
• Implemented Custom Error Handling (Record Level) by using the Script component to generate custom error messages and redirected the error rows to a staging error table.
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database (Oracle and Text format data) to SQL Server.
• Migrating DTS package from SQL Server 2005 to SSIS in SQL Server 2008.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Creation / Maintenance of Indexes for fast and efficient reporting process.
• Managing historical data from various heterogeneous data sources (i.e. Excel, Access).

Environment: SQL Server 2005/2008, T-SQL, Report Manager, Report Viewer, SQL Server Integration Services 2008, Vb.net, Data Transformation Services, SSRS, BIDS.