SUMMARY

• 8 Yearsof extensive IT experience as aMicrosoft SQLServer2000 /2005/2008/2008R2/2012.Developerin creating Business Intelligence Solutions likeSSIS,SSAS, SSRS.
• Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005/2008/2008R2/2012.
• Experience with all phases ofsoftwaredevelopmentlifecycle (SDLC)and project methodologies.
• Excellent skills in implementingETL Packages usingData Transformation Services(DTS) and SSIS2005/ 2008/2008R2/2012.
• MigratedDTS packages to SSIS and modified usingDTS editor wizard.
• Developed a dashboard solution for analyzing STD statistics by building SSIS 2012 cubes and Tableau
• Experience in usingSSIStools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Worked with the Version control Systems likeTeam Foundation Server (TFS), Visual Source Safe (VSS).
• Proficientin usage of SSIS Control Flow items(For Loop, Execute package/SQL tasks, Script task, send mail task)and SSIS Data Flow items(Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Trained and experience in working onSplunkand developing dashboards onSplunkserver.
• Dealt with huge amount of data and usedSSASin order to retrieve the data.
• Extensively worked onErwin Data Model Tooland good knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts.
• Experience in buildingSSIS packages (.Dtsx)involvingETLprocess, extracting data from variousflat files, Excel files, legacy systemsand loading into SQL server.
• Experience in writingMultidimensional Expressions (MDX)and used the MDX queries in the report generation
• Designed and implemented solution to integrateapplications with Partner Companylike GSI,DAXfor more than 36 applications.
• Experience increating Jobs, Alerts, SQL Server Mail Agent, andscheduleusing DTS/SSISPackages.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation ofEvent Handlers, Loggings, Checkpoints, Transactionsandpackage configurations.
• Experience inImporting/ExportingData from various data sources like SQL Server, Excel, DB2 and Flat file usingDTS utility.
• Experience in Designing, Creating,DeployingandProcessing of CubesusingSSAS.
• Good experience in DesigningAggregations and pre - calculating the same inSSAS2005/2008/2008R2/2012.
• Excellent hands on experience in creating groups, hierarchies and measures, KPIs.
• Developed a dashboard solution for IntegratedSAP ECC, SAP BWwith IBM Information Server.
• Expertise in designing complex reports likeDrill-Down Reports,Drill-ThroughReportsandParameterizedReportsusing SQL Server Reporting Services(SSRS)basedonclientrequirement.
• Expert in creatingAd-Hocreports,Linkedreports,Snapshotreports,Cross-Tab, Conditional, Top Nand Sub reports using SQL SSRS.
• Proficient in creatingStandardSubscriptionsandData driven subscriptionsfor delivering reports to people internally within the project.
• Expert in deploying theSSRS reports usingReport manager.
• Built effective queries for high-performance reports and rendered them toHTML, XML, PDF and Excelformats usingSSRS.
• Integration ofSSRS Reportsusing various web parts into Share point (MOSS2007) and various delivery mechanisms.
• Strong experience withCrystal Reports.
• StrongData MappingExperience.
• Administered and optimizedMySQL and SQL Server 2000 databases
• Data modeling experience usingErwinData Modeler andMS Visio.
• StrongASP.NET, VB.NETknowledge.
• Expertise inRDBMSconcepts such as Tables, User Defined Data Types, Indexes, Indexed Views.
• Good experience onQlikviewBusiness Intelligence reporting tool for developing dynamic reports.
• Expert inComplexStoredProcedures,User Defined Functions(UDFs),Triggers, Common Table Expressions(CTEs), Table Variables and Views.
• Extensively usedJoinsandSub-Queriesto simplify complex queries involving multiple tables and established relationships between tables usingPrimaryKey&ForeignKeyConstraints.
• Migrated the MySQL database to SQL Server 2000
• Evaluated database performance and performedmaintenance duties such asTuning, Backup, RestorationandDisaster Recovery.
• DevelopedMDX Scriptsto create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Experience in calculating measures and dimension members usingMulti-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Experience in creatingCell Level Securityin cubes usingSSAS.
• Experience inSQL Optimizingby usingSQL Profiler, Index Tuning Wizard,Database TuningAdvisor(DTA), DBCC Commandsand Query Execution Plans.
• Designed and DevelopedKPIs, Aggregations and Cube Partitions.
• Good Knowledge and working exposure inInformaticaPower Center 9.5
• Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.

TECHNICAL SKILLS

Operating Systems: Windows NT 4.0, Windows 2000 Server, Windows 2000 Advanced Server, Windows 2003 Server, Windows XP, Windows Vista, 7.

Programming Languages: SQL, SQL*Plus, HTML, XML,C,C++, DS, Visual Studio 2005, MDX

Software MS: Office 2010/2007, RDBMS, MS SQLServer 2008/2005/2000SQL Server: Management Studio(SSMS), SSAS, Oracle 9i, MS Access

ETL Tools: DTS, SQL Server Integration Services(SSIS)

Database: Query ToolsMS SQLServer Query Analyzer, SQL Profiler

PROFESSIONAL EXPERIENCE

Confidential, NY

SeniorSQL Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Involved in Planning, Defining and Designingdata,based on business requirements and provided documentation.
• Involved in development and implementation ofSSIS,SSASandSSRSapplication solutions for various business units across the organization.
• Involved in Extraction, Transformation amp; Loading (ETL) process and usedInformaticaPower Center tools - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager and Workflow Monitor
• DesignedData Mappingdocuments,DDL scripts,and DataDictionaryandMetadataof themodelsandmaintainedthem.
• DevelopedSQL scriptsfor administration task.
• MaintainedSQL scripts, indexes, complex queriesfor data analysis and extraction.
• Used .NET provider Data Reader Source Task to Read from RDBMS sources.
• Involved extensively in Functional Testing, System Testing, Integration Testing and Regression Testing and Content Testing, both manually as well as using automated testing tools including Quality Center, QTP, SAP TAO and Load Runner.
• Wrote UNIX Shell scripts forInformaticaETL Tool.
• Manage database and transaction log files, auto loans log files using scheduled script.
• Worked inASP.NETWeb forms, State management and Caching feature.
• MaintainedWCFservices across the enterprise and integrating UI usingMVCpattern
• Developed some codes to work onVisual Studio 2008andTeam foundation server(TFS)also used the same code in SSRS to generate Reports.
• Upgraded MS SQL Server 2008 R2 database to MS SQL Server 2012, by using Detach/Attach, Back up & Recovery.
• Wrote C#,VB.NET Code for Script Task in SSIS 2008
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 AnalysisServices(SSAS).
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts.
• Worked on variousRDBMSssuch asMS SQL Server 2000,Access 2000 and MySQL
• Using the complex SQL queries in Oracle and Teradata in Data Warehousing environment
• CreatedSSIS packagesto extract data fromOLTPand transformed toOLAPsystems and Scheduled Jobs to call the packages and Stored Procedures.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such asConditional Split,Derived Column, which were used for DataSupported in creatingKPI, calculation members and measure groups, and MDX queries
• Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Worked with the Version control Systems likeTeam Foundation Server (TFS), Visual Source Safe (VSS).
• Developed a dashboard solution for IntegratedSAP ECC, SAP BWwith IBM Information Server.
• Experience increating Jobs, Alerts, SQL Server Mail Agent, andscheduleDTS/SSISPackages.
• Developed a dashboard solution for analyzing STD statistics by buildingSSIS 2012 cubes and Tableau
• Experience in configuring and deploying SSRS reports ontoMicrosoft Office SharePoint Server.
• Involved in developing database objects such as procedures, triggers, constraints, indexes and views. Used T-SQL to build dynamic stored procedures.
• Involved in Development of data access, business and Application layer using LINQ,C# AND ASP.NET
• DevelopedSSIS packages for File Transferfrom one location to the other using FTP task
• Used ETL to implement theSlowly Changing Transformation, to maintain Historical Data in Data warehouse.
• UsedTeam Foundation Server (TFS)for source version control on a shared team environment.
• CreatedSub-Reports, Drilldown-Reports, Summary Reports, andParameterizedReportsin SSRS.
• Analyzed the data from multiple sources such asMicrosoft (MS) SQL Server, MS Access, Legacy systems, Mainframes, DB2,SalesForceAutomation (SFA /SaaS),Microstrategy(MSTR), Tableau.
• Generatedad-hocreports using MS Reporting services andCrystal reports.
• Worked onErwin Data Model Tool and good knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts.
• Part of a one week training program forSplunk.
• Involved in creating dashboards and reports for various scenarios.
• Responsible to add data and maintain the data onSplunkServer
• UsedSSRS to create reports, customized Reports, on-demand reports, ad-hoc reportsand involved in analyzing multi-dimensional reports in SSRS. Provided Ad-hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems.
• Createdreports using SSRSfromOLTPandOLAPdata sources and deployed on report server.
• Experienced in creatingSSASOLAP Cubes andPartitioning Cubes.
• Designed and implemented solution to integrate fanatics applications with partner companylike GSI,DAXfor more than 36 applications.
• DefinedCalculated members,named sets, and executed other script commandsusingMDXexpressions.
• Conducted weeklyCrystal Reportstraining session for the reports team
• Created Error and Performance reports onSSISPackages, Jobs, Stored procedures and Triggers.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• PerformedT-SQLtuning and optimization of queries for reports that took longer execution time usingMS SQL Profiler,Index Tuning WizardandSQL QueryGenerated reports using SSRS which were sent to different Clients, and managers
• Performed Documentation for all kinds of reports, DTSandSSISpackages.
• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications by using T-SQL.
• Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
• Evaluated database performance and performed maintenance duties such asTuning,Backup,RestorationandDisaster Recovery.
• Created Linked Servers for data retrieval usingOLE DBdata sources and providers.
• Designed and developed and normalized tables for the MySQL database
• Design and implementation ofstored procedures and triggersfor automating tasks.
• Interacting with the users and troubleshooting the problems involved with the development ofstored Procedures,triggers and problems related to the privileges.
• CreatedViewsto reduce database complexities for the end users.
• Createdprovidedassistance to development teams on Tuning Data, Indexes and Queries.
• Worked on troubleshooting and maintaining large (terabyte-size) clustered databases.
• Created Functions, Stored Procedures, Database Triggers
• Createdchecks and constraintsto maintain data integrity.
• Involved inDe-Normalizationof existing tables for faster query retrieval.
• Involved in development, enhancement, testing andperformance tuningof the application.
• DevelopedMulti-dimensional Objects (Cubes, Dimensions) using MS Analysis services (SSAS).
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment:Windows 2003 Server/XP, C#, SQL Server 2008/2005, Teradata, SSAS, SQL Integration Services(SSIS), SQL Reporting(SSRS), Business Intelligence Studio, Visual Studio 2008/2005, Team foundation Server, Tableau, VB.NET, OLE DB, DTS Package, SharePoint MOSS 2007, Crystal Reports, Erwin 4.0, VB.Net, HTML.

Confidential, Jersey City, NJ

SQL Developer/MSBI Developer (SSIS, SSAS, SSRS)

Responsibilities:

• ConductedData Migrationprocesses in the SQL Server environment using SQL Server Integration Services 2005.
• Conducted and automated theETL operationsto Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, and dataintegrity.
• Designed Web-based ASP.NET and C# Internet applications linked to firm wide SQL Databases.
• Used differenttransformationslike Conditional Split, Lookup, Merge Join, Aggregate, Fuzzy Grouping etc. for creating manySSISpackages.
• Created many Variables that were used to pass parameterized values into the package which makes the package Dynamic.
• Created logical and physical database design using Erwin.
• IntegratedSAP ECC, SAP BWwith IBM Information Server.
• Designed many Configuration files that were used to pass parameters from outside the Business Intelligence Development Studio(BIDS)into the packages usingXMLfiles.
• Wrote C#,VB.NET Code for Script Task in SSIS 2008
• Used MicrosoftVisual Source Safe (VSS)andTeam Foundation Server (TFS)for integration, maintenance and Security of code.
• Developed a dashboard solution for analyzingSTD statistics by building SSAS 2008 cubes and Tableau
• Ensured best practices are applied and integrity of data is maintained through security and documentation.
• Good experience onQlikviewBusiness Intelligence reporting toolfor developing dynamic reports.
• Hands on experience in developingQlikViewDashboardsusing Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar etc.
• Used .NET provider Data Reader Source Task to Read from RDBMS sources.
• Worked in ASP.NET Web forms, State management and Caching feature.
• Conducted Testing in many multi-layer data warehouse on Teradata systems.
• Designed Incremental Load Packages which were used to load the updated and new data into the Enterprise Data Warehouse without removing the existing data.
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions Worked with different methods oflogginginSSIS.
• Designed and developed and normalized tables for the MySQL database
• Used SSIS and T-SQL stored procedures to transfer data fromOLTPdatabases tostagingarea and finally transfer intodata martsand performed action in XML.
• UsedMDX to create calculated membersin the cube.
• Worked onEvent Handlersto do Event handling on error at the package and task level on error, on warning and configured it usingsend email taskandscript task.
• Created packages in SSIS witherror handling.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Migrated all the packages to Test Environment and finally deployed from Test Environment.
• Designed reports using SQL Server Reporting Services (SSRS).
• Implemented Software Configuration Management, setting up company Version policies utilizing Team Foundation Server (TFS).
• Designed and Developed matrix, tabular andparametricReports in the SQL Server Reporting Services 2005
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown,Ad hocand Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and deployed SSRS reports.

Environment:SQL Server 2005, Windows 2000/2003, Teradata, MS Access 2000/2003,T-SQL, Windows 2000 Advanced Server, SQL Server Integration Services(SSIS), SSRS, Crystal Reports, Tableau, VB.NET, SharePoint (MOSS) 2007, Erwin 4.0.

ETL Developer/ MSBI Developer (SSIS, SSAS, SSRS)

Confidential, TX

Responsibilities:

• Involved in theMigration of Databasesfrom SQL Server 2005 to SQL Server 2008
• Involved in development and implementation ofSSISandSSRSapplication solutions for various business units across the organization.
• Wrote T-SQL queries and T-SQL stored procedures in SQL SERVER 2000.
• CreatedSSISpackages to clean and load data todata warehouse.
• CreatedSSISpackage to transfer data betweenOLTP and OLAPdatabases usingIncremental Load.
• CreatedSSISPackages using Fuzzy Lookup, Derived Columns, Pivot Transformation,Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and toexport cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Experience in designing, creating, processing of cubes using SSAS.
• Good experience in Designing Aggregations and pre-calculating the same in SSAS.
• Created report Model on SSAS Cubes as well as changing default configuration on existing Cubes.
• Scheduled CubeProcessing from Staging Database Tables usingSQL Server Agent.
• Configured complex SQL queries to meet customer requirements as needed.
• Worked onComplex SSRS Reports, Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Reports Design.
• Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications.
• Developed a dashboard solution for analyzing STD statistics by buildingSSAS 2008 cubesand Tableau
• CreatedCrystal Reportsusing Crystal Reports formulae, Grouping, Parameters, Selection criteria.
• Experienced in creating SSAS OLAP Cubes andPartitioning Cubes.
• WroteMDX queries to retrieve the data from data warehousedimensions and to perform analysis
• Experienced in using Dimension Usage, Aggregations, Calculation and Perspective on a Cube.
• Experience in SQL joins, sub queries, tracing, usage of Table Variables, Temp tables etc.
• Involved in optimization of queries, improving the performance by using various approaches from execution plans, Index optimization, and DMV’s.
• Hands on experience in developingQlikViewDashboardsusing Chart Box (Drill Down, Drill up & Cyclic Grouping), List, Input Field, Table Box and Calendar etc.
• Carry out creation ofSDLCdocumentationfor existing applications
• Assigning new Users and permitting access rights to the users.
• Worked withSplunksupport team to resolve theSplunkissues.
• Filtered inaccurate data from legacy system using complexT-SQLstatements, and implemented various constraints and triggers for data consistency.
• Createdviewsto display required information on user interface, andtriggersto validate consistent data entry into the database.
• Createdchecks and constraintsto maintain data integrity and createdComplex Stored Procedures.

Environment:MS SQL Server 2005/2008, SQL Server Integration services (SSIS), VB.NET, Tableau, Teradata, SSAS, SQL Server Reporting Services (SSRS), BIDS and Windows 2003, SharePoint (MOSS) 2007.

Confidential, PA

SQL Server SSIS/SSRS Developer

Responsibilities:

• CreatedSSIS packagesand used Analysis Services processing task to update thecubewith current data.
• CreatedSSIS Reusable Packagesto extract data fromMulti formatted Flat files,Excel,XMLfiles intoDatabaseandBilling Systems
• Extract Transform and Load (ETL)source data into respective target tables to build the required datamarts
• CreatedSSIS packagesto load dataintoSQLServer using varioustransformationsin SSIS.
• Analyzed the existing tool and participated in meetings with the business users to gather
• Requirementsand design goals ofdata warehouse.
• Identified thedimension,fact tablesand designed thedata warehouseusingstar schema.
• SSAS storage and partitions, aggregations, calculation of queries withMDX, data mining models, developing reports usingMDX and SQL
• Deployedand processedOLAP Cubes.
• DevelopedAggregations,partitionsand calculated members forcubeas perbusinessrequirements.
• Defined appropriate measure groups andKPIs&deployedcubes.
• CreatedParameterized reports, Cross-Tab reports,Drill down reports& Summary reports by usingSSRSanddesigned reports using Crystal Reports.
• Created report snapshots to improve the performance ofSSRS.
• Developed new objects (i.e. Tables,Views, andStored Procedures) in SQL server 2005 database and performed tuning on it.
• Migrateddatabase from SQL server 2000 to SQL server 2005 using utilities i.e.exp/impandattach/detachfor SQL servers 2005 futures.

Environment:SQL Server 2005, Windows 2000/2003,T-SQL, Tableau, SQL Server Integration Services, VB.NET, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, MS Excel 2003, MSIIS,Visual Studio 2005, Visual Team Foundation Server, Crystal Reports.

Confidential, Atlanta, GA

SQL Server BI Developer

Responsibilities:

• Involved in developing database objects such asprocedures, triggers, constraints, indexes and views. Used T-SQL to builddynamic stored procedures.
• Created data-related documentation(e.g., file descriptions and definitions, entity relationships and attributes, etc.).
• Managed Database files, transaction log and estimated space requirements.
• Monitored database application.
• Responsible for developing automation of maintenance jobs, tuning SQL Server locks and indexes configurations, administering SQL Server security.
• Experience in calculating measures and dimension members usingMulti-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Designed and implemented severalcomplex reportsandadministration modules.
• Used .NET provider Data Reader Source Task to Read from RDBMS sources.
• Worked in ASP.NET Web forms, State management and Caching feature.
• Designedstored proceduresformodule integrityand application.
• Involvedin installation, upgrade and configurationof Microsoft SQL Server and databases.
• Involved in Microsoft SQL Server Database Administrationincluding planning, backup, and recoverystrategies.
• Implemented High availability concepts,Data base Mirroring, Replication and log shipping.
• Involved inPerformance Tuning, Query Optimization, Database consistency checksusing DBCC utilities.
• Involvedimplementing Disaster Recoveryfor minimal downtime using different types of database backups, restore, and replication.

Environment:SQL Server v2000, T-SQL, Win NT v4, Win 2000, MS Excel, ASP.NET