PROFESSIONAL SUMMARY:

• 9+ years of experience in Confidential domain in the IT industry.
• Hands on Experience in various technologies like ASP.NET, C#.NET, ASP, PowerShell, SQL Server, SSIS, Azure DevOPs Implementation, Cosmos DB, Cosmos Cluster Admin, and PowerBI.
• Good exposure on developing web application using .Net Frameworks 2.0/3.5/4.0/4.5 , JavaScript, Ajax, Confidential Enterprise Library, Angular JS, CSS.
• Hands on experience on writing Scope Script and scheduling them using XFlow for data process.
• Querying Azure Cosmos DB by using the SQL API based on business requirement.
• Good experience on handling Cosmos clusters, by storing structure/un structure stream.
• Writing Gremlin queries for generating json files by connecting Cosmos DB with API.
• Has a good hands - on experience on DevOps implementation using Azure DevOps Build and deployment.
• Good Exposure on writing PowerShell scripts for automating based on business requirement
• Has good experience on SQL server by writing stored procedures, functions, joins and subqueries.
• Expertise on customer handling and team management. involved in all phases of software development life cycle.
• Designed and Developed the SSIS Packages by using different data Transformations to Load data into databases
• Good analytical skills and hands on experience on creating power bi reports.
• Good Experience with Package Deployment, Configuration and Scheduling.
• Experience in working with Setup & Deployment for the development of packages.
• Participated in requirements gathering, specification & mapping documents preparation related to project management.

TECHNICAL SKILLS:

Web Technologies: ASP.Net 3.5, HTML, Java script, CSS .

Languages/Scripting: C,C++,C#.net, PowerShell Scripting.

Operating System: Windows XP, Windows 2012/08/03 Server.

Development Tools: Visual Studio.Net 2017/15/08/2005.

Databases: SQLServer-2008,R 2/2008/2005. Document DBWeb Serve Internet Information Services (IIS 5.1& 6.0).

MSBI Technologies: SSIS, SSRS,SSAS,Power BI.

PROFESSIONAL EXPERIENCE:

Confidential

Module Lead

Software: Azure Cloud, C#, Cosmos DB, DevOps, Power shell, Tinker Pop

Responsibilities:

• Establish continuous integration (CI) pipeline to fully automate deployment of the highly available, customer facing cloud products.
• Support and improve our tools for continuous integration, automated testing and release management.
• Automating build and release process.
• Develop power shell scripts for deployment and configuring applications.
• Actively work to improve production environments, troubleshooting and implementing monitoring/debug tools which will proactively help identify and resolve future issues in production
• Troubleshooting and resolving issues in our development, test and production environments.
• Working with Development Team Leads and Architects to come up with new deployment methodologies and best practices

Confidential

Team Member

Software: C#,Asp.net,K2 Black pearl, k2 Smart forms,K2 package and deployment, SQL severer.

Responsibilities:

• Install and configure the K2 platform and supporting products within supported architectures.
• Provide ancillary infrastructure troubleshooting.
• Provide onsite and remote technical consulting that support K2's products and systems to ensure customers are able to successfully deploy the platform and related components into their desired environments.
• Able to create low complexity solutions based upon K2 products.
• Maintaining a professional level of documentation and deliver complete and comprehensive reports to this end.
• Having good knowledge on IIS, for maintain K2 web application.
• Having hands of experience MSMQ and MSDT services installation and Active directory configuration
• Having hands of experience in building k2 packages from development environment and deploying it into other environments.
• Giving the permission/access for the specified users using k2 workspace.

Confidential

Team Member

Software: C#.net,Asp.net, SSIS,SSRS,MS-SQL Server, IIS 6.0,Windows XP

Responsibilities:

• Extract the data from multiple sources (Excel, SQL Database, Flat file) and load them to the database by applying the business rules
• Worked on OLEDB, Excel Sources and OLEDB Destinations.
• Performed operations like sorting, merging, Conditional Split on the source data in order to clean the data and remove duplicates.
• Worked with configuration and logging files.
• Created stored procedures as needed.
• Worked on OLEDB/Excel Sources/Destinations, SCD’s, Lookup Plus.
• Worked with execute sql task, oledb command, for loop and Sequence Containers, send mail task, lookup transformations.
• Creating SSRS reports using Cascading, Drill through approach.
• Running SQL profiler traces to check any issues with the application
• Created standard report Subscriptions and Data Driven report Subscriptions

Confidential

Team Member

Software: SSIS,SSRS,C#.Net, ADO.Net, Oracle 9i, Crystal Reports, VSS (Visual Source Safe) and Windows XP

Responsibilities:

• Understanding Functional design given by Product Architects.
• Development of the prototype of the complete system.
• Involved in the Analysis and Technical Design, Technical Uptake, Developer Test cases for common components.
• Extracting data from external data source using SQL server 2k5 and 2K8
• Running SQL profiler traces to check any issues with the application
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS)
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

Confidential

Team Member

Software: ASP.Net, C#, MS-SQL ServerJavaScript and Validation Controls, IIS 6.0, CSS VSS (Visual Source Safe) and Windows XP

Responsibilities:

• Involved in gathering requirements after brief discussion with the AP Genco
• Commercial Department for Commercial Module.
• GUI Design and coding Web Forms using asp.net with using C#.
• Involved in designing queries using SQL Server
• Wrote stored procedure in SQL Server 2005 to handle data manipulations.
• Coding and unit testing.
• Wrote Database Queries According To the Business Requirement
• Wrote The Join Queries, Views And Indexes