Application Developer Resume
Overland Park, KS
SUMMARY
- 9+ years of experience in project design, analysis, requirement gathering, documentation, development & product delivery.
- Managing multiple offshore development teams, taking accountability for product development and delivery.
- Strong experience in handling multiple projects which are in different phases - Development/Support phases.
- Doing code review, following effective ways of development, code analysis, functional testing to ensure the requirements are met. Good knowledge on Implementing and understanding Object Oriented Programming in C#.
- Extensive experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
- Expertise is SQL Server 2014/2012/2008/2005 Reporting Services (SSRS), SQL Server 2014/2012/2008/ 2005 Integration Services (SSIS) and in SQL Server 2014/2012/2008/2005 Analysis Services in Business Intelligence (BI. Strong analytical, problem troubleshooting/solving skills, self-starter.
- Strong hands onT-SQL and query optimization, developing ETL strategies. Adept knowledge in SSIS architecture, configuration tools and XML processing. Worked wifPerformance Tuningfor Oracle RDBMS usingExplain Planandhints. CreatedPackagesandProceduresto automatically drop table indexes and create indexes for the tables.
- Expertise in Object Oriented Programming (OOP) Concepts like Inheritance, Polymorphism, Abstract Classes, Interfaces and delegates
- Extensive experience in developing Web applications, Client-Server technology using C#, ASP.NET, ADO.NET, .Net Framework 4.5/4.0/3.0/2.0/1.1 , XML, HTML5, CSS and good knowledge in software engineering practices.
- Expertise in developing Ad-hoc and Parameterized Reports, Create complex reports (ex: drill down reports using different objects) using SSRS.
- Experience inETLtechniques and Analysis and Reporting including hands on experience wif the Reporting tools such as SSRS. Experienced in developing complex reports using Business Objects Webi Rich Client & Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
- Developed different projects wif ASP.NET, ASP MVC, C# and database using ADO.NET, Entity Framework and LINQ.
- Experience in developing User Interface (UI), Business Logic and Data Access components to meet user requirements.
- Extensively worked on Entity Framework generating ORM Models and integrating them through Entity SQL and LINQ to Entities.
- Experienced in web application design and development using multiple versions of .NETframework including ASP.NETMVC wif C#.
- Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
- Developed complex SSIS packages using multiple data sources, and worked on creating jobs, Alerts and scheduled them using SQL Server Agent. Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
- Experience in a fast-pacedAgileDevelopment Environment including Extreme Programming. Developed the design documents, coming up wif LOE, handling the project and tickets escalations during the project development life cycle.
- Holding biweekly internal and external meetings to ensure the development is on track.
- Excellent knowledge in data warehouse concepts like OLAP and OLTP.
- Extensive experience in using and implementation of ETL methodology in data extraction, transformation and loading.
- Worked wif open source SFTP, SCP, and FTP client like WINSCP, FileZilla.
- Designed, developed and went live after migrating several MS Access &SQLServer databases for corporatedevelopers, resolving typical database issues. Experience in writing SQL queries for pulling large volume of records from facts and claims database using stored procedures, and Extraction, Transformation, and Loading (ETL) process using SSIS.
- Experience in Monitoring, Job scheduling, Trouble shooting, Backup, Recovery and System upgrading.
- Created various reports like drill through reports, drill down reports, sub reports, cascading parameters, linkedreports, matrix etc. using BIDS.
- Experience wif Microsoft SQL Server 2005/2008, SQL Server Profiler, SQL Reporting Services. Ability to detect and troubleshoot SQL Server related CPU, memory, me/O, disk space, and other resource contention issues. Resolved application T-SQL related issues. Created periodic Disaster Recovery testing plan and enable the capability for all SQL Server environments. Intermediate experience using application of Analytics using MDX/DAX and data mining.
- General understanding of Azure Cortana Intelligence suite machine learning and artificial intelligence. Understanding of both Kimball and Corporate Information Factory data modeling approaches. Other data platforms such as Alteryx, AWS, Google Cloud Platform, Oracle, Business Objects, SAP, MicroStrategy, Crystal Reports and ClikView. SQL Server 2008 R2, SSIS/SSAS/SSRS. Reporting Services/Report Builder 3.0, MSBI PowerPivot, or Tableau.
- Knowledge of technology and information systems, wif concentrations in contact center, data analysis, relational database, OLAP, and reporting tools.
- Experienced in a data-rich environment using SQL for data extraction, processing, manipulation, query & reporting wif a demonstrated practical knowledge of building analytical databases and managing data.
- Experienced in Marketing or Sales organization preferred; experience wif CRM (me.e. Siebel, Salesforce.com), Marketing Automation Platform (me.e. Marketing Cloud, Marketo) and/or Web Analytics (me.e. Google Analytics)
- Good experience in using Multidimensional Expressions (MDX) for querying and manipulating the multidimensional data stored in OLAP cubes. Presenting the tools at Global level for different customers and doing the enhancements as per the end customers need to gain more business. Designing the workflow and prototypes to communicate in Business language during the requirement gathering phase.
- Managing and monitoring the project to ensure the SLA’s are met. Taking the accountability and updating the project tollgates to the PM and Business on a regular interval during the project development life cycle.
- Working wif the Business on the usage of Tableau version 9.1 and setting up the environment and training the users as well.
TECHNICAL SKILLS
Database Tools: SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), Server Query Analyzer, SQL Server Agent, SQL Jobs, SQL Alerts and SQL Mail, SQL Server Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), BIDS, SQL Server Profiler, Power BI.
Languages& Application: T-SQL, PL/SQL, C#, .NET, ASP.NET, Java Script, JQuery, LINQ, HTML. Visual Studio, MS Office, Team Foundation Server
Operating Systems: Windows 2007/2010 Windows Server 2000/2003/2008/2008 R2/2012, LINUX
Databases: MS-SQL Server / 2008 R2 / 2012, MS Access, MySQL, T-SQL, T-SQL, PL-SQL, AZURE Analytics services, Azure Data Lake
Data Modelling Tools: Erwin, Microsoft Visio 2000/2003, Microsoft Project/Office 2003,2007, 2010, 2013
Reporting/ Analysis Tools: Microsoft Excel, SSRS, SSAS(Tabular Model, DAX / MDX), SSIS, Power BI Desktop/Service, Tableau, SharePoint.
Application Software: Visual Studio, MS Office, Team Foundation Server, GIT.
ETL Tools: DTS, SSIS, Bulk Copy Program (BCP), Business Intelligence Development Studio (BIDS), Crystal Reports.
Testing tools: Issue Tracker, JIRA
Other Tools: WINSCP, Putty, FileZilla
PROFESSIONAL EXPERIENCE
Confidential, Overland Park, KS
Application Developer
Responsibilities:
- Involved in supporting/development of multiple projects. Completely involved in the project development life cycle to ensure the committed tollgates are met.
- ASP. Net MVC 4.5, C#, HTML5, JavaScript, JQuery, CSS3, Bootstrap, XML, Angular JS 2.X and, custom web controls and user controls.
- Developed the middle tier business logic components using ASP.Net MVC 4.0 and C#.NET as the programming language.
- Implemented validations and applied exception handling in some parts of the application
- Used JavaScript for client-side validations for immediate response from the browser to the End User.
- Involved in consuming Web API (Application Program Interface) for client-side web application.
- Functional testing the code to ensure the requirements are met and doing the deployment of the code in dev/test/production environments. Designing the HLD, LLD & Flow Charts for the functional features and coming up wif LOE
- Handling Business Demo’s and Code deployment in Dev/Test/Prod environments.
- Adhoc Code fixes and ensuring the best approach is followed during the project development life cycle.
- Identifying the gaps and fixing the code during the escalation process of project testing and prod issues.
- Using the Tableau to generate the business reports and training the end users.
- Implementing RDBMS concepts and good understanding of database schemas.
- Involved in improvement of optimized query performance by creating Indexes.
- Involved in Analyzing, designing, building and testing of OLAP cubes wif SSAS 2008 and in adding calculations using Multidimensional Expression (MDX).
- Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Databases
- Responsible in ETL releases and support daily ETL runs feeding multiple data warehouses
- Develop data mapping and transformation rules and detailed designs based on system and business requirements.
- Performed SQL admin duties using SQL Server Agent for data backup, creating different roles on users and created jobs.
- Supporting multiple projects and escalating/fixing the issues depending on the priorities of the issue.
- Working wif the Testers to come up wif the Test Case scenarios and sharing the same info wif the Business users which is used during the UAT by the testers.
- Documenting and keeping track of the Test Results to ensure they are fixed and are not repeated down the road.
- Biweekly and adhoc meetings to address the development status and to meet any last-minute priorities.
- Experience in Microsoft Visual C# in script task and script component of SSIS.
- Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.
- Integrating the reports wif the UI. Maintaining and doing the Enhancements on UI using Entity Frame work.
- Created multiple drill down reports into a single master financial report which TEMPhas all the required data of Cost, Revenue, P&L, Units & LOE information. Experience in working on different kinds of reports Parameterized Reports, Linked Reports and Drill-through reports. Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including currentstatus. Responsible for creating and maintaining the documentation for implementation and for future changes.
- Experience in targeting dimensional data ware house models which includes some schemas and modeling designs.
Confidential
Software Developer
Responsibilities:
- Worked as a php developer for my shelf project. Integrating the SMS Module wif the user’s registration and notifications part.
- Interacting wif the scheduler and google maps for the relevant pages. Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction. Created Database Objects like Tables, Stored Procedures, Views, Triggers, and UDFs. Created new database/tables to put in the extracted data and rebuild the relationship.
- Developed ETL packages wif different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing various kinds of transformations using SQL Server Integration Services (SSIS).
- Developed many Tablix Reports, Tabular Reports, Matrix Reports, Drill Down Reports and Charts using SQL Server Reporting Services (SSRS/2008). Utilized event handling effectively to generate logs for the packages created.
- Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2008 Analysis Services (SSAS) and Reporting service (SSRS).
- Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries wif MDX, Data Mining Models, developing reports using MDX and SQL.
- Planed, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
- Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.
- Created reports as per user requirement using SQL Server reporting services (SSRS) which delivers enterprise and Web-enabled reports. Used Power shell to manage SSIS packages across multiple SQL Server instances.
- Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from various locations. Performed Identification, analysis and resolved report defects wifin time scope and established development guidelines.
Confidential
SSRS Developer
Responsibilities:
- Understand user requirements and Data Model defined and developed by the business analysts and data architects.
- Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis.
- Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
- Implemented different types of constraints on tables.
- Designed and applied entity and attributes description and definition for the models.
- Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
- Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
- Extract, Transform and Load source data into respective target tables to build the required data marts.
- Designed ETL process using SSIS to transfer data from heterogeneous data sources.
- 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.
- Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
- Worked on Deploying, Scheduling Jobs, and Alerting and Maintaining SSIS packages.
- Developed Cube wif Star Schema.
- Created usage based aggregations in cube to minimize time for query retrieval from client tool Target.
- Gatheird business requirements to create business user reports.
- Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
- Developed optimal stored procedures and queries to create data sets for reports.
- Designed and implemented stylish report layouts.
- Generated Reports using Global Variables, Expressions and Functions for the reports.
- Responsible for scheduling the subscription reports wif the subscription report wizard.
- Played a Content Manager role on report server.
- Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
- Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.
Environment: Microsoft SQL Server 2005, SSIS 2005, SSAS 2005, SSRS 2005.
