SUMMARY

• Over 7+ years of Information Technology development experience in Database Design and Development inSQLserver2012/2008 R 2/2008/2005/2000 system in OLTP and OLAP environment.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server2012/2008 R 2/2008/2005/2000.
• Used TFS (Team Foundation Server) for project management and source control.
• Maintaining Version control for T - SQL, SSRS, and SSAS using TFS.
• Experienced with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensive experience in TSQL Development which includes creating Complex Business Stored Procedures, Tables, Cursors, Views, Indexes, Triggers and User Defined Functions.
• Hands on experience with T-SQL, Distributed Queries, and Correlated Sub Queries and used most of the systems function.
• Hands on experience in Writing & Debugging Stored Procedures and Triggers, Troubleshooting Database issues.
• Experience in Code Optimization and Improving Efficiency in Databases including Re-Indexing, Updating Statistics, Recompiling Stored Procedures and performing other Maintenance Tasks.
• Experience in working with SSIS Packages for Extraction, Transformation and Loading (ETL) operations.
• Experience in Import & Export of various data formats using DTS (Data Transformation Services), BCP, Bulk Insert and SQL 2012 Integration Services.
• 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).
• Experience in creating dashboards, scorecards and building reports using performance point server 2007.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Developing reports on SSAS & SSRS on SQL Server (2008/2005). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Modified the MDX query in the reports wherever necessary as per the requirement.
• Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Extensive experience on Data modeling, Erwin 3.5.2 (Logical, Physical and Star Schemas) Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling.
• Experience with working on ProClarity Analytics server to analyze results produced in the Dashboard.
• Possesses excellent technical and analytical skills with a clear understanding of data architecture, metadata, design goals of ER modeling for OLTP and dimension modeling for OLAP
• Excellent Analytical, Interpersonal and Communication Skills & Desire to Excel, Fast Learner, Hardworking and Versatile Team Player.
• Experience in Business Objects for BI and ETL Operations.

TECHNICAL SKILLS

Operating System: Windows Server 2008/2003, Windows 8/7/XP/Vista, Linux and UNIX.

SQL Server Tools: Enterprise Manager, SQL Server Management Studio(SSMS), Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler, SSIS, Profiler, Query Analyzer,.NET

ETL Tools: Export & Import (DTS), SSIS (Integration Services)

BI Tools: SQL Server Analysis Services 2005, SQL Server Reporting Services 2005

Data Modeling: Erwin, Microsoft Visio

Databases: MS-SQL Server 2012/2008/2005 , MS Access 2010/2007, Oracle 7.x to 11i.

Languages: C/C++, JAVA, J2EE, C#, T-SQL, ASP.Net, Visual Basic, PL/SQL

Web Technologies: HTML, XML, XSL, CSS, JavaScript, AJAX

Web Servers: Microsoft IIS, Apache, Apache Tomcat

Office Suite / Tools: MS SharePoint, MS Office (Word, Excel, Power Point, Access) 97/2000/07

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr SQL BI Developer

Responsibilities:

• Responsible for interacting with Business users for new reports development or any changes in the existing reports.
• Participated in Planning, Defining and Designing data based on business requirements and provided documentation.
• Developed and maintained ETL processes using SQL Server Integration Services (SSIS).
• Explored and executed SSIS packages in Business Intelligence Development Studio (BIDS & SSDT). Configuring checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Hands on experience in Writing & Debugging Stored Procedures and Triggers, using joins and sub queries and Troubleshooting Database issues.
• Created SSRS reports like table and matrix formats based on Hidden parameters, multi value parameters, dynamic connection strings, end-user sort, and fixed headers using SSRS.
• Successfully tested and stored all history versions of TSQL codes, SSIS Packages as well as reports using Team Foundation Server.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Perform unit testing at various levels of the ETL.
• I worked on LINUX and UNIX environments and executed SAS codes using SAS Enterprise Guide.
• I experienced with Teradata in this project, where we pull data using Teradata.
• I worked on BLUELIGHT which is an AMEX inbuilt tool for developing Front end Reports.
• Worked on creating Cube structure optimization for MDX query performance in Analysis Services 2012(SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube in SSAS.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Monitored user queries and stored procedures by database tracing using SQL Server profiler.
• Planned and scheduled backup strategy to ensure reliable backup.
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• SSRS experience with extensive report development experience, dash boarding and development of cubes for reporting.

Environment: Microsoft SQL Server 2012, MS Visio 2013, Microsoft Visual Studio (SSIS/SSAS/SSRS) 2010, T-SQL, Microsoft Office 2013 and Microsoft TFS 2010.

Confidential, VA

MSSQL/BI Developer

Responsibilities:

• Create data mappings and data dictionaries by understanding business data relationships by working with Business Analyst & Project Manager.
• Developed and maintained ETL processes using SQL Server Integration Services (SSIS)
• Developed packages to extract large volumes of data, transformed (cleansed)the data and loaded into Data warehouse using SSIS
• Explored and executed SSIS packages in Business Intelligence Development Studio (BIDS & SSDT).
• Scheduled SSIS Packages and configured email alerts for job failure
• Updated the multi-dimensional cube data using SSIS packages
• Configuring checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS
• Prepared detailed design documentation for SSIS packages involved in the ETL process.
• Extensively worked with TFS to keep track of all changes made in the project, also used to get the latest project version from VSS to the staging server.
• Maintaining Version control for T-SQL, SSRS, SSAS using TFS.
• Designed and Developed Custom Integration Solutions for multiple sources
• Created various OLAP cubes using SQL Server Analysis Services
• Created reports of SQL Server Analysis Server cubes in SQL Server Reporting Services (SSRS)
• Wrote MDX queries for Analysis Services
• Worked on creating calculated measures that fits business logic, using MDX queries.
• Use excel and SharePoint to connect to the cube data source
• Created SSIS packages to automate the creation of partitions and process the partitions within the cube.
• Developed reports using SSRS 2008 in various formats
• Created SSRS reports like table and matrix formats based on Hidden parameters, multi value parameters, dynamic connection strings, end-user sort, and fixed headers using SSRS
• Writing views, function and ad-hoc queries in an effort to enhance the testing automation framework in support of various application like MBT (Model Base Testing)
• Responsible for generating ad-hoc reports for MBT testing using SQL Server, MS Excel and MS Access, SSRS also develop and maintain VBA code within Excel templates and MS Access.
• Performed in performance monitoring and trouble-shooting issue in SQL Server database and validating transactions. Also scheduled maintenance job using SQL Server Agent.
• Successfully tested and stored all history versions of TSQL codes, SSIS Packages as well as reports using Team Foundation Server.
• Analyzed the error output and error log of an automated process in case of failure of the process.

Environment: MS SQL Server 2012/2008, SQL Server Analysis Services, (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Confidential, WI

SQL BI Developer

Responsibilities:

• Participated in Planning, Defining and Designing data based on business requirements and provided documentation.
• Installed and Configured SQL Server 2012/2008 enterprise edition per client request.
• Used TFS (Team Foundation Server) for project management and source control.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in SQL Server.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2012/2008.
• Created SSIS packages using Active X scripts and with Error Handling.
• Enhanced and deploying the SSIS Packages from development server to production server.
• Using different transformations like fuzzy lookup, derived column transformations etc in SSIS packages.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Perform unit testing at various levels of the ETL.
• Worked on creating Cube structure optimization for MDX query performance in Analysis Services 2008(SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube in SSAS.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Created different kinds of reports like tabular reports, matrix reports, sub-reports, drill down reports etc. and deployed them to the report manager using SSRS.
• SSRS experience with extensive report development experience, dash boarding and development of cubes for reporting.
• Integrated SharePoint Server with SSRS and deploying SSRS reports on to SharePoint Server.

Environment: SQL Server 2012/2008 R2, SSIS, SSRS, SSAS, OLAP, OLTP, Erwin, Performance Point Server, SQL Server Business Intelligence Development Studio(BIDS).

Confidential, San Francisco, C A

MS SQL Server Developer

Responsibilities:

• Upgraded database from SQL Server 2005 to SQL Server 2008 using In-Place and Side-by-Side strategies.
• Participated in many internal and client-engaged discussions about best-practices concerning SQL Server especially relating to High Availability and shared storage optimization.
• Design database models and ER diagrams integrating existing and new tables, based on business requirements and corporate database development standards. Create data mapping of the new fields to existing or new data sources
• Created, deployed, and scheduled SSIS packages to run SQL tasks and enable data transfer from several sources including Oracle, Excel, Access and flat files.
• Generated different SSIS packages using transformations such as fuzzy lookup, derived column and slowly changing Dimensions (SCD) to perform different business requirements.
• Designed and developed dynamic SSIS packages to process dynamic queries and dynamically produce flat files at runtime.
• Migrated data to transfer database objects among servers using different SSIS packages in Business Intelligence Development Studio (BIDS).
• Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS Reports. Generated different reports such as parameterized reports, drill through reports, matrix reports, linked reports in SSRS.
• Deployed reports on report manager and created different report models for the users to generate and customize ad-hoc reports.
• Defined granularity within a measure group and drill through actions using SSRS 2005/2008.
• Developed interface stored procedure to transform and load policy feeds.
• Responsible for developing and maintaining ODS run book.
• Used of T-SQL for developing complex Stored Procedures to retrieve clean data according to client requirements. Created triggers for the updating of required fields accordingly.
• Developed complex User defined functions (UDF), Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Monitored locking issues and high availability issues.
• Monitored user queries and stored procedures by database tracing using SQL Server profiler.
• Planned and scheduled backup strategy to ensure reliable backup.

Environment: MSSQL Server 2008/2005, Oracle, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Management Studio, Transact-SQL, MS Excel, Excel VBA, .NET, Live Meeting, Windows XP/2003.

Confidential

Jr. SQL Server Developer

Responsibilities:

• Prepared Functional Documents / Specs for each assigned report and uploaded them for sharing
• Used Best Practice approach with SSIS and SSRS for SQL code reviews and did documentation for the required changes
• Created OLAP applications with OLAP services in SQL Server and build cubes with many dimensions using both star and snow flake schemas
• Create Calculated Members using MDX within Microsoft Analysis Services (SSAS)
• Created Partitions and Aggregated cube with 40% performance for better performance
• Updated the multi-dimensional cube data using SSIS packages
• Generated reports in formats like Table and Matrix format using Reporting services (SSRS)
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution
• Using property expressions in SSIS to dynamically connect multiple servers at runtime (to run backend jobs)
• Train and manage developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices
• Analyzing source systems, Identifying and implementing data rules, violations and cleansing strategies
• Managing, Securing and deploying SSIS packages to SQL Server 2005
• Extract, Transform and Load data using Microsoft ETL tool (SSIS) from stage tables between different sources and target databases (Oracle, SQL 2005)
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard

Environment: Windows Server 2003, MS SQL Server2005, IIS 6.0, XML, .Net, Erwin, SSRS, SSIS, PPS 2007.