SUMMARY:

• Over 8 years of professional experience as MS SQL Server Database Design, Development and Analysis related to Retail, Banking and Health Insurance domains.
• Hands on experience in all phases of SDLC (software development life cycle) involving Requirement Highly analysis, Software design, development, implementation, testing, maintenance.
• Motivated Business Intelligence Professional using SQL Server and Microsoft Technologies.
• Proficient in SQL Server and T - SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables
• Expertise in creating, modifying, using and debugging Stored Procedures, Views, User Defined Functions
• Efficient, in creating Sub-Queries and Joins for complex queries involving multiple tables, using Exception Handlers
• Experience in Developing, Deploying and Monitoring Packages for ETL Tasks using SSIS, DTS Import/Export Utility, BCP (Bulk Copy Program) and DTS Packages.
• Expert in working with SSIS for creating packages to transform data from different OLEDB Provider like DB2, MS Access, Flat File, Excel, Oracle and Automate the ETL
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS Packages.
• Experience in designing Ad hoc reports and different types of Drill Down, Drill Through reports, Tabular reports, Cross tabs, Matrix reports, Custom reports, Sub reports, Parameterized reports in multiple formats using multiple Data Sets and creating Charts using SQL Server Reporting Services SSRS.
• Proficient in building Cubes, defining Referenced Relationships and creating Hierarchies in SSAS.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.

TECHNICAL SKILLS:

Programming Languages: C, C++, Java.

Databases: SQL Server 2008/2005/2000, 7.0, MS Access, Teradata, Oracle, DB2, AS400 and MySQL

Database Tools: SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, T-SQL, PL/SQL, OLAP, MOLAP, ROLAP, OLTP, DBCC.

Reporting Tools: SQL Server Reporting Services, MS Excel, Oracle Report Builder

Application Packages: MS-Front Page, Microsoft Office Suite, SSIS, SSAS, SSRS

.Operating System: Windows 2003, XP, 2000, NT, ME, 98, 95, MS DOS 4.0 - 6.2, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburg, PA

SQL Server Developer

Responsibilities:

• Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers.
• Understanding the business requirements, analyzing source system, source files, setting up the goals for implementing the new client.
• Created the Logical, Physical model and ETL Mapping Documents based on Business logic.
• Extracted data from Oracle, DB2, AS400, SQL Server, Flat Files, Excel and XML using SSIS and cleanse the data.
• Configured the SSIS Packages using Environment Variables for Dynamic Selection.
• Converted data types using Derived Column, Data Conversion Transformation.
• Converted various data files (CSV, XML, COBOL and Legacy Flat Files) based on business logic using Script Task and Script Component.
• Generated 7M Record files using SSIS Script Task and Script component Format the files based on client requested format using.
• Created analytics system using PowerBI and SSRS 2016 to monitor status and efficiency for development of business reports.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau .
• The project involved extending the Datawarehousing functionalities by adding more countries and products.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• Created logging, custom logging and error handling packages.
• Creating, Modifying SSAS Measures, Dimensions Attribute relationships and Hierarchies.
• Designed SSAS Cubes, Named Calculations for Dimensions.
• Dimension and Fact table design and cubes for KPI, Defining hierarchies and rollups.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Targit.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Created Advanced Reporting Services Programming Using the Reporting Services Web Service.
• Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
• Created Development and Production support documents.

Environment: SQL Server 7.0/2008/2005 Enterprise Edition, Visual Studio 2005, DB2, AS400, Microsoft Visual Basic, VBScript, XML, Microsoft Visio, Windows 2003 R2.

Confidential, Charlottesville VA

SQL Server Developer

Responsibilities:

• Involved in gathering the requirements, conducted meetings with clients and documented the requirements and ITIL assessment & implementation of project
• Responsible for the design, development and implementation of mappings/transformations based on source-to-target specifications, defining ETL (extract, trans0form, load) and ETL development standards and conventions.
• Designed best practices document for ETL and Reporting systems.
• Tableau Modified current database by adding tables, altering referential integrity and relationships to support online system.
• Developed new mappings using SSIS Look Up/Aggregation transformations to match the needs of the business case.
• Ran Informatica sessions and batches using UNIX Shell script.
• Performed Pre and Post session shell commands.
• Developed Tabular solution model and assisted in creating PowerBI reports for Media Industry Analysis.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in.
• Designed slowly changing dimension transformations (SCD) and customized the existing mappings.
• Created DTS Packages and converted DTS packages to SSIS 2005
• Performance tested a number of BI, BW Reports pulling data from the Data warehousing.
• Converted data using Derived Column, Data conversion transformation and Script task.
• Used SSAS MDX to extract data from cubes and Created MDX script for representing Cube Calculation.
• Created views to reduce apparent database complexity for end users and preventing sensitive columns from being selected.
• Created Ad-hoc reports, Tabular reports, Drill down and Drill up reports.
• Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.
• Delivered the final SSRS Report using the Request Handler.

Environment: SQL Server 2005 Enterprise Edition, Informatica 7.1.2, Oracle, Teradata, Microsoft Visual Basic, VBScript, XML, Microsoft Visio, Windows 2003, IIS 5.0, MOSS, Microsoft Reporting Service, BO XI R2.

Confidential, Sacramento CA

SQL Server Developer

Responsibilities:

• Created ETL to load transactional data to GameStop Data Warehouse and built Analysis Services Database to provide summarized data to Targit Client for dashboards.
• Created Custom Measure groups (Calculated Members) in cube to implement business logic
• Created Scopes in the cube to provide flexibility for users to see revenue in their local currencies.
• Created roles and implemented security at department level to allow/restrict users to view data depending on the departments.
• Created partitions and designed various storage modes to increase the performance of cubes using SSAS.
• Created dimensions in the performance point server.
• Imported data into Performance point server from SQL database through CSV files.
• Successfully created and implemented a targeted territory growth campaign centered on Data warehousing and Business Intelligence .
• Consolidated data from OLTP databases in to OLAP using SSIS as ETL.
• Created parameterized stored procedures to implement business logic.
• Created views on database for better performance and security.
• Created Sql jobs and scheduled them for nightly loads.
• Created SSIS package to get data from share point and load Cubes.
• Implemented pre-validation and post-validation for the data imports.
• Created archival jobs to archive last # iterations of data.
• Involved in creating windows installer to install the application in SIT/UAT/Production environments.
• Created work flow items in version control system (Visual Studio TFS) to assign work to team.
• Tuned the performance by making use of clustered and non-clustered indexes.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Performing query plans and making sure each and every query is using appropriate useful indexes.
• Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.
• Created UTP document and performed unit test processing.
• MDX queries to retrieve data from cubes using SSIS.

Environment: Microsoft SQL Server 2005, SSIS 2005, SSRS 2005, SSAS 2005, Visual Studio 2005/2008, Microsoft Office Performance Point Server, Planning Business Modeler, Microsoft Office share point 2007, Targit, windows 2003/XP/vista,, .NET Framework, C#, VB, ASP.NET, ADO.NET.

Confidential, CA

MS SQL Server Developer

Responsibilities:

• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
• Creating functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Created packages in both DTS and SSIS.
• Created packages and scheduled it to get data from OLTP.
• Administered the ETL process for Data warehousing by to form the data mapping through data analysis.
• Created ETL package for data conversion using various transformations tasks.
• Creation of New NT Logins and granting privileges to users/Groups and objects.
• Experience in building star schema and snowflake schema depending on the business data requirement.
• Used DBCC commands to check physical and logical consistency of the databases and Rebuild indexes.
• Backup and recovery of Master, MSDB and Application databases
• Rebuilding Indexes and Tables as part of performance tuning exercise
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
• Scheduling Jobs and Alerting using SQL Server Agent
• Developed custom reports using SSRS/SQL Server BI studio.
• Created reports that call Sub reports in SSRS.
• Involved in writing MDX queries.
• Created Cubes from which data can be retrieved rapidly by enterprise information consumers.

Environment: Windows 2003/XP/vista,.NET Framework, MS Excel, Microsoft SQL Server 2005/2008, SSIS, SSRS, SSAS, T-SQL, Visual Studio 2005/2008, Team foundation server (Version Control Systems.

Confidential . Richardson, TX

SQL Developer

Responsibilities:

• Designed, coded, tested and implemented user interfaces, procedures and functions for new and existing software application requirements.
• Created Business Requirements, Design, Functional Specifications.
• Created custom and Ad hoc reports using SSRS.
• Login and User Management: Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Analyzed the Business benefit of columnar storage for Data warehousing.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Materialized views, dimensions and stored outlines for optimal performance.
• Wrote Triggers and Stored Procedures.
• Actively involved in Normalization & De-normalization of database.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Created complex variables, multiple breaks, sorts in the reports.
• Created generic Measure class for generic measures, and created separate class for conditional objects.
• Decided upon the locking strategy that could be used for various batch Programming structures & Transactions.
• Involved in System testing.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2000/2005 Enterprise Edition, SSIS, SSRS, MS .NET Frame Work, ASP.NET, T-SQL, C#, Access 2000 & Windows 2K platform ADO.NET, MS Project.

Confidential,

SQL Server Developer

Responsibilities:

• Installation and Configuration of SQL Server 2000.
• Monitor the performance of SQL server using Windows Performance Monitor and Spotlight.
• Used SQL DTS to setup ETL processes.
• Promote databases from QA to Production environment.
• Development and modification of document related to systems and operational procedures.
• Tuned Stored Procedures and Queries for optimal Database performance.
• Consolidation and Migration of databases from decommissioned servers to newly built blade servers.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in incremental data loading.
• Materialized views, dimensions and stored outlines for optimal performance.
• Create and implement logins and user permission to databases.
• Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
• Implemented and successfully tested Log shipping in SQL Server 2000 and SQL Server 2005.
• Creating Database objects - tables, views, and functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Development of SQL Server Maintenance plan, scheduling of Jobs, Alerts and Troubleshooting.
• Modified databases in QA and Production environment as per need and user’s request.
• Developed multiple reports using reporting services.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: MS SQL Server 2000, Windows 2000 Advance Server, SSRS, Windows 2003 Server, ASP, XML, T-SQL, MS Excel, MS Access.