SUMMARY

• Overall 7 years of IT experience, 3 years as a Workday Consultant in developing Integrations/Reports using Workday Tools. 4 years as a SQL BI Developer with expertise in analyzing, designing, tuning and developing of Data Base and enhancement of new business processes.
• Supported the implementation of a new client on the Workday platform by defining, documenting and testing functional business processes for Workday HCM including Core HR, Recruiting, Talent and Performance Management and Periodic Compensation.
• Hands on Workday HCM systems integration implementation experience and working noledge on Workday Payroll, iLoads, Inbound/Outbound Integrations, Data Migrations and Reporting.
• Experience with software as a service - workday ( Saas)
• Experience in leading and managing teams. Handled multiple roles - Project Lead, Software Architect, Developer and Systems Analyst.
• System Support for private companies including broad industry experience in Finance Industries and Finance modules
• Experience in Human Capital Management and Financial Management and Employee Expense Management
• 3 years of Extensive experience as a Workday Integration Consultant in analyzing PeopleSoft documents, reports, queries, SQLs etc. and transforming them into Workday Technical design documents.
• Proficient in agile scrum methodologies and experienced with SDLC using Waterfall, Agile and Software Testing Life Cycle (STLC).
• Analyze, design and recommended solutions which included Customization of pre-existing interfaces, integration points, bolt-on and UI enhancements.
• Experience in performing requirement analysis, design, conversion, Migration and testing including developing functional specifications from functional requirements and customizations of projects.
• Experience in documenting Business Process Procedures and End User Training.
• Advanced reports design and development, Configuration of Dashboards, Worklets and advanced analytics.
• Experience in developing and supporting “Workday Studio Integrations”.
• Worked on field mapping of legacy data with the corresponding PeopleSoft benefits and payroll data.
• Experience in conducting discovery sessions for Workday Integrations.
• In-depth IT experience in support of human resource processes such as employee data management, organizational structure management.
• Experience with data flow and object modeling, case analysis, workflow analysis and functional decomposition, customization and data migration, testing and training services.
• Experience in designing Workday Integration Implementation plan, conducting blueprinting sessions
• Good noledge of EIB Inbound/Outbound integrations, Workday Studio, Report Writer and Calculated Fields.
• Expert in utilizing ETL tools including SQL Server Integration Services (SSIS), Data Transformation Services and ETL package design.
• Expertise in Microsoft Reporting Services (SSRS) with Report authoring, Report Management, Report Formatting, Report Distribution, Report Delivery and Report Security.
• Ability to work cross-functionally with various stakeholders and team members.
• In depth noledge of Software Development Life Cycle (SDLC) phases such as Requirement analysis, Design, Development, Testing and Deployment.
• Decisive problem solver, effective communicator and team player with a focus on adding value to stakeholders and clients.
• Quick learner and excellent team player having ability to meet tight deadlines and work under pressure.
• Excellent communication / analytical skills

TECHNICAL SKILLS

Operating System: Windows 95,98,NT, XP, Vista, 7,MS-DOS

Databases: Microsoft SQL Server 2000, 2005, 2008 R2, MS Access

Application Tools: Microsoft SQL Server Management Studio, Query Analyzer, Export and Import, DTS, Microsoft SQL Server Integration Services (SSIS),VB Macros, Visual Studio 2008/2010, Team Foundation Server 2008/2010

Languages: T-SQL, PL/SQL, .NET, Visual Basic 6.0, HTML, C, C++, XML, XSLT

SAAS: Workday HCM 19/20/21/22, Employee Contracts, Workday Studio, Custom Reports, Calc Fields, Packaged, Payroll Reports, EIB, Core Connector, Report Writer

Reporting Tools: Crystal Reports 8/10, SQL Server Reporting Services (SSRS), PS Reporting Tools

Version Control: Team Foundation Server, JIRA

Other Tools: Windows MS-Office, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Pittsburg, Pennsylvania

Workday Consultant

Responsibilities:

• Created Supervisory Organizations, Cost Centers, Cost Center Hierarchies, and location hierarchies' maintenance, and modification ofWorkdayBusiness Processes and definitions.
• ConfiguredWorkdaycompensation packages including salary, bonus, allowance, commission, and merit plans for multiple countries including merit and bonus plan processing.
• ConfiguredWorkdaybenefits including groups, plans, coverage types, event types, and eligibility rules for multiple countries.
• Worked onWorkdayconversion processes and tools like iTool, EBI,WorkdayStudio etc.
• Worked alongside the integration team to configure and test integrations between theWorkdaysolution and the client's selected payroll and benefits providers
• Maintained the integrity of the employee information within the systems by performing regular system audits, working closely with HR and end-user teams
• Assist the integration consulting team in halping to configure and test integrations betweenWorkday and third party/custom solutions. Automate processes where possible
• Worked on WorkdayData Migration through iLoad and spreadsheets
• Responsible for Build and Delivery of Workday Integrations dat were built using EIB’s, Cloud Connect and Workday Studio.
• Created customWorkdayreportsand modify/troubleshoot existing customreports. Troubleshoot integrations.
• Write, maintain, and support a variety ofreportsand queries - both standard and custom.
• Maintained and updated different pay groups on a daily basis
• Worked with eDesk to resolve everyday defects and issue handling
• Documented workflow, configurations, business process for performance module using Excel, MS project and Visio
• Observe the standards and procedures established by the project office and Track business needs during development phases in Business Life cycle.
• Streamline processes dat enhance operational efficiencies of HR systems. Maintain application securityand conduct access control review
• Setup business process steps, such as Action, Approval, Approval Chain and Checklist, and how they work and integrate withsecuritygroups
• ConfiguredWorkdaysecurityroles and groups to the required level of confidentially and segregation of duties.
• Work with business team to review report requirements. Maintain/Assignsecurityrole assignments
• Maintain/Support HCM business processes

Environment: Workday, Workday EIB, Workday Studio, Core Connector, eDesk, XML, XSLT, WebService, PeopleSoft, Data Warehousing, Data Cleansing, MS Project, User Acceptance Testing (UAT), MS

Confidential, Montclair, NJ

Workday Financial Consultant

Responsibilities:

• Develop and execute custom configured reports in financial management in Workday, and other systems, and provide detailed analysis and recommendations as needed.
• Meet with customers to gather requirements for new reports and for existing report defects or enhancements.
• Provided reporting support to the finance departments Business Expense system via reporting tools
• Contacting SMEs and Solutions Architects to discover and formulate the scope of requirements for Integrations andReports.
• Produced and distributed monthly financial reports to the chief financial officer.
• Developed complex custom reports and also leveraged the Workday built in reports.
• Proficient in creating various types of reports like Simple, Advanced, Matrix.
• Provide input to planning of work activities as well as manage execution of day to day activities related to HCM operation
• Managed Benefits open enrollment process from inception to administration
• Maintained and supported all the HR Business processes like compensation, Hiring, Performance and talent management implemented on workday
• Designed, implemented and administered benefits programs such as life, health and insurance, retirement plans and employee assistance etc
• Worked directly with key business and IT stakeholders to confirm requirements, consider design alternatives, facilitate discussions and ultimately drive requirements sign-off.
• Provided strategic direction and managed IT resources on all HR related IT initiatives
• Provided financial expertise management in managing diverse projects for a manufacturer and global distributer
• UsingWorkdayStudio to bring in daily worker data changes toWorkday
• Generated ad-hoc reports and queries as specified and developed specifications for other reports and metrics using Workday report writer including the use of calculated fields.
• Developed outbound integrations using Enterprise interface builder (EIB), Web services, Document Transformation and Workday Studio for several integrations from Workday to downstream internal and vendor systems.
• Configured various aspects of workday HCM such as compensation, Business Processes, Payroll, Benefits and Reports
• Executing the day to day activities of workday advisory engagements for a variety of clients including process design, package implementation lifecycle support and project reviews
• Involved in data conversion from legacy systems to workday HCM
• Identified opportunities for business process improvements and make recommendations as appropriate
• Compiled and prepared a summary of overall monthly Finance transformation operation results in reports and updating the trend analysis and finance transformation each month with workday reporting
• Configured Workday compensation packages (post implementation) including salary, bonus, allowance, commission, and merit plans for multiple countries including merit and bonus plan processing.
• Day to day support of Workday HCM, security, compensation and reporting issues.
• Developed integrations using web services on the Workday clout platform such as Payroll Integration, ADP Inbound/Outbound, Active Directory Inbound and UDW Inbound/Outbound.
• Build reports using Workday’s Report Writer.
• Completed tasks like hiring, Implementation of a new delivery model and working with the sales and delivery teams to correctly bill the new development model
• Performed System, UAT, Stress/Performance, and parallel efforts throughout the life of the implementation.
• Extensively used Report Wizard, Report Builder and report Manager for developing reports and deploying reports in SSRS
• Provided technical support and served as a Subject Matter Expert/provide training to educate system end users on how to navigate and use the system as needed.

Environment: Workday, Workday EIB, Workday Studio, Core Connector, XML, XSLT, WebService, PeopleSoft, SQL, SSIS, SSRS, Data Warehousing, Data Cleansing, MS Project, User Acceptance Testing (UAT), MS

Confidential, Calhoun, GA

Workday Integration Client

Responsibilities:

• Worked on Post-implementation support and enhancements.
• Design, Build, Test and Deploy integrations.
• Generated monthly financial reports for senior management using Excel
• Developed Integration technical documents, which includes scope discovery review, field mapping, data transformation and translation rules and test cases.
• Involved in the implementation of a Financial Management project to enhance customers ability to make informed financial decision
• Assisted and directed various finance projects like audits and member invoicing
• Worked with the workday Finance management Suite both strategically and tactically
• Participated in the design and optimization of all global HR processes. Ensured dat the Workday HCM system is configured and leveraged to support HR/Payroll business processes.
• Manage integrity and accuracy of Workday, while serving as HCMS expert in support of HR business processes and data integration.
• Perform technical analysis to determine present and future financial performance for Financial Management
• Worked as a Reporting Specialist to create custom reports using Workday Report Writer to meet the business needs of HR and Payroll application report consumer groups.
• Understand Legacy reporting requirements and translate them into Workday reports.
• Implemented integration solutions with existing financial software, third-party service vendors.
• Provided Strategic vision and worked with multiple finance system and created the strategy and scope for finance implementations
• Assisted on Performance Management, Workday Absence Management and Workday time tracking
• Produced Ad-Hoc reports as required, often combining data from multiple sources to achieve desired results.
• Worked closely with the client’s project teams to ensure dat the customer’s successful deployments Workday’s Integrations.
• Developed data analytics and dashboards to satisfy requirements.
• Coordinated with other IT resources to support configuration of SFTP sites and Single Sign on capabilities as needed to support project requirements.
• Maintain log of issues for existing reports & document new report needs.
• Managed integration deliverables associated with Workday Implementation projects.
• Responsible for Database creation, MS Access Queries and Custom reporting, with intensive data manipulation.
• Responsible for developing the reporting strategy for the HCM Domain. Advised the business on the use of leveraging Workday Standard Delivered reports.
• Daily Implementation of company data into Workday and migration of system information.
• Responsible for Build and Delivery of Workday Integrations dat were built using EIB’s, Cloud Connect and Workday Studio.
• Documentation of system changes, and business processes for upgrades and capture of business processes.

Environment: T-SQL, Workday, Workday EIB, Workday Studio, Core Connector, XML, XSLT, WebService, Log Management, Data Warehousing, Data Cleansing, MS Project, SQL

Confidential, Hoboken, NJ

Workday Integration Consultant

Responsibilities:

• Hands on Workday Systems Integration experience building custom integrations using Workday Studio, Cloud Connect and Document Transformation.
• Designed the customizations to suit the business requirements and wrote the technical specifications.
• Responsible for company owned integrations which send non secure data to consuming applications within the company via DIME (ETL Application)
• Performed fit-gap analysis and retrofitted the customizations after completing an impact analysis on what is delivered for Fields, Records, People Code, SQR and Application Engines.
• Creating the new business processes and notifications in deployment and sandbox tenants based on the designed business flow diagrams.
• Experienced in leading design session for multiple financial functional areas
• Developed and Outbound interface (AE) providing voucher information after voucher post processing for current accounting period.
• Worked with Workday Report Writer and creating custom integrations with third party applications using Workday Cloud Connect and Enterprise Interface Builder (EIB).
• Recommend better solutions for customization based on new features available and perform end-to-end development of project from planning and implementation.
• Held meetings to look at financial reports from different departments
• Involved as a key resources in the following areas during the implementation and Post-Production support activities of Workday HCM: Core Organization Setup Configuration of Business Processes and Compensation Configuration, Workday Security Configuration, Integration Maintenance and Modification Enterprise Interface Builder (EIB), me Load & Report Writer Tenant setup activities, alert and notification configuration Preparing the KAD document as key document for each release.
• Involved in the design phase and prototyping for further discussions with the client.
• Created new permission lists and roles for Security Administration.
• Used sequence generators, generating templates and validating inbound integration system resources. Good noledge of Domain, Role and User based security.
• Created and used calculated fields in reporting, business processes, integrations and other areas within Workday.
• Converted data from 8.8 custom modified records to delivered records to 9.1
• Created SSIS package to check XML file validation and data validation to match the requirements.
• Created new integrations to pull the new hires information using Core Connector Worker and document transformation, which uses connector integrations XML output as its data source input.
• Involved in Data Conversion and Workday BP Configuration.
• Designed and developed a set of integrations to integrate Workday HR with recruiting system.
• Created and modified SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued parameters, Debugging Parameter issues, Matrix reports and charts.
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS.
• Created drill down, drill through, ad hoc, linked, sub and charts using SQL server reporting services 2012/2008 (SSRS)
• Provided training to Clients to develop their own ad hoc reports using SSRS

Environment: T-SQL, Workday, Workday EIB, Workday Studio, Core Connector, XML, XSLT, WebService, Log Management, Data Warehousing, Data Cleansing, MS Project, SQL, SQL Server Reporting Services (SSRS)

Confidential, Saint Paul, MN

SSRS Developer

Responsibilities:

• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for Developing Cubes using MDX.
• Linked database to Excel Spreadsheets of BLT Decks mainly for Personal Care, Perishable and Non-Perishable Items.
• Linked Database Tables to get the reports, routinely, in the excel sheets, required by the managers for analysis
• Design tables using file streaming for image and different schema tables for better performance, backup and recovery.
• Designed and createdReport templates,bar graphsandpie chartsfor analyzing data.
• DevelopedDrill down Tabular, Matrix and List Reportsof the project given by Tech Lead/Manager usingSSRS.
• Created parameterized Reports using Charts, Cross- Tab and Sub- report types
• Developed reports using complex formulas and to query the database to generate types of ad-hoc reports using SSRS
• Created reports using SSRS from SAS and DB2 after analysis of data.
• Experienced working with SAS data analysis.
• Design and developSSISpackages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Created SSIS packages to transfer Access tables into SQL
• Deploying andscheduling ReportsusingSSRSto generate alldaily, weekly, monthlyand quarterly Reports including current status.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses (since Stored Procedures passes the whole block at one time).
• Analyzed and developed stored procedures, complex queriesusing complex joins, co-related, sub-queries for the application.
• Designand developSSISpackages, store procedures, configuration files, tables, views
• Created report Model on SSAS Cubes as well as changing default configuration on existing Cubes.
• Setup ETL procedure using linked server for Oracle database.
• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures, with a lot of interaction with the client.
• Performance tuning on stored procedures.

Environment: T-SQL, Query, Windows XP, SQL Server 2005/2008 R2 Enterprise Edition, Windows 2003 advance server, SQL Server Integration services (SSIS), SQL Server Management Studio (SSMS), Data modeling, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Access, VB Macros, Visual Studio 2008/2010, Waterfall development, Team foundation Server 2008/2010

Confidential, Iselin, NJ

Sr. BI Developer

Responsibilities:

• Installed the patches and service packs for the SQL server 2008/2005.
• CreatedSSISPackagesto import and export data fromExcel Spreadsheets, Text file, MS Access and CSV files.
• Developed some codes to work on Visual Studio 2008 and Team foundation server also used the same code in SSRS to generate Reports.
• CreatedSSISPackages for bothOLTP and OLAPdatabase.
• Created and scheduled the packages using SQL Server DTS packages.
• Used SSIS and extract transform loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• DesignedDTS/SSISpackagesto exportandimport data from SQL ServertoMS Access, Oracle10g, text filesandExcel files.
• Migrated simpleDTS packages toSSISpackages usingDTS Migration tool.
• Automated consistency check of the database (DBCC) for SQL Server.
• Performed successful migration from database SQL server .
• Has designed, developed and implemented database securityin SQL server 2008 successfully.
• Monitored and scheduled existing/new jobs on production environment.
• UsedSQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
• Extensively usedImport/Export wizardto convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data typeand Vice versa.
• Used Reporting Services (SSRS) to generate Reports in PDF, Excel, and CSV format.
• Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions.
• Provided technical architecture and database engineering support to move databases from development to test and production for multiple applications.
• Developed and maintained Enterprise database management Architecture for SQL server 2005.
• Monitored MS SQL Server performance using performance monitor and profiler.
• Created login accounts and database user accounts and managed database security using groups and roles.
• Created Logical and physical Data models for SQL server 2005.
• Developed, deployed and monitoredSSISPackages including upgrading DTS toSSIS.
• Used most of the controls and features inSSIS/DTSfor transforming data from different sources.
• Involved in building an extensiveOLAPdatawarehouse onSQLAnalysis services (Cubes, stars schema)
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Developed C# CLR using windows base authentication and custom authorization, for use validation for Scanner.
• Used MS SQL Server reporting services (SSRS) to use daily report basis with client-server application.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.

Environment: T-SQL, Query Analyzer, SQL Profiler, Windows XP, SQL Navigator, SQL Server 2005/2008 Enterprise Edition, Windows 2003 advance server, SQL Server Integration services (SSIS), SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Access, VB Macros, Visual Studio 2008, Team foundation Server 2008

Confidential, Bronx, NY

SQL Developer

Responsibilities:

• Installed SQL server 2008 on windows 2003 advanced servers, applied service packs and security fixes.
• Imported Data from text files and excel spread sheet into SQL Server 2008 database using SSIS package.
• Worked with OLTP to provide services and streaming informational display within the videoconferences.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications
• Has done migration of database SQL server successfully.
• Developing triggers, stored procedures and enforcing business rules via checks and constraints
• Performance tuning and optimization of procedures and queries.
• Configured product meta-data tables to support client data reporting needs.
• Performance: Analyzed database performance with SQL Profiler andOptimized indexes to significantly improve queries.
• Written complex SQL statements using joins,sub queriesandcorrelated sub queries.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• CreatedSQL reports,data extractionanddata loading scriptsfordifferent databases and schemas.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, usingSQL Server Reporting Services (SSRS).
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option usingSSRS.
• Data transfers between various servers usingBCPandSSIS.
• Designed and developed theER Diagramsfor the logicalDatabase Model in Erwin data modeler.
• Assisted inproduction OLAPcubes, wrote queries to produce reports usingSQL Server 2005/2008and reporting service (SSRS).
• Writing queries to generate reports for analysis of data using SQLServer Reporting Services, Report Builder.
• Designed and createdReport templates,bar graphsandpie chartsfor analyzing data.
• Based on the requirements designing and implementing a variety ofSSRSreportssuch asParameterized,Drilldown,Dynamic sorting, Defining data source, Ad hocandSub-reportsusingGlobal Variables, Expressionsand Functions inReport DesignerandReport Builder.

Environment: Windows 2003 Advanced Server, MS SQL Server 2008/2005, SQL Server Integration services (SSIS), SQL Server Management Studio (SSMS), SQL Server Reporting Services, MS Access

Confidential

SQL Developer

Responsibilities:

• Created new database objects likeProcedures, Functions, Packages, Triggers, Indexes and ViewsusingT-SQLin Development and Production environment for SQL Server 2000.
• Created Visual Basic applications to update Production databases.
• Created Triggers and Stored Procedures for back-end validations.
• Performance monitoring of Servers and Tuning SQL Code.
• Establishing connectivity between Application software and the database.
• Writing Windows Batch Programs to automate operations.
• Testing of applications for performance, data integrity and validation issues.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Managed historical data from various heterogeneous data sources like Excel, Fixed Width Flat Files.
• Migration: copied production SQL Server 7.0 databases to test server running Windows 2000 Advanced Server and SQL Server 2000.
• Develop and maintain in-house utilities to automate problem determination, change
• Implementation and monitoring activities.
• Writingcomplex Stored Proceduresto meet the business requirements.
• Creating tables,relationships,triggersandindexesfor enforcing business rules.
• UsingSQL Profilerto estimate the Slow Running queries andperformance tuningpurpose.
• Created and maintained various databases for production, development and testing usingSQL Server 2000.
• Import Data from MS-Access Database and XML to SQL Server Database.
• Created packages, procedures, functions, and triggers.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent Data entry into the database.
• Imported data from text files and excel spreadsheets intoSQL Server 2000 database using DTS package.
• Worked on Migration techniques across differentdatabases and servers.
• Created Users and Roles, and managed security and permission of database.
• Involved in analyzing SQL Server Storage Structure, Index and Security Architecture.
• Setup the SQL Mail in SQL Server 7 to allow SQL Server to send and receive E-mail by establishing a client connection with a mail server.
• Worked on DTS packages for transferring data from various data sources like Oracle, MS Access, Excel, *.Txt file, *.CSV files.

Environment: MS SQL Server 7/6.5, MS SQL Server 2000, Windows NT, DTS