Sql Developer Resume
Troy, MI
SUMMARY
- Accomplished programming professional with increasing responsibilities and experience in design, analysis, software development, training and team management. Understand the overall picture and detail levels. Strong organizational skills. Advanced education with field experience increases productivity & cost savings for clients.
- Around 6+ years of experience in Software Development which includes gathering requirements, definition, design implementation, testing, troubleshooting, maintenance and enhancing the performance of the existing systems.
- Experience with SOLID principles, Agile methodology, Scrum rituals, waterfall development.
- Work with internal and external clients on - site locally, nationally, and internationally to help set-up software, train, troubleshoot, and problem-solve issues.
- Project lead experience for analysis, design, planning and development of major projects and tasks ensuring completion on time.
- Expert in using SQL Server Agent to Schedule and monitor Jobs.
- Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability.
- Expert in Writing SQL Queries, complex Stored Procedures on Oracle and DB2 to pull the data into Spotfire.
- Extensive experience in using various SAS modules like SAS/Base.
- Expertise in performing data transformations of financial transactions, model scoring and generate SAS datasets that are used across teams.
- Excellent knowledge in SAS macro's and created various utility macro's as per business requirement.
- Hands on Experience in developing ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from various sources like (Excel, CSV, flat file) by using multiple transformations provided by SSIS and Analysis Services (MDS).
- Experience in configuring Data Quality Services, (DQS), Master Data Services (MDS) and IIS.
- Related various B2B Predictive and descriptive analytics using R and Tableau
- Worked on different data formats such as JSON, XML and performed machine learning algorithms in Python
TECHNICAL SKILLS
OS: Windows 7, Windows Server 2003, 2008, Windows 10
Databases: SQL Server 2016/2014/2012/2008/2005 , PL/SQL, MySQL, Oracle 11g/8.0i, Microsoft Access 2000/8.0 Teradata14.0, Oracle (8i/9i/10g), MDS 2012
Languages: C, C++, PL/SQL, TSQL, DB2, MYSQL, DHTML, VB.NET, ASP.NET, .NET Frame Work, C#, JavaScript
Development Technologies: Agile, Scrum and Water fall
Scripting Languages: HTML, XML, Java Scripting, VB Scripting
Web Tools: C#.Net, ASP.Net, VB.Net, Visual Studio.Net, XHTML1.0, JavaScript, VB Script
ETL & Reporting: SSRS 2005/2008/2012/2014 , SSIS 2005/2008/2012/2014 , Excel, Power BI
Analytical Tools: Python (Sklearn, NumPy, Pandas), SAS 9.4, R, Tableau, Spotfire, SAS enterprise miner
Version & Defect Control: Microsoft TFS, MS VSS, Synergy, HP Quality Center & Jira
Others: MS Office, Erwin, Crystal Reports XI, Visio, Microsoft Business Intelligence Studio, Service Oriented Architecture (SOA) SQL Server Notification Services, SQL Server 2000/2005 Analysis Services (SSAS), Visual web developer, MS FrontPage, Windows Scripting Host, Erwin Data Modeler, MS Visual, SAS/Access, Crystal Reports SAP Business Objects, MS SharePoint
PROFESSIONAL EXPERIENCE
Confidential, Troy, MI
SQL Developer
Responsibilities:
- Developer to Ascension Healthcare for design, development, and maintenance of provisioning application for adding. Modifying, and terminating access rights for employees and contractors.
- Help implement Virtual Care provisioning during COVID-19 response.
- C#, MVC, ASP.Net, XML, JSON, SQL, SQL Server 2016 - 2019.
- Help design and develop enhancements for provisioning application allowing customization for various standardized healthcare applications through a database driven user interface architecture.
- Provide maintenance fixes enhancements for ministry and national level systems.
- Assist in the implementation of provisioning and enrolling healthcare providers and staff in Virtual Care Health system to quickly support Ascension Healthcare’s COVID-19 response.
- Provide support for production issues.
- Designed and created SQL Databases, tables, indexes, and views based on user requirements.
- Worked with the application developers and provide necessary SQL Scripts using T-SQL.
- Developed web based ASP.NET internet applications.
- Data mapping using Business Rules and data transformation logic for ETL purposes.
- Designed star schemas and bridge tables to control slowly changing dimensions.
- Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.
- Assisted in the design of report layouts to maximize usability and business relevance.
- Created SSIS packages with which data resources are loaded daily to create and maintain a centralized data mart. Made the package dynamic so it fit the environment.
Confidential, Downey, CA
SQL Developer
Responsibilities:
- As a developer, I was responsible for the systems study, analysis, understanding systems design and database design.
- Designed and created SQL Databases, tables, indexes, and views based on user requirements.
- Worked with the application developers and provide necessary SQL Scripts using T-SQL.
- Developed web based ASP.NET internet applications.
- Data mapping using Business Rules and data transformation logic for ETL purposes.
- Designed star schemas and bridge tables to control slowly changing dimensions.
- Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.
- Assisted in the design of report layouts to maximize usability and business relevance.
- Created SSIS packages with which data resources are loaded daily to create and maintain a centralized data mart. Made the package dynamic so it fit the environment.
- Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
- Created score cards with executive summary dashboards in MS Performance Point Server 2008 Dashboard Designer deriving data from a SQL Server OLAP data source. Advanced extensible reporting skills using SQL Server integration Services (SSIS).
- Developed a High-level dashboard using SSIS.
- Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
- Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
Confidential
Data Analyst
Responsibilities:
- Worked on cost/benefit analysis and risk assessment methodologies.
- Handled multiple teams and effectively communicated with WAAM’s, VPA's and VP's. Took initiation in mentoring new analyst for the onboarding training which helped in reaching up the deadlines.
- Utilized Teradata to research for singleton hierarchies, analyze and provide recommendations to maintain data consistency. Provided recommendations for the data corrections utilizing D & B Hoovers and other data repositories.
- Researched and documented sponsor/stakeholder needs in accordance with Project Life Cycle methodology utilizing reporting tools, requirements gathering methodologies, process models, data models and prototypes.
- Used conditional formatting as well as graph and chart manipulation for extensive data cleaning and analysis.
- Responsible for the development of ETL and Reporting solutions to address business needs.
- Understand source data, and the business systems that create and utilize this data during operations, collaborate with other Business Intelligence teams to design and developed business solutions.
- Design, Develop, Implement SQL scripts to transfer data between Netezza and Oracle databases.
- Identifying the Source Systems, possible Fact tables and Dimension Tables and created multiple data sources like SQL server, Oracle 11g, Derby, Teradata going into MicroStrategy.
- Effectively articulated reasoning for data model design decisions and strategically incorporated team member feedback to produce the highest quality Data Models.
- Worked with project and application teams to ensure that they understand and fully comply with data quality standards, architectural guidelines and designs.
Confidential
SQL/SAS Developer
Responsibilities:
- Expert in data validation, cleansing, consolidation and mining for sense, consistency and accuracy and compliance standards.
- Identified the data source and defining them to build the data source views.
- Looked at the reports and fixed bugs in stored procedures.
- Wrote shell scripts for running various SAS and SQL jobs.
- Developed DataStage jobs to load the data into Teradata tables using Fast load utility.
- Responsible for design and developing Teradata BTEQ scripts, MLOAD based on the given business rules and design documents.
- Experience in Coding Teradata SQL, Teradata Stored Procedures, Macros and Triggers
- Wrote complex MySQL queries using joins, sub queries and correlated sub queries to retrieve data from different MySQL Server Databases and Excel files, apply business logic, load in table and create view for end users.
- Build and maintain MySQL scripts, indexes, and complex queries for data analysis and extraction.
- Developing migration scripts for MySQL database to create new tables, indexes and procedures.
- Extensively worked on views, cursors, CTE’s, schemas, permissions and performance issues with client/server database design.
- Writing SQL Queries, complex Stored Procedures on Oracle to get the data into Spotfire
- Involved in Migrating database from Oracle to Teradata, especially converting programs both Oracle compliant SAS code to Teradata compliant SAS code. Migration involved both code conversion and testing the code and output including user acceptance testing. Did an extensive documentation for the migration and published the same in the portal.
- Captured data lineage for all the top-level reports by validating the authorized data sources with system of records and system of origin.
- Performed analysis on existing data model to understand the methodology of model and help QlikView developers understand the requirements.
- Created scheduled jobs for QVD extracts and report reloads using QlikView Server and publisher.
- Validated the data at QVD level and Dashboards level using QlikView.
- Provided tech team support for SDLC Data Warehouse.
- Assisted Project Managers in establishing plans, risk assessments and milestone deliverables.
- Designed data models using Oracle Designer.
- Designed programs for data extraction and loading into Oracle database.
- Managed database tables, procedures and indexes.
- Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote SQL queries to perform Data Validation and Data Integrity testing.
- Implemented enhancements to existing software products.