SUMMARY:

• 8+ years of experience as SQL Server Developer/Business Intelligence Developer Experience includes requirements gathering, development, design, testing, deployment and maintenance of SQL Server technologies.
• Experience in OLTP, OLAP/Data Warehouse, and Data Mart and ODS Data Bases.
• SQL Server 2008 R /2016 RDBMS database development including T - SQL programming
• Proficient in T-SQL queries using Stored Procedure, Dynamic SQL, joins, Views, User defined functions, Triggers, Cursors, CTE, DML, and DDL etc.
• Proficient in Performance Tuning of SQL query or Query Optimization.
• Knowledge in writing PowerShell scripts to automate administrative tasks.
• Good experience in SAS programming and SAS macro language Structured Query Language (SQL)
• Experience SAS Macros and SAS SQL to query data and to obtain results that were generally stored as delimited text
• Excellent in MS SQL Server 2005/2008 suite of products like SSIS, SSAS and SSRS.
• Good experience in developing reports using SQL Server (SSRS)
• Experience in creating SSIS packages to process the data. Make use of various Control Flow and Data Flow items from Toolbox. Perform Error handing and version log using Event Handler.
• Error handling in SSIS packages and PowerShell script for automation process, executing bat files.
• Experience in Shell scripting
• Wrote PowerShell scripts to monitor SQL Server services and perform other administrative functions.
• Good at creating SSAS cubes, configuring and managing data sources, data source views, dimensions, roles and creating hierarchies using SSAS .
• Created summary reports on SSAS cubes.
• Designed Partitions in Cubes on time for improvement in performance using SSAS
• Experience in Visual Studio Team Foundation Server, Visio
• ETL experience across Oracle, Access, MySQL and Excel
• Proficient in writing MDX query and good knowledge of all MDX Functions
• Experience in making formal and informal presentations to technical and non-technical staff
• Expert in Creating and managing roles for security in SSRS reports.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Excellent experience in Crystal report. Use tables, view, Store Procedure as data Source.
• Strong Applications Development experience with back-end databases such as SQL Server, SQL MDS 2012, Oracle and MS Access using OLEDB and SQL client.
• Handle ODBC, OLEBD, .net Object as Crystal Report Data Source, write Complex Crystal Formula to format report as business logic and worked with parameters.
• Good experience in SSAS to create cubes with various measures and dimensions for financial reports generation.
• Hands on experience using DQS services and DQS tasks for Data Cleansing and creating rules for business.
• Expertise in analyzing requirements creating and maintaining test documentation like Test Plan, Test Cases, Test Strategy, Requirements Traceability Matrix
• Hands on experience with N-tier architecture for presentation layer, the Business and Data Access Layers and were Coded using C# also worked with agile methodology for Application Development.
• Knowledge in development of Windows and Web Application using .NET Framework 4.0, 3.5, 3.0, C#, .NET, ASP.NET, ADO.NET and MS SQL Server.
• Understanding query flow using execution plan and tuning the query to appropriate Scan/Seek (Index, Seek, Index Scan and Table Scan)
• Collaborated with technical team and business stakeholders to resolve issues in a timely and efficient manner, and communicating testing status to upper management.
• Experienced in Application Performance Monitoring
• Active Directory Basic operation and integration with related application for directory entity.
• Manage Group, Role, Organizational Unit almost the whole profile of user.
• Proficient in preparing technical documents based upon user requirement.

TECHNICAL SKILLS:

RDBMS/DBMS: MS-SQL Server 2014/2012/2010, 2008, Oracle 11g/10g, MySQL and MS Access 2003

Database Technologies/Tools: SQL Server Entreprise Manager, Microsoft Management Console, EIM, SQL, T-SQL, DQS, OLTP, OLAP. Microsoft Visio, ER Studio, Appscan

Reporting Tools: Microsoft SQL Server Reporting Services, Crystal Reports.

Operating Systems: UNIX, W indow s NT/XP /Vi sta/7/2008

Programming Languages: SQL, T-SQL, C#, HTML, VB.Net, C++

Internet Technologies/ Tools: ASP.NET, XML, C SS, HTML, Ra tiona l R ose, MS Office, Visua l Studi o 2 0 14/2012/2008, DTS, SSAS, SSIS, SSRS, PowerShell

Data Warehouse/ Business Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio, SSAS, Business Intelligence Development Studio (BIDS)

PROFESSIONAL EXPERIENCE:

Confidential, Portland, Oregon

SQL Server BI Developer (SSAS/SSIS)

Responsibilities:

• Worked on the integration of existing systems at Data warehouse and Application systems level.
• Data analysis of existing data base to understand the data flow and business rule applied to different data bases by SQL.
• Worked to standardizing the new architecture, data flow and documentation of the process and business flow at enterprise level.
• Participated in all phases of project including Architecture, Design discussion, Requirement gathering, Analysis, Coding, Testing, Documentation.
• Developed Business logic layer by implementing Object Oriented Programming languages (OOPS) concepts abstraction, encapsulation, inheritance, polymorphism in C#.
• Extensively used SQL for Data Analysis and to understand and documenting the data behavior within and between two companies.
• Designed and created dimensional data model that help risk management to identify insured house information for tracking and analysis with fact and dimension tables on daily basis.
• Reverse engineered existing data bases to understand the data flow and business flows of existing systems and to integrate the new requirements to future enhanced and integrated system.
• Designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Worked on defining deadlines and helped team to meet the deadlines.
• Extensively worked on documentation of Data Model, Mapping, Transformations and Scheduling jobs.
• Designed Mapping Documents and Mapping Templates for SSIS ETL Developer.
• Managed Multiple Highly Complex Tabular cubes pulling from 2TB Data Warehouse.
• Responsible for the entire SSAS infrastructure. Responsible for communicating SSAS and BI messages to BI and Business Teams.
• Developed numerous SSAS Tabular Cubes to analyze Cloud Infrastructure, Application and Business Data with Visualization on Microsoft BI Platform.
• Automated daily database refreshes using PowerShell from production to stage area and on-demand refreshes from production to test environments, involving SQL versions2016, 2014/2012/2008.
• Wrote PowerShell scripts to monitor SQL Server services and perform other administrative functions
• Deployed naming standard to the Data Models at enterprise level and followed company standard for Project Documentation.
• Designed aggregations and pre-calculations in SSAS.
• Involved in designing Partitions in Cubes to improve performance using SSAS.
• Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#, Entity Framework and SQL.
• Designing ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys) and convert them to physical data model including capacity planning, object creation and aggregation strategies, partition strategies, Purging strategies as per new architecture.
• Working on Gap Analysis of existing warehouse models.
• Conducted meetings with the business and technical team to gather necessary analytical data requirements in JAD sessions.
• Partitioned tables based on the requirement and developed purging and archival rules.
• Designing and developing strategies for Data Conversions and Data Cleansing
• Creating Data mappings, Tech Design, loading strategies for ETL to load newly created or existing tables.
• Created Schema objects like Indexes, Views, and Sequences, triggers.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Pre-populate the static tables in the Data warehouse.
• Responsible and Involved in Application Performance Monitoring
• Developed strategies and loading techniques for better loading and faster query performance.

Environment: SQL Server 2016, 2014, Visual Studio 2015, DTS, SSIS, SSRS, SSAS, C#, SharePoint, T-SQL, Microsoft Office, Erwin, Windows Server 2008R2.

Confidential, St. Louis, Missouri

SQL Server BI Developer (SSAS/SSIS/SSRS)

Responsibilities:

• Installed, configured, maintained and supported SQL server 2012 and 2014 in different environments.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Migrated objects from SQL to Oracle using SQL developer.
• Created tables, indexes, views, aliases and constraints.
• Created and executed SQL statements in both SQL production and development environments.
• Used a MERGE Statements to modify data in a target table based on data in a source table.
• Creating, Inserting, Updating, and Deleting Data by Using MERGE statements
• Provided SQL Support to front end users.
• Create SSIS packages to process the data. Make use of various Control Flow and Data Flow items from Toolbox. Perform Error handing and version log using Event Handler.
• Work with data analytic to check and manage SQL Server performance
• Transferring the data (ETL) to Data warehouse by SSIS and process SSAS cubes to store data to OLAP databases.
• Created dimension and fact tables and developed the ETL’s to load dimension and fact tables from Stage for SSAS cube.
• Created relationships between measure groups and dimensions in a cube using MS SQL Server Analysis Services (SSAS).
• Created and worked on configure/ run/ debug EIM process
• Used N-tier architecture for presentation layer, the business and the data access layers and were coded using C#, worked with Agile methodology for application development.
• Created EIM process to load the Claim status Bill Feedback data from EIM tables to Siebel base tables and created activities for missing data.
• Manage Large Scale Store procedure and tuning to reduce execution time
• Developed and maintained a backup and recovery strategy for all databases.
• Rewrite the existing code for long running queries by replacing cursors with various joins, common table expression (CTE) and indexing
• Work with EVENT MANAGER to manage the whole scheduling reports and manage recipient scheduling.
• Used Report Manager to assign roles, permissions and to create report schedules.
• Configured Reporting Services to a scale out deployment to allow concurrent users.
• Used Lookups Transformation to get the data from reference data sets
• Created permanent tables, temporary tables and table variables.
• Used Joins to write queries that retrieve data from more than one table.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Implementing the calculations to aggregate physical measures.
• Developed T-SQL queries and stored procedures with multiple parameters to created data sets for reports.
• Developed SQL scripts, ensured optimal performance of the queries to generate reports from various relational databases like Oracle.
• Created report snapshots to improve the performance of SSRS.
• Created SSRS report to read blob data for various types of images from a SQL table
• Created Parameterized reports, Cross-Tab reports, drill down reports & Summary reports by using SSRS.
• Created several SSIS Packages to load data from various data sources including Flat files, MS Excel, MS Access, to SQL Server
• Created Data Stage Job to load data from SQL server 2014/2012 to Oracle 11g.
• Created complex SSIS packages using various transformations.
• Created SSIS package to load multilevel XML data into Oracle database.
• Used Master Data services (MDS) to create golden records for customer.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Created SSIS package to loop through multiple shared folders for multiple file servers to get all the files along with file path and folder names.
• Created Event Handlers for the SSIS package on Error, on Post execute.
• Cleaned existing data and converted them into useful SAS Datasets, merged datasets and created reports based on requirements.
• Developed ad-hoc reports as per business requirements and created various reports like summary reports, tabular reports
• Used named calculations and new named query cubes to calculate values at run time.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Created stored procedures to load data into fact tables and dimensions tables for spot fire reporting dashboard

Environment: SQL Server 2014, 2012, 2010, SSAS, Control-M Manager, DTS, SharePoint, C#, Visual Studio, SSRS 2008, T-SQL, Visio 2010, Crystal Report 2011, .Net, Enterprise Manager, Windows Server.

Confidential, Cary, NC

SQL Server BI Developer

Responsibilities:

• Created Databases with STAR Schema and managed schema objects such as Tables, Views, Indexes and referential integrity depending on our requirements.
• Involved in development of Windows and Web Application using .NET Framework 4.0, 3.5, 3.0, C#, .NET, ASP.NET, ADO.NET and MS SQL Server.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results.
• Created ETL packages with different data sources and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Created dynamic packages in SSIS to meet the requirements and created Database Maintenance Plans for the various data Sources and centralizing the data using SSIS.
• Created Parameterized Reports, Cascaded Reports and Linked Reports and thorough knowledge of report server architecture using SSRS.
• Created reports that included formatting options such as Grouping, Sorting, Drill-down, Parameter prompts in SSRS.
• Created different Parameterized Reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Created Subscriptions to send the reports to a group of people every day through Email.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Using SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
• Involved in creating Sequence Diagrams and involved in creating dynamic models using UML.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports per business requirements using SQL Server Reporting Service.

Environment: Microsoft SQL Server 2012/2008R2 Enterprise edition, SSMS, SSIS, SSRS, BIDS, MS Excel 2003, Microsoft Visual studio.

Confidential, Hauppauge, NY

SQL Server BI Developer

Responsibilities:

• Designed and implemented stored procedures and triggers for automating tasks.
• Involved in developing SSIS packages using BIDS for Incremental loading process including getting data from transactional system in to data ware house and then making data available to be viewable in the cube.
• Loading data from various sources like, flat files, to SQL Server database Using SSIS Package.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing and Scheduling the SSIS packages and Jobs.
• Involved in writing MDX Scripts for the OLAP CUBES.
• Developed multidimensional Objects (Cubes, Dimensions) using MS Analysis.
• Created Analytical Reports using ProClarity tool.
• Designed and developed various abstract classes, interfaces, classes to construct the business logic using C#, Entity Framework and SQL.
• Involved in Creation of Dimensions using STAR and SNOWFLAKE Schema
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting, so create reports that draw content from a variety of data sources.
• Design and create report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports.
• Used SSAS to create cubes with various measures and dimensions for financial reports generation.
• Deployed SSRS Reports in SharePoint for web based access for multiple end users
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Created reports using stored procedure and involved in scheduling, creating snapshots and subscriptions for the reports SSRS.
• Involved in improving the performance of the system.
• Developed and executed several optimized queries in SQL.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Deployed SSRS Reports in SharePoint for web based access for multiple end users.

Environment: Windows XP, MS SQL Server 2008 R2, SQL Server Management Studio (SSMS), Query Analyzer, Enterprise Manager, T-SQL, SSAS, SQL Server Integration Services (SSIS), Microsoft Excel, SQL Server Agent.

Confidential, Charlotte, NC

SQL/ BI Developer

Responsibilities:

• Experienced in creating different types of reports Drill Down Reports, drill through reports, parameterized reports, crystal report, matrix reports, tabular reports, chart reports as per the user request.
• Created Ad-hoc Reports Using Report Builder 1.0 and Report Builder 2.0.
• Worked for Web sales department to create, test, distribute and maintain Crystal Reports.
• Partnered with various Business lines to improve existing reports and create new control reports to reduce errors and streamline the process.
• Provide suggestions to assigned business line to streamline reporting and procedures as necessary.
• Built the SSRS reports from Different Databases like Oracle and SQL Server.
• Involved in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Pulled the data from DB2 Server by using open queries and SSIS Packages to load data into SQL Server database to create SSRS Reports.
• Creating Indexes and used Scan and Seeks for performance tuning.
• Part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
• Deployed the report rdl files to the report manger (or) share point site to make report visible for user by using web server link, it’s easy for upper management to view the reports in report manager or share point site.
• Utilized functions in DB2 Queries to concatenate, finding date differences, finding date part, finding part of the string in DB2 Server which are different from SQL Functions.
• Worked on Team Foundation Sever 2008 to store (check in or check out) the SQL queries, packages, and reports to share them with the team members. Even if the local system crashes down we can able to use the code from TFS.
• Documented the process (Upper management reports) of pulling the data from DB2 Server and load it into the SQL Server tables, so that it could be used as a training manual for new hires and for audit validations.
• Responsible for interacting with business users to learn the business requirements and business functionality to improve the reporting process.
• Used N-tier architecture for presentation layer, the business and the data access layers and were coded using C#, worked with Agile methodology for application development.
• Transferred data from various data sources/business systems including MS Excel, MS Access, and Flat Files etc. to SQL Server using SSIS/DTS packages using various features.
• Involved in Creating SSIS Packages to pull the data from DB2 Server, Flat files and Excel Files then load the data into the SQL Server table destination.
• Utilized different types of task’s (Execute SQL task, Data flow task, For Loop Container, For Each Loop Container, Bulk Insert task) to load the data from source to destination based on business requirement with all conditions applied by task functionality.
• Used different transformations (Derived Column, Data Conversion, Condition Split, Lookup transformation, multicast, and script component transformation) under Data Flow Task while pulling and loading data from one source to another source to makes the data clean and consistent.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Responsible for creating and scheduling the jobs to run store procedures and SSIS packages on daily manner to automate the loading process by using SQL Server Agent, adding new steps to the existed jobs in the SQL server agent.

Environment: Enterprise Manager, SQL Server 2008/2012, Control-M Manager, Oracle 9i/10g Visual Studio 2008, SSIS, SSAS, SSRS, C #, T-SQL, Performance Tuning, Visio 2010, Windows Server.

Confidential

SQL Developer & Analyst

Responsibilities:

• Analysis of Business logic implementing same in technical specifications.
• Involved in Developing Business logic layer by implementing Object Oriented Programming languages (OOPS) concepts abstraction, encapsulation, inheritance, polymorphism in C#.
• Developed Complex SSIS packages for development of OLAP database from OLTP source.
• Developing Batch data flow process using Incremental extraction methodology.
• Performed database design by analyzing business requirements.
• Developed complex SQL queries, stored procedures, and Job scheduling using server agent.
• Worked on optimization and tuning of SQL queries and indexes.
• Assisted in the application development, debugging, configuration, and optimization from database
• Reviewed applications and database design for compliance with best practices standards.
• Assisted in troubleshooting and resolution of database issues.
• Supported business functions through use of internally-developed and third-party software solutions.

Environment: SQL Server 2005, SSIS, T SQL, MS Visual Studio, Crystal Reports XI, TFS, MS Visual Source Safe, Citrix, IBM Clearcase, Windows 2003/XP