We provide IT Staff Augmentation Services!

Sql Server \ Data Warehouse \application Developer Resume

Seattle, WA

PROFESSIONAL SUMMARY:

  • Around 11 years of Professional experience in IT industry as a SQL Server /BI developer /Data Modeler /Report Analyst
  • Information gathering, analyzing the information gathered, documenting the functional or business requirements
  • Good SQL Server 2000/2005/2008/2012/2014 Administration skills including user authorizations, Database creation, backup, restore, replication, scheduling and clustering
  • Worked on Front End Application Like Salesforce, MS Dynamics and custom - built apps with .net, Delphi
  • Exposed to Cloudera technologies to AWS with open Source Hadoop frame version (hartonworks)
  • Experienced in pulling data from Upstream Sources into staging and eventually destinations using SSIS
  • Converted reports from crystal and MS Access to SSRS
  • Used C# for script task within SSIS, both to call Rest API and retrieve data through Flat Files, Outlook
  • Expertise in Manual Testing, Mainframe Testing, Automation Testing and Database Testing
  • Excellent understanding of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Test Methodologies from project definition to post deployment
  • Good experience with writing and utilizing SQL queries for data verification in Oracle and other RDBMS
  • Upgrading data to recent versions from earlier versions using MS Access, SQL server
  • Experienced in using Data Modeling tools like Visual Studio, ERWIN, MS-Visio
  • Extensively used crystal reports, SSRS to generate reports based on the client needs
  • Experienced in building up dashboards using MOSS 2007 and knowledge on performance point
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS/SSIS Packages.
  • Experienced in converting crystal reports to SSRS reports
  • Understand the Map-Reduce algorithms and make use of horizontal Computing in Cloud Storage
  • Experience in Data Conversion and Data Migration from earlier versions to current SQL server using SSIS and DTS services across different databases like Oracle, MS access and flat files.
  • Extensive exposure in SSIS, SSRS and SSAS and charting tools like graphical charting
  • Good knowledge of share point 2007 in managing documents creating workspaces. Exposure towards moss 2007 and performance point.
  • Knowledge on MES, TFS, MDX, Replication understanding C#, .net (validated applications using asp.net) concepts
  • Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.

TECHNICAL SKILLS:

Operating Systems: Windows 2003 / NT / XP/ME/9.X, UNIX (Solaris 8.0/9.0)

Languages: C, C++, JAVA, VB 6.0, T-SQL, Java/VB Script, C#

Web Technologies: HTML, WML, XML

Databases: MS SQL SERVER 2016/2014/2012/2008 / 2005 / 2000 / 7.0, MS Access 2003, ORACLE

Packages: G-Track, JIRA, MLH, MS Visio, MOSS 2007, ERWIN, CSS, VSS, TFS, Visual Studio, Sarema Dimensions, Workfront, JIRA, Salesforce, Eloqua

Testing: Win Runner, Load Runner

ETL tools: DTS, SSIS, SSAS, SSRS, Informatica, ProClarity, Crystal Report 9/11

Database Tools: SQL Enterprise Manager, SQL Profiler, SQL Agent, SQL Alerts, SQL Mail, SQL Client Configuration utility, Backup Server, Replication server, OLAP Services, Replication Tools

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

SQL Server \ Data Warehouse \Application Developer

Responsibilities:

  • Involved in re-writing SQL Scripts and SSIS Packages to enhance performance within EDW environment
  • Worked on C# Scripts with SSIS to call Rest API to retrieve and push data to Eloqua
  • Worked with the marketing team to gather requirements as per their needs for several campaigns
  • Unit tested and code reviewed Proc’s following SDLC life cycle
  • Used different database objects to fix the existing issues
  • Handled and addressed various ad-hoc and Data Extract Workfront Tickets on a priority basis
  • Worked on T-SQL scripts to make changes and load data into Data Warehouse
  • Worked on C# to break up data from Various Sources to load tables as per the requirements
  • Used Cozy/Roc within SSIS to Integrate with Salesforce Objects
  • Involved in Migrating/storing Database Using AWS utilizing S3 Storage into Cloud
  • Utilized Gsync to bulid groups and scheduled them to migrate data to Cloud Systems
  • Exposed to Hive SQL and worked on Hive database to query back data from the cloud systems

Environment: SQL Server 2016/2014, C#, TFS, SSIS, SSRS, Eloqua., Workfront, Salesforce Workbench, AWS

Confidential, Bellevue, WA

SQL Server \ SSIS Developer

Responsibilities:

  • Good understanding of Partner Incentives Program and its relationship to business requirements
  • Extracted data from Upstream Sources to stage, cleanse and transformed data into SQL server using SSIS
  • Worked and Developed new SSIS Packages introducing new programs to the existing Program to enhance the Partners Flexibility
  • Developed Packages and Increased performance by tuning the Procedures and ETL Design
  • Written Complex Stored Procedures, Views and Functions on the SQL Server 2012 as part of the ETL to move data between Databases across Servers
  • Gained good knowledge and used TFS as a source control, build to deploy to various environments
  • Created Stored procedure to pull data for reports
  • Used SSRS to build reports both for external and internal users maintain security
  • Worked on C# to call API and breaking up data from Various Sources to load tables as per the requirements

Environment: SQL Server 2012/2014, C#, MS Visio, TFS, SSIS, SSRS, EXCEL 2007

Confidential, Worcester, MA

Soarian Reports Programmer \ ETL Developer

Responsibilities:

  • Good understanding of Soarian reporting architecture and its relationship to business requirements
  • Worked on Soarian Admin Desktop in Clinical, Soarian Financials and Soarian Analytics
  • Worked Siemens pharmacy data into Soarian Clinicals and DSS
  • Automated SSIS to load the mappings, used it for loading Different trustee data loads
  • Extensively used SSIS as part of ETL between Data Bases and used different type of Configurations on a case by case scenario
  • Migrated oracle data to SQL Server as part of migrating data to Data ware house Using SSIS
  • Worked on Package Configuration to in corporate smoke test within SSIS Packages
  • Developed Crystal Reports and Increased performance by tuning the Procedures
  • Written Complex Stored Procedures, Views and Functions on the SQL Server 2008 to create the reports in Soarian Clinicals, Soarian Financials, and Soarian Analytics.
  • Developed Procedures for Data Extract and send them to different Sources through Soarian Scheduler, SSIS Packages

Environment: SQL Server 2012/2014, Soarian Clinicals/Financials, SSIS, SSRS

Confidential, Costa Mesa, CA

SQL Server Database Engineer \ ETL Developer

Responsibilities:

  • Involved in re-writing reports from OLTP environment
  • Increased the performance of existing Stored Procedures by writing Sargable code
  • Unit tested and code reviewed Proc’s following SDLC life cycle
  • Used different database objects to fix the existing issues
  • Handled and addressed various ad-hoc and Data Extract Tickets on a priority basis
  • Worked on T-SQL scripts to make changes and load data into Data Warehouse
  • Worked on C# to break up data from Various Sources to load tables as per the requirements

Environment: SQL Server 2012, MS Visio, Sarema Dimensions Team track, SSIS, XML, VB Script. C#

Confidential, Irvine, CA

SQL Server / SSIS Developer / Report Analyst

Responsibilities:

  • Involved in re-writing reports from OLTP environment to Data Warehousing environment
  • Designed and engineered the flat file data formatted and automated the process to pull data and post it to Share Location
  • Used VB Script to format excel files for various trustees
  • Involved in Database Administration roles like monitoring, production support and assigning roles
  • Designed packages using SSIS to load legacy data and to call web service tasks
  • Worked with XML Files to load/ pull data to/ from database
  • Gained experience on JIRA ticketing system and updated the progress on various projects
  • Worked on C# to call API
  • Hands-on experience using PL/SQL while converting procedures from SQL Server to Oracle
  • Worked on MLH to deploy reports(SSRS) to various environments
  • Wrote ETL scripts to load Dimension and fact tables and scheduled them to refresh on hourly basis
  • Designed and re-written SSRS reports from stage to EDW environment
  • Experienced in Creating linked, sub reports to enhance the drop down and drill through capability
  • Wrote data driven and time valued subscriptions as per the report and business requirement
  • Made use of the Tablix report object to created reports and to avoid unnecessary grouping

Environment: SQL Server 2008, SSRS, SSIS, DTS, MS-Visio, VSS, JIRA, VB Script, T-SQL, PL/SQL, C#

Confidential, West Chester, PA

SQL Developer / BI Developer / ETL Developer

Responsibilities:

  • Created new Tables, Stored Procedures and Functions as per the technical document
  • To establish a single process and application that supports the process for complaint capture, product analysis, and vigilance reporting, and trending at a franchise level
  • Worked with business users to define and analyze problems, create logical data model, implement physical data model, and the implications of business solutions to the current and future environment
  • Worked with MS Access, Cognos to create and modify the existing reports
  • Identified new process, finding out gaps in existing process, arranging training modules for new process development and implemented
  • Implemented Normalized database from scratch, Using Stored Procedures and SSIS Packages
  • Troubleshoot ETL scripts written in PL/SQL in case of issues raised
  • Designed and automated different types of reports using SSRS
  • Used lock hints like nolock, Xlock for better performance and efficiency
  • Create joins and sub-queries for queries involving multiple tables
  • Data migration using ETL scripts, in order to create a complete new environment to avoid the discrepancies while doing reporting

Environment: SQL Server, SSRS, SSIS, DTS, MS-Visio, MS Access, Erwin, G-track, PL/SQL

Confidential, Columbus, OHIO

SQL developer/SSRS developer

Responsibilities:

  • Automation of reports using SSRS through stored procedures and parameters
  • Designed reports from scratch involving drilled-down and drilled through reports and sub-reports
  • Generated Report model so that the users can develop their own projects using report wizard
  • Developed stored procedures with complex calculations and nested joins from different tables within a single and more databases with the help of linked server
  • Integrated report manager with SharePoint in Naïve mode, eliminating the first layer of security to the report manager
  • Used ProClarity as the reporting and analyzing tool as a Dashboard for the cube structures
  • Assisted fellow developers with OLAP and Doing ETL in transformation of cubes
  • Assisted in migrating cubes from 2000 to SQL server 2005 using SSIS
  • Used SSIS packages to load date from spreadsheet into the data base and also used packages to move data between databases (oracle, flat-files) on different servers
  • Migrated reports from crystal and MS Access to SSRS and scheduled them appropriately

Environment: MS SQL Server 2005, Erwin, SSIS, SSRS, SSAS, ProClarity, Visual Studio, MOSS 2007

Confidential, Cincinnati, OH

MS SQL Developer, Freight Re-allocation

Responsibilities:

  • Created new Tables, Stored Procedures and Functions as per the technical document
  • To establish a single process and application that supports the process for complaint capture, product analysis, and vigilance reporting, and trending at a franchise level
  • Troubleshoot ETL scripts written in PL/SQL in case of issues raised
  • Designed and automated different types of reports using SSRS
  • Used lock hints like nolock, Xlock for better performance and efficiency
  • Create joins and sub-queries for queries involving multiple tables
  • Data migration using ETL scripts, in order to create a complete new environment to avoid the discrepancies while doing reporting

Environment: MS SQL Server 2005, T-SQL, ETL/SSIS, SSRS, INFORMATICA, Erwin 4.1, Oracle

Confidential

MS SQL Server DBA/Developer, Trainee

Responsibilities:

  • Created new Tables, Stored Procedures and Functions as per the technical document
  • Worked with business users to define and analyze problems, create logical data model, implement physical data model, and the implications of business solutions to the current and future environment
  • Identified new process, finding out gaps in existing process, arranging training modules for new process development and implemented
  • Implemented Normalized database from scratch, Using Stored Procedures and SSIS Packages
  • Troubleshoot ETL scripts written in PL/SQL in case of issues raised
  • Designed and automated different types of reports using SSRS
  • Used lock hints like nolock, Xlock for better performance and efficiency
  • Create joins and sub-queries for queries involving multiple tables
  • Data migration using ETL scripts, to create a complete new environment to avoid the discrepancies while doing reporting

Environment: SQL Server 2000/7.0, T-SQL, Windows 2003 Server, VB.net

Hire Now