SQl/SSIS developer

Samjhana Kafle

SQL/SSIS/SSRS DEVELOPER

Phone: 469-***-****

Email: **********@*****.***

Location: Dallas, TX

Summary:

Professional with 5 years of IT Experience in Database Design, Development, and Implementation of Microsoft SQL Server 2016/14/12/08, in Development, Test and Production Environments with various business domains such as Financial, Retail and Healthcare.

Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).

Thorough understanding of all the phases of SDLC including requirement gathering, analysis & design, implementation, and delivery; versatility to work on different platforms and bring an innovative approach in designing solutions

Integrated SQL Server 2005 reporting services with Microsoft Share point Portal Server.

Experienced in working in cross-functional teams and tight schedules.

Worked in tandem with the end users for understanding the business requirements and recommending feasible solutions.

Experience in developing optimized SQL using best practices.

Expertise in writing dynamic-SQL, complex stored procedures, functions, and views.

Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.

Experience in creating SSIS packages using with Error Handling.

Experience in enhancing and deploying the SSIS Packages from development server to production server.

Experience in working with row, partially blocking, and fully blocking transformations and adept at performance tuning of SSIS Packages.

Adept at capturing the execution errors in SSIS for analysis purposes.

Experience in sync processes between two databases using SSIS.

Experience in importing/exporting data between different sources like Oracle/XML/Excel etc. using SSIS/DTS utility.

Experienced in working with C#.Net in SSIS.

Experience in creating configuration files to deploy the SSIS packages across all environments.

Strong experience in generating drill-down, drill-through and cascaded-parameterized reports on top of relational databases and cubes.

Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).

Experienced in creating various SSRS Reports involving variety of features like Charts, Filters, Sub-Reports and Multi-valued parameters.

Experience in developing cubes using SQL Server Analysis Services (SSAS)

Experienced in designing and developing ETL logic for moving data into data warehouses

Involved in collaborating with Database Architects for basic Data Warehouse Design.

Good understanding of star schema and snowflake schema.

Excellent communication skills and team player.

Ability to grasp new technologies/concepts.

Technical Skills:

Technologies: Microsoft Business Intelligence, SharePoint

Languages: SQL, T- SQL, HTML, Oracle 9i/10g, XML, DB2

Databases: SQL Server 2016/2014/2012/2008/2005/2000/7.0, MS Access

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), Power BI, SQL Server Analysis Service (SSAS)

ETL Tools: SSIS (SQL Server Integration Services), DTS (Data Transformation Services), Import Export Data

Operating Systems: Windows 2003/XP/ 10

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server Query Editor

Other Software: MS Office- 2013/2010, Data Modelling, Data Mapping, SQL Performance Optimization, SVN (Subversion),

UNIX Shell Script, Microsoft teams, BMC Remedy, JIRA etc.

Education:

Bachelor’s in Science

University of South Alabama

Mobile, Alabama

Diploma in Computer Engineering

Tribhuvan University

Lalitpur, Nepal

Annexure of Projects:

Role: SQL/SSIS Developer

Client: GM Financial

Domain: Finance

Duration: March 2019 – Present

Location: Arlington, TX 76014

GM Financial Is A Global Provider of Auto Finance Solutions. GM Financial provides auto loan financing through auto dealers across the U.S. and Canada. GM Financial is the wholly owned captive finance subsidiary of General Motors and is headquartered in Fort Worth, Texas. They are a global provider of auto finance solutions, with operations in North America, South America and Asia. Through their long-standing relationships with auto dealers, they offer attractive retail financing and lease programs to meet the needs of each customer.

Responsibilities:

•Gathering & analyzing requirements, understanding business requirements and finalizing technical & business specifications.

•Involved in complete SSIS life cycle in creating SSIS packages, building, deploying, and executing the packages in both the environments (Development and Production).

•Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.

•Involved in ETL architecture enhancements to increase the performance using query optimizer.

•Experienced in writing complex SQL Queries, complex Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and created clustered and non-clustered indexes.

•Created SSIS packages to create csv files and excel sheets. Used Package Configurations to make the SSIS Package reusable in any server.

•Created global temporary tables in the Execute SQL task and created reports based on the global temporary tables inside the data task flow.

•Used Execute SQL Task, Data flow Task, Sequence Container, For Each Loop Container, File System Task, Execute Package Task.

•Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS/DTS using various features like data conversion etc.

•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.

•Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.

•Created SSRS reports like tables, matrix, charts, sub reports, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.

•Created reports based on both cascading and standard parameters.

•Created different Parameterized Reports (SSRS 2014/2012/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.

•Designed and built cube using SQL server Analysis Services for salary analysis.

•Worked on dimensional data modeling, dimensions, and facts for OLAP cubes configured report server environment and deployed reports to the database.

•Extensive experience in SSAS (SQL Server Analysis Services), Design and Developed cubes testing and Deployment/ Implementation.

•Experience in writing complex MDX queries for calculated members and measure groups.

Environment: MS SQL Server 2014/2012/2008/2005 Enterprise Edition, SSIS 2008R2, SSAS 2008R2, SSRS 2008R2, T- SQL, VSS, Windows Sever 2000/2003/2008, SQL Server Management Studio, SQL Profiler, Query Analyzer, MS Visio.

Role: SQL/ SSIS Developer

Client: ALTAPOINTE HEALTH SYSTEM

Domain: Healthcare

Duration: March 2017-Feb 2019

Location: Mobile, AL 36693

AltaPointe Health is Alabama’s largest and most comprehensive health and human services organization and psychiatric hospital system. And, the second largest in the southeastern US serving Mobile, Baldwin, and Washington counties in south Alabama and Clay, Coosa, Randolph, and Talladega counties to the north.

Responsibilities:

Gathered & analyzed requirements, understood business requirements & specifications from the business and technical perspective, participated in the full life-cycle implementation of the project

Worked on ETL SSIS Development, creating packages using various transformation techniques and created jobs that are scheduled to run on daily basis and thus load into the Data Warehouse.

Created SSIS package to load data from XML Files, Flat files, Ftp server, Sybase and SQL Server to SQL Server 2014/2016 by using Lookup, Derived Columns, Condition Split, OLEDB Command, ODBC Term Extraction, Aggregate, Pivot Transformation, Execute SQL Task and Slowly Changing Dimension.

Developed Validation Plans for SSIS packages for checking the functionality of each component and code.

Implemented the Master Child Package Model in the EDW and Data-Mart for easier maintenance and better performance of SSIS Packages review.

Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.

Planned and executed SSIS Package step process to load data, validate data and recommending task to resolve performance issue with loading data into the Data Warehouse.

Scheduled jobs for executing the stored SSIS packages which were developed to update the database on daily basis using Autosys.

Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.

Job overlap alert.

Gathered user requirements from the users to develop the business logic and analyzed and designed software and database solutions and involved in cresting TDD (Technical Design Documents), FSD (Functional Specification Document).

Worked in setup auditing, logging environment to track the status of the events like error raise, task fail.

Designed tool to automatically add derived column, parameter, and configuration value to the package.

Involved in writing MDX queries and performance optimization of the SSAS cubes.

Created reports to retrieve data using function, views, cube, and stored procedures using parameters.

Created various database objects like stored procedures, functions, tables, views, triggers.

Configured the report viewing security for various users at various levels using Report Manager.

Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.

Extensively used T-SQL in constructing Stored Procedures, Common Table Expressions (CTEs), User Functions, Indexes, User Profiles, Relational Database Models, Data Dictionaries, triggers, cursors, tables, and views and other SQL joins and statements for applications.

Provided documentation for all kinds of SSIS packages.

Designed and implemented stored procedures and Triggers (DDL & DML) for automating tasks.

Environment: MS SQL Server 2008/12/14, SQL BI Suite (SSMS, SSIS, SSRS), XML, MS Excel, MS Access 2007, SQL Profiler, Data Analyzer, OLAP, Windows 7, TFS

ETL Developer

Client: GPS IT SOLUTIONS

Domain: Retail

Duration: March 2015-Feb 2017

Location: Tuscaloosa, AL 35404

GPS IT Solutions is a rapidly growing Information Technology and Consulting Services company with a unique combination of high skilled people, matured processes, customized delivery models and right tools to help our customers find solution for their business and technology challenges. GPS IT Solutions offers a wide range of IT services that help customers address their technological challenges.

Responsibilities:

Worked on modifying the SQL stored procedures, SQL scripts based on the defects & issue raised by client in existing system.

Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages.

Involved in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert).

Involved in error handling of SSIS packages by evaluating error logs.

Successfully extracted transformed and load data into data warehouse. Created reports using SSRS from OLTP and OLAP data sources and deployed on report server

Performed Database Search and Query Strategy design, implementation, testing, and optimization.

Extensively used SSIS 2008 transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

Documentation of test reports and defect reports.

Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

Involved in designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.

Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server.

Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using SSRS.

Created queries for generating drill down reports in SSRS.

Lead the offshore Team and involved in Team tracking activities.

Expertise in prepares Integration Test Plan that was used by functional team as well as development team.

Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts.

Create nested, conditional subgroups and formatting features in reports.

Environment: MS SQL 2008/20012/2014, Windows 2000/XP, SQL Query Analyzer and Enterprise Manager. MS Access 2000 & Windows NT platform-SQL, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Reports using SQL Server Reporting Services (SSRS).

Contact this candidate