SUMMARY

• Over 7 years of professional IT experience in designing, developing and maintaining Database using MS - SQL server 2005/2008/R2/2012.
• Efficiently helped in the Software Development Life Cycle processes including Requirement Analysis, System Design, Implementation, Testing and Maintenance.
• Expertise in conceptual, logical and physical designing and development of Data Models, Data Normalization, OLTP and OLAP Database and Data Warehouse.
• Experience in coding, testing, deployment, support and maintenance of business applications using MS-SQL Server 2005/2008/R2/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Expertise in T-SQL in creating and using Views, User Defined Functions, Triggers, Indexes, Stored procedures involving joins, sub-queries from multiple tables and established relationships between the tables using primary and foreign key constraints.
• Experience in SQL Server up gradation from older versions to latest version.
• Excellent in High Level Designing of SSIS Packages to perform ETL from heterogeneous sources such as Excel, CSV, Oracle, flat file, Text Format Data by using multiple transformations provided by SSIS to generate underlying data for the reports and to export cleansed data.
• Well versed in converting Crystal Reports to SQL Server Reporting Services reports using crystal report migration services.
• Hands on Experience in creating various types of dynamic reports like Tabular, Matrix, Drill-Down, Cascaded parameterized, Chart reports, Sub reports, Ad-Hoc Reports, Cross Tab Reports and Distributed Reports in multiple formats using SSRS based on client requirements.
• Good knowledge in designing, creating and implementing cubes, dimensions and fact tables for star /snowflake schemas using SSAS.
• Have good experience in implementing MDX queries to design OLAP architecture, MOLAP, ROLAP and HOLAP.
• Experience in developing Dashboards, Scorecards using multiple KPI’s using Microsoft Share point.
• Good experience in creating Pivot Tables and Charts in Excel using data sources like SQL Server, MS Access, SSAS cubes and power pivot.
• An Enthusiastic and goal oriented team player with excellent analytical, communication and interpersonal skills and proficient in technical writing and presentations.
• Ability to work independently or part of a team to accomplish critical business objectives.

TECHNICAL SKILLS

Database Tools: SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, SSRS, SSIS, SSAS, Backup Server, Replication server, OLAP Services, SQL, Agents, SQL Alerts, SQL Jobs, Replication tools, Data visualization ( Composite tool).

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

Operating System: Windows 2003/2008/7/8 , Linux, HP-UNIX

Programming Languages: C, C++, VB.NET, ASP.NET, C#, SQL, TSQL, PL/SQL, MDX

Web Technologies: HTML, DHTML, CSS, Java Script, AJAX, VB Script, XML, SOAP, IIS

Markup Languages: XML, HTML

Design and Development: Visual Studio 2008/2005/2003 , Visual Studio 6.0

Reports: SSRS, Crystal Reports, Cognos Reporting tool, Business Objects.

PROFESSIONAL EXPERIENCE

Confidential, Foster City

MS-SQL Server / BI Developer

Responsibilities:

• Involved in requirement analysis, system design and implementation phase of Water Fall software development life cycle process in a Data Warehouse project.
• Translated business requirements into data analysis, data source for BI reports and applications.
• Moved data from different databases to end database and maintained batch log files.
• Created Database objects like User Defined Functions, Stored Procedures, Triggers to be used for ETL, Audit and Maintenance Tasks.
• Generated various reports using parameterized stored procedures like sales assessment reports for different medicines produced by the company, target reports of the company.
• Created SSIS packages to extract, transform and load data from various sources like Excel, Text, and Access to SQL Server destination using various complicated transformations like conditional split, derived column, and data conversion.
• Configured send mail task to sent failure/success mails upon deployment of a SSIS package.
• Extracted data using SSIS packages from SQL server source and exported them as excel and flat files to the users.
• Migrated packages from development server to production server using package configuration.
• Created projected income statements and financial reports using features like drill down, drill through, parameterized reports. Developed yearly, quarterly, monthly sales reports and scheduled the reports to run on daily and weekly basis in report manager and also email them to project manager to review in Excel sheet.
• Generated reports using query parameters, filters, interactive sorts to compare test result for different administrations.
• Involved in developing Cubes in Business Intelligence Development Studio using SSAS.
• Created dashboard and scorecard reports involving KPIs using share point.

Environment: MS-SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), T-SQL, Visual Studio 2008, ASP.net, MS Access, SQL Profiler, Windows 2007, MS Excel, Java script.

Confidential, Bedminster,NJ

MS SQL Server/ SSRS Developer

Responsibilities:

• Developed SSIS packages with various control flow and data flow transformations to perform ETL to data warehouse from heterogeneous sources.
• Used SSIS tasks like fuzzy lookup, conditional split, derived column transformations to perform data cleansing and data scrubbing in the staging area, before loading the data into the data warehouse.
• Used slowly changing dimensions up to type 2 to maintain the history of the data in the data warehouse.
• Maintained Jobs, Alerts, Subscriptions, and schedules of SSIS Packages to run as per required by the manager.
• Used Bulk copy program (BCP) to import and export large amounts of data in and out of the SQL Server databases.
• Worked with business analysts to design and implement solutions to extract data and integrate it to and from databases, data marts for the purpose of extracting data to generate reports using SSRS.
• Involved in performance tuning and query optimization using SQL profiler.
• Generated performance based reports using features like drill down, drill through reports using SSRS for the managers.
• Implemented mechanisms to accelerate query performance including aggregations, caching and indexing to retrieve data faster.
• Implemented database standards and naming convention for the database objects to document all the processes involved in maintaining the database for future reference.

Environment: SQL Server 2005, Excel (pivot tables), SSIS, T-SQL, BCP, Visual Basic, Visual Studio 2005, Windows 2000/XP.

Confidential, Bensalem, PA

MS SQL Server /SSIS/SSRS Developer

Responsibilities:

• Involve in Planning, Defining and Designing data based on business requirements and provide documentation.
• Optimized Indexes, Views, Stored Procedures and Functions using T-SQL.
• Used SSIS jobs for importing data from the flat files that brings the data to the application tables.
• Monitor and kill processes that create deadlocks within the database.
• Write complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for the application.
• Used SSIS and T-SQL store procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which are used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Develop and deploy data transfers packages to the appropriate destinations using SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSISPackages.
• Create SQL server configurationsforSSISpackages.
• Use SSIS transformations to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Responsible for creating reports based on the requirements using SSRS 2012.
• Define the report layout and identified Datasets for the report generation.
• Create different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.
• Generate reports on wealth information, account information, research reports using ad-hoc reporting to be used by the clients and advisors.
• Design and create report templates, bar graphs and pie charts based on the financial data.
• Scheduling the monthly/weekly/daily reports to run automatically.
• Develop implement and maintain various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Develop and implement procedures to ensure the quality, usability and accuracy of reports.
• Create Packages to group logically related column types and to transfer data.
• Design both logical and physical data models in Erwin

Environment: MS SQL Server 2012, SQL server Reporting Services 2012, SQL Integration Services 2012, Microsoft Visual Studio 2010, Microsoft Visual Basic, Oracle 11g, SQL Server Management Studio 2010, MS Excel, T-SQL,ERWIN.

Confidential, Columbus, GA

SQL/SSIS/SSRS Developer

Responsibilities:

• Gathered functional requirements and Business requirements and wrote the technical specifications for building the Data model.
• Worked closely with end users in designing and creating the Data warehouse for management group using SSIS and Erwin.
• Implemented logical and physical database modeling using Erwin tool.
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updating to improve the query performance.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Developed and deployed SSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusingLookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server IntegrationServices.
• Successfully implemented SCD transformation in SSIS and performed security.
• Created star schema for OLAP cube generation and extensively worked dimension modeling for analysis service using SSAS.
• Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler in MS SQL Server 2005.

Environment: Microsoft SQL Server 2005 Enterprise Edition, Windows Server 2003, SQL Server Management Studio(SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services(SSAS), Business Intelligence Development Studio(BIDS), Oracle 10g, Microsoft Visual Studio 2005, IIS.

Confidential, Mayfield Village, OH

MS SQL/SSRS Developer

Responsibilities:

• Developed logical and physical database (using ERwin, Normalization, Dimension Modeling and Enterprise Manager).
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.
• Made sure that standards and best practices in database development were followed and maintained.
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency checks and index defragmentation.
• Set up database backup and recovery strategies.
• Designed and Implemented the Stored Procedures and Triggers for automating tasks.
• Maintained all records of project status and followed changes as per control procedures.
• Provided technical support to internal developers and external clients.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Environment: MS SQL Server 2005, MS Access 2000, Erwin v4.0, T-SQL, MS-Excel, MS-Access, SQL Query Analyzer, MS SQL Profiler

Confidential, Plano, TX

Jr. SQL Server Developer

Responsibilities:

• Developed SSRS reports based on the user stories (similar to use cases) in each sprint (Agile Methodology).
• Involved in Sprint Planning and Estimation for the requirements.
• Designed and Developed Complex Chart Reports, Drill-Through Reports, Form Reports and Tabular Reports.
• Written Complex Stored Procedures, Views and Functions.
• Conducted Peer Review for the reports developed by other developers.
• Involved in Production Support & Maintenance for earlier releases.
• Configured Report Builder and trained business users so that they could create reports from the report models I created.
• Implemented the Best Practices and Standards for SQL Server Scripting and SSRS.
• Performed Unit Testing and Defect Fixing in all the phases of the project (SIT, UAT).
• Interaction with Sales Process Team, CRM Team, Testing Team, and Integration Team for better understanding of the functionality.
• Worked along with Usability team in developing UI for developed Reports.

Environment: BIDS (SSIS, SSRS 2008/2008R2), SQL Server 2008/2008 R2, Report Builder 2, Microsoft Dynamics CRM 2010, Team Foundation Server, .Net, Windows XP, QC, Erwin 4.2