We provide IT Staff Augmentation Services!

Senior Developer/architect Resume

SUMMARY:

  • Highly accomplished and versatile result - oriented Technical Project manager with 16 + years of industry experience in Business Development, Project Management and Software Delivery. Strong hands on developing and executing all activities related to end-to-end Program management including Portfolio and product development & management. Directly manages all aspects of the projects and works with matrix business, corporate and IT partners to oversee all phases.
  • Experienced in the Administration, Maintaining and Development of MSBI (SSIS/ SSRS /SSAS)
  • Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2/2012.
  • Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
  • Hands on Experience in working with ecosystems like Hive, Sqoop, Map Reduce.
  • Successfully loaded files to Hive and HDFS from Oracle
  • Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
  • Developing reports on SSRS on SQL Server (2000/2005/2008/2012 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
  • Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL
  • Experience in Performance Tuning and Query Optimization.
  • Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
  • Business Objects: Seven years experience developing reports in Business Objects v5.16, 5.19 and XI R2. Tools: Designer, Developer, Webi, Supervisor, SDK, Broadcast Agent, Live Office. Currently Business Objects administrator.
  • Advanced extensible reporting skills using SQL Server 2005 Reporting Services (SSRS)
  • Expertise at Oracle 9i/10g server (PL/SQL) and MS SQL-Server 2008, SQL, PL/SQL, SQL*Plus, SQL*Loader, configuring client-server connectivity, Query Optimization, Stored Procedures and Triggers and strong knowledge of relational databases.
  • Expertise in Design and Development of Win Forms and ASP.NET Web Forms using
  • C#.NET, VB.NET, ASP.NET, ADO.NET, WCF, AJAX, VB6.0, ASP, XML, XSL, JavaScript, VBScript, DHTML, CSS, MS SQL Server (T-SQL) and MS Visual Studio 2003/2005/2008.
  • Experience in Design, Development and Deployment of Business Systems in Banking & Finance domain and Reporting domain.
  • Extensively worked on Active/Passive cluster configurations in Business Objects Enterprise XI R2 and Crystal Enterprise 10
  • Experience in using ADO.NET objects such as SQL / OLEDB connection object, ODBC DSN for Crystal Reports template design.
  • An ELT Developer is experience with database procedural languages / commercial ETL Tools/shell scripting / XML/ file transfer methods/ financial applications/brokerage and investment systems.
  • Expert BO Data Integrator (BODI) XI 11.7.X / BO Data Services XI 3.0 developer.
  • Developed Complicated Cross-Tab reports, Sub reports, Drill down reports for Client Server Applications.
  • Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
  • Expert in creating Parameterized Reports.
  • DTS (Creating DTS, Active-x Scripts, Scheduling and Monitoring).
  • Hands on experience in UNIX shell scripting for Job Scheduling, SQL Script execution.
  • Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

TECHNICAL SKILLS:

BI Tool: MSBI (SSIS, SSRS, SSAS), Business Objects Enterprise XI Release 2, Crystal Enterprise 10

Big Data: Hadoop, Map Reduce, HDFS, Hive, Sqoop

Reporting Tool: Tableau, Crystal Reports XI, Actuate ERD Pro, Crystal Reports Server9, Crystal XI Celsius, Business Objects Data Integrator XI (BODI).

NET Platform: .Net 4.0, C#. NET, VB.NET, ADO.NET, ASP.NET 2.0, Web Services, SOAP, AJAX, XML and XSLT

Languages: VC++, Visual Basic 6.0 and XML. COM/DCOM, HTML

Databases: SQL Server 2000/2005, MS-Access, Oracle

Web Development: MS Commerce Server, MTS, Classic ASP, HTML, VBScript, JavaScript, XML, XSD, XSL/XSLT, CSS, IIS, Crystal Business Object Server

Tools: and Utilities: Visual Studio .NET 2003, Microsoft Visio 2003, Visual SourceSafe, Crystal Reports XI, Active Reports, Data Reports

Third Party Tools: Infragistics, PeterBlum, Pinsplit, TOAD (Oracle) and DTS

Finance Application: Fundsation Application, Recon Plus Application, FSR (Fund Services Reporting)

PROFESSIONAL EXPERIENCE:

Senior Developer/Architect

Confidential

Responsibilities:

  • Create new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008/2012.
  • Generated reports using Tableau Desktop version, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
  • Shell scripts to dump the data from Oracle to HDFS.
  • Experimented to dump the data from MySQL to HDFS using sqoop
  • Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
  • Performance tuning of Stored Procedures and T-SQL Queries.
  • Performed data conversion from flat file into a normalized database structure.
  • Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.
  • Designed and created the table schema and stored procedures that will be used in Data QC.
  • Used Joins and sub-queries for complex queries involving multiple tables from different databases
  • Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
  • Responsible for documentation of system related activities.
  • Provides technical documentation of the system
  • Actively participated in interacted with users, Technical Lead to fully understand the requirements of the system.

Technologies: SQl Server 2012, SSIS, SSAS, SSRS, Oracle 10g/11g,Toad, Hadoop Horton Works, Hadoop, Hive, Sqoop, Tableau Report, Ambari,, Windows 8, Auto Sys Job.

Technical Lead/Architect

Confidential

Responsibilities:

  • Create new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008/2012.
  • Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
  • Responsible for creating the reports basing on the requirements using SSRS 2008.
  • Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
  • Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
  • Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio.
  • Developed, monitored and deployed SSIS packages.
  • Performance tuning of Stored Procedures and T-SQL Queries.
  • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
  • Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
  • Performed data conversion from flat file into a normalized database structure.
  • Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Designed and created the table schema and stored procedures that will be used in Data QC.
  • Used Joins and sub-queries for complex queries involving multiple tables from different databases
  • Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
  • Responsible for documentation of system related activities.
  • Provides technical documentation of the system
  • Actively participated in interacted with users, Technical Lead to fully understand the requirements of the system.

Technologies: SQl Server 2008/2012, SSIS, SSAS, SSRS, Netezza, Net C#.NET, VB6.0, VBA, Batch jobs & Windows scheduler jobs.

Technical Lead

Confidential

Responsibilities:

  • Involved in architect/ design, development of Data model of Actuate, Data archive Planning/Management and deployment.
  • Extensively used Autosys for scheduling of the UNIX shell script jobs, writing new shell scripts and modifying existing shell scripts.
  • Automating the shell scripts using Autosys Job Scheduler and autosys 4.0 is used to develop jobs; jobs are scheduled individually.
  • Responsible for writing file watcher jobs, box jobs, send event jobs and scheduling jobs Using calendars, time parameters and job dependencies
  • Developing and maintaining a detailed project plan and managing project deliverables in line with the project plan.
  • Managing project scope and escalating issues where necessary
  • Monitoring project progress and performance.
  • Worked with Business Analysts and Users to understand the requirement.

Technologies: SQl Server 2008, SSRS, DB2, Actuate ERD Pro, Business Objects XI Release 4, Crystal Reports XI, Sqldbx, Autosys job, Shell Scripts.

Technical Consultant,

Confidential

Responsibilities:

  • Migrated Existing REG-Reporter application from VB.NET to C#.NET.
  • SQL Server Reporting Services (generation and presentation of listing-type reports)
  • Web Services functionality for historical CRI download, web Services functionality for taxonomy download and web Services functionality for CRI submission
  • Login and authentication and validation for the shared components location setting
  • Failed validity edits processing and support for missing historical instance documents (e.g., for de Novo banks)
  • Reportability Rules processing/logic and primary Interop Assembly for Microsoft Excel 2002

Technologies: SQl Server 2005, SSRS, Crystal Reports XI, C#.NET, VB.NET, VSS and Visio, Autosys, UNIX, Shell Scripting.

Sr Developer

Confidential

Responsibilities:

  • Analysis and planning of business requirements for Universe design.
  • Designed DTS/SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000/2005 environment, and deploy the data; Scheduled the jobs to do these tasks periodically
  • Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS)
  • Architect faux data mart solutions to improve performance of SQL Server 2005 Reporting Services (SSRS)
  • Administered Business Objects Enterprise XI Release 2
  • Installed and Configured Business Objects Enterprise XI R2 in a clustered environment to support failover scenarios.
  • Implemented Business Objects Enterprise XI R2 in a multi tier environment (DMZ, SESF, ESF).
  • Designed WebI reports for Fund Accounting Services and Transfer Agency according to the business needs.
  • Involved in data migration including existing Universe and Repository objects from existing system to a new environment using Import Wizard.
  • Troubleshoot issues during migration & installation on various environments.
  • Designed reports based on Business Views.
  • Migrated More than 700 reports form Access Report to Crystal Report X1
  • Managed running of 1000 reports scheduled in Business Objects Enterprise XI
  • Designed and Developed Report Templates using Crystal Reports XI & Crystal Reports 8.5 for newly developed system and existing systems respectively.
  • Confidential also end-to-end developed many hundreds of complex migration transformations using BODI XI Release 2 (11.5.1.7), and wrote a number of migration quality reports using Crystal Reports XI. We also collaborated on the design and implementation of a Business Objects Dashboard Manager and Performance Manager based data cleansing monitoring and management solution.
  • Involved in designing scorecards for the performance of various Fund Accounting applications.
  • Mapping the business requirements to technical requirements.
  • Extract Transform Load (ETL) development using SQL Server 2005 Integration Services (SSIS/SSAS)
  • Designed and developed end-to-end ETL process for pulling data from SunGard to load UNIX environment oracle database using DTS packages.
  • Extensively used Autosys for scheduling of the UNIX shell script jobs..
  • SQL server 2005, Oracle 9i, Autosys, Windows NT, windows 2000, UNIX, Shell Scripting, TOAD.
  • Transferring files using sftp, ftp and automating the whole process of encryption, file transfer and auditing of file moves and the process of file moves (push and pull).
  • Writing new shell scripts and modifying existing shell scripts.
  • Automating the shell scripts using Autosys Job Scheduler.
  • Autosys 4.0 is used to develop jobs, jobs are scheduled individually and in Boxes.
  • Responsible for writing file watcher jobs, box jobs, send event jobs.
  • Scheduling jobs Using calendars, time parameters and job dependencies
  • Created system architecture diagrams using Visio
  • Designed reports using Crystal reports XI.
  • Scheduled reports using Business Objects Enterprise XI R2
  • Used Microsoft project plan to track the schedule and efforts.
  • Written stored procedures for reports in SQL Server 2005 & Oracle 9i.

Technologies: SSIS Packages, SSRS, ETL, Business Objects XI Release 2, Crystal Reports XI, Microsoft Access 2K Reporting, IIS, SQL Server 2008/2005, Oracle 9i, DB2, Win2K, Visual Source Safe and Visio, Autosys, UNIX, Shell Scripting, TOAD.

Sr Developer

Confidential

Responsibilities:

  • Team Lead and Application Developer
  • Managed all database servers in production, staging, and development and test environments
  • Responsible for the design, development and implementation of mappings/transformations based on source-to-target specifications, defining ETL (extract, transform, load) and ETS development standards and conventions
  • Daily, weekly, and monthly production data processing, monitoring, and trouble-shooting in an environment of mission-critical operational systems, benchmark establishment, and capacity planning.
  • Designed and developed reports using Crystal Reports XI.
  • Implemented Crystal Enterprise XI in a multi - tier environment for Active/Passive failover configurations.
  • Imported data from existing CMS to a new server without affecting the production.
  • Troubleshoot issues in Crystal Enterprise 10 installation and configuration. Managed all scheduled reports and ensured all running of reports hosted in CE.
  • Scheduled reports dynamically in Crystal Enterprise XI using Crystal SDKs such as Report Application Server.
  • Developed batch process for report generation and use with Adobe InDesign.
  • Configured Crystal Enterprise to work in a failover situations by using clustering services provided by crystal Enterprise XI Server.
  • Involved in Support and Maintenance of Crystal Enterprise environment.
  • Implemented Crystal Enterprise XI in a multi - tier environment for Active/Passive failover configurations.
  • Imported data from existing CMS to a new server without affecting the production.
  • Troubleshoot issues in Crystal Enterprise XI installation and configuration. Managed all scheduled reports and ensured all running of reports hosted in CE.
  • Scheduled reports dynamically in Crystal Enterprise XI using Crystal SDKs such as Report Application Server.
  • Configured Crystal Enterprise to work in failover situations by using clustering services provided by crystal Enterprise XI Server.
  • Involved in Support and Maintenance of Crystal Enterprise environment.
  • Designed and Developed ASP.Net forms using VB.Net
  • Designed and Developed Common Secured ADSI Components using .Net Directory Services
  • Developed Common Base Class and User Controls
  • Designed, Developed and integrated reports using Crystal Reports
  • Designed and programmed Webworms ASP. Net, ADO. Net, JavaScript, HTML, CSS, etc
  • Implementation of required Stored Procedures which included Tsql
  • Coded, compiled and debugged ASP. Net, XML in all modules
  • Responsible for Source and Version control using VSS

Technologies: SQL Server 2005, DTS, Enterprise, Query Analyzer, Business Objects XI R2/6.5, Crystal Reports XI, VB. NET, ASP.NET, Oracle, Web services, Infragistics Presentation Layer Utility 2006 V2,, 2K Reporting, IIS, Oracle 9i, Visual Source Safe and Visio, TOAD

Tech Lead/Senior Developer

Confidential

Responsibilities:

  • Preparation Functional and Program Specifications documents.
  • Involved in the requirement analysis, Design, Development & testing of the Application
  • Developed Dynamic Web Pages for Request System using ASP. Net and code behind class written in C#.
  • Designed, developed and implemented Business and Data layer components in C#
  • Used SQL client to Execute Stored Procedures and SQL Text Commands against SQL SERVER database.
  • Designed and developed reports using Crystal Reports 9.
  • Developed formulas and filters in Crystal Reports to fetch the data according to business rules.
  • Developed stored procedures for reports in SQL Server 2000.
  • Involved in design of report templates.
  • Used OLEDB, ODBC connections to retrieve the data for the report
  • User Interface layers created and integrated to maintain the performance of data flow and data integrity using ASP.Net User Controls, Web Server Controls and ADO. Net.
  • Exporting data to CVS using XML writer
  • Enforced Code Access Security on the assemblies created in C# by creating Strong Name to the assembly where CLR of the .NET Framework has its own secure execution by enforces security policy based on where code is coming from rather than who the user is.
  • Implemented SOAP protocol to allow conversion of data from Email to Word Doc and Text file, and presented the data in XML format.

Environment: Crystal Reports 8.5, VS.NET 2002, Dot Net Framework, C#. Net, ASP. Net, ADO.NET, XML, XSL, IIS, Web Services, Java Script, SQL Server 2000, TOAD, Windows 2000 and HTML.

Hire Now