SUMMARY

• Over 6 years of experience in Database Development of MS SQL Servers 2000/2005/2008/2012 in Production, QA, and Development environments.
• Extensive experience in MS SQL Server 2005,2012 wif Business Intelligence in SQL Server Reporting Services and SQL Server Integration Services
• Very good understanding of SQL Server Architecture design.
• In - depth noledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
• SQL Server 2000/2005 RDBMS database development including T-SQL programming.
• SQL Server 2005 OLAP database development including KPIs, Data mining, working wif changing dimensions
• ETL implementation using SQL Server Integration Services (SSIS)
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, user defined data types and functions
• Good ETL skills, Data modeling, Dimensional Modeling noledge wif experience in developing data movement, data cleansing and data integrity processes for teh purposes of loading decision support applications utilizing advanced noledge of DTS packages and Transact SQL, design and support/enhancements/maintenance
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using MS SQL Server DTS and SSIS
• Developing reports on SSAS & SSRS on SQL Server (2000/2005). Sound Experience and understanding of SSAS, OLAP cube and Architecture
• Expert in creating SQL Server Reports using SSRS 2005 in designing stylish report layout parameterized, performance, Chart Reports, ad-hoc reports.
• Expert in creating teh MDX cubes and dimensions.(SSAS)
• Experience wif working on ProClarity Analytics server to analyze results produced in teh Dashboard
• Worked in Data modeling, creating star and snowflake schemas in SSAS
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Experience in creating indexed views, complex stored procedures, TEMPeffective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Involved in DBA activities such as backups, restores, replication etc.
• Experience in report writing according to teh business requirement in SSRS.
• Very good experience in Installation, configuration and maintenance of SQL Server.
• Strong experience in design and construction of data marts, data views and data mining
• Experience in backup and disaster recovery procedures and creating packages, Jobs, Sending Alerts using SQL Mail. Used Microsoft Source Safe for version control and configuration management.
• Excel miner tool (For Data Mining Techniques and Analyzing Data),POM QM, @risk(simulation tool) Microsoft Excel wif solver plug-in.

TECHNICAL SKILLS

Platforms: Windows 95/98/Me/XP/NT/2000 server/XP/2003 server/Vista, Linux, UNIX

Langu2ages: C, C++, SQL,T-SQL, PL/SQL, JAVA

RDBMS: Microsoft SQL Server 2000/2005/2012/2014 , MS Access, Oracle 10g

IDE: Microsoft Visual Studio 2003/2005/2012/2014

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, Export & Import (DTS), SSIS, SSAS, SSRS, Database Tuning Advisor, SQL* Plus

Web Technologies: HTML

Other Tools: Erwin, MS Visual SourceSafe, VERITAS Backup Exec 10, MS Office suite, MS Visio, SPSS, Excel Miner, @Risk

PROFESSIONAL EXPERIENCE

Confidential, City of New York, NY

ETL/ SQL BI Developer

Responsibilities:

• Participated pro-actively in analyzing teh telephonic systems and their IVRS call-flows to identify missing data points.
• Developed mock up reports for client services wif best possible metrics and addressed teh discrepancies and assisted in getting them approved from teh client.
• Initiated group meetings to fix around teh technicalities of point source of data.
• Participated and contributed actively to teh development of OLAP layer in building teh Agent-Analysis cube and worked on extracting teh statistics around cube from Microsoft Dynamics CRM tables.
• Used SSIS (ETL)/SSAS/SSRS in building teh OLAP layer and SSRS wif MDX query for teh development different reports used by Analysts on performance tuning of business, Contact Analysis, KPI, Dashboards, Vendor Analysis etc., Lead Analysis etc.
• Analyzed and created Facts and Dimension Tables using SSAS.
• Created teh Data source connections, Data Source Views, Relationships, Named Query for customized analysis in SSAS.
• Developed multi-dimensional Objects Cubes, dimensions using SSAS.
• Addressed teh data issues around teh missing data points and halped in fixing teh reports on daily basis.
• Generated drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into teh web front end.
• Built ad hoc reports for teh non-technical analysts and also pivot tables for their day to day business functionalities.
• Created various cohorts, weekly and monthly reports, showing detailed information.
• Converted Crystal reports to SSRS reports.
• Created packages in ETL to load ODS tables, package configured and automate to run through teh SQL SERVER Agent.
• Monitored SQL SERVER jobs through SQL monitor and assigned tickets to appropriate departments to load balance and performance tune or any database issues.
• Created stored procedures for new requirements and modified old stored procedures as per teh change in business rules in fast pace to catch up wif teh Client satisfaction.

Environment: MS SQL Server R2/2008/2005 SSIS, SSRS, SSAS, Visual Studio 2009, T- SQL, Windows Server 2008 R2, Sub Version, XML,ADO.NET, VISIO,ERWIN, Crystal Reports, MS-Excel,I3(Interactive Intelligence) Telephonic System.

Confidential, Dallas, TX

SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Designed and developed SQL Server Reporting Services (SSRS) SQL Server 2005/2008.
• Involved in Report writing according to business requirment using SSRS and Crystal Reports.
• Generated database monitering and data validation reports in SSRS.
• Expert in creating Tabular reports, Matrix reports, List report, Parameterized reports, Subreports, Adhoc reports (SSRS).
• Deployed SSRS Reports in SharePoint for web based access for multiple end users.
• Configure teh report server and generated teh report models for user interactions.
• Involved in Partition of cubes in order to increase teh performance of cubes.
• Sound Experience and understanding of SSAS, OLAP cube, Data mining and Architecture.
• Involved in Performance Optimization of Microsoft SQL Server stored procedures, Analysis Services and cubes.
• Used windows Power Shell Script to automate application deployment process.
• Generated dynamic stored procedures, triggers, Cursors, Joins for teh database development.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Used Informatica to Extract and load teh Data as per teh requirement.
• Interacting wif Business users and BA’s to gather requirements for creating ETL Packages and Reports.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using BCP utility, SSIS services.
• Creating SSIS Packages using different type’s task and wif Error Handling.
• Experience in creating complex SSIS Packages wif error handling using control and dataflow elements.
• Fine tuned teh complex database stored procedures to increase performance.
• Performance tuning and optimization of procedures and queries.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.
• Created SSIS Packages to migrate slowly changing dimensions. Scheduling teh SSIS packages and Jobs.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2005.
• Successfully deployed reports in various sources like XML, Web browser and PDF.
• Understanding teh OLAP processing for changing and maintaining teh warehousing, optimizing Dimensions, Hierarchies and adding teh Aggregations to teh cube.
• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.
• Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.
• Expert in writing stored procedures, user-defined types, triggers, table valued functions, and aggregates using a .NET managed language
• Created SQL Server Profiler traces and used wif Database Tuning Advisor (DTA) for optimum performance of T-SQL and MDX queries.
• Created SSIS Packages to migrate slowly changing dimensions. Scheduling teh SSIS packages and Jobs.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Created Analytical reports by ProClarity tool.
• Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to teh business requirement.
• Designing Cubes, Star Schema and Data models for Data Warehousing Applications.
• Experience in Designing and Building teh Dimensions and cubes wif star schema and snowflake schema using SQL Server Analysis Services (SSAS).
• Involved in Unit testing process.

Environment: MS SQL Server 2005/2008, Management Studio(SSMS), ETL, DTS, Notification Services, Crystal Reports9.0, Data Modeling, OLAP, Data ware Housing, MDX, Share point (2003/2007), Asp.Net, T-SQL, SQL Profiler, IIS 6.0, Windows 2003 Advanced Server, SSAS, SSIS, SSRS 2005/2008, community server, Erwin

Confidential, Framingham, MA

SQL Server Developer (SSIS/SSRS)

Responsibilities:

• Creating complex SQL Queries to partition and aggregate teh data based on cookie and session ids of millions of visitors.
• Creation of temporary tables, efficient index mechanisms and optimizing joins to match teh performance expectations of teh system.
• Multiple stored procedures wif transaction processing for different modules.
• Creation of reference tables, mapping of page ids to teh product line categories and teh sources of information.
• Creation of SSIS packages to request a dump of weekly page views from Staples databases to our databases.
• I worked on autanticating users and providing on-demand reports using server-side scripting wif ASP.Net (VB Script). It involved connecting to database, calling queries and stored procedures, displaying forms and tables and implementing means for navigation to different reports.
• Identified teh data source and defined them to build teh data source views.
• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Developed SSIS packages not only for Initial Data Loads but also for incremental/delta loads.
• Created a Log tables to capture teh SSIS events and used it to Perform Debugging of packages.
• Created and scheduled a SSIS package to run our stored procedures to create teh output report tables and regenerate reports automatically on weekly or monthly bases using SSRS 2005.
• Designed and created drill down reports in SSRS 2005.
• Identified and worked wif parameters for parameterized reports in SSRS 2005.
• Designed and developed several Reports using SSRS (SQL 2005 reporting services) according to business requirements.
• SSRS module to request data from output tables, design of report templates, use of bar and pie charts, drill-down and drill-through reports, use of parameters, global variables and functions to generate final reports.
• Designed ad-hoc reports using Report Model and configured using Report Manager.

Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2005, MS SQL Server Integration Services 2005, Windows XP

Confidential

SQL Server/Application Developer

Responsibilities:

• Involved in Data modeling to develop teh database design using Erwin 4.0
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Actively involved in Normalization & De-normalization of database.
• Designed DDL and DML for MS SQL Server 2000.
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types and user defined functions.
• Actively designed teh database to fasten certain daily jobs, stored procedures.
• Optimized query performance by creating indexes.
• Involved in writing SQL batch scripts.
• Wrote T-SQL statements for retrieval of data and involved in performance tuning of T SQL queries and stored Procedures.
• Created joins and sub-queries for complex queries involving multiple tables.
• Developed complex stored procedures to create various reports.
• Configuring, tuning, and optimizing SQL Server 2000.
• Developed complex financial reports using Crystal reports.

Environment: SQL Server 2000/7.0, T-SQL, Stored Procedures, Windows XP, Crystal Reports 9, ASP.NET 1.1, IIS3.0.

Confidential

SQL Server Developer

Responsibilities:

• Involved in Physical / Logical design of database, creating and managing teh database and all teh database objects.
• Created ER diagrams (physical and logical using Erwin) and mapping teh data into database objects.
• Worked wif Implementation team and closely moved wif end users to implement manufacturing solutions.
• Worked closely wif developers, end users and Administrators in designing and creating databases and other objects.
• Actively involved in designing databases for teh system.
• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Configured Server for sending automatic mails to teh respective people when a DTS process failure or success.
• Regularly monitored teh system for bottlenecks for CPU, RAM, Disk IO and Networking
• 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.
• Analyzing teh Database Growth and Space Requirement. Handling Users/Logins/User Rights

Environment: T-SQL, SQL Server 2000, OLAP Services, Windows 2000 Server, Query Analyzer, DTS,MS Access 2000, Oracle, VB.net 2003, Erwin Data Modeler