Sign in

Data Sql Server

Jacksonville, Florida, United States
January 14, 2018

Contact this candidate


Ashraya Chapagain

Email: a

Cell: 904-***-****



● Experience in MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Service (SSRS), SQL, T-SQL and IT Solutions that include experience in design, development and implementation of complex data delivery systems using MS SQL Server technology.

● Extensive knowledge and experience in dealing with Relational Database Management Systems (RDBMS) and backend skills using Stored Procedures, Joins, Indexes, Triggers and User defined functions [UDF].

● Knowledge in Designing and deploying of SSIS Packages for integrating data using different connections from heterogeneous sources (SQL server, Excel, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Sort, Conditional Split, Merge and union all.

● Experience in using Lookup transformation, derived columns, error handling, deploying packages in SSIS.

● Involved in creating and analyzing cascaded reports, drill-down reports, drill-through reports and parameterized reports to provide data using SSRS.

● Expertise in Creating and managing Event Handlers, Package Configurations, Logging, Checkpoints and User Defined Variables for SSIS Packages.

● Knowledge of SDLC (Software Development Life Cycle) like gathering requirements, design, development, implementation and testing, agile methodologies like Scrum, Test Driven Development and Continuous Integration/Continuous Delivery.

● Thorough understanding of big data and hadoop, hadoop architecture, mapreduce, HDFS, Spark, Hive, Hbase, Sqoop, Spark.

● Good understanding of Data Warehousing methodologies such as Multidimensional modeling (Star / Snowflake Schemas).

● Ability to accomplish tasks under minimal direction and supervision.

● Excellent communication and presentation abilities, self-starter with strong logical and analytical skills.

● Strong team player with excellent interpersonal and teamwork skills.

● Work under pressure and in tight deadlines.

Professional Experience:

Allstate Benefits, Jacksonville, FL Feb 27,2017 - Present Database Analyst / Production Support Analyst

● Generated reports using SQL queries and providing it to different department in a corporate and consulting environment.

● Created test scenarios, test data in QC and production environment, logged and reported bugs to respective team.

● Conducted meetings to collect and document business requirements for project.

● Interacted with internal teams to troubleshoot and resolve complex problems.

● Data mining to understand and solve root causes for issues within databases.

● Evaluated user problems and issues with software performance.

● Identified appropriate metrics and created reports in terms of in-depth trend analytics.

● Took ownership of production problems, issues and drove them to completion coordinating with business and technology partners.

● Anticipating to mitigate risks, escalate issues appropriately to keep all necessary parties informed, formulated and implemented a work-around often in a critical timeframe.

● Identified program variances through testing.

● Created SSIS packages connecting different sources and destination using numerous transformations to obtain desired data like Data Conversion, Sort, Conditional Split, Merge and union all, Look up, Derived columns using various environment variables.

● Experience in using Lookup transformation, derived columns, error handling, deploying packages in SSIS.

● Created processes, procedures, and documentation for production support activities and kept updated with new versions of software.

● Interacted with agents to resolve different technical issues on the spot.

● Understood the flow of business in technical aspect while analysing and fixing bug.

● Interact with developers and explained places with bugs in the application and resolved issues accordingly.

● Re-Test applications after the fixes.

● Monitor Business flow daily and weekly based on requirements of upper management.

● Identified data issues and provided recommendations for resolution to ensure optimal performance.

● Provide technical assistance in a number of different areas, including functional assistance on different platforms.

● Troubleshoot and minimize production down issues.

● Worked with business, development, DBA and other internal teams closely to resolve production issues.

● Supported application released, infrastructure changes, database modifications, data corrections and other ad-hoc productions changes requests.

Verisk Information Technologies, Nepal May, 2015 – July, 2015 Data Analyst Intern

Project: Data Analytics and Research Project


● Requirement gathering, maintained data entry, verification task reviewing correcting, deleting data using some standard procedures.

● Analysed and write Business Rules Documents for clients, created functions and stored procedures using SQL.

● Designed and developed SSIS Packages to import and export data from MS Excel, Flat files and SQL server.

● Created Checkpoints to implement restartability of SSIS packages.

● Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages.

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

● Implemented Event Handlers and Error Handling in SSIS packages.

● Created reports and dashboards in SSRS based on requests from management.

● Created Datasets, stored procedures in T-SQL for SSRS.

● Designed complex reports like dynamically driven parameterized, drill through reports, drill down reports, subreports using SSRS.

● Maintained and provided weekly, monthly reports and deployed them as required.

● Transferred data from Data Dashboard to Auto Import Platform and checked for the accuracy using SQL commands, optimization opportunities in scripts, wrote data encryption scripts to protect data in files

● Studied and documented about data mining, US healthcare and HIPAA.

● Carried out research works which included collecting data where earthquake took place in Nepal and mapping them into graphs with magnitude and name of the places using C artoDB. Election Commission, Nepal May, 2014 - July, 2014

Business Intelligence Analyst Intern


● Collected business requirements from users and translated them as technical specification and design docs for development

● Identified various sources, formulated data dictionaries, design and developer data models based on the given specifications and requirements.

● Maintenance and updating of databases and tables.

● Created stored procedure and functions to update the database continuously.

● Created various SSIS Packages to input voters’ information from multiple Excel files to SQL table and used various Transformations to meet the requirements like data conversion, sort, conditional split, multicast, merge, union all etc.

● Used SQL server agent to automate the SSIS package execution.

● Analyzing and understanding the Excel Data and Created SSIS Packages accordingly to dump the data into SQL Database.

● Used SSRS to generate cascaded, drill through, drill down, parameterized reports according to requirements.

● Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSIS.

● Analyzed end-to-end data and preparing reports using SSRS.

● Developed complex Stored Procedures to generate various Drill-through reports, Drill-down, Parameterized reports using SSRS.

● Experience in end user reporting definition, development and platform support using SQL Server Reporting Services ( SSRS) and Performance Point.

● Performed ad hoc queries, design and deployed reports using SSRS. National Academy of Science and Technology, Nepal May, 2013 - July, 2013 Data Analyst Intern


● Development, maintenance and restoring of databases for information retrieval.

● Creating tables, triggers, indexes, views for storing information on different areas.

● Using SQL queries against information in database for data retrieval as per the requirements.

● Import Data from SQL table to excel sheets using external data group.

● Extracted and collected data to create needed reports.

● Worked on queries for loading the required data from Source tables.

● Creation of DDL and DML scripts are per the corporate naming standards.

● Conducted production database analysis on a regular basis and also provided technical assistance.

● Provided customer assistance and support pertaining to database system queries and complaints.

● Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.


Bachelors in Technology, Computer Science and Engineering 2 012 - 2016 Malaviya National Institute of Technology Jaipur, India Technical Skills:

MS SQL Server 2012, SSRS (SQL Server Reporting Services), SSIS (SQL Server Integration Services), Microsoft Office Suite, MySQL, SQL, Java, C, T-SQL, Windows, UNIX and Linux environment, HTML, PHP, JavaScript, Shell Script.

Contact this candidate