| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
Email: EMAIL AVAILABLE
Mobile: PHONE NUMBER AVAILABLE
LinkedIn: https://LINKEDIN LINK AVAILABLEObjective: To obtain a challenging opportunity as a SQL Developer / Oracle PL/SQL Developer / SSIS / SSAS / SSRS / Informatica Lead suitable to my education, abilities, and experience.
Summary:
Working as a Developer/Analyst/Tech Lead in the areas of analysis, design and development of Web and Windows applications, Oracle PL/SQL and SQL Server. Experience with SQL Server, SSIS, SSAS, SSRS, Informatica, ETL Testing, Data mapping, DataStage, Normalization, Oracle PL/SQL, C#.Net, Azure CI/CD, TFS, GitHub and Agile Scrum Experience in Informatica ETL mappings and workflows, extracting data from various heterogeneous source systems like Flat files, XML, Oracle and SQL Server. Create reusable transformations, mapplets, workflows, worklets using Informatica PowerCenter Experience with data warehouses, data marts and data cleansing. Modify existing SSIS packages/projects according to specified systems designs, test modified programs to ensure that they conform to design. Experience with business requirements gathering and documentation of system changes in conformance with department standards, including report descriptions, user procedures, operations procedures Experience with develop test data for use in program testing. Designing and developing data transformation solutions using a variety of SSIS components Data Flow Task, Data Flow transformations, Data Flow containers, Foreach Loop containers, Script components using C#. Used Visual Studio Data Tools for SSIS/SSRS/SSAS related builds. Work with business users, developers, and other stakeholders to determine and document the requirements of the data warehouse and data marts. Experience with Data Visualization tools such as SSRS, Tableau, PowerPivot and Power BI. Design and develop data pipelines for transferring data between several data sources in an efficient manner Used Service now tool for application issues ticket tracking.
Experience with Route cause analysis and production support request process. Knowledge on Star Schema and Snowflake Schema. Design, develop, and maintain Power BI reports and dashboards to visualize data and provide actionable insights. Strong proficiency in Power BI Desktop, Power Query, Power Pivot, VBA, DAX, and M language functions. Experience in data modeling, data visualization, and dashboard design. Experience with snowflake and Star schema in data model. Design, build, and populate data objects such as SSAS cubes, relational dimensional databases, and SSAS data mining models. Designs and builds BI user interfaces such as dashboards and reports using Power BI/SSRS/Tableau Tools. Supports Data Warehouse enhancements and operations including table, view, stored procedure, and other changes. Experience with Data marts and Data mining. Performance tuning and T-SQL query tuning. Experience with OLAP cubes development and scheduling jobs, actions and MDX queries.
Experience with Azure Data Lake, Azure Data Factory, Data activities, Data flows and Pipelines Knowledge on IT Services tools like Service Requests, Incident and Problem Management, Knowledge Management, Reporting, Integrations. Agile Scrum software development methodologies using Azure DevOps and Dashboard configuration. Lead the customer interface for the project on an everyday basis, proactively addressing any issues. Requirements gathering and translate them into solutions using the necessary skills. To ensure successful initiation, planning, execution, control and completion of a small or a less complex project through monitoring, tracking and analyzing project control metrics.
Lead project development, production support and maintenance activities.
Interact with client to understand the issue and resolving the customer support issues. Experience with data encryption and masking. Creating request/incident in Request center and obtaining all approvals from business owner and IT supervisor for data/code change.
Analyzing the issues and find the Route cause for customer reported post launch issues and suggesting the Change request if required. Experience with Autosys and Cron Jobs Development and MonitoringCertifications:Microsoft Certifications:
Developing ASP.NET MVC Web Applications Developing Solutions for Microsoft Azure AZ 203 Microsoft Azure Architect Technologies AZ 300TECHNICAL SKILLS:RDBMS
Microsoft SQL Server 2008/2012/2016/2017, Oracle PL/SQL 10g/11g, MySQLLanguages
T-SQL, VB Script, C#.Net, VB.Net, PythonDeveloper Tools
SQL Server Management Studio, Business Intelligence Development Studio (BIDS), SQL Profiler, SQL Query Analyzer, DTS Import/Export, Microsoft Visual Studio, Team Foundation Server (TFS), GitHub, PVCS, CI/CD, Azure DevOps, Scrum, MySQL WorkbenchETL ToolsData Transformation Services (DTS), SQL Server Integration Services (SSIS), Azure Data Factory (ADF), Azure Data Lake, Informatica Power Center 10.5.2, WinSCP, PuttyReporting Tools
SQL Server Reporting Services (SSRS), Power BI, TableauOperating Systems
Windows 2007/2010/2011 Server XP/Vista, UNIX, LinuxWeb TechnologiesHTML, XMLWORK EXPERIENCE:
Client: Staples Inc. Nov 2022 CurrentProject 1: Server MigrationRole: Senior SQL DeveloperThe Server migration is migrating Oracle Database to Azure SQL Server database. The database Tables, Triggers, Views, Functions, Procedures and packages. Converting all objects from Oracle to SQL Server, copying data between servers, error handling, compiling and performance tuning for functions and procedures.
Responsibilities: Involved in database migration from Oracle to Azure SQL Server. Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible. Created SSIS packages for data movement and loading with error checking and well documented code. Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column. Implemented Event Handlers and Error Handling in SSIS packages
Ensure data quality and integrity throughout the data lifecycle. Developed documentation for data pipelines, processes, and systems. Created Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers. Optimizing long running SQL queries using indexing strategies and query optimization techniques. Converting PL/SQL scripts to T-SQL Queries, Views, Functions and Triggers. Designed and Deployed SSRS reports using Microsoft Reporting Services (SSRS). Troubleshoot and resolved issues related to SSRS reports, data discrepancies, and performance bottlenecks Performed data validation, data profiling, and data quality checks to ensure data accuracy, completeness, and consistency in SSRS reports. Troubleshooting the issues in SSRS report in case of failure and fixing the issue. Install, configure, and maintain SSAS instances. Design, build, and populate data objects SSAS cubes,
to ensure optimal performance and reliability. Implement security measures to protect sensitive data within SSAS cubes and Excel workbooks. Used Azure Data Lake, Azure Data Factory, Data activities, Data flows and Pipelines for Data movement. Involved in stored procedure execution, Error handling Testing and debugging the code. Responsible for rebuilding the indexes and tables as part of performance tuning. Developed Informatica workflows to data extract, transformations and load (ETL) data into SQL server database. Used Azure data lake and Data bricks to load data into SQL server database. Used GitHub, Jira/confluence and Agile/ Scrum methodologies. Used Azure DevOps pipelines for continuous integration and continuous delivery/continuous deployment (CI/CD). Worked with data owners and end users to understand business requirements to develop appropriate data models. Connect, import, and transform data for Power BI reporting. Developed, published, and scheduled Power BI reports per business requirements. Translate data into informative visuals and Power BI reports based on the needs of data owners and end users. Developed visual reports, dashboards and KPI scorecards using Power BI desktop. Created Measures, DAX and calculated fields for the reports. Used Service now tool for issues tracking. Worked with informatica Transformations in workflow creation and mapping. Used Python coding skills to develop and maintain data pipelines, ensuring efficient data processing and transformationEnvironment: Microsoft SQL Server Management Studio 2017, Oracle SQL Developer, Informatica 10.5.2, Jira, GitHub, Azure Data Lake, Azure Data Factory, Data bricksOrganization: Tech MahindraClient: Navistar Inc..@ Lisle, IL Dec 2021 Nov 2022Project 2: Mobile ApplicationRole: SQL Developer Lead
The Mobile Application would be a cross-platform mobile application available to both the Android as well as the IOS platform. Mobile Digital Platform shall be developed for small business users typically with small fleets or the ones where the drivers change very frequently or where the fleet owner himself is continuously on the move.Responsibilities:
Involved in Working with business analysts to build tight technical specifications within a formal SLDC project environment assuring the business requirements are met by the coded solutions. Requirements gathering and translate them into solutions. Responsible for writing T-SQL (DDL/DML) Queries, Views, Functions and Triggers. Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible. Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers. Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques. Used Service now tool for issues creation and tracking the status. Used SQL Server Agent for scheduling SQL Server Integration Services jobs. Developed SQL Server Package Configuration technique to make Dynamic configurations. Data profiling and source system analysis and present clear data to visualizations. Responsible for rebuilding the indexes and tables as part of performance tuning. Used SSIS to create ETL packages to validate, extract, transform and load data into Data Warehouse and data marts. Used C# for Script Task changes in SSIS. Used Azure Data Lake, Azure Data Factory, Data activities, Data flows and Pipelines for Data movement. Developed reports using Microsoft Reporting Services (SSRS) from a variety of data sources including Cubes and relational databases. Data cleaning and transformation done using Power Query. Defined key performance indicators (KPIs) for Reports. Designed, developed, and maintained Power BI reports and dashboards to visualize data. Created Measures, DAX, M language functions and Calculated fields for Power BI Reports. Developed Power BI data models that aggregate data from data sources to meet requirements, configure, and set up gateway refreshes. Maintain Power BI reports and dashboards that provide valuable insights and support data-driven decision-making. Optimized Power BI reports and queries for performance and responsiveness. Developed SSAS Cubes and data processed for Dimensions. Monitor SSAS performance and troubleshoot issues as they arise, ensuring timely resolution. Document SSAS installations, configurations, and best practices. Integrate SSAS cubes with Excel workbooks to provide users with intuitive and interactive data analysis tools
Created SSIS package to extract data from XML files and load into Database. User GitHub, Jira and Agile Scrum methodology for Development. Configured SQL Mail Agent for sending automatic emails when SSIS packages fails or succeeds. Developed Named Sets in MDX and describes the purpose of named sets in MDX, and the techniques needed to create and use them in MDX queries. Worked with various SSIS packages which involve Transactions, restart ability and roll back techniques. Configured SQL Mail Agent for sending automatic emails when SSIS packages fails or succeeds. Developed Slowly Changing Dimensions (SCD) Packages using SSIS (ETL) to perform the Incremental Historical load from Source to Staging Environment and into the Enterprise Data Warehouse.Environment: Microsoft SQL Server 2016, Visual Studio 2015, SSIS, SQL Server Management Studio, SQL Profiler, Query Analyzer, Azure DevOps, Agile Scrum, GitHubOrganization: Tech MahindraClient: Ford Motor Company @ Dearborn, MI (Offshore Project from Chennai) Jul 2018 Dec 2021Project 3: EUSEDRole: SQL DeveloperThe Web application is used for remarketing of used vehicles PVs and CVs for 9 Markets. We have multiple interfaces to validate vehicle data and get images and shown to the end users and they can search by location and contact the Dealers located in that location.Responsibilities:
Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data. Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area. Created views to facilitate easy user interface and implemented triggers on them to facilitate consistent data entry into the database. Design, develop, and maintain Power BI reports and dashboards to visualize data. Power BI development, generate technical solutions to resolve complex data, reporting, process, and/or tool needs. Researches, reviews, and analyzes the effectiveness and efficiency of existing Power BI reporting and ETL procedures and develops strategies for enhancing or further leveraging these processes. Follows appropriate incident, problem, change management, and project processes. Achieves goals assigned to the Developer as part of the department's annual operating plan and budget. Troubleshoot the Tableau dashboard and report problems independently, determining the root cause and fixing the problem. Developed interactive Dashboards using Tableau Migrated DTS packages from SQL Server 2010 to SQL Server 2012 as SSIS Packages. Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code. Migrated data from MS Access into SQL Server 2012 using SSIS Packages in Business Intelligence Development Studio. Extracted Data from various Heterogeneous Databases such as Oracle and Access database, flat files to SQL server 2012/14 using SSIS. Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column. Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities. Used Text Files/SQL Server Logging for all SSIS packages. Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS). Developed reports using Microsoft Reporting Services (SSRS) from a variety of data sources including Analysis Services SSAS Cubes and relational databases. Troubleshoot and resolved issues related to SSRS reports, data discrepancies, and performance bottlenecks Performed data validation, data profiling, and data quality checks to ensure data accuracy, completeness, and consistency in SSRS reports. Troubleshooting the issues in SSRS report in case of failure and fixing the issue. Deployed and configured the reports in the Report Server. Involved in generating Matrix reports, Sub reports and Complex reports with multi value parameters for the analysis of Performance using SSRS. Developed complex Stored Procedures to generate various Drill-through reports, Parameterized Reports, sub-reports and linked reports using SSRS and integrated into the front end. Used Query and Slicer Axis (MDX) and describes what query and slicer axes are and how to specify them. Building Named Sets in MDX and the techniques needed to create and use them in MDX queries.Environment: Microsoft SQL Server 2016, Visual Studio 2015, SSIS, SQL Server Management Studio, SQL Profiler, Azure DevOps, Agile Scrum, Rally, Git, MySQL WorkbenchOrganization: Tech MahindraClient: Ford Motor Company @ Dearborn, MI (Offshore Project from Chennai) Jul 2015 Sep 2018Project 4: Retail Identification Program Sign Ordering SystemRole: SQL DeveloperCustomer facing website for placing online orders of all Sign boards, is the control system for all approved signs at franchised Ford and Lincoln dealerships under the Retail identification Program. Invoice creation, Dealer bill creation and approval process of all orders and the implementation of signboards.Responsibilities:
Worked extensively with SSIS to import, export and transform the data between the linked servers. Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/Data Models, Requirement documents and ETL Specifications. Created database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL server 2012. Daily support, troubleshooting, monitoring, optimization, tuning and blocking of servers and SQL server environments across entire system. Used DDL and DML for writing Triggers, Stored Procedures and Data Manipulations. Created Autosys Job and implemented for data processing. Prepared test data, implement and support test activities including the creation of test plans and test cases and track results Involved in Unit Testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements. Generated Database SQL scripts and deployed databases including installation and configuration. Created DTS Packages for data import/export, scrubbing and scheduled jobs for backups for SQL and Oracle Databases. Used SQL Profiler and Query Analyzer to optimize DTS Package queries and Stored Procedures. Migrated DTS objects to SQL Server Integration Services (SSIS) environment. Used TFS version control. Created SSIS package to extract data from XML files and transform the data in required format to load into Database table. Responsible for extracting and transforming data using DTS Import/Export, DTS Packages, MS SQL Server Integration Services (SSIS) Packages, Bulk Insert and Utilities like BCP. Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
Developed various reports using SSRS, which included writing complex stored procedures for datasets. Involved in Report Authoring, Report Delivery (using both Pull and Push strategy) and Report Management for various types of reports.
Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation. Developed key performance indicators (KPIs) for reports based on business requirements Performed data validation, data profiling, and data quality checks to ensure data accuracy, completeness, and consistency in SSRS reports and datasets. Experience with Create Data extraction and Import programs using SSIS for SSRS reports. Develops mission critical business reports using SQL Server Reporting Services (SSRS) consisting of both the presentation (design) and data layers. Performs basic administration of SQL Server Reporting Services Report Manager ASP Web Page.Environment: Microsoft SQL Server 2012, Visual Studio 2012, SSIS, SQL Server Management Studio, SQL Profiler, TFSOrganization: Tech MahindraClient: Ford Motor Company @ Dearborn, MI (Offshore Project from Chennai) Jul 2013 Jun 2015Project 5: Government Bid Management SystemRole: SQL DeveloperWeb based online concession request, analysis, approval notification process integrated with dealer portal(s) and fleet web site. Dealers will create Bid, and which will be routed to internal managers approvals based on concessions. Emails automated to Dealers for request creation and approvals.Responsibilities:
Worked extensively with SSIS to import, export and transform the data between the linked servers. Involved in business analysis and technical design sessions with business and technical staff to develop Entity Relationship/Data Models, Requirement documents and ETL Specifications. Created database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL server 2012. Daily support, troubleshooting, monitoring, optimization, tuning and blocking of servers and SQL server environments across entire system. Used Selenium Automation tool for Testing. Used C# language in SSIS package development. Monitoring and Troubleshooting SQL Cluster, Mirroring, Log Shipping. Used DDL and DML for writing Triggers, Stored Procedures and Data Manipulations. Involved in Unit Testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements. Generated Database SQL scripts and deployed databases including installation and configuration. Created DTS Packages for data import/export, scrubbing and scheduled jobs for backups for SQL and Oracle Databases. Created Cron Jobs and used Unix scripts to implement, monitor and fix the issues. Written complex SQL statements using Joins, Sub Queries and Co-Related Sub Queries. Resolved any deadlocks issues with the Databases/Servers on a real-time basis. Used SQL Profiler and Query Analyzer to optimize DTS Package queries and Stored Procedures. Migrated DTS objects to SQL Server Integration Services (SSIS) environment. Responsible for extracting and transforming data using DTS Import/Export, DTS Packages, MS SQL Server Integration Services (SSIS) Packages, Bulk Insert and Utilities like BCP. Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
Developed various reports using SSRS, which included writing complex stored procedures for datasets. Involved in Report Authoring, Report Delivery (using both Pull and Push strategy) and Report Management for various types of reports.
Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation. Uses SQL Server Analysis Services to enhance existing, or develop new, OLAP (SSAS) cubes used in the EDW system. Uses Multi-Dimensional Expression (MDX) query language to extract data from OLAP cubes for reporting and analytical purposes. Building Cell Calculations in MDX, details the process of creating and using calculated cells. Creating and Using Property Values (MDX), creating and using dimension, level, member, and cell properties.Environment: Microsoft SQL Server 2008, Visual Studio 2008, SSIS, SQL Server Management Studio, SQL Profiler, GitOrganization: Tech MahindraClient: Ford Motor Company @ Dearborn, MI (Offshore Project from Chennai) May 2010 Jun 2013Project 6: FIN SuiteRole: Oracle Developer
FIN Suite application allows the users to create FIN and Welcome Package sending welcome mail to the FIN user after receiving all document. This application mainly used for FIN registration process as enrollment and activation.
Responsibilities:
Requirements gathering and analysis, prepare specification. Code review with Team Perform Unit and regression Testing. Store procedures, functions and Triggers creation in Oracle database Create and update queries, stored procedures, functions, Views and database objects. Troubleshoot existing solution to resolve the issues.Environment: Oracle 11g, Visual Studio 2008, PVCSOrganization: Tech MahindraClient: City Financial International @ Chennai Sep 2008 Apr 2010Project 7: I-Loan (Integrated Loan Management System)Role: Oracle Developer
I-Loan (Integrated Loan Management System) is running an n-tier application developed using Asp and VB using Oracle 9i database engine. For improving the performance, flexibility and scalability of this application, CFI customer decided to migrate I-loan to Microsoft Framework with Oracle 10g database. This I-loan contains functional and nonfunctional Modules. The Functional modules performs things like loan application processing, sales management, access the customer information dealer agent tracking information and loan operations/account maintenance.Responsibilities:
Implement normalization, transformation, aggregation, etc. to organize and prepare data for use. Create queries, stored procedures, and triggers. Updating existing Stored Procedures, Functions and Views Perform data extraction, ingestion, mapping, deduplication, standardization. Collaborate with the data analysis team to ensure data integrity. Validating data with Development team and performance tuning
Create new database objects as per the business requirements.Environment: Oracle 10g, Visual Studio 2008, PVCSEDUCATION: Master of Science in Computer Science Sri Venkateswara University, 2003 Bachelor s Degree in Computer Science Sri Venkateswara University, 2001 |
