SUMMARY

• 9+ years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008/2008 R2/2012, 2014).
• Experience in creating dashboards, scorecards and building reports using performance point server 2007.
• Good experience in using Multidimensional Expressions (MDX) for querying and manipulating the multidimensional data stored in OLAP cubes .
• SQL Server 2000/2005/2008/2008 R2/2012/2014 RDBMS database development including T-SQL programming.
• SQL Server 2005 OLAP database development including KPIs, Data mining, working with changing dimensions.
• Design and Build Data Warehouse and Data Mart pulling data from different Business sources.
• Developing reports on SSAS & SSRS on SQL Server ( 2000/2005/2008/2008 R2/2012/2014). Experience and understanding of SSAS, OLAP cube and Architecture.
• Modified the MDX query in the reports wherever necessary as per the requirement.
• Experience with ad-hoc reporting, Parameterized, Custom Reporting using SSRS for daily reports using SQL Server Reporting Services (SSRS) (2005/2008/2008 R2/2012/2014).
• Thorough understanding of Kimball’s’ theory, KPIs, SQL 2005 Architecture.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• Worked in Data modeling, creating star and snowflake schemas in SSAS.
• Used data model tools like Erwin, Visio 2010/2013/2016.
• Dealt with large database sources like HDFS.
• 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.
• Data migration from SQL 2008 to SQL 2014.
• Documentation on the developed Code in SSIS, SSAS, SSRS, and Informatica etc. according to the Company guidelines and standards specified.
• Experience in creating Indexed views, complex Stored Procedures, CTE’s, Triggers and Functions to facilitate efficient Data manipulation and consistent Data storage.
• Involved in DBA activities such as backups, restores, replication etc.
• Exposure to CMMI, ISO and QA processes, version controlling, change control management, etc.
• Excellent communication skills, analytical skills, understand business requirements in various Domains.

TECHNICAL SKILLS

Platforms: Windows Server 2000/2003/2008 , Windows Vista/XP/2003/2000 UNIX, Linux, DOS

SQL Server Tools &Packages/BI tools: SQL Server Management Studio, Enterprise Manager, Business Intelligent Studio, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, SQL Server Agent, Crystal Reports, ETL, SSIS, SSAS, SSRS, Erwin Data modeler

Applications: C/C++, HTML, XML, Visual Studio

Desktop: MS Office Suite, Word, Excel, Access, PowerPoint, Outlook

Databases: SQL Server 2000/2005/2008/2008 R2, 2010, 2012, 2014, MS Access 97/2003/2005/2008

PROFESSIONAL EXPERIENCE

Confidential, Pendleton, IN

SQL BI/.NET - SSIS Developer

Responsibilities:

• Worked on After Market (AM) project to handle multiple applications (Lab Order, PPAP, SCAR, Customer Shipping, Warranty, Order Management System (OMS), IRFQ, CustomAppSecurity, PRS)
• Design and model the Mini Mart using Microsoft Visio 2016.
• Migration of SQL Server and 2016.
• Worked on Power BI (data visualization BI Tool) to develop reports and packages accordingly and integrate to Office 365 as an added feature to 2016.
• Working on MDX scripting while developing reports.
• Use Cosmos products in developing internal applications and presentations.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation
• Create different SSRS Reports based on the user’s requirement. All kinds like ad-hoc reports,
• Create Web and Console applications using Visual Studio 2014, C# .NET framework
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Trouble shoot and solve data issues or validation issues in SSIS packages and web applications.
• DesignedSSIS Packagesto transfer data between Active Directories, Servers and databases.
• Bug fixes in SSRS and stored procedures as necessary.
• Worked in an Agile Scrum methodology.
• Scheduling the jobs to run for ETL using SQL Server Agent.
• Worked on writing the T-SQL code for the historical data to pull according to the specification requirement.
• T-SQL in constructing User Functions, CTE’s, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Perform T-SQL tuning and optimizing queries for SSIS packages.
• Scheduling SSIS jobs using SQL Server Agent and production support.
• Handling Production issues if any bugs reported via TFS.

Environment: MS SQL Server 2008, MS SQL Server 2012, Micro Soft Visual Studio, Business Intelligence Development Studio, SQL Server Reporting Services (SSRS), Power BI, SQL, GIT, ClearCase, ClearQuest, PowerBuilder Classic 12.5, Visual Basic 6.0/VB.net, VB Script and Windows 2008 Server.

Confidential, Carmel, IN

SQLBI Developer/.NET - SSRS Developer /Programmer Analyst

Responsibilities:

• Worked on Auction Management System (AMS) data to build reports.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation
• Create different SSRS Reports based on the user’s requirement. All kinds like ad-hoc reports,
• Create Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using Visual Studio 2012.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Trouble shoot any kind of data issues or validation issues
• DesignedSSIS Packagesto transfer data from various sources of the Company into the database that was modeled and designed.
• Bug fixes in SSRS and stored procedures as necessary.
• Worked in an agile scrum methodology.
• Worked with large data sources like HDFS.
• Worked on Power BI (data visualization BI Tool) to develop reports and packages according to the Client requirement.
• Experience in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional like Star and Snow Flake Schema.
• 3rd Normal Form (3NF) for developing Cubes using MDX.
• Work in SAFE certified Agile Scrum Methodology.
• Scheduling the jobs to run for ETL using SQL Server Agent.
• Worked on writing the T-SQL code for the historical data to pull according to the specification requirement.
• T-SQL in constructing User Functions, CTE’s, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Perform T-SQL tuning and optimizing queries for SSIS packages.
• Worked on Incremental Loads using concepts like Checksum and Column to Column compare.
• Scheduling SSRS jobs and production support.
• Production support for tickets issues in ClearQuest for SSRS jobs.

Environment: MS SQL Server 2008, MS SQL Server 2012, Micro Soft Visual Studio, Business Intelligence Development Studio, SQL Server Reporting Services (SSRS), SQL, ClearCase, ClearQuest, Power BI, PowerBuilder Classic 12.5, Visual Basic 6.0/VB.net, VB Script and Windows 2008 Server.

Confidential, White Plains, NY

Business & Data Analyst / SQL BI Developer

Responsibilities:

• Santander is a locally-focused bank backed by the strength of the Santander Group, a leading global financial institution. Here in the U.S., it offers a broad spectrum of products and services for personal, business, and corporate banking customers. It answers customer’s unique needs and ideas and offer useful solutions and personalized guidance to help them put their money to work to accomplish their goals.
• Detailed Data mapping for different schedules for FRY-M and FRY-Q’s
• Deal with General Ledger for different banks like Santander, SBNA, Santander Consumer USA (SCUSA), Miami, Puerto Rico
• Worked on CCAR reporting and Risk Data Assessment (RDA) for banks like Santander, SBNA, Santander Consumer USA (SCUSA), Miami, Puerto Rico.
• Created SSIS process design architecting the flow of data from various sources to target.
• Designing and model the Mini Mart using Microsoft Visio 2013.
• Worked on SQL Server 2012in Report building
• Lead the team of 5 in meeting the Company and Client deadlines.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation
• Create different SSRS Reports based on the user’s requirement. All kinds like ad-hoc reports,
• Create Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using Sql Server Reporting Services (SSRS) 2012.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Trouble shoot any kind of data issues or validation issues
• DesignedSSIS Packagesto transfer data from various sources of the Company into the database that was modeled and designed.
• Design the ETL frame work for the data load into FRY Tables.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Worked on the ADW Data Warehouse for Santander Bank.
• Create Master Package to run different other ETL in one Master package.
• Bug fixes in SSIS, SSRS and stored procedures as necessary.
• Used C# and VB Scripts in ETL Packages where ever necessary.
• Worked in an agile scrum methodology.
• Worked with large data sources like HDFS.
• Use JIRA to update the tasks and raise tickets and bugs.
• Scheduling the jobs to run for ETL using SQL Server Agent.
• Migration of SQL Databases from SQL 2005/2008 to SQL 2010/2012/2014.
• Worked on writing the T-SQL code for the historical data to pull according to the specification requirement.
• T-SQL in constructing User Functions, CTE’s, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• SAS programming in developing internal applications.
• Perform T-SQL tuning and optimizing queries for SSIS packages.
• Worked on Incremental Loads using concepts like Checksum and Column to Column compare.
• Scheduling SSRS jobs and production support.
• Production support for SSIS and SSRS jobs.

Environment: MS SQL Server 2008, MS SQL Server 2012, Micro Soft Visual Studio, Business Intelligence Development Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL, SharePoint Server 2010 ( MS Visual Studio.NET# 2008, MS Visual Studio.NET# 2010, JIRA, Power BI, Team Foundation Server (TFS 2012), Visual Basic 6.0/VB.net, VB Script and Windows 2008 Server, Erwin Data Modeler, SAS.

Confidential, Manchester, NH

MS SQL Server / (SSRS Developer)

Responsibilities:

• UsedSQL Server 2012tools likeSQL Server Management Studio, SQL Server Profiler, SQL Server Visual Studio.
• Used T-SQL in constructing User Functions, CTE’s, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Create different SSRS Reports based on the user’s requirement. All kinds like ad-hoc reports,
• Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, Grids using Sql Server Reporting Services 2008 R2, 2012 and COGNO’s.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Created reports using crystal reports.
• Create Master Package to run different other ETL in one Master package.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Trouble shoot any kind of data issues or validation issues
• Bug fixes in SSRS and stored procedures as necessary.
• Used C# and VB Scripts in ETL Packages where ever necessary.
• Worked in an agile scrum methodology.
• Lead a team of 4 in meeting the internal and Client side deadlines
• Have lead a team of four in building reports and also facilitated client meetings in gathering requirements and suggesting better user options that Users are not aware of.
• Scheduling the jobs to run for ETL using SQL Server Agent.
• Worked on writing the T- SQL code for the historical data to pull according to the specification requirement.
• Played roles in production support for SSRS jobs.
• Perform T-SQL tuning and optimizing queries for and SSIS packages.
• Migration of SQL Databases from SQL 2005/2008 to SQL 2010/2012/2014.
• Created SSIS process design architecting the flow of data from various sources to target.
• Worked on Incremental Loads using concepts like Checksum and Column to Column compare.
• Scheduling SSRS jobs and production support.
• Use of SharePoint 2010 and TFS for version controlling, storing and report the same by creating Tasks in TFS.

Environment: MS SQL Server 2008, MS SQL Server 2012, Micro Soft Visual Studio, Business Intelligence Development Studio, SQL Server Integration Services (SSIS), SAS, SQL Server Reporting Services (SSRS), SQL, SharePoint Server 2010 ( MS Visual Studio.NET# 2010, Team Foundation Server (TFS 2012), Visual Basic 6.0/VB.net, VB Script and Windows 2008 Server, Windows 2012 Server.

Confidential, Berkeley Heights, NJ

Business Analyst/ Senior SQL BI Developer (SSIS/SSRS/SSAS Developer)

Responsibilities:

• Identify the Required columns necessary for Dimensions and Facts for the Mini Mart by following the Specifications.
• Prepare a Mapping Document which helps in designing the Database Model
• Designing and model the Mini Mart using Microsoft Visio 2010.
• Extract the DDL for the database by reverse engineering in Visio.
• Used SAS language, T-SQL in developing Functions, Views, Indexes, and Stored Procedures.
• Experience in usingSQL Server 2008and Server 2012tools likeSQL Server Management Studio, SQL Server Visual Studio.
• DesignedSSIS Packages using Visual Studio 2008to transfer data from various sources of the Company into Mini Mart with a truncate and Load.
• Set up Daily Jobs to load the Mini mart using SQL Agent Jobs.
• Perform Validation and Error Handling as a part of daily ETL Maintenance.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Used C# and VB Scripts in ETL Packages where ever necessary.
• Followed Agile Scrum Methodology in development.
• Develop a Cube in Visual Studio 2008 using the Mini Mart as the source
• Established desired Dimensions, Facts, Attribute Relationships and Partitions based on their Time Intelligence specifications.
• The Calculated Columns were created as per the reporting requirements from the Measures Chosen.
• Prepared SSRS reports on top of the Cube created using the Visual studio 2010.
• Worked on creating two Grids and two Charts representing data at different Grain level which involved tricky MDX scripting.
• Slowly Changing Dimensions (SCD)’s were considered and developed accordingly while ETL Development.
• Support for establishing SharePoint 2012 farm to host the reports by branding the site.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Use of SharePoint 2010 and TFS 2010 to store all the related work and report the same by creating Tasks in TFS.

Environment: MS SQL Server 2008, MS SQL Server 2012, Micro Soft Visual Studio, Business Intelligence Development Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL, SharePoint Server 2010 (MOSS 2007Performance Point Server, MS Visual Studio.NET# 2008, MS Visual Studio.NET# 2010, Team Foundation Server (TFS 2010), Visual Basic 6.0/VB.net, VB Script and Windows 2008 Server, Microsoft Visio 2010.

Confidential, AZ

Senior SQL Developer/ Data Analyst/ SSIS, SSRS, SSAS Developer

Responsibilities:

• Designing and modeling the Data Base Model using Microsoft Visio 2010.
• Design and build a Data Mart application to satisfy the business requirements from six different sources.
• Experience in usingSQL Server 2012tools likeSQL Server Management Studio, SQL Server Profiler, SQL Server Visual Studio.
• Used T-SQL in constructing User Functions, Views, CTE’s Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Design the ETL flexible for error handling.
• DesignedSSIS Packagesto transfer data from various sources of the Company into the database that was modeled and designed.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Created Projects using Semigo to pull data from different sources like txt, excel sql etc and also compare the data in two different tables for validation purposes respectively.
• Create Master Package to run different other ETL in one Master package.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Play a Business Analyst role to gather requirement and also know the Domain Knowledge about various Sources.
• Conduct Status meetings, Business Meetings, User's meetings to know their requirement etc.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, Grids using Sql Server Reporting Services 2012.
• Used C# and VB Scripts in ETL Packages where ever necessary.
• Scheduling the jobs to run for ETL using SQL Server Agent.
• Worked on writing the T-sql code for the historical data to pull according to the specification requirement.
• Played a major role in production support of SSIS jobs.
• Perform T-SQL tuning and optimizing queries for and SSIS packages.
• Created SSIS process design architecting the flow of data from various sources to target.
• Worked on Incremental Loads using concepts like Checksum and Column to Column compare.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Document the developed Code in SSIS, SSAS etc and take the approval of the team and send to write a playbook to Tech writer.
• Scheduling SSRS jobs and production support.
• Use of SharePoint 2010 and TFS to store all the related work and report the same by creating Tasks in TFS.

Environment: MS SQL Server 2008, MS SQL Server 2012, Micro Soft Visual Studio, Business Intelligence Development Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL, SharePoint Server 2010 (MOSS 2007Performance Point Server, MS Visual Studio.NET# 2008, MS Visual Studio.NET# 2010, Team Foundation Server (TFS 2012), Visual Basic 6.0/VB.net, VB Script and Windows 2008 Server, Microsoft Visio 2010, Semigo 2013.

Confidential, Owings Mills, MD

SQL BI Developer - SSRS Developer

Responsibilities:

• Experience in usingSQL Server 2010, 2012tools likeSQL Server Management Studio, SQL Server Profiler, SQL Server Visual Studio.
• Extensively used T-SQL in constructing User Functions, Views, CTE’s Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• DesignedSSIS Packagesto transfer data from various sources likeText Files, XML Files, Excel, Flat files to SQL Server 2008 R2
• Analyzing and designing reports and reporting solutions according to the specifications given.
• Knowledge and implementation of Reporting Services and other MS tools and in combination to design report solutions to deliver on several CI projects.
• Meet deadlines while meeting the reporting needs of the business users and project owners.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Designed the SSIS packages with error handling.
• Built a consolidated Data Mart for five different Company Organizations which was further populated and used to build a Cube on SQL Server 2012 for further reporting requirements.
• Using SQL Server Reporting Services(SSRS)delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Creating Ad Hoc and Parameterized Reports using SQL server 2008 R2 Reporting services.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports using Sql Server Reporting Services 2008 R2 and and COGNO’s.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• GeneratedSub-Reports,Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Representation for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Wrote the Visible Basic expressions in SSRS according to the requirement of the report developed.
• Worked on some ETL development using Informatica.
• Reports were created according to the report specifications and make sure to submit the work assignment before the due time.
• Scheduling the jobs for monthly reports and yearly reports
• Played a major role in production support and maintenance of SSIS jobs.
• Documenting the Developed Code by following the Organizational guide lines where ever required.
• Perform T-SQL tuning and optimizing queries for Reports and SSIS packages.
• Assisted in Creating SSIS process design architecting the flow of data from various sources to target.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation
• Use of version control system (SERENA) for proper accounting.

Environment: MS SQL Server 2008, Micro Soft Visual Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL, SharePoint Server 2007 (MOSS 2007Performance Point Server, MS Visual Studio.NET# 2008, TFS (Share Point ), Visual Basic6.0/VB.net, VB Script and Windows 2008 Server.

Confidential, Atlanta, GA

Programmer Analyst

Responsibilities:

• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design,
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Extensively used T-SQL in constructing User Functions, Views, CTE’s Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• DesignedSSIS Packagesto transfer data from various sources likeText Files, XML Files, Excel, Flat files to SQL Server 2008.
• Involved in building and maintainingSSIS Packagesto import and export the data from various data sources usingBIDSbased on the design data models.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Worked on ProClarity for creating, analyzing and deploying Reports.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS).
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Design and Develop bars, graphs and charts using Power BI tool. Develop Drill-through and Drill-down reports and dashboards.
• Created Packages in SSIS with error handling.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Involved in creating Dimensions, KPI, Measures and calculations in SSAS 2008.
• Configured SSRS 2008 with MOSS 2007 for directly deploying the report in SharePoint 2007.
• Representation for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema, 3rd Normal Form (3NF) for developing Cubes using MDX.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created SSIS process design architecting the flow of data from various sources to target.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Created reports to retrieve data usingStored Proceduresthat accept parameters.
• Using SQL Server Reporting Services(SSRS)delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.
• GeneratedSub-Reports,Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Experience in usingSQL Server 2008tools likeSQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment: MS SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SharePoint Server 2007 (MOSS 2007), Erwin, OLAP, OLDP, MDX, Performance Point Server, MS Visual Studio.NET# 2008, TFS (Share Point ), Visual Basic6.0/VB.net, VB Script and Windows 2008 Server.

Confidential

SAS Developer/C#.NET Developer

Responsibilities:

• Data transfer between Development, Testing and Production databases.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Provided support to development staff about database related issues.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation
• Scheduled database backup and performed full, incremental and differential backups of database and transactional logs
• Alteration of tables and fields as per requirements and recreation of indexes.
• Involved in gathering user requirements, draft specifications, design and create Database objects for performance tuning.
• Part of team for analyzing and implementing the physical design for the database.
• Responsible for drafting documentation for describing the metadata and writing technical guides.
• Created Stored Procedures, Triggers, Views and SQL Joins and other statements for various applications.
• Responsible for transferring of the databases and database objects from Development to Production Server using DTS.
• Analyzed and tuned complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures.
• Exposure in developing reports using SSRS 2000.

Environment: SQL Server 7.0/2000, T-SQL, Query Analyzer, Windows NT/2000 server.