SUMMARY

• Around 8 years’ experience in Database Design, Development and maintenance of database applications on SQL Server 2000/2005/2008/2008 R2/2012 in OLTP/OLAP/BI environment.
• Conducting the basic and advanced bootcamp to make business partners self - sufficient in MDM implementation.
• Helping business partners in there POC’s and give them direction to solve given use case scenario in Infosphere MDM.
• Reviewing MDM strategy for business partners and suggest them the best approach depending on the requirements.
• As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Experience in developing complex store procedures, efficient triggers, required functions, creating indexes and indexed views for performance.
• Excellent Experience in monitoring SQL Server Performance tuning in SQL Server 2000/ using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
• Experience in creating jobs, SQL Mail Agent, Alerts and schedule DTS/SSIS Packages.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence and writing MDX Scripting.
• Good experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, Deploying and Processing SSAS objects.
• Experience in creating Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through And Cascading reports using SSRS.
• Strong experience of SSAS and dimensional modeling. Expert in creating and modifying SSAS cubes (dimensions, facts, members, calculations) and in-depth knowledge of MDX query language.
• Experience in creating reports by using ProClarity Views and Dashboards strategy.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

TECHNICAL SKILLS

RDBMS/DBMS: Microsoft -SQL Server 2008/2005/2000/7.0 , Oracle 8i & 9i, 10g, MS Access.

BI /Data model Tools: Microsoft SQL Server Reporting Services 2005/2000, Crystal Reports, DTS, SSIS, Erwin And Visio.

Operating Systems: Windows 9x/Windows 2000/Windows NT/ Windows Server 2003/Windows XP, IIS 5, 6

Programming Languages: T-SQL, PL/SQL, C, Visual Basic 6.0, VB Script, SQL * Plus, VB .NET, ASP .NET, C#, HTML, Linux, Unix.

Application Packages: MS Office, MS Outlook.

Database Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio, Visual Studio .NET 2005, SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), ODBC, OLAP, MOLAP, ROLAP, OLTP, DBCC, AS 400, BCP

PROFESSIONAL EXPERIENCE

Confidential, Jersey city, NJ

MS SQL BI developer/ SSIS/SSRS

Responsibilities:

• Involved in Designing, Developing and Testingof the ETL(Extract, Transformation and Load) strategyto populate thedatafrom various source systems feeds usingSSIS.
• Responsible for Brokerage Account Operational Management Batch: (.NET Batch& WCF)
• Developed a standalone .Net application which is responsible for identifying and processing account related data using New Account Opening (NAO) application.
• Performed account/customer maintenance using Account Maintenance (AM)and Beta Back Office (BBO) tools.
• Responsible for development of Brokerage Analysis Portal: (Web Application).
• Applied Multithreading techniques for creating high performance applications.
• Developed a web portal which became an integral business component of the Hogan Web Application.
• Developed system to Generate reports from Account/Customer Audit History, Account/Customer Maintenance and Transaction Inquiry tracking account failures and correcting errors for further processing.
• Analyzed and designed new .NET Web, Batch and WCF application from design to completion stage.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for codingSSISprocesses to import data into the Data Warehouse fromExcelspreadsheets, Flat Filesand OLEDB Sources.
• Involved in building and maintainingSSIS Packagesto import and export the data from various data sources usingBIDSbased on the design data models.
• Worked on various tasks and transformations likeExecute Sql Task, Execute Package Task, and Conditional split, Script Component, Merge and Lookupwhile loading the data into Destination.
• Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.
• Responsible for creating datasets using T-SQL and stored procedures.
• Responsible to support SQL Servers with ever-changing workloads, and achieving some level of predictable performance (or minimizing variance in plans and performance).
• Responsible for Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups
• Developed dimensions and fact tables based upon the requirements and based on these facts and dimensions, designed SSAS cubes
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Built data connection to the database using C#.
• Knowledge of developing reports from Cubes using the KPI’s for decision making, also debugged data connections, data sources and Data Source Views.
• Creating Ad Hoc and Parameterized various Reports using SQL server 2008 R2 / 2012 Reporting Services.
• Develop and implement web applications using HTML, Javascript, ASP and SQL Server stored procedures.
• Created MDX queries to extract data from the Data Mart.
• Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non queried parameters).
• Developed manyMDXqueries for creatingcalculated measuresthat fits business logic.
• Involved in designing and developing Data Warehouses, Data marts andBusiness Intelligenceusing multi-dimensional models such asStar SchemasandSnow Flake Schemafor developing Cubes using MDX.
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Have used BCP, BULK INSERT to transfer data from and to SQL server database
• Implemented security to restrict the access to users and to allow them to use only certain reports.

Environment: MS SQL SERVER 2008 R2, SQL Server 2012, MS SQL Server 2005/2008, SSIS, SSRS, Microsoft Visual Studio 2008, SQL Profiler, T-SQL, MDX, C#, HTML, SSAS, Microsoft Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential, Chicago, IL

SQL BI Developer

Responsibilities:

• Involved in gathering the user requirements.
• Involved in physical and logical data modeling using Erwin along with the architects.
• Created stored procedures, triggers, Joins, functions and views.
• Created SQL server Reports using SSRS 2008.
• Created Cross-Tab, Drill-down, Drill-down and Sub-Report using and linked reports using SQL SERVER Reporting Services.
• Identified the data source and defining them to build the data source views.
• Debugging reports and deploying reports.
• Involved in SSRS report deployment and report server configuration.
• Developed various types of reports like drill down, matrix, cross tab, ad hoc, Parameterizedand cascading parameterized reports using SSRS.
• Created Tabular reports, Cross Tab Reports and Sub Reports.
• Created SSIS Packages to import and export data from Excel Spreadsheets, Text files and CSV files.
• Scheduled the reports to run automatically.
• Launching the report builder for adhoc reports.
• Configuring the report viewing security.
• Created schedules and subscriptions.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring during execution
• Manage security, backup and restore on MS SQL Server databases and AS400 and iSeries systems.
• Created SSIS packages to migrate data from Oracle DB to SQL Server 2008.
• Data migration (Import & Export using BCP) from text to SQL Server 2008.
• Retrived data from SQL Server and AS400 to create different financial reports.
• Creating Stored Procedures for reports generation.
• Involved in database backup, recovery procedures
• Planned back up strategy for disaster recovery
• Responsible for log backups and restoration
• Worked with Dynamic Management Views (DMV) for improving query performance.
• Analyzed the existing application programs and tuned SQL queries using Execution plan, Query Analyzer, SQL Profiler and database Engine tuning Advisor.
• Proficient with SQL server agent for scheduling jobs, SQL profiler for database tuning
• Created and used tables, views, indexes, stored procedures, triggers, used joins to retrieve data from tables
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, tables, and views and other SQL joins and statements for applications.
• Designed and implemented stored procedures and triggers for automating tasks.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Tested applications for performance, data integrity and validation issues.

Environment: MS SQL Server 2005/2008, MS SQL Server Reporting Services 2005, AS400, T-SQL, C#, HTML, Windows 2003 server.

Confidential, Phoenix, AZ

SQL Server/SSRS /SSIS/ Server Developer

Responsibilities:

• Involved in database development using stored procedures, triggers, views and cursors.
• Involved in creating Indexes for faster retrieval of data.
• Maintained data integrity by performing validation checks.
• Involved in running the SQL Profiler for better execution Plans.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Scheduled Automated jobs using SQL Server Agent.
• Imported data from various sources into a staging area, merges the data into the OLTP data model, and presents it to all levels of users.
• Added Script and lookup components using C#.
• Used SSIS in importing data from XML files.
• Monitored the performance and optimized SQL queries for maximum efficiency.
• Developed SSIS solution for developing a fully fledged data warehouse solution
• Monitored and deployed SSIS packages and involved in notification services, error handling.
• Developed many asp.net web applications using SQL Server and C#, to provide solutions for company wide needs. (ASP.NET, C# Windows apps, C# console Apps, SQL Reporting Services)
• Interrogated Active Directory with C# to use existing user data.(C# console app) Grabbed data from distribution lists and copied to our Data warehouse in SQL server.
• Identified the database tables for defining the queries for the reports.
• Assisted in migrating de-normalized report DB into a Star Schema design
• Responsible for creating the reports basing on the requirements using SSRS2005.
• Deployed the generated reports on to the server.
• Involved in Fine tuning of database objects and server to ensure efficient data retrieval.
• Extensively involved in theSSASstorage and partitions and Aggregations, Calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL.

Environment: SQL Server 2008, DBA, C#, MDX, ERWin 4.0, HTML, MS Outlook, FTP, TSQL, Windows 2003

Confidential, NY

SQL Server / SSIS /SSRS Developer

Responsibilities:

• Involved with Installation, Upgrade and Troubleshooting of MS SQL Server 2005.
• Created Complex Stored Procedure, Triggers, Cursors, Tables, Views and other T-SQL JOIN techniques.
• Designed, Developed and maintained Relational databases.
• Extensively involved with Database Space Management, Performance.
• Involved with tracing activities using SQL Profiler.
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Responsible for SSIS activities to move data from text files to SQL Server.
• Scheduled SSIS Packages daily and weekly Basis.
• Extensively involved in knowledge transfer for the documentation team for the development activities carried out by team.
• Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Created calculated measures and dimension members using multidimensional expression (MDX), mathematical formulas, and user-defined functions.
• Developed MDX expressions for cube calculations and Key Performance Indicators (KPIs).
• Extensively involved with the development team in carrying out the Unit testing of the applications and tuning of complex procedures.
• Involved in Planning, development, and testing of disaster recovery strategies and procedures to restore the production environment to a production state.

Environment: Windows 2000 Advanced Server, MDX, SQL Server 2000, 2005, MS Outlook, FTP, TSQL

Confidential, Berkeley Heights, NJ

SQL Developer (SSIS/SSRS)

Responsibilities:

• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Logical Data Modeling using ER-Win to fit business requirement.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Physical Implementation of database into SQL Server 2000 using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
• Data migration (import & export/BCP) from Text to SQL Server.
• Configured Replication Server.
• Worked on a Terabytes of Data.
• Planned complete Back-up of Database and Restored the Database from Disaster Recovery.
• Generating ad-hoc reports using MS-Excel and Crystal Reports.
• Coordinating post-implementation events such as testing.

Environment: SQL Server 2000, ER-Win, T-SQL, Excel, Access and Windows NT.