Business System Analysts Resume
ChicagO
SUMMARY
- Over 15+ years of Professional experience in SDLC performing various roles, involved in developing various kinds of Enterprise Level Distributed / work flow applications which includes Enterprise, IoT, Smart Client, Micro services, Event driven and Server Applications.
- Approximately 13 years of Client/Server, Distributed Enterprise, Design & Implementation of highly scalable OOAD / Service Oriented Architecture (SOA) / Agile methodology/ Microservices architectural style based business applications for private, public, Health care, Shipping, Scheduling, Planning, Customer Communication and Internet of things(IoT) using .NET technology.
- Worked on cloud native applications, server less computing and event driven applications using AWS Sdk/ Console - Lambda, S3, Cloudwatch, Api, SNS, SQS, Api gateway, EFS and Aurora server less.
- Hands on expertise in developing end-to-end applications using .NET, Web Api, WPF, Win forms, WCF, AWS, ASP.NET CORE 2.0, C#, ADO.NET, Web Services, MVC, HTML5, Entity Framework, Dapper, DB4S, JQuery, LINQ, Angularjs, Visio, Knockout, AJAX, IIS, SQL Server, Redis, BizTalk2006 and Share Point 2003.
- Lead role for installation of CDH3, CDH4, experience with processing Big data/ Hadoop framework.
- Hands-on experience with Hadoop HDFS, NoSQL, MapReduce, Hive, Sqoop & Hue - Oozie.
- Created & managed team builds, work Items & responsible for configuration using VSS (Visual source safe), VSTS (Visual Studio Team Services), Confluence, JIRA and DevOps with VSTS for continuous integration & deployment / release management (CI/CD).
- Worked closely with Business analyst, technical team, stack holders / clients to understand requirements and transform into Functional specifications, Work Items (WI’s), CR's, Technical Specifications, assisted project manager / scrum master in project coordination/ management, escalate issues, track & resolve impediments.
- Embedded third party controls such as JQGrid, Infragistics, Kendo and DevExpress.
- Worked extensively JSON and XML related technologies XML, XSLT, XSD, DOM and DTD.
- Expertise in database design and data modeling. Created normalized data models using SQL Server (7.3 to 2014), SQLite, Oracle 8,11g, PostgreSQL using DBeaver, PgAdmin and Workbench.
- Generated various reports using SQL Reporting Services (SSRS), Crystal Reports 8.0, Cognos 10.2 (Event Studio, Framework manager, Report studio) HP Exstream design manager.
- Extensive use of SQL server tuned SQL/ Stored Procedures, Functions, Views and Triggers, activities like Backup, Restore, Import and Export for SQL Server and installation, configuration
- Key role in BizTalk Server production support. Developed BizTalk orchestrations, schemas, maps, pipeline components, functoid’s, adapters. Experience in setting up BizTalk Server installation and Configuration.
- Thoroughly tested the applications using XUnit and performed code reviews to ensure proper coding techniques, standards, Technical Debts and approached as well as adherence to Code Analysis tool by CAST standards and FxCop being followed. Eliminated compiler or runtime errors, redundancies using refactoring tool Resharper
- Comprehensive knowledge and real time experience to provide dynamic IoT solutions- Vehicle tracking, Digital signage, Smart street light, programmable LED signage, Home automation and track custom device monitoring.
- Worked as a lead player in IoT (Internet of Things), involved in all stages - concept, requirement, software & hardware design, prototyping, development, testing, server installations, UAT and support.
- Led and mentored other developers in day-to-day activities. Guided developers to write effective code.
TECHNICAL SKILLS
Frameworks: .NET CORE, .NET Framework (2.0/3.0/4.0/4.5/4.7 ) & Hadoop
Client Server: ASP.NET, Mobile Apps, .Net Core 2.0, C#, ADO.NET, WCF, WPF, AJAX, MVC, MVVM, Web Api, AWS, Silverlight. Microsoft Azure Storage, HTML, JavaScript, VBScript, CSS, ASP, JQUERY, Microsoft Azure, Redis, ElasticSearch, LinQ, Swagger, Postman, Knockout,Vue.js and Fiddler, Visual Basic (5.0, 6.0), ADO, OLE-DB, .NET Win Forms, .NET Windows Services, MVC 5, WCF, Entity Framework 6.0
Cloud Technologies: AWS Sdk/ Console - S3, Lambda, Sql Server, Amazon Aurora MySql and PostgreSql, API Gateway, Cloudfront, Code build, deploy and Codepipeline, SNS (Simple Notification Service), SQS (Simple queue service), Kinesis Firehose and Cloud watch. SQL Azure
XML Technologies: XML, XSD, DTD, DOM, XSL, XSLT, SOAP, WSDL, AJAX, Json and LinQ
Tools: & Applications: Visual Studio IDE (2019, 2017, 2015,2013,2010, 2008, 2005, 2003, 6.0), Visual Studio Code, Visual Inter Dev, HTML TIDY, Macromedia and Flash Fireworks 8.0,, VSTO (Visual Studio Tools for Office), MEL (Microsoft Enterprise Library), Windows Media Services (WMS), ANTS profiler, NUnit, XUnit, Moq and MS Setup & Deployment, MP Lab, Mono development, shell scripting, HDFS, Hive, Pig, Sqoop, Hue UI, Oozie, CA Workload automation, .NET reflector, NetCoole 4, CAST, FxCop, Resharper, Vysor, NLog, Nagios, Splunk, dotPeek, Flurl, Dapper and FacSys. IIS (5.0, 6.0, 7.0), Share Point Portal Server 2003 and BizTalk Server 2006.
Modeling & Scheduler: UML, MS Visio 2003, CA automatic Work Load Automation
UI Controls: Infragistics, DevExpress and KendoUI
Version Control: GIT, Tortoise SVN, Team Foundation Server (TFS), Rational Clear Case, MS Visual Source Safe (VSS), VSTS (Visual Studio Team System), TeamCity 7.0, Atlassian Source Tree, JIRA and Confluence
Build & Deployment: Jenkins, VSTS and TeamCity
Databases & Tools: MS-SQL Server (2000, 2005, 2008R2, 2014), SQL Express, Oracle (7.3, 8), TOAD, Oracle Sql developer 3.2, PostgreSQL-Greenplum & MS-Access, SqLite, DynamoDb, MongoDb, AWS Auroa MySql, DBeaver, PgAdmin, Workbench, Aurora PostgreSQL and SQL Server Management Studio,DB4S
Reporting Tools: IBM Cognos 10.2(Framework manager, Event studio, Query studio, Report studio), SQL Server Reporting Services 2000/ 2005 (SSRS)/ Crystal Reports (7.0 / 8.0), HPExStream, DevExpress Pdf.
Change Management: HP Service Manager, CA Service Desk, and ServiceNow
Tools: Fiddler, Postman, Mozilla REST Client, Beyond Compare and Slack
Operating Systems: Windows Server (8, 7, 2008, 2003, 2000,2012 NT 4.0), Windows XP, 98, 95, Ubuntu, Debian Wheezy and Motion Eye
Office Automation Tools: MS-Office, Page Maker, Adobe photo shop, Dreamweaver, After Effects, Adobe Flash fireworks and Front Page.
Embedded: RFID Readers, Tags, Barcode scanners, Finger print scanners, GSM / GPRS Modems, Wi-Fi Access Points, LPWAN and BLE, Raspberry pi, Banana pi, Toradex, Beaglebone and ESP 8266 / 32
PROFESSIONAL EXPERIENCE
Confidential, Chicago
Business System AnalystsResponsibilities:
- Participate in a design meeting, iteration planning and discussion of design, code, test and implementation of applications.
- Coordinate with stake holders - engineers, product developers to develop a common language and approach to analyzing and communicating information and insights
- Worked directly cross function teams across OEM to develop, maintain, and document a robust set of important metrics for quality, long-term performance tracking
- Provision to apply discounts, taxes, service charges and tips and process the payments through Shift4 payment gateway. Interfaces to provide AP Invoice reports to report to the Finance team, raw data to E15 at the stand/event level and monitor all activities in POS system based on In-event and EOD.
- Holistic approach covering current and latest technology / trends - AWS IaaS/PaaS/SaaS, Virtualization, Cloud Storage/Compute, .NET Core, VS 2019,2017, Sql and NoSQL database.
- Developed POC’s, wireframes, framework, core components and libraries to integrate with third party API’s such as Square /Appetize / Shift4.
- Extensive use of .NET Core, VS 2019,2017 to develop Lambda functions and Api gateway using AWS Sdk.
- Responsible for configuration, tables, view, stored procedures and fine tune of NoSql database - DynamoDb, Aurora server less RDS and Sql Server; familiar with IDE’s such as Dbeaver, workbench, PgAdmin, Sql server management studio and DB4S (Db Browser for SqLite).
- Define Rules & web hooks in Cloudwatch to invoke lambda functions using cron expression and SNS based on publisher/ subscription model.
- Responsible for design, develop and deploy web applications in Elastic Beanstalk, VPC and On-premise windows server.
- Mechanism to log all processed information through functions, errors, events, configurations and sns messages using Cloudwatch, DynamoDb and shift files in S3 bucket, performance monitor, tune and analyze, debug dev /qa / production applications which are built using a microservices architecture using Aws X-Ray and Cloudwatch.
- File storage / archive implementation and draft policies into S3, Glacier, EFS
- Leadership for development efforts including technical designs, object development and unit testing for all the objects identified in Solution Design.
- Relevant experience in Design Review, Code Review and worked closely with Technical Architect for Solution Designs
Environment: .Net Frame work 4.6.1,4.7, .NET Core, Visual Studio 2019, 2017, C#, Entity Framework, MVC, Json, WCFAWS Sdk / Console - S3, Lambda, Cloudwatch, SNS, SQS, Kinesis Firehose, Aurora Server less MySql and PostgreSql, Webhooks, DynamoDb, Elastic Beanstalk, Api Gateway, Aws X-ray, EFS, LINQ, JQuery, SQL Server 20014, Dapper, DB4S (Db Browser for SqLite) & NpgSql 4.1, Confluence, JIRA, Bitbucket, Autofac, KendoUI, Swagger, HTML5, CSS, Bootstrap, dynamic Json.Net, and Atlassian Source Tree,Git, Elmah, Dbeaver, MySql, workbench, PgAdmin, saml2aws, swagger-net, Fiddler, PostMan and Mozilla REST client.
Confidential, Chicago
Business System AnalystsResponsibilities:
- Interact with Business System Analysts and team members to transform business requirements and application requirements into appropriate data model solutions.
- Ability to work effectively with business users and (or) Client to understand and resolve the issues.
- Cooperated work on healthcare members data, eligibility (834), providers and file development processes across business and technical groups.
- Drove tasks in Agile development environment and provided analytical and discovery documents into Confluence.
- Key player in gathering requirements and turn them into database objects, design documents and essential elements to develop console applications.
- Developed various utilities, batch jobs, base frameworks in compliance with SOLID architecture pattern.
- Wrote complex stored procedures, functions to retrieve data for invalid members and providers.
- Performed Data analysis and Data profiling using complex SQL on various sources systems
- Proficiency in coding moderate to complex SQL logic as part of data extraction processes
- Efficient design and extraction process for member's Geographic data from census.gov.
- Extensive use of C# with multithreaded design, Task parallel library, dependency injection (Autofac) to handle logic and Dapper as ORM.
- Created working model of database tables, mappings, identify the keys and data for adequate data relations.
- Conducted meetings with business, defined the ask. Created and updated user stories in JIRA
- Designed and uploaded project structure into Bitbucket repository to maintain code and track history.
- Completed various mandatory certifications under Corporate Privacy Compliance
- Supported on enhancing the existing web apps using progressive framework - Vue.js (CDN) and web Api’s using .Net Core 2.
Environment: .Net Frame work 4.6.1, .NET Core, Visual Studio 2017, C#, Json, XML, Dapper (ORM), LINQ, SQL Server 20014, Confluence, JIRA, Bitbucket, Autofac, Telerik JustDecompile,Vue.js, Swagger, HTML5 and Atlassian Source Tree
Confidential, Chicago
C# Consultant
Responsibilities:
- Worked on enhancement process of areas sales, Opportunity, Renewals and Call tags and Orders
- Adhesive use of .NET 2017 / 2015/ 2017 , ASP.Net Core, C#, Sql
- Extensive development using WPF with DevExpress controls for rich look and feel desktop application.
- NLog & custom application model for logging errors, warning and trace information; Nagios for monitoring health and Splunk analytics tool to search, analysis and visualize resource conditions.
- Strictly followed MVVMP pattern for design process and followed Domain driven development process,
- Used performance monitoring tools and coding standard analysis using CAST and FxCop, Eliminated compiler or runtime errors, redundancies using refactoring tool Resharper, dotPeek and .NET Reflector.
- Created POC's using ElasticSearch, RedisCache and MongoDb with in .Net apps.
- Integrated custom controls, AngularJs/ HTML and containers into WPF desktop application.
- Developed various windows services to support maintenance jobs using CA Automation tool, custom user controls and common utilities to be shared in between entities
- Created Reports and packages in various format such as HTML, CSV & PDF using HP Exstream- Design manager 9.0 .Net & DevExpress Pdf
- Wrote Integration, code coverage and unit tests include Moq's using XUnit.
- Created adapters to interface AS400 database to SQL and FacSys.
- Migrated Delphi application to .Net using NetCoole 4.
- Order overview - Mobile App using Cross-Platform, developed standard, Shared project and portable class libraries.
- Involved integrating DevOps with VSTS for continuous integration and promoted packages using Proget to ensure only verified packages are promoted in Beta, QA, Stage, Training and Production.
- Considerable knowledge on configuration and experience within CA Automatic Work Load Automation tool to deploy and schedule windows services.
- Used Splunk and Nagios to trace and monitor health of WebApi's.
Environment: .Net Frame work 4.0,4.5.1, 4.6.1, Visual Studio 2013, 2015,2017, Visual Studio Code, .ASP.NET Core 2.0, C#, WPF, WCF, Web API 2, AngularJs, DevExpress 15.1 &17.1, XML, Entity Framework 6.0 (ORM), LINQ, SQL Server 20014, RedGate .NET reflector, FacSys, CAST, CA Workload Automation, Resharper and FxCop, NetCoole 4.0, HP Exstream- Design manager 9.0, JetBrains dotPeekDevOps with VSTS, Proget, Git, Atlassian Source Tree
Confidential, Naperville, Illinois
Technical Consultant
Responsibilities:
- Involved in designing process flow for individual subscribers, invoices will be generated and load balanced across multiple jobs.
- Worked closely with LOB to define the life cycle of subscribers to be billed.
- With my proven abilities worked with DBA’s in planning stage on how each of the stored procedures is split into .Net methods and stored procedures which can run in multi-threaded environments.
- Developed proof of concept (POC) in multi-level threading environment, SQL transaction based on SOA (Service Oriented Architecture) using Visual Studio 2010, 2013, Entity Framework 6.0, C# and SQL server 2008 R2.
- Developed batch framework using .NET C# to work under multi transaction scopes.
- Developed layers to interact with database using LINQ.
- Implemented Autonomous transaction, loopback logic for all the servers.
- Integrated try catch block logic in all stored procedure
- Raise error logic implementation, return of appropriate error message from all stored procedures.
- Tuned SQL queries, stored procedures to optimize performance.
- Invoked database calls (Stored procedures) using Entity Framework 6.0.
- Developed data layer classes for performing Bulk-Copy/Bulk-Insert.
- Error logging mechanism in .net using NLog.
- Created adhoc reports pull up in Excel from SQL server.
- Developed logic to generate unique global identifiers for each batch and job, entity layers under single data transaction / connection using Entity Framework 6.
- Rollback logic in .net business layer and capture invoice information for further escalation.
- Performance monitoring & tuning using various tools ANTS, Fog light and SQL profilers.
- Monitored health of application servers using DynaTrace.
- Point of contact for release management using TFS.
- Timely fashions coordinate with offshore and onshore team members for build’s, defect fixes.
- Maintained TFS tasks, deployment tickets, Build notes and WI’s, played a role as scrum master.
Environment: .Net Frame work 4.0, Visual Studio 2010, 2013, C#, ASP, XML, Entity Framework 6.0 (ORM) LINQ, SQL Server 2008 R2, MEF, Foglight, ANTS, DynaTrace & Nlog
Confidential, New York
Lead Software Developer / Consultant
Responsibilities:
- Worked closely with business analysts in gathering requirements, converted in to technical, functional specifications
- With my expertise involved in designing the entire application based on SOA (Service Oriented Architecture) approach. Played a lead role in defining the life cycle of each alert and analyze of data source from various data sources.
- Responsible for Installation / setup of Cognos framework manager, Pervasive.
- Developed proof of concept (POC) application to interact with various data sources such as Greenplum, Oracle and Pervasive
- Applications for client subscriptions, notifications, schedulers, batch processing and work flow for each alert. Implemented new .net features of Task parallel library (TPL), integration of MEF (Managed extensibility framework) for defining rule engine.
- Developed web applications using .NET 2013, MVC 5, Entity Framework 6.0,HTML 5, CSS3, Web API 2, Knockout JS, JQuery, Bootstrap.
- Implemented mechanism of error logging, tracking activities of client using custom logging, Elmah.
- Designed & implemented various entity layers for integrity, bridge to data sources, utility helpers and customized entity layers.
- Actively participated in improving the performance for querying results in every cycle of batch processing.
- Developed web UI using HTML5, Jquery, Ajax, Jquery tabs, Knockout and CSS3.
- Validation controls using Jquery, displayed data in JQGrid.
- Implemented formatters which is configurable from database and drive the notifications, developed libraries such as Core, interfaces, utilities, formatters, business and dal.
- Used Nuget, Ninject’s dependency injection to hold the repositories.
- Created generic web ApI 2.0 in order to extract the results from Green plum.
- Schedulers have been implemented using batch files, Cognos Event studio.
- Designed the IBM data model, subject queries with multi relations. Created packages using IBM Cognos framework manager and published in development environment in order to further work with report studio, event studio and Agent views.
- Defined a workflow in Cognos which extracts the results from web service and push the data to oracle database, notify admin / concern person on status of each schedule.
- Developed Cognos reports using report studio and created multiple agent views which runs on different schedules and notify the clients.
- Coded library for notification services which internally calls AWS (Amazaon web services)
- Consumed (SES & SNS) simple E-mail and simple push Notification services.
- Validations are implemented using Jquery & java script functions on the client side and using data annotations on the server side.
- Designed alert generation engine to distribute the notifications through AWS (Amazon web services) using SES, SNS.
- Performance tuning on oracle, pervasive and Greenplum to achieve fast results. Wrote queries for oracle using linq from database first generated model edmx.
- Implemented npgsql to interact with greenplum database.
- Responsible for configuration management, perforce as source control for development and builds.
- Teamcity for web deployment, x-copy of batch files. Processed cosgnos agent view’s at scheduled interval.
Environment: .Net Frame work 4.5.1, C#, ASP.NET, XML, MVC 5.0, Entity Framework 6.0 (ORM) LINQ, Web API 2.0, WSDL, JQUERY, AJAX, HTML 5, JavaScript, Oracle 11g, Greenplum, Pervasive, Cognos 10.2 - Event Studio, Report Studio and Query studio, JQGrid, Knockout, CSS3, Perforce, MEF, AWS (Amazon Web Services), Teamcity, Resharper and Windows 7.