SUMMARY

• 8+ years of extensive experience in Databases and BI Solutions using Microsoft Technologies.
• Strong Knowledge in all phases of Software Development Lifecycle and design through programming, documentation, project management, configuration management, installation and implementation.
• Expertise in Database design and development of applications using SQL Server 2000/2005/2008 R/2012, Reporting Services (SSRS), Integration Services (SSIS),Analysis Services (SSAS), OLAP Cubes, Star and Snow flake schema.
• Involved in Database Design, Data Modeling, Development, Programming, Implementation, ETL and Reporting in SQL Server 2000/2005/2008 /2012.
• Extensive hands - on experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using MS SQL Server 2000/2005/2008 .
• Extensively worked logical & physical Data modeling, data architecture design, Normalization and De-Normalization techniques for both OLTP and OLAP (Star Schema/Snowflake schema) using DM tools like ERWIN, Visio, SQL Diagrams
• Involved in designing numerous DB Objects like Tables, Constraints (Primary Key, Foreign Key, and Unique), indexes, defaults rules, synonyms and assemblies.
• Involved in writing Complex Queries, heavy stored procedures, Batch Scripts, Triggers, Functions, Views using SQL.
• Experience in Writing Complex T-SQL Queries, Dynamic-queries, sub-queries, Complex joins.
• Tuning the performance of Stored Procedures and large T-SQL Queries using Clustered Indexes, Efficient Coding standards.
• Data migrating (using ETL tools like DTS, BULK INSERT, BCP) between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Highly experienced in whole cycle of DTS/SQL server integration services Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008 /2012), use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using SQL Server Analysis Services (SSAS)
• Expertise skills in creating OLAP cubes, calculating measures and dimension members in SQL Server Analysis Services (SSAS 2005/2008/2012 ) using multi dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Developed cubes using Partitions, KPI’s, and Perspectives, slowly changing dimensions etc and created various user roles.
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Creating and Managing users, roles and assigning necessary permissions
• Created Dashboard/Scorecard pages in SharePoint Server/MOSS 2007/Performance point server dat use different types of web parts and excel services for reports
• Experience wif Implementation and maintenance of Business Intelligence tools for analysts and executive dashboards.
• Excellent communication and interpersonal skills and has ability to handle multiple tasks which can take initiative to handle responsibilities independently as well as a proactive member of a team.
• Good team player wif problem solving, troubleshooting capabilities, Software Installations, Server Configurations, documentation and follow up skills.
• Ability to adapt fast to changing technologies.

TECHNICAL SKILLS

OPERATING SYSTEMS: Windows XP/ 2000/2003/2008/ NT 4.0/9x/Vista and MS-DOS, UNIX.

RDBMS: MS SQL Server 2000/2005/2008 /2012, MS Access 2000/2003/2005 Oracle8i/9i/10g/11i, IBM-DB2.

LANGUAGES: T-SQL, PL/SQL, MDX, C, ASP.net, VB.net, C# (.NET).

WEB TECHNOLOGIES: HTML, XML, XSL, JavaScript, IIS (4.0/5.0/6.0).

TOOLS: AND PACKAGES: SQL Server Management studio, Enterprise Manager, Profiler, SQL Server Business Intelligence Development Studio (BIDS), DTS, SSIS, Crystal Reports9.0, Informatica 6.x, Visual SourceSafe6.0, Team Foundation Server, Visual Studio .NET, ETL, ProClarity.

DATABASE DESIGN TOOLS: Erwin and PowerBuilder

BI TOOLS: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), Business Intelligence. Development Studio (BIDS), Visual Studio, Crystal Reports, Cogno’s, Hyperion.

APPLICATION PACKAGES: Microsoft Performance Point Server 2007, Microsoft Office SharePoint Server (MOSS) 2007/2010.

PROFESSIONAL EXPERIENCE

Confidential, NYC (NY)

SQL/BI (SSIS/SSRS) DEVELOPER

Responsibilities:

• Worked wif various upstream and downstream systems and customers in interfacing various systems for Data extractions, ETL, Analytics and reporting needs.
• Involved in writing stored procedures for both Online and Batch requests handling business logic and Functionality of Various modules.
• Worked on developing Tables, Indexes, Views, Creating complex stored procedures, Triggers and Functions.
• Involved in source Data Analysis, Design and Creation of Data Mappings for Extraction of bulk data from heterogeneous sources like Oracle, ADSI and other OLEDB data sources.
• Extracted data from various sources like SQL server 2005/2008, Oracle, CSV, Excel and text file from various systems and through FTP.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and load the Data from various Databases using SSIS.
• Scheduling and Maintaining SSIS Packages and batch jobs through SQL Server Agent and using Shell Scripts, VB Script and batch (.bat) files on a day to day basis.
• Experience in configuring wif checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Designing Enterprise reports using SQL Server Reporting Services (SSRS 2008/2012) and Excel pivot tables based on OLAP cubes which make use of multiple value section in parameters pick list, cascading prompts, matrix dynamic reports and other features of Reporting services.
• Built Drill Down, Drill through, linked and sub reports using SSRS 2008.
• Designed and developed Actuate reports.
• Developing OLAP cubes by identifying tables (fact and dimension), data source and data source views, attributes and dimension members using SQL Server Analysis Services (SSAS).
• Developed many MDX queries for creating measures dat fits business logic.
• Worked on Key performance Indicators (KPIs), design of Star schema and snowflake schema in Analysis Services (SSAS)
• Published reports on to the SharePoint and created Web parts in SharePoint to show various reports generated from Excel and SSRS in one web part page
• Created SharePoint forms to show live data from underlying data-sources like SQL Server to Clients enabling them to edit the data and update the data in the underlying data-sources and allowing the users to insert data into the underlying data sources.

Environment: MS SQL Server2005/2008R2/2012, SSIS 2005/2008,2012, SSRS 2005/2008/2012 , SSAS, XML, BIDS, MS Project, MS Access 2000 and Windows 2k platform, SharePoint 2007/2010, Visual Studio, Crystal Reports, VBScript.

Confidential, JACKSONVILLE (FL)

BI/SQL DEVELOPER (SSRS/SSIS/SSAS/SQL)

Responsibilities:

• Involved in Data Warehouse POC and development starting from inception to implementation and ongoing Support.
• Involved in Designing architecture of the EDW, Logical & Physical Data modeling, data Dictionary mappings.
• Involved in writing various DB Objects like User defined functions, Views, Instead of triggers, Usage of Indexes for accomplishing various tasks.
• Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, and Query Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS.
• Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by Performing different kinds of transformations like Lookup Transformations, Merge Joins, Fuzzy Look Ups,Derived Columns, Merge, Join, Conditional Split, Data Conversion wif Multiple Data Flow tasks.
• Created Package Configurations, Event Handlers for On Error, On Warning, On Task Failed Event Types Designed Complex Packages wif Error Handling and Package Logging dat stores the Logging results in SQL Table and log files.
• Involved in Automating SSIS Packages using SQL Server Agent Jobs, Windows Scheduler, and third party Tools.
• Involved in Monitoringand troubleshooting complex packages by using Data Viewers Grids, Debugging and Maintenance of ETL packages and ETL optimization using SQL Server best practices.
• Configured, Installed and Administered Reporting Services 2005/2008.
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through/Drilldown Reports and Created Large Number of Report Models for users to create their own reports.
• Deployed the solutions on Web Server, Involved in Creating User Security and Roles In Reporting Services at both Parent Level and Report Level.
• Created Report Email Subscription using Data Driven and Time Driven ReportSubscriptions.
• Worked on Dimensional Data Modeling using Star and snowflake schemas for Fact and Dimension tables.
• DevelopedOLAP Cubes by using SQL Analysis Services (SSAS)and and defined Data Sources, Data Source Views, Dimensions, Measures, Hierarchies, Attributes, Calculations, KPI’s, Perspectives and Roles.
• Extensively involved in theSSAS storagemethods (MOLAP, HOLAP, and ROLAP), partitions, andaggregations, calculation of queries, Data Mining Models, developing reports using MDX and SQL.
• Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Written MDX Scripts in order to create datasets to perform reporting and included interactive drill down Reports, report models, KPI’s and Dashboard/Scorecard reports.
• Created and modified Dashboard pages in SharePoint server dat use Excel Web Access web parts and reporting services web parts and Used Excel Services for reports and web parts.
• Used Team Foundation Server to store, run, view, edit and revert back to different versions of the design and development phases.
• Provided documentation about database/data warehouse structures and Updated functional specification and technical design documents.
• Involved in code reviews, change control and auditing procedures.

Environment: T-SQL, PL/SQL, MS SQL Server 2005/2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), ETL, MS Excel, Team Foundation Server, Windows Server 2003/2008, Oracle9i, VBScript.

Confidential, NJ

SQL DEVELOPER (SSRS/SSIS/ SSAS/SQL)

Responsibilities:

• Analyze client requirements and translate them into technical requirements.
• Involved in writing various DB Objects like User defined functions, Instead of triggers, Usage of Indexes.
• For accomplishing various tasks, worked on Performance tuning queries by looking at the Indexes, Appropriate joins, Query Statistics and Execution plans.
• Created SSIS/DTS Packages from various heterogeneous source systems like Oracle, SQL Server, Flat Files and Excel Spreadsheets into the destination databases for Dashboard Reporting on a daily basis
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) Scripts.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS Packages using checkpoints.
• Created master ETL packages wif multiple packages and scheduled them to execute based on the given requirement time.
• 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.
• Developing OLAP cubes using SSAS 2005 and calculates the metrics dat were revealed in the functional analysis.
• Worked on creating calculated measures dat fits business logic, using MDX queries.
• Handling Initial and Delta loads and processing Cubes across all environments.
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Involved in writing lots of reports incorporating business logic and user requirement.
• Created stored procedures to use as the datasets for the Report Design.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Designed ad-hoc reports, grouping and sorting using SSRS and Crystal Reporting 9.0.
• Involved in designing sub reports and linked reports depending on the user requirement and in order to limit the number of Data Sources.
• Developed Complex SSRS Reports involving Sub Reports (Matrix/Tabular Reports, Charts and Graphs).
• Created huge number of report models for users to build their customized reports.
• Configured report subscriptions like Time Driven and Data Driven subscriptions.
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint Integrated SQL Server Reporting Services wif Microsoft Office SharePoint Server (MOSS).
• Created Scorecards based on Key Performance Indicators (KPI’s), and generate KPI Score-card dashboard and pivot tables/charts for decision making, data mining.
• Deployed and uploaded the SSRS reports to SharePoint Server/ProClarity for the end users to look at them.
• Creates technical specifications, test plans and test data to support ETL processes.
• Helped the users to test the reports created and optimized the performance of the end reports getting data from SQL server Databases and SQL server analysis services.

Environment: MS SQL Server 2005, SQL Server Analysis Services (SSAS), Reporting Services (SSRS 2005), Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), Data Transformation services (DTS), ETL,MDX, Microsoft Office SharePoint Server (MOSS) 2007, Performance Point Server 2007, ProClarity, Microsoft.NET (Asp .NET, C# .Net), Visual Source Safe, Toad, Oracle 10g.

Confidential, CINCINATTI (OH)

SSRS/SSIS/SQL DEVELOPER

Responsibilities:

• Gatheird and documented business requirements, Security requirements, Enterprise Data Sources and External Data Feeds.
• Designed Technical Architecture (Dimensional Modeling, Physical Design, ETL Development) Designed Snowflake Schema based on the assessment for end user reporting and Analysis needs.
• Developed Business Analysis Applications and Ad-Hoc/Custom reports using SSRS 2000/2005.
• Migrated Oracle 10g Databases, PL/SQL Scripts to SQL 2000/2005.
• Installed SQL 2005 and all necessary tools in the Development, Staging, and Production environments.
• Installed and utilized the Oracle 10g .Net Data Provider for use wif SQL 2005 and VS.Net 2005.
• Upgraded SQL 2000 DTS (ETL) to the new SQL Server Integration Services SQL 2005 (SSIS) format.
• Designed Complex SSIS packages interfacing SQL wif Oracle 10g.
• Extensive use of T-SQL DDL and DML commands for various applications.
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, TSQL Scripting.
• Expert in implementing an extra level of security by creating views and creating stored procedures to query the confidential data.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the Performance of databases.
• Experience in optimizing the database by creating various clustered, non-clustered indexes and indexed views.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Migrated Crystal reports to SSRS reports. Also Created Parameterized reports and linked reports using Bookmark links, Drill through links and Hyperlinks.

Environment: MSSQL Server 2000/2005, Windows server 2003, Business Intelligence Development studio (SSRS and SSIS), Microsoft.NET, MS Office Access 2003, VBScript, Erwin, and Visual Studio 2005.

Confidential, NJ

SQL DEVELOPER (SSRS/SSIS/SQL)

Responsibilities:

• As a member of Database and BI Reporting team, extensively worked on T-SQLs, Data loads and Reports.
• Determined the MS SQL Server 2000 installation options. Installed SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server and implemented different security modes.
• Installed and maintained database applications to improve processing performance including applying upgrades, patches, and bug fixes in all database instances.
• Used Aggregation Design Wizard to decide best possible aggregation for a given amount of disk space in MS Analysis services 2000.
• Experience in DTS for data flow from source files like Excel, Tables, and Views to other databases or files wif proper mapping.
• Implemented a successful security plan by creating statement permissions, linked servers and encryption of connections by creating certificates.
• Experience wif Distributed transactions building linked servers, complex queries, error handling using SAVEPOINT in OLTP transactions.
• Creating Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones.
• Developed DTS Packages to transform data to MS SQL Server from Excel for further analysis.
• Configured Database Mail, created operators, jobs and alerts for automating databases.
• Experience in creating, debugging DTS packages using Active X Task, dynamic properties task to for file check, sending mails upon package completion, and file archiving.
• Designed DTS package, wif DTS Import/Export wizard for transferring data.
• Data migration (Import & Export - BCP) from text to SQL Server.
• Applied schema change scripts to existing objects to synchronize wif changing business rules by adding or enhancing relevant entities/tables, columns etc.

Environment: T-SQL, MS SQL Server 2000 Enterprise Edition, Enterprise manager, MS Analysis Services 2000, MS Access 2000 & Windows NT platform, Reporting Services, Crystal Report 8.0, DTS.

Confidential

JR.SQL DEVELOPER

Responsibilities:

• Installation, configuration the MS SQL Server 7.0 and maintenance of servers in various environments.
• Performance and tuning of SQL servers and application issues related to migration.
• Testing of applications for performance, data integrity and validation issues.
• Data Transfers between various servers using BCP and Managing Disk space on NT systems.
• Used DTS for data flow from source files like Excel, Tables, and Views to other databases or files wif proper mapping.
• Designed DTS package, wif DTS Import/Export wizard for transferring data.
• Data migration (Import & Export - BCP) from text to SQL Server.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Complete automating on NT so dat the tasks are run wifout user monitoring.
• Writing the stored procedures, checking the code for efficiency. Routine backups and restoration.
• Develop and maintain in-house utilities to automate problem determination, change implementation and monitoring activities.
• Administrative and Production support for various applications in all environments.
• Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans. Testing and implementing these procedures.

Environment: SQL Server 2000, Query Analyzer, SQL Profiler, Windows 2000 Server, Import & Export Data.