SUMMARY

• Around 7 years of IT experience as Business Analyst with design, development and implementation of SQL Server based Application methodologies in the field of commercial and business applications.
• Well rounded experience in Full SDLC implementation phases and methodologies.
• Experience in Object Oriented Analysis and Design and preparing UML diagrams including class diagrams, Use - Case diagrams and activity diagrams.
• Excellent writing skills in Business Requirements Documents, Functional Requirements Specifications, System Design and System Requirements Specification.
• Experience in Microsoft Business Intelligence SSRS.
• Experience in Microsoft SQL Server Database Administration including planning, implementing, backup, and recovery strategies.
• Strong Transact-SQL query and PL/SQL writing skills including creating objects such as Databases, Tables, Stored Procedures, Triggers and Cursors, Constraints, Indexes, Views, Indexed Views in Microsoft SQL Server and Oracle
• Hands on experience in designing, Installing, Creating, Maintaining of Databases,
• Performance Tuning, Backup and Recovery, Optimization and Database Security.
• Expertise in generating reports using SQL Server Reporting Services (SSRS)
• Experience in configuration of Report Server and Report Manager Scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS)
• Strong knowledge of Data Warehousing Concepts, Dimensional Data Model concepts, Dimension and Fact tables, Surrogate keys, Star and Snow Flake Schema, Physical and Logical Data modeling.
• Strong Knowledge of ETL concepts and Informatica Power Center 9.x
• Maintaining, creating / Designing and monitoring databases (SQL server, Oracle) Monitors database for potential problems and create end user reports. Also Security Administration and Replication, Database mirroring & clustering.
• 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

Databases: MS SQL Server 2005, 2008, 2008 R2, 2012, 2014, Oracle 9i/10g/11g

Database Tools: Oracle SQL*Plus, Toad

Reporting Tools: SSRS

Languages: SQL, T-SQL, PL/ SQL, UNIX Shell ScriptETL Tools Informatica PowerCenter 9.x, Informatica MDM 9.5/9.7

Operating system: Windows (8/7/vista/XP), UNIX, Linux

Other Tools: MS Visual Studio, MS Visio, MS Office, MS Excel

PROFESSIONAL EXPERIENCE

Confidential, Eddison, NJ

SQL BI/SSRS Developer

Responsibilities:

• Upgraded databases SQL server 2008 R2 to SQL server 2012 and SQL server 2014
• Identified compatibility issues and new requirements for several business applications to work with SQL 2012/2014.
• Responsible for upgrading SQL server objects such as Stored Procedures, Views and triggers.
• Created several complex Stored Procedures, Views, SQL Joins, and other T-SQL code to implement business rules.
• Responsible to upgrade and design SSRS reports to show data crossing across different platforms, when data s validated during transferring and archive data files for different DBMS.
• Involved in transferring data from homogenous and heterogeneous sources data sources such as MS Access, MS Excel, Flat Files into SQL Server
• Designed and maintained various typed of reports using SSRS, such as cascading (collapsed), printable, interactive reports(drill down and drill through), parameterized and cascading parameterized reports.
• Configured SSRS to integrate with SharePoint and automated deployment of reports to SharePoint Server.
• Designed, developed, reported all events and requirements in SSRS and deployed SSRS Reports in SharePoint for web based access for multiple end users.

Environment: SQL server 2008/2012/2014 , Windows Server 7/2012, Microsoft Office 2010, SQL Server Reporting Services, Profiler, Share Point 2010.

Confidential, Jersey City, NJ

SQL BI Developer (SSRS)

Responsibilities:

• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.
• Developed highly optimized stored procedures, functions, and database views to implement the business logic and also created clustered and non - clustered indexes.
• Involved in performance monitoring, tuning and capacity planning.
• Advised optimization of slow performance queries by looking Confidential Execution Plan for better tuning of the database.
• Translated business requirements into BI application designs and solutions..
• Designed, deployed, and maintained complex canned reports using SQL Server 2012 Reporting Services (SSRS).
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created reports to retrieve data using Stored Procedures that accept parameters.
• Created Parameterized Queries, generated Tabular reports, Sub reports, Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008.
• Created SSRS reports which contain Drop-Down Parameters, Multi-Valued Parameters, Debugging Parameter Issues, Matrix Reports and Charts.
• Developed various operational Drill-through, Drill-down and linked reports using SSRS 2008R2
• Converted all the reports form SSRS 2008R2 to SSRS 2012 and maintained all the updated versions in TFS.

Environment: Windows server 2012, Windows 7/XP, IIS 6.0, SharePoint, MS SQL Server-2012/2008R2/2005 Enterprise Edition, Oracle DB 10g, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Performance Point Sever, Office-2007, MS Excel

Confidential, Chicago, IL

SQL BI/ SSRS Developer

Responsibilities:

• Evaluated current system for bottlenecks and identified scope for redesign or improvement.
• Designed high level documents to show case expected improvement in performance and ease of operations.
• Prepared requirement documents and necessary schema diagrams.
• Created several databases along with tables and other database objects.
• Implemented Constraints, Rules, Defaults, User defined data types and Indexes on tables.
• Developed complex T-SQL code for data retrieval.
• Worked on creating complex Stored Procedures, Functions, Triggers, Cursors, Tables, Views, and other SQL joins.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Designed several SSIS packages and was responsible for transferring the data from different servers using the SSIS packages.
• Worked with variety of data sources including OLE DB, ODBC, and flat file, Excel, and XML adapters.
• Generated reports using SSRS (SQL Server Reporting Services).
• Generated reports to keep track of the performance of sales agents, demographics for clients etc.
• Designed and created Views for security purposes.
• Used database maintenance plans for backing up the database and transaction log files.

Environment: MS SQL Server 2008 R2/2012, Reporting Services (SSRS), Integration Services(SSIS), T-SQL, Visio, SQL Profiler, SQL Server Agent, Microsoft Visual Studio, MS Access, MS Excel.

Confidential, New York, NY

SQL BI/ SSRS Developer

Responsibilities:

• Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both Online and Batch requests handling business logic and functionality of various modules
• Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc and used configuration files and variables for production deployment
• Developed ETL packages using multiple data sources (SQL Server, Flat Files, Excel source files, XML files etc)
• Involved in dimensional modeling with Star &Snowflake schemas and created the Data Source Views (DSV) and Cubes using the identified Fact and dimension tables.
• Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2000/2005/2008 ) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• 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).
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Create ad-hoc SQL queries for customer reports, executive management reports
• Created Reports, Report model Definitions, Scorecards, KPIs, and Dashboards utilizing Performance Point Server 2007/SharePoint Server
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Provided documentation about database/data warehouse structures and Updated functional specification and technical design documents.

Environment: MS SQL Server 2008/2012, SQL Server Reporting Services (SSRS 2008/2005), SQL Server Analysis Services (SSAS), T-SQL, Microsoft Office SharePoint Server (MOSS ) 2007, MS Excel, Team Foundation Server(TFS), Microsoft Visual Studio, MS Access, MS Excel

Confidential, Bloomingdale, IL

SQL BI

Responsibilities:

• Planned, Defined and Designed data based on business requirement and provided documentation.
• Gathered data and documenting it for further reference and designed Database using Erwin data modeler.
• Created SSIS package to load data from Flat Files and SQL Server 2008/R2 to SQL Server 2012 a using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2012.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS - 2012.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2012.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database object like stored procedures, functions, tables, views
• Configured the report viewing security for various users Confidential various levels using Report Manager
• Deployed the generated reports on to the server.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

ENVIRONMENT: MS SQL Server 2008 R2/2012, Reporting Services (SSRS), Integration Services(SSIS), T-SQL, Win 2003 Advanced Server, Erwin v7.3, SQL Profiler, Database Engine Tuning Advisor, SQL Server Agent.

Confidential

Data Warehouse Analyst/ ETL Developer

Responsibilities:

• Understanding the business requirements by partnering with business and application developers.
• Designing and performing the Data Profiling, Data analysis using Data Quality Tools to implement Standardized the data and to increase the data accuracy.
• Designing the ETL code using Informatica, modifying the data using different transformations
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes.
• Created Data Base connections and worked with different source files.
• Designed and Developed the Informatica workflows/sessions to extract from different Data Bases, transform and load the data into oracle.
• Created different transformations for loading the data into targets using various transformations like Source Qualifier, Joiner transformation, Router, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator, and Sequence Generator.
• Extensive use of IDQ to improve quality and accuracy of important fields.
• Writing and executing IDQ Plans for Standardization, Data Matching, address validation and Data Consolidation for the data.
• Analyzed the structure and content of enterprise data and identify strengths and weaknesses.
• Manage bad records and duplicate records. Fixed bad records and consolidate duplicate records.
• Extensively used Toad for SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Worked on Informatica PowerCenter Tool - Source Analyzer, Warehouse designer, Mapping Designer, Workflow Manager, Mapplets, Worklets and Reusable Transformation
• Involved in Performance tuning Confidential various levels including Target, Source, Mapping, and Session for large data files.
• Prepared project documentation, Program Specifications, Test Cases and Participated in the complete SDLC.
• Used Teradata utilities to load and export data into the databases and maintain them
• Developed Test Plans, Test Cases.

Environment: Informatica Power Center 9.5.1, UNIX Shell Scripting, Erwin, Microsoft SQL Server 2008, Toad, SQL Developer, Oracle 11g

Confidential

SQL/T-SQL Developer

Responsibilities:

• Wrote various Stored Procedures for the purpose of application development.
• Tuned SQL statements (e.g.: using Indexes) and Stored Procedures.
• Maintained disaster recovery and database maintenance plan.
• Worked on replication of data (Transactional method used).
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Performed job scheduling and alerts.
• Designed and implemented user log in and security.
• Resolved any deadlocks issues with the databases/servers on a real - time basis.
• In-Depth working knowledge of ODBC.
• Created many complex Stored Procedures and user defined functions.

Environment: SQL server 2008/2008R2 Enterprise and standard Editions, Windows Server 2008 Enterprise and standard, SQL DB Access, T-SQL, Microsoft Visual Studio, MS Access, MS Excel.

Confidential

JR SQL DBA

Responsibilities:

• Installed and configured SQL server 2008/2008 R2 and service packs
• Performed database backups and restored database in point in recovery
• Troubleshoot SQL server issues for better optimal performance
• Provide on call support for large SQL server implementation.
• Implemented database security measures, specify users and user access levels for each database.
• Experienced in implementing operational automation using T-SQL scripts and GUI
• Created and managed indexes, tables, views and stored procedures
• Fixing missing indexes and missing indexes.
• Analyzed execution plans and tuned queries and databases for optimal performance.
• Job monitoring and making sure all jobs run successfully every night

Environment: SQL server 2005/2008 Enterprise and standard Editions, Windows Server 2005/2008/7 Enterprise and standard, SQL DB Access, SQL server profiler, Backup Utility, T-SQL