SUMMARY

• 8+ years of experience in Data modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database Systems using MS SQL Server
• Experience in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2012/2008
• Extensive experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS,SSIS,SSAS) using MSSQL Server 2000/2005/2008
• Expert in providing Enterprise Reporting solutions using SSRS 2000/2005/2008 , Crystal Reports Suite (9/10)
• Extensive ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads
• Extensive Experience in Microsoft .Net Technologies using .Net Framework 1.1,2.0/,C# (.Net), VB.Net, ASP.Net.
• Utilized Integration Services (SSIS) to produce a Data Mapping and Data Mart for reporting.
• Developed Drill through and Drill downreportsusing SQL Server Reporting Services (SSRS).
• Developed & supported various mission critical Client Server applications by handling database requests for various application development teams involving complex business logic, functionality.
• Involved in Designing numerous DB Objects like Tables, Constraints(Primary Key, Foreign Key, Unique ), Indexes, Defaults, rules
• Extensive usage of Database diagrams and data modeling tools like Erwin in creating Logical and Physical models, establishing Entity Relations and forward/Reverse engineer to database systems
• Involved in writing Complex Queries, heavy stored procedures, Batch Scripts, Triggers, Functions using T-SQL
• Thorough noledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities
• Involved in scheduling jobs, address Batch process issues, Debug code and Maintenance and bug fixes.
• Test & Deploy code across various SDLC Environments like TEST, UA/UT/Production.
• Involved in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2000/2005/2008 across various environments
• Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems
• Expertise in Enterprise Reporting in generating reports using linked reports, sub reports and filters, charts in SQL server reporting services.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Experience in Integrating SQL Server Reporting Services with Microsoft Office Share Point Server (MOSS).
• Extensive noledge in ETL Process & Progressive noledge in using DTS/SSIS utilities
• Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities
• Expertise in designing SQL Server SSIS packages to import and transform data between databases and external data sources.
• Involved in migration of DTS Packages (2000) to SSIS (2005/2008) and troubleshoot migration issues.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
• Developed OLAP cubes using SSAS (SQL Server Analysis Services). Calculate the metrics that were revealed in the functional analysis
• Excellent communication and interpersonal skills and TEMPhas ability to handle multiple tasks; can take initiative to handle responsibilities independently as well as a proactive member of a team.

TECHNICAL SKILLS

Operating Systems: Windows Vista/ XP/ 2003/ 2000/ NT 4.0/ 9x, MS-DOS

Programming Languages: T-SQL, PL/SQL, MDX, C, VB Script, C# .NET, VB .NET

Web Technologies: HTML, XML, XSL, JavaScript, IIS (4.0/5.0/6.0)

Databases: Microsoft SQL Server 2012/2008, MS-Access 97/2000/2003 Oracle 9i/10g

Tools: /Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Visual SourceSafe 6.0, Visual Studio .Net, Microsoft Management Console, DTS, SSIS, Business Intelligence Development Studio (BIDS), Crystal Reports 9.0, ETL

Database Design Tools: MS Visio, Erwin Configuration Clear Case, Clear Quest, Visual Source Safe

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

Application Packages: MS Office, Ms Outlook (Microsoft Office Suite) Portal SharePoint Portal Server 2003, Windows SharePoint Services

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

MSBI Developer

Responsibilities:

• Involved in project planning, gathering requirements from the users, creating spec and layout of the report.
• Used Footprints tickets for version control of thereportsto no the status of thereport.
• Enhance/modify existingreportsby creating new Parameters, Formulas etc.,
• Assist in Business Administration in setting up security for variousreportson Enterprise.
• Responsible for setting up the Database logon info and parameters on Info View for the users to run thereports.
• Retrieved data from Teradata database.
• Create and Maintain Teradata Tables, Views, Macros, Triggers and Stored Procedures.
• Interact directly with the business users in gathering requirements.
• Optimize various SQL queries to make thereportsrun faster.
• Create test data by creating views/procedures for reporting purpose.
• Create and edit alerts onReports, as per User request.
• Generated the ad-hoc data as excel Reports to Users (through Teradata)
• Migratereportsfrom Dev. to Production.
• Provide on call support afterreportsare deployed to production.
• Exportreportsin various formats like MS Excel, PDF, MS Word, Text and CSV.
• Create nested, conditional subgroups and formatting features inreports.
• Create Subreportscalled from the mainreportto implement the business logic.
• Create various database objects like Tables, Views and Stored Procedures by using Toad.
• Responsible for defects raised during testing of thereports.
• Assist UAT team in testing thereportsusing SQL queries in TOAD, SQL developer and Win SQL and advise them with necessary changes.

Environment: XI 3.1, 4.0, IDT, Oracle 10g/9i, PL/SQL, Teradata, SQL Developer, Win SQL, UNIX, Windows XP.

Confidential, Washington D.C

SQL Developer/SSIS

Responsibilities:

• Responsible for gathering and defining user report requirements and developing appropriate interfaces for the reporting infrastructure environment to meet customer business needs, based on business processes and data entities between various systems.
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually
• Developed, monitored and deployed many SSIS packages
• Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler.
• Developed appropriate layout and designs for required reports using the SSRS and Stored procedures to retrieve data from the SQL Server using appropriate SQL language (PL/SQL, T-SQL) to provide optimal performance.
• Worked on server Migration of databases, Permissions, Logins, SQL jobs, SSIS Packages, from one server to another server and preparing the corresponding document for other environments.
• Created Tabular reports, Matrix reports, List reports and Sub reports using SSRS.
• Involved in Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through, and Report Models Drill Down Reports
• Used complex expressions to Calculate, Group, Filter, parameterized and Format the contents of the report according to the requirement.
• Used Conditional Formatting to change the behavior of the report depending on the requirement.
• Developed various Custom Code functions using VB Script.
• Deployed the SSRS Reports to the report server and maintained them.
• Migrated and Converted over 200 Crystal Reports to SQL Server Reporting Services (SSRS).

Environment: SQL Server 2008 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Microsoft Visual studio 2008, Oracle 10g, Crystal Reports, PL/SQL, T-SQL, XML, Microsoft Visual Source Safe, TFS (Team Foundation Server), Subversion, Pivotal Tracker, MS Access 2003 & Windows Server 2003, VB Script.

Confidential, Westborough, MA

SSRS/SSIS Developer

Responsibilities:

• Loaded legacy source data from MSSQL, MySQL, Oracle, Access, and SQL Server DB’s into SQL Server 2008 R2 staging DB’s using SSIS Import &Export Wizard and VB scripts, SQL Server Migration Assistant (SSMA) and SSIS packages.
• Worked on Health Data Conversions for NFL (National Football Leagues) and SeaWorld. Generating on demand reports using eBO reporting using SSRS and adhoc reporting using report builder feature in SSRS.
• Maintaining and supporting the existing reports as per the requirements in the customer support portal. Worked on Maintaining, Generating Reports and Data Migration for various Hospital Database systems using SQL Server 2008, SSRS, SSIS, MySQL and vb.
• Participate in creating data conversion and migration strategy, conversion design and conversion development documents. Participate in Data Modeling Sessions. Hosted SSIS, SSRS noledge transfer, data quality issue meetings with the client on a weekly/biweekly basis.
• Improved the performance of SSRS reports by tuning the Stored Procedures and TSQL queries using various join conditions. Generate experience in converting Actuate reports into SSRS. Created XML, PDF, EXCEL files using SSRS.
• Created stored procedures and SQL statements for generating Ad-hoc Reports in SSRS. Used dynamic connection managers using SSIS expressions to load data from 25 databases into a single DB.
• Deployment of SSIS packages to the conversion server and create and schedule SQL Server Agent jobs to automate the run of SSIS packages on a weekly basis. Experience in creating master and child packages, using package configurations (XML, SQL Server) and SSIS logging.
• Performed SQL Server DBA tasks like Conversion DB backups using compression, restore and disk space management on the conversion server, disabling and enabling constraints and triggers, applying DB Change requests, lookup data changes in corporation, logins & permissions. Created linked servers to write validation queries against the source and target present on different servers.
• Involved in the entire conversion lifecycle stages of Requirement Analysis, Data Profiling, Logical and Physical Data Mapping, Strategy, design, development, Unit testing, conducting conversion mock runs to provide data for the Development DB, SIT, UAT, Data Reconciliation and validation.
• Documentation of Business Rules, Data Mapping Spreadsheet, Meeting Minutes, Key decisions from the client, SSIS and SSRS introduction material to the client.
• Worked with Managers to prepare requirements gathering documents and quality documents.

Environment: SSIS 2008/2012,BIDS,SQL Server 2008R2, T-SQL, Visual Basic .Net, Vb6, XML, eManager, eBO reporting, Microsoft Project, SVN, Core Java, Microsoft Access, SSRS, Microsoft Excel, QAS.

Confidential, PA

MS SQL Developer/SSRS/SSIS

Responsibilities:

• Gathered business requirements by interacting with the Business Analysts. Installed and Configured SQL Server 2005. Configured the Window Server for required Service Packs.
• Developed Database Objects such as Tables, Views, Stored Procedures, Functions, and Triggers using SQL Server Management Studio (SSMS) and T-SQL statements to implement complex business logic. Designed and implemented Stored Procedures and Triggers for automating tasks.
• Created Indexes and performed Index Tuning using Index Tuning Wizard for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, statement & using the TOP operator to limit the Select Statement in certain Queries.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Worked on Report generation using SQL Server Reporting Services (SSRS) that could be used to send information to Compliance Group, Order Flow management (OFO) Group, Network Planning Group, TN Management Group etc.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server. Integrated ASP.Net pages with SQL server Database. Designing and building data load procedures using MS SQL Server.
• Generated Sales Ranking reports using SQL Server Reporting Services for different subjects. Documented all the procedures and processes for future references.

Environment: MS SQL Server 2005, SSRS 2005, SSIS 2005, Windows Server 2003, PVCS, Citrix, Windows XP, Erwin 7.1, MSMS, MS Visual Studio 2005, ASP.Net, Xml.

Confidential, Charlotte, NC

MS SQL Server SSIS/SSRS/BI Developer

Responsibilities:

• Involved in all the phases of SDLC.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various types of Constraints and Triggers for Data Consistency.
• Used Stored Procedures for updating Servers.
• Used DDL and DML Triggers, Stored procedures to check the Data Integrity and verification at early stages before calling them.
• Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data Ware House.
• Developed, deployed and monitored SSIS Packages. Involved in creating log files for SSIS packages.
• Created SSIS Package configurations for executing in different environments.
• Enabled Check points in SSIS package. Created break points in order to view the status of data, variables and over all status of SSIS package.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Developed and Deployed different types of Reports like List, Matrix, and Chart and Sub Reports etc.
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created/ Maintained clustered/ non clustered Indexes for fast and efficient reporting process.
• Used SSRS to create interactive reports with an ability to drill down into details.

Environment: .NET 3.0, MS SQL Server 2005, SSIS, SSRS, T-SQL,Visual Studio 2005, MS Office 2003, SQL Profiler, Windows 2003/2008.

Confidential

SQL/SSRS Developer

Responsibilities:

• Administered and enhanced SQL Server Reporting Services (SSIS).
• Being a member of BI development and reporting team, involved in writing lots of reports incorporating business logic and user requirement.
• Involved in building huge number of reports using multivalve, single valued and dependent parameters.
• Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler.
• Developed reports using complex TSQL queries, User Defined Functions, store procedures and Views
• Involved in Installation, Configuration of SSRS Reporting server and involved in Deploying reports.
• Used VB.Net, VB Scripts for loading data using SSIS Packages.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Involved in designing sub reports and linked reports depending on the user requirement and in order to limit the number of Data Sources.
• Involved in building huge number of reports using multivalve, single valued and dependent parameters.
• Involved in Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through, and Report Models Drill Down Reports
• Involved in writing C# scripts for script task in SSIS.
• Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS
• Deployed reports across Test, Development and Production Environments

Environment: T-SQL, PL/SQL, MS SQL Server 2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS), Windows XP, Crystal Reports 9.0, Oracle9i, C#.