SUKANYA

Microsoft SQL Server BI Developer

Mob: +1-484-***-****

E-mail: acubcy@r.postjobfree.com

Summary:

Over 8+ Years of extensive IT experience in MS-SQL Server 2012/2008R2/2008/2005. Developer in creating Business Intelligence Solutions like SQL Server Reporting Services, SQL Server Integration Services and SQL Server Analysis Services.

Experience in IT, Finance, Banking, Telecom, and Insurance environments with primary skill on the Analysis, Design, and Development and Implementing Client/server application using Microsoft SQL Server and BI suite for both OLTP & OLAP.

Experience in writing Distributed Queries between SQL Servers to monitor and SQL Server for deadlocks, long running queries and tune the same to improve performance.

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key & Foreign Key Constraints.

Excellent knowledge in creating Databases, Tables, DDL/DML Triggers, Locks, Cursors, CTE and Indexes using T-SQL.

Have a good experience in usage of Tran Count, Row Count, and Raise Error, Try Catch Blocks, Set Xact.

Developer in creating Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), like SSRS, SSIS and SSAS, Notification Services (SSNS) and MDX ad-hoc Reporting.

Experience in Implementing various SSIS features like Event Handling, Precedence Constraints, Break Points, Check Points, Transaction, and package configurations and Logging for Complex SSIS Packages

Have a good experience in usage of SSIS Control Flow items (For Loop, For each loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).

Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule using SSIS Packages.

Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments.

Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Bulk Insert, BCP, and XML.

Experience in designing complex reports like Table reports, Cross-Tab, Pie Chart reports, Drill-Down reports, Drill-Through reports, Dash-Board reports, Ad-Hoc reports, Linked reports, Parameterized reports, Cascading reports, Snapshot reports using SSRS based on Client Requirement

Experience in deploying the SSRS reports using Report manager.

Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS.

Strong experience with Group reports, sub-group reports, Adjacent group reports, Total Reports, Sub-total Reports, Grand Total Reports, Crystal Reports, Strong Data Mapping, Data modeling experience using Erwin Data Modeler and MS Visio.

Experience in designing, building and deploying Cubes with Star Schema and Snowflake Schema using SQL Server Analysis Services (SSAS 2005/2008/2012).

Experience in Cube Optimization Techniques such as Cube Partitioning, Aggregation Wizard, Defining Hierarchies.

Experience in designing Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models.

Flexible, enthusiastic and project oriented team player with good written, verbal communication to develop creative solutions for challenging client needs.

Self-motivated, diligent with the ability to quickly adapt to new environments and changes.

Capable of forming and maintaining positive and productive working relationships in internal, external and team environments.

Technical Skills:

Databases

MS SQL SERVER 2012/ 2008 / 2008R2/2005, MS Access 2007/2003/2000,DB2, Oracle 9i/11g,10g.

Operating Systems

Windows 2007/XP/Vista/2003, MS-DOS,LINUX,UNIX.

OLAP/Reporting Tools

SQL Server Analysis service (SSAS),SQL Server Reporting Service (SSRS),MDX, Business Objects 6.x

ETL Tools

SQL Server Integration Services (SSIS)

Other Tools

Microsoft Visual Source Safe, Microsoft Office, MS Visio, Red Gate Data Compare, SQL Compare, Beyond Compare.

SQL Server Tools

SQL server management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler, FTP.

Programming languages

Transact-SQL,PL/SQL,MS-SQL,C#, VB.Net, VB script, ASP.Net HTML,XML

Data Modeling

Star Schema Modeling, FACT, Dimensions Tables, SQL Physical and Logical Data Modeling, Erwin 4.0/7.x,9.0

Client: QVC, West Chester, PA Sep 2014 – Till Date

Role: MS SQL Server SSRS/SSIS Developer

Description:

QVC is the world's leading video and ecommerce retailer, offering a curated collection of desirable brands to millions of customers around the globe each day through broadcast, Internet, and mobile sales platforms. QVC is the world's top multimedia shopping company in terms of viewers and revenue and ranks among the top online mass merchandise retailers.

Responsibilities:

Responsible for Managing BI Environment which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and Reporting tools.

Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.

Generated DDL scripts for database schema and created all other database objects.

Involved in merging existing databases and designed new data models to meet the requirements.

Create joins and sub-queries for complex queries involving multiple tables.

Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.

Used various SSIS tasks such as Conditional Split, Derived Column etc. which including data validation checks during Staging, before loading the data into the Data warehouse.

Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, Sort, Merge join, script component.

Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system.

Responsible for implementation of Data viewers, SSIS Logging, Error configurations for Error handling, Try Catch Blocks in the packages.

Responsible for Performance Tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.

Created Alerts to report successful or unsuccessful completion of Jobs.

Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions and Functions, Sorting the data and Subtotals for the reports using SSRS.

Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.

Created reports to retrieve data using Stored Procedures that accept parameters.

Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.

Performed checkpoints/reviews on designs and code being created by the other Data Integration developers.

Responsible for creating and executing Test cases, performing UAT and documenting the results.

Extensively used Calculations, Variables, Break Points, Drill, and Slice and Dice for generating reports.

Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS.

Experience in building and maintaining Data marts. Created roles for using the cubes.

Implemented the calculations to aggregate physical measures.

Responsible in creating and customizing Dashboard pages.

Created and deployed Adhoc reports, drill down reports as required.

Performance tuning the existing reports.

Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.

Developed various Charts (Pie Charts) and Graphs like Bar Chart (Side by Side, Stacked) using SSRS.

Responsible for Conceptual, logical and physical design with a significant effort towards application using ERWIN.

Environment: Erwin, SQL Server 2012/2014,Microsoft Visual Studio 2013/2012, MS Server Integration services, SSRS (MS server Reporting Services), MS SSAS, T-SQL, Window 2012 Server, Oracle 9i/10g/11g,Db2,Crystal Reports.

Client: Small Business Administration, Washington, D.c Jul 2013-Aug 2014

SQL Server Developer/BI Developer

Description:

The U.S. Small Business Administration is an independent agency of the federal government to aid, counsel, assist and protect the interests of small business concerns, to preserve free competitive enterprise and to maintain and strengthen the overall economy of our nation. The SBA helps Americans start, build and grow businesses. Through an extensive network of field offices and partnerships with public and private organizations, SBA delivers its services to people throughout the United States.

Responsibilities:

Obtained initial requirements from the users of various departments and corresponded with them throughout process.

Optimized the performance of queries with modification in T-SQL queries, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.

Created DDL scripts to create Database schema and Database objects like tables, stored procedures, views, functions using T- SQL.

Created Triggers to enforce data and referential integrity, on the specific table which helped users to prevent inserting invalid data or to respond to a certain events like INSERT, UPDATE and DELETE.

Involved in database designing using Normalization, and also Normalized the entities and De-Normalized for data warehousing purpose.

Used ADO, DAO objects to access data from other sources i.e. from access and SQL Server

Performed operations like Data validation and Error Handling, Event Handling after Extracting data, and Performed Tuning and optimized queries to increase the performance.

Have good hands on experience working with FTP component in SSIS and used Configuration Manage to retrieve the data.

Designed high level ETL/SSIS architecture for overall data transfer from the OLTP to Data warehouse with SSIS and also prepared ETL/SSIS mapping processes and maintained the mapping documents.

Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, Fuzzy Lookup, merge, Derived Column, Conditional Split, and Slowly Changing Dimension (SCD) to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.

Automated the process of data storing to DB and also Sending Data to other Systems through Windows Task Scheduler and also SQL Agent Job.

Configured SQL Mail Agent for sending automatic emails when an event is failed or succeeded.

Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2012 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Created Static Reports using MDX queries and created MDX Base Report Definition.

Created complicated reports like parameter based reports, graphical reports, and Sub Reports well-formatted reports, drill-down reports, drill-through reports, matrix reports, chart and tabular using SSRS.

Successfully deployed reports in various sources like XML, Web browser and PDF.

Environment: SQL Server 2012/2008/2008 R2/2005 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2012, Oracle 10g/9i, DB2, Microsoft Visual Studio 2013/2012.

Client: Shire Genetic Therapy, Lexington, MA Jul2012-Jun2013

SQL BI (SSIS, SSRS, SSAS) ETL Developer

Description:

Shire Genetic Therapy enable people with life-altering conditions to lead better lives and focus on developing and delivering innovative medicines for patients with rare diseases and other specialty conditions. Shire priorities are to drive optimal performance of our existing products, increase patient access to these medicines, and to build pipeline through research and development in order to deliver new medicines to patients.

Responsibilities:

Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Created Stored procedure, Views, Cursors and functions to support application

Use DDL and DML for writing triggers, stored procedures, and data manipulation.

Created SSIS package to extract, validate and load data into Data warehouse.

Extensively worked on creating SSIS packages and have used For each Loop containers, Sequence Container for developing processes and loaded data using different transformations such as Derived Columns, Condition Split, Aggregate, Merge Join and Union all.

Created the SSIS packages and scheduled them using SQL Server agent.

Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Utilized Event Handling effectively to generate audits and logs for the generated SSIS packages.

Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.

Creating SSIS Packages to extract data from CSV and TXT files into schema tables and sends Email attachment of the extracted data.

Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Employing data warehouse principles and theories, including knowledge of the various tactical approaches to data warehouse development.

Designed and implemented Parameterized and cascading parameterized reports, Drill Through, Drill Down reports, Sub reports, ad-hoc reports using SSRS.

Deploying and Scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.

Created snapshots of reports to reduce the load on the server using SSRS 2012.Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units.

Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.

Performed partitioning of cubes as well as cube optimization in order to increase the performance of cubes

Environment: SQL Server 2012/2008 R2 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Crystal Reports, Windows Server 2008, Oracle 9i, MS Excel, MS Access, C#.Net, VB script,Microsoft Visual Studio 2008.

Client: Anthem Health Insurance, Wallingford CT Oct 2011-Jun2012

BI/SQL Developer (SQL/SSRS/SSIS) Developer

Description:

The Anthem Health Insurance Company is the health insurance provider. This company provides various health care plans for its customers. And they have branches in 18 states. The scope of this project was to, extract data from various sources and server locations and load into SQL Server 2005 and create reports such as Claim Detail Report, Accounts Report. Creation of data warehouse, store procedures, triggers.

Responsibilities:

Created rules, defaults, tables, views, user defined data types, joins, sub-queries and user defined functions.

Use DDL and DML for writing triggers, stored procedures and data manipulation.

Actively designed the database to fasten certain daily jobs, stored procedures.

Optimize query performance by creating indexes (clustered & non-clustered index).

Created new database objects like Sequences, Procedures, Functions, Packages using T-SQL in Development and Production environment for SQL Server

Worked with the Migrate feature in the Web Matrix Databases workspace.

Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments for the SSAS cubes.

Created the SSIS packages and scheduled them using SQL Server agent.

Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join, script component and Slowly changing dimension .

Utilized event handling effectively to generate audits and logs for the generated SSIS packages.

Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.

Employing data warehouse principles and theories, including knowledge of the various tactical approaches to data warehouse development.

Designed and implemented Parameterized and cascading parameterized reports using SSRS.

Experience in creating snapshots of static reports and configure subscription.

Developed Query for generating Drill Down and Drill through Reports, sub report in SSRS.

Deploying and Scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.

Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.

Created snapshots of reports to reduce the load on the server using SSRS 2008

Interacted with Business Users and Analyzed user requirements and built reporting solutions such as relational database reports OLAP reporting, dashboards.

Environment: Erwin 4.1/7.2.5, SQL Server 2008R(2), Microsoft Visual Studio 2010, MS Server Integration services, SSRS (MS server Reporting Services), MS SSAS, Window 2008 Server, Oracle 9i,Db2,Crystal Reports.

Client: Qualcomm, Hyderabad, India Mar2009 – Sep 2011

SQL Server Developer/SSIS

Description:

Qualcomm plays a central role in the rapid adoption and growth of 3G and next-generation wireless around the world. Its visionary technology leadership has been carrying the world forward, changing it by improving the way people communicate, work and live. And with that same pioneering spirit, Qualcomm is still innovating; still chipping away at the boundaries of what’s possible, still changing the world, one idea at a time.

Responsibilities:

Requirement gathering – Solution design.

Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.

Actively designed the database to fasten certain daily jobs, stored procedures.

Optimize query performance by creating indexes.

Wrote T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL

Create joins and sub-queries for complex queries involving multiple tables.

Use DDL and DML for writing triggers, stored procedures, and data manipulation.

Experience in creating complex SSIS packages using proper control and data flow elements.

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.

Creating SSIS Packages to extract data from CSV and TXT files into schema tables and sends Email attachment of the extracted data.

Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2008 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Environment: MS SQL Server 2005, 2008/2008R2 T-SQL, SSIS, SQL Server Enterprise Manager, SQL Profiler.

Client: ICICI, Hyderabad, India Aug2007 – Feb2009

SQL Server Developer/BI

Description:

ICICI Bank (Industrial Credit and Investment Corporation of India) is Indian Multinational banking and financial services company .It offers a wide range of banking products and financial services for corporate and retail customers through a variety of delivery channels and specialized subsidiaries in the areas of investment banking, life, non-life insurance, venture capital and asset management.

Roles and Responsibilities:

Created new database objects like Functions, Packages, Indexes and Views using T-SQL in SQL Server 2008.

Wrote store procedures to generate account statements for different types of accounts.

Created DDL/DML triggers in SQL Server 2005/2008.

Maintained database performance by normalization, indexing, collecting statistics, etc

Generated DDL scripts for database schema and created all other database objects.

Involved in upgrading the instance of development environment of SQL Server 2005 to SQL Server 2008.

Designing/ Implementing Backup policies for databases.

Designed, developed and maintained the reports

Validated change requests and made appropriate recommendations. Standardized the implementation of data.

Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.

Retrieved data from cubes and generated OLAP reports using SSRS

Collected requirement and generated stylish reports using SSRS

Designed data models and generated Entity-Relationship diagram (ERD) using Erwin

Modified database structures as directed by developers for test/development environments and assist with coding, design and performance tuning.

Managed user access. Created and managed new security accounts.

Provided back-end support for functional testing and performance testing.

Developed front-end/UI for easy data access and submission in C#

Environment: SQL Server 2005/2008, Microsoft Visual Studio 2008, SSRS, Erwin 4.1/7.1, Oracle 9g, C#

EDUCATION:

Bachelors of Engineering,India.

Contact this candidate