PROFESSIONAL SUMMARY:

• Around 7+ years of IT experience in the Analysis, Design, Development, Administering Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment).
• Highly proficient in the use of T - SQL for developing complex stored procedures, triggers, tables, user profiles, relational database models and data integrity, SQL joins and query writing.
• Very good noledge wif T-SQL (DDL and DML) statements, RDBMS, data dictionaries.
• Experience in MS SQL Server 2014/2012/2008/2005, SSRS, SSIS and SSAS packages.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes.
• Experience in Integrating SQL Server Reporting Services (SSRS) wif Microsoft Office Share Point Server (MOSS 2007)
• 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
• Strong technical noledge in MS SQL Server development including Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Hands on experience working wif SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Experience of working wif SQL Server SSIS packages dat include designing and implementing end-to-end ETL packages involving data extraction from multiple heterogeneous sources like SQL Server, Excel, Oracle, Teradata, DB2 and CSV.
• Experience in using recursive CTEs, CTE, temp tables and TEMPeffective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and SQL Server Integration Services (SSIS).
• Experience in Cube designing in Business Intelligence Development Studio using SSAS.
• Experience in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Involved to develop web applications using VB Script, C#, and ASP.Net, VB.Net and .Net framework creation in SSAS and SSIS.
• Experience wif job scheduling using SQL Server Agent to perform hourly/daily/nightly updates.
• Experience in Data Modeling using Erwin, Rational Rose (UML) and MS-Visio to create logical and physical data models; use case diagrams and data flow diagrams respectively.
• Worked in a disciplined Software Development Life Cycle (SDLC) process and have excellent analytical, programming and problem solving skills & desire to excel, fast learner, hardworking and versatile team player.
• Creating reports in Micro Strategy and Business Objects for reporting of sales and daily numbers for the Disney Parks Store Online
• Hands on work experience in building Canned/Ad-hoc/Analytical reports using ROLAP & MOLAP Business Intelligence reporting tools (Micro Strategy 8i & 9i), Micro Strategy Desktop, Micro Strategy Administration, Micro Strategy Web, and Micro Strategy Office, Object manager, Intelligent Cubes, Intelligence Server, Report Services, Enterprise Reporting, OLAP provider and Data Mart.
• Experience in creating the Dynamic Dashboards & Scorecard reports using Micro Strategy 9.0.1.
• Experience in Micro strategy Report development, Report testing, Report tuning, Ad-hoc, scheduling report delivery and Alerts.
• Experience in Tableau 9.x/8.x/7.x of Desktop, Server and Reader.
• Strong experience in interacting wif stakeholders/customers, gathering requirements through interviews, workshops and existing system documentation or procedures, defining business

TECHNICAL SKILLS

Programming Skills: T-SQL,PL- SQL, Micro strategy, C, HTML, CSS, XML,Power Pivot, VB, C#

RDBMS: MS SQL Server 2014/2012/2008/2005, MS Access.Database Design Tools and Data Modeling MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Visual Studio 2005/2008/2013

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

Systems familiarity: OLTP,DSS,OLAP

Tools and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Business Intelligence Development Studio (BIDS)

PROFESSIONAL EXPERIENCE:

Confidential, Secaucus, NJ

SQL Server Developer/SSRS/SSIS

Responsibilities:

• Worked closely wif business unit(s) to understand key business drivers and tan identify the individual business metrics and key measures dat support them.
• Designed and configured, including parameters, settings, metrics, data elements and objectives.
• Worked wif management to develop strategies to support company needs.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views, Rules, Defaults and complex SQL statements.
• Utilized SSRS reports from different source formats and satisfying clients by representing reports and presentations.
• Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized reports.
• Wrote complex SQL queries using joins, stored procedures, User Defined Functions to verify the data from the database to generate reports based on the business requirement
• Created ad Hoc and parameterized various reports using SQL server 2014/2012 reporting Services.
• Implemented multiple grouping into several reports using visibility and toggle options.
• Involved in XML Development and XML File Parsing in SSIS and SSRS.
• Developed the SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS.
• Involved in mock testing and Unit Testing and Integration testing in SSIS.
• Created automated stored procedures for day end operations using SQL Server agent.
• Coordinated wif front-end for implementing logic in stored procedures and functions.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS.
• Used multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the Staging Data base
• Extensively worked in ETL and data integration in developing ETL mappings and scripts usingSSIS, Worked on Data transfer from a Text file toSQL Serverby using bulk insert task inSSIS.
• Involved in SSIS ETL Transformation for de-normalization of data sources using UNPIVOT and UNION.
• Created Packages dat Transfers Databases from OneSQL Serverinstance to Another Instance and Scheduled the SSIS packagefor Migration of data from old system to MS SQL 2014
• UsingSSIS, loaded XML data to the Database tables and Extracting Data usingSSISinto Excel Files for Marketing purpose
• Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files, and 2000.
• Planned Backup strategy based on projects requirements.
• Data migration (import & export/BCP) from Text to SQL Server.
• Export or Import data from other data sources like flat files using Import/Export through SSIS.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Customized SQL queries to create RDL Datasets and create SQL reports.
• Created Tabular and Matrix Reports wif all aggregate functions and expressions, dashboard SSRS reports under report server projects and publishing SSRS reports to the reports server.
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables.
• Created SSRS Data Model projects using Microsoft Visual Studio 2012 and using Report Builder for report server to facilitate Ad-hoc reporting by the business users.
• Extensive experience in Tableau 9.x/8.x/7.x of Desktop, Server and Reader.
• Strong experience in interacting wif stakeholders/customers, gathering requirements through interviews, workshops and existing system documentation or procedures, defining business.
• Experience wif designing complex dashboards taking advantage of all tableau functions including data blending, actions, parameters, etc.,
• Extensive noledge in various reporting objects like facts, attributes, Hierarchies, Filters, Sets, Groups, Parameters in Tableau.
• Combined Reports & View into interactive dashboards in Tableau desktop and presented to program managers, Business users and End users.

Environment: SQL Server 2008 R2/2012/2014, SSIS, SSRS, XML, MS Access, Excel, C#, Crystal Reports, ER Studio

Confidential, Watertown, MA

SQL BI Developer

Responsibilities:

• Generated database monitoring and data validation reports inSQL Server Reporting Service (SSRS).
• Createdpartition tablefor very large database for good performance.
• Designed dynamicSSIS Packagesto transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL andDTS/SSIS
• DeployedSSISpackages and Reports to Production Servers.
• Involved in creation of Data warehouse Cubes inSQL Server Analysis Service (SSAS).
• Migrated data using ETL Tool inSSIS.
• Maintained system monitoring jobs and providedhigh availability support.
• Worked on Migration of packages from DTS usingSQL Server Integration Service (SSIS).
• ParticipatedDatabases Architectureanddata modelingdesign.
• Performing DBA functions, installing, configuring and supporting database systems.
• Developed various operational, drill-through and drill-down reports using SSRS.
• Reported all events and requirements through established reporting mechanisms inSSRS.
• Reviewed and developeddata models and database designswif development teams
• Wrotestore proceduresfor some job automations.
• Generated test data andtested databaseto meet the functionalities deliverables in the project documentation and specifications.
• Designed and developed OLAP using MS SQL ServerAnalysis Services (SSAS).
• Designed and developedMS SQL ServerReporting Services (SSRS)under SQL Server 2008R2.
• Configured replication servers and transactional replication between production & standby server for disaster recovery.
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Creating and Maintaining Users roles groups and granting the privileges to users and Groups and maintaining security up to date.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues wifinTableau Server and Reports.
• In depth noledge on Tableau Desktop and Tableau server.
• Provided technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services.
• Experience in designing techniques like snowflake schemas, star schema, fact and dimension tables, logical and physical modeling.
• Extensive Experience in Installation, configuration, upgrade (simple Configuration, 3-server and 5-server cluster) and administration of Tableau Desktop/Server.
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis, Cross Map,ScatterPlots,Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.

Environment:MS SQL Server 2008R2, SSRS, SSIS, SSAS, ProClarity,C#,ASP.NET, VB.NET, OLAP, Erwin 7.0, DTS/SSIS, BIDS.

Confidential, Mason, OH

SQL/BI Consultant

Responsibilities:

• Developed SSIS Packages to extract data from various data sources such as MS Access, Excel and flat files into SQL server 2008 using different transformations, Derived column, Sort, Row count.
• Developed, deployed and monitored SSIS Packages.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Made SSIS packages parameterized using Configuration files.
• Experience wif SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• Studied the existing OLTP system(s) and Created facts, dimensions and Star Schema representation for the data mart.
• Responsible for identifying and defining Data Source and Data Source views.
• Created cubes and defined the dimensions.
• Optimized cubes for better query performance.
• Created and integrated User defined functions and stored procedures for reporting purposes.
• Generated reports dat ca handle dynamic grouping and dynamic sorting.
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.
• Defined relationships between Dimensions and Measure groups.
• Expert in calculating measures and dimension members using mathematical formulas, and user-defined functions.
• Created Cross-Tab, Drill-down, Drill-through and Sub drill down reports -Report using RDL. Promoted RDLs to Reporting Service Server.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.

Environment: MS SQL Server 2008 Enterprise Edition, MS SQL Analysis Services 2008,MS SQL Reporting Services 2008, MS Access, MS SQL SSIS/SSRS 2008, Windows XP Professional, Relational DBMS, data warehousing, Insurance Systems.

Confidential

Jr. SQL Server Developer

Responsibilities:

• Involved to work wif troubleshooting the stored procedures, functions, views, triggers etc. & part to be increasing the performance tuning.
• Wrote several SQL Scripts such us finding tables dat have Identity Columns, finding tables dat do not have primary key.
• Developed and performed data modeling studies, support data selection, extraction and cleansing of mediation applications.
• Developed SSIS ETL packages to meet data flow needs.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Modifying & Implemented simple encryption stored procedure in order to transform the business rules.
• Proven ability in generating Drill down and Drill through reports wif Drop down menu option, sorting the data, defining subtotals in SSRS 2005.
• Created Parameterized reports and Linked reports and thorough noledge of report serving architecture using SSRS.
• Designed and implemented Disaster Recovery Procedures like Log Shipping and mirroring between production and DR servers.
• Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
• Developed SSIS ETL Packages to meet data flow needs & building platform wif the using of SSIS.
• Involved to work wif .NET, C# environment to do custom coding wifin SSIS packages, SSRS reports.
• Managed source code, keeping track of project deliverability such as defects, requirements, tasks & versioning control wif the using of Team Foundation Server.
• Migrated legacy database and spreadsheets (Access/Excel) to SQL Server 2005 using Data Transformation Services (DTS Transformation) and T-SQL scripts.
• 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 Index usage statistics to determine how useful an index is and if an index is improving or hindering application performance.
• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005/08R2 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Enhanced performance of databases using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.

Environment: SQL Server 2005, SSRS, SSIS, T-SQL, Microsoft Office, Windows 2003/XP.