Priyanka L

858-***-****

ac7if5@r.postjobfree.com

SUMMARY

Business Intelligence Developer with around 5 years of experience in SQL/ETL Developer with BI Tools (SSIS, SSRS, SSAS) across various business domains including Finance and Insurance Industry.

Experienced in Relational Database Management Systems including normalization, data import/export, joins and cursors.

Experience in T-SQL programming skills along with expertise in writing complex queries, stored procedures, triggers, and functions using T-SQL.

Extensive experience in migrating data from various sources such as Excel, Oracle, MS Access, and flat files to different destinations using SSIS.

Utilized Control Flow tasks like For Loop Container, for each Loop Container, Execute SQL Task, File System Task and Data Flow Task in designing SSIS packages.

Experience in ETL DTS Packages & SSIS(DTSX) Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and union all.

Experience in providing logging and error handling of SSIS packages using Event Handler and Custom Logging.

Proficient in performance tuning SSIS packages by using row, block and unblock transformations.

Experience in creating Jobs, Alerts, SQL Server Agent, and scheduled SSIS Packages.

Experience in deploying packages in SQL Server 2014 and other versions.

Expert knowledge in developing multidimensional cubes using SSAS.

Experience in OLAP cubes using SSAS for data mining.

Skilled in dimensional modeling including Star/Snowflake Schemas and performance optimization of SSAS cubes.

Expert in creating different types of reports such as drill down reports, drill through reports, parameterized reports, linked reports, sub reports etc., using SSRS.

Experience in Creating, Managing, Delivering SQL Server Reports using SSRS 2005/2008/2012

Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS 2005/2008/2012.

Experience with deploying reports across various sources like in a web browser using XML or PDF or any other formats.

Experience in Migration of SSRS reports from SQL 2008 to SQL 2014.

Experience in Functional, Regression and System Integration testing using Manual and Automated testing tools.

Experience designing and building complete ETL/SSIS processes moving and transforming date of ODS, Staging and Data Warehousing.

Basic knowledge on C# which can lead to create SSIS Packages.

Expert in interfacing with clients, business analysts, developers, QA, project managers and various cross-functional teams to execute projects successfully.

Extremely dedicated, hardworking, and a strong team player with an ability to take on new roles swiftly.

Strong team player with solid communication skills that can juggle multiple priorities effectively.

High aptitude to learn new technologies/concepts quickly in support of the project requirement

EDUCATION: Bachelor of Technology in Computer Science, JNTU, India

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Enterprise Manager, T-SQL, Data Transformation, Services (DTS), SQL Server Query Analyzer, Query Profiler, SQL Server Agent, SQL Jobs, SQL Alert, SQL Mail, SQL Server Management Studio, BIDS (Business Intelligence Development Studio), Visual studio (VS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Profiler, Power BI.

ETL Tools: Data Transformation Services (DTS) – Export/Import, SQL Server Integration Service (SSIS), Power BI, Talend.

Reporting Tools: SSRS, Crystal Reports, Business Objects

Database: MS SQL Server 2005/2008 R2/2012/2014, Oracle 9i/10g/11g, SQL, MS Access

Programming: T-SQL, C#

Operating Systems: Microsoft Windows: 95/98/2000/2002/Vista/Windows7/Windows 8/10

Other Tools: Erwin, Microsoft Visio, Power BI

PROFESSIONAL EXPERIENCE

Nationwide, Phoenix, AZ Jan 2017 – Till Date

SQL BI/SSIS/SSRS/SSAS Developer

Responsibilities:

Collaborated closely with the business users defining and documenting reporting requirements to design, develop and maintain SQL Server 2008 R2/2012 Reporting Services.

Created MSSQL database design, implementation, performance tuning, and capacity planning. Managing large scale database system.

Involved in MSSQL DBA activities including installation, configuration, backup, recovery, permissions and validating the enhanced queries.

Responsible for creating T-SQL programming implementing stored procedures, functions, constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, and Cursors for different tasks.

Extensively performed full lifecycle ETL software development – analyze, design, develop, document and test using SSIS.

Migrated data from various sources such as Excel, Oracle, MS Access, and flat files to different destinations using SSIS.

Used some of the transformations like Lookup, Derived Column, Conditional Split, Sort, Data Conversion, Multicast, Derived Column, Union All, Merge Join etc. while loading data from one server to another server using SSIS packages.

Utilized SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and DataMart databases.

Designed and developed data warehouses, data marts and business intelligence reporting.

Designed SSIS packages with various complex transformations.

Built packages in SSIS with custom error handling and different methods of logging.

Used SSIS/ETL to implement the slowly changing transformation in data warehouse.

Designed, developed and deployed SSIS packages to SQL Server by using C# which is involved in the task.

Responsible for creating Jobs, Alerts, SQL Server Agent, and scheduled SSIS Packages.

Deployed packages in SQL Server 2014 and other versions.

Responsible for Designing the complete ETL/SSIS processes moving and transforming date of ODS, Staging and Data Warehousing

Designed, developed and deployed custom reports to Report Manager in MS SQL Server environment using SSRS 2012.

Responsible for Creating, Managing, Delivering SQL Server Reports using SSRS 2005/2008/2012

Used variables, expressions, functions for the reports and in handling Parameterized reports in SSRS 2005/2008/2012.

Conceived different types of reports including tabular forms, matrix (cross tab report) form, charts and sub reports.

Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.

Created and Managed Star schema cubes using SSAS.

Created OLAP cubes and Multi-Dimensional cubes using SSAS.

Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.

Designed and created views using complex joins and documented the table relationships with diagrams.

Involved in Functional, Regression and System Integration testing using Manual and Automated testing tools.

Created and Executed Test Cases for Functional and System Integration testing for Information in Portal.

Environment: MS SQL Server 2005/2008/2012/2014, T-SQL, C#, SSIS 2008/2012, SSRS 2005/2008 R2/2012

Wal-Mart, Bentonville, AR Aug 2016-Dec 2016

SQL Server Developer

Responsibilities:

Collaborated closely with the business users defining and documenting reporting requirements to design, develop and maintain SQL Server 2008 R2/2012 Reporting Services.

Designed data warehouse utilizing both Star and Snowflake schemas.

Performed logical and physical data modeling

Wrote T-SQL programming implementing stored procedures and functions for different tasks.

Wrote complex queries, triggers and stored procedures as well as defined roles and privileges to control access to database.

Performed optimization and performance tuning of SQL Server application by using Performance Monitor.

Designed and implemented reports using business intelligence platforms across multiple applications.

Developed different types of tabular reports, matrix reports (crosstab or pivot), charts and graphs, reports that aggregate data, reports containing parameters and groups, reports containing totals and subtotals, drill-down reports and ad-hoc reports using SQL Server 2008 R2 Reporting Services.

Designed and created reports and distributed reports in multiple formats such as Excel, PDF, XML, HTML, and CSV using SQL Server 2008 R2/2012 Reporting Services.

Developed different types of ad-hoc reports using Report Model and Report Builder tools of SQL Server 2008 R2 Reporting Services.

Designed custom assemblies/functions to enhance the functionality of different reports.

Created and configured cubes using SQL Server 2008 Analysis Services.

Designed and created data source and data source views using SQL Server 2008 Analysis Services.

Configured Dimensions, Measures and Measures Groups using SQL Server 2008 Analysis Services.

Created MDX queries to access cube information.

Designed Data Transformation Services (DTS) packages to refresh data in development, QA, staging and production.

Supported team in resolving SQL Reporting Services, SQL Integration Services and T-SQL related issues.

Environment: MS SQL Server 2005/2008/2012, T-SQL, SSIS 2008/2012, SSRS 2005/2008 R2/2012.

Bharat Heavy Electrical Limited, Hyderabad, India Jan 2014 – Dec 2015

SQL Developer

Responsibilities:

Performed data migration (import & export) from text to SQL Server. Used scripts, variables, and email notifications for ETL process via Data Integrator in SSIS and SSAS.

Optimized stored procedures and queries for faster execution and server efficiency in SSAS and SSIS.

Performed performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS.

Designed, implemented and maintained database schema, entity relationship diagrams, data modeling, tables, stored procedures, functions and triggers, constraints, indexes, schemas, functions, views, rules and complex SQL statements.

Generated various reports like matrix, tabular, chart, link, and drill-down reports.

Utilized Snapshot Replication to synchronize the data between different stores.

Performed SQL Server mirroring and database optimization.

Created and configured OLAP Cubes (Star and Snowflake Schema) using SQL Server 2008 Analysis Services (SSAS).

Generated reports using global variables, expressions and functions using SSRS 2008.

Created technical and functional documents including detailed description and screenshots specifying the application’s functionality.

Environment: SQL Server 2005/2008, SSIS, SSRS 2008 R2, SSAS, SQL, Visual Studio 2008/2010, Windows XP, MS Office, Windows Server 2003, Crystal Reports

Contact this candidate