SUMMARY

• Over 8+ years of experience in Data Modeling, Database Design, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2008/2008R 2/2012/2014.
• Expirence and understanding of different phases of Software Development Life Cycle (SDLC). Experience in software Analysis, Design, Development, Testing, Implementation and Production, support of Client/Server and Web based applications.
• Strong experience in using Microsoft BI studio products like Server Integration Services, Reporting Services and Analysis Services.
• Good hands-on working experience
• Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries.
• Writing Complex Transact SQL (T-SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc.
• Programming in SQL Server Stored Procedures, Triggers, User-defined Functions and Views, Cursors.
• Performance tuning of Stored Procedures and T-SQL Queries.
• Implementing SQL Server Indexing and Query optimization using Indexes
• Logical & Physical Data modeling, data architecture designs etc.
• Understanding existing data models, data flows and data dictionaries.
• Creating new data models, data flows and data dictionaries.
• Normalization and De-Normalization techniques.
• Involved in Backing up databases and refreshing Data across environments.
• Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc.
• Creating data load and Upgrade scripts for data migrations, data formatting and data validations.
• Implementing all high availability techniques like clustering, log shipping, replication.
• Knowledge of Relational Database Modeling and Dimensional Modeling in combination with SSAS to develop OLAP cubes having Star/Snowflake schemas.
• Strong experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Power Pivot.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Knowledge of creating SSIS Packages. Created packages to extract data from flat files, Teradata, Oracle and DB2 and transform the data according to the business requirements and load the data in SQL server tables.
• Expirence in scheduling and monitoring ETL Processes using DTS Exec utilities and batch files.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS) and Informatica.
• Ability to work in a team and as an individual with minimal supervision.

TECHNICAL SKILLS

Database: MS SQL Server 2005/2008/2011 , Oracle 10g/11g, MySQL 6.3, MS-Access 2007

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services(SSIS).

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export, Visual SourceSafe 6.0, Visual Studio Net, DTS, SSIS, Business Intelligence Development Studio (BIDS), ETL Tidal Job Scheduler, JIRA, Tortise SVN

Version Control: Visual SourceSafe 6.0/2005

Script and Query Languages: T-SQL, PL/SQL, VB Script, Java Script,XML

Operating Systems: Windows Vista/ XP/ 2003/ 2000/ NT 4.0

PROFESSIONAL EXPERIENCE

Confidential, Glen Mills, PA

BI Developer

Responsibilities:

• Create ETL packages (SSIS packages) using Microsoft Visual Studio 2008 and Microsoft SQL Server Management Studio 2008. The ETL packages are referred to as pre-processors that process the input data to a financial services based software application.
• Deploy the packages to extract data from flat files (.txt files) and load the data into the destination table in the production environment. The table serves as a primary input to the financial services based software application used for generating financial reports.
• Implement business logic using the ETL packages, to perform necessary transformations on the data before it is loaded into its final destination table.
• Develop test cases and test plans to perform unit testing on the packages created, for quality assurance. Assist quality assurance testing teams.
• Modify existing ETL packages to support additional/new features based on the customers’ requirements.
• Provide technical support, troubleshoot and monitor packages released for staging and production.
• Work closely with the Business Intelligence and Analysis team to understand the customer’ requirements and jointly develop the business logic used for creating the ETL packages.
• Liaise between the Technical Operations (Tech Ops) group and the Business Intelligence and Analysis group; effectively communicate technical specifications and requirements associated with business solutions and goals.
• Prioritize tasks, develop and deliver effective on-time business solutions to successfully implement customers’ business goals.
• Participate in all phases of software and business solution development.

Environment: MS SQL Server 2008, MS Visual Studio 2008, ETL, T-SQL, Business Intelligence Development Studio (BIDS), MS Excel 2010, MS Office 2010, C#, Windows 7.

Confidential, Virginia Beach VA

MSBI Developer

Responsibilities:

• Worked on creating complex SQL stored procedures, Triggers, Functions, User defined functions,Views, Indexes in Microsoft SQL Server 2012.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Worked on created Cross-Tabs, Drill-down and Sub-Reports using SSRS and also deployed RDLs to Report Server.
• Worked on created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Generated reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Generated reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Generated Report Subscription and Data Driven Subscription using SSRS 2012.
• Worked with business teams to generate business requirements and translating them to technical specifications.

Environment: MS SQL Server-2012/2008 Enterprise Edition, SSIS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Sever, Windows server 2007, IIS 6.0, Tidal Job Scheduler.

Confidential, Austin, TX

Server SSRS/SSIS Developer

Responsibilities:

• Develop SQL statements using joins, sub queries and correlated sub queries.
• Involved in creation of data modeling techniques.
• Analyzed complex queries and tune the same to optimize application and system performance.
• Designed and developed monthly, quarterly and yearly reports at branch and bank level.
• Created tables, indexes, triggers by coordinating with DBA team
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Involved in optimization of long running Stored Procedures and Queries for effective data retrieval.
• Converted DTS to SSIS and development and implementation of SSIS on an enterprise level.

Environment: SQL Server 2000/2005, T-SQL, Windows Server 2003, SQL Profiler, SQL Server Reporting services, Visio.

Confidential, Minneapolis MN

SR.SQL Developer (SSIS, SSRS)

Responsibilities:

• Expirence in database design to create star schema using Dimensional and Fact tables.
• Involved in creation of tables, views, Indexes and establishing the relationships between the tables and design the star schema using SQL Server 2012.
• Responsible for created SSIS packages to implement complex business logic.
• Responsible for Published SSIS packages and SSRS repots in testing and production server.
• Responsible for Creating Jobs to execute SSIS packages, on daily, weekly and monthly time periods.
• Involved in creating complex table, matrix, sub reports and chart reports using SSRS.
• Involved in requirements analysis and attended requirements review meetings.

Environment: SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Data tools 2012, XML, and Windows Server 2003/2008/2012.

Confidential, Richmond VA

T-SQL Developer

Responsibilities:

• Worked with business teams to generate business requirements and translating them to technical specifications
• Created database objects like tables, indexes, stored procedures, views, user defined functions,cursors and triggers.
• Worked on developing complex Stored Procedures, Triggers, User Defined Functions based on the requirement.
• Worked on creating and modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Worked on tuning of SQL statements and Stored Procedures for performance
• Worked on developed complex programs in T-SQL\PL-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Performed data testing by checking positive and negative scenarios.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Generated the reports in PDF formats as per the business requirement and also configured for printing all the reports in a batch process for Monthly Statements.
• Gained experience in implementing ETL packages and proficient in implementing all transformations available with SSIS/DTS toolbox.

Environment: MS SQL Server 2005/2008, SQL Server Integration services (SSIS) 2008, SQL Server Reporting services (SSRS) 2008, SQL Server Management Studio, VB, DTS, T-SQL, Windows Sever XP/2007, SQL Profiler, Query Analyser, Erwin 7.0

Confidential, Mt.Laurel, NJ

SQL Server Developer & App Support

Responsibilities:

• Responsible for creating complex SSIS packages using proper control and data flow elements with error handling.
• Responsible for tuning of Slow Running Queries or inefficient Queries for Optimal Performance using SQL Profiler and Managing Indexes and Statistics.
• Responsible for creation of schema objects, granting of roles and privileges to the users, compilation of procedures etc.
• Responsible for created SQL Scripts for data loads and Upgrades for data migrations and data validations.
• Generated Tabular and Chart Reports in SSRS.
• Experience in building and maintaining Data Marts for SSRS.
• Responsible for designing cubes with star schema using SQL Server Analysis Services (SSAS).
• Responsible for Developing cubes with various Perspectives and deployed those cubes in development, integration, validation and production servers of SSAS.

Environment: SQL Server2005, 2008