Krishnan A Email & Phone Number

Scranton, Pa, Us

Boston, Ma

Responsibilities: • Mentoring a team of 8 people as a Senior Member of my Team• Requirement gathering and analysis of new requirements for various financial and Healthcare domain projects• Responsible for developing data strategy, data model components and Master DATA Management. • Analyzed legacy and data sources to bring ALL DATA to a centralized environment and developed data governance, data quality and architected to analyze large volume of information• DML data manipulation, Data modeling, Crystal reports, Data retrieval, handling security application in SQL server database and report development• Managing Permissions with Stored Procedures, Signing Stored Procedures in SQL server• Customizing Permissions with Impersonation in SQL Server, Granting Row-Level Permissions in SQL Server• Data synchronization using ETL process of Data flow and Control flow in SSIS package.• Master Data Management, Microsoft SSIS Packages, Database Design and Data warehouse – integrated and Nonvolatile collection of data that supports management's decision-making process• Monitoring regular production activities, Data Analysis using Excel.• Verify all scheduled SQL jobs have run successfully without any issues.• Used various transformations in SSIS like Data Conversion, Lookup, Fuzzy grouping, Conditional Spilt, Pivoting/Un-Pivoting Transformations with error handling for different modules.• Built efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions.• Scheduled SSIS packages by creating corresponding job tasks.• Created logical model including Entity-Relationship diagram.• Developed T-SQL, stored procedures, functions, triggers and views.• Managed server security, created new logins for users for System Integration Testing (SIT), User Acceptance Testing (UAT) and on production environment

Moosic, Pa

Responsibilities: • Writing SQL queries to Create tables, update, delete and search entries.• Identified business priorities on MDM subject areas. Translated business requirements to technical implementation. • Designed MDM solution for integration plan and hub architecture for customer, products, and vendor.• Used SQL queries and stored procedures to generate account opening criteria in the system.• Database creation, applying Patches, installing SP on SQL Server Database• Checking Alert logs Files, Trace Files, System Event Logs and Sql Server Logs for unusual events.• Developed the Custom Form and Customized the existing form as per the client requirement.• Customized standard reports to include project information.• Extensively used XML, HTML for developing visually appealing User Interface pages of the web modules.• Configured SSRS Reports in Share point Environment.• Created SSRS reports using Share point Data sources.• Deployed BI Features in Share point 2010.• Created Power Pivot data sources for creating Power View Reports.• Used dynamic SQL extensively in stored procedures.• Generated Adhoc reports using T-SQL• Created SSRS reports using Share point Data sources.• Created Power Pivot data sources for creating Power View Reports.• Developed, configured and Deployed reports in MS SQL Server environment using SSRS-2008• Worked on Sub Reports, Data Drill-Down and Data sorting/grouping Report Design in SSRS.• Designed and created Report templates, bar graphs and pie charts based on the financial data.• Used dynamic parameters in SSRS to enable/disable parameters based on user selection.Environment: SQL server 2008 R2, XML/SGML, MS Visio 2007, Windows 2000 Server, Perl Script, VB Script, SSIS, SSRS, Share Point 2012

Chennai Area, India

• Used PL/SQL to create stored procedures for Entity Summary Pages.• Writing Backend Procedures, Functions & Packages in PL/SQL• Troubleshooting experience in debugging and fixed the wrong data or data missing problem for SQL Database• Involved in data migration from SQL database to Ms Access.• Worked on Tuning the SQL Queries for better performance and troubleshooting development problems.• Experienced in installing, creating SQL databases in different platforms like Red Hat Linux, and Windows.• Offering SQL query for Cold Fusion front-end page directly.• Used dynamic SQL extensively in stored procedures.• Create Functions and Views using T-SQL in Development and Production environment for SQL Server 2008/2005. • Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.• Created SQL Server query to generate XML files.• Implemented transaction executions safely by using COMMIT and ROLLBACK commands.• Managing the production database for SQL Server and resize the space of database/Datafiles/Tablespace/Transactional Logs• Creating, Updating, Altering Table space, Indexes, Tables, Views, Synonyms, Profile, Role, Privileges• Creating/Managing users profiles and analyzing their privileges and tables pace quotas

Puducherry Area, India

• Analyze the DTD• Making sample coding for New SGML / XML projects• Preparing Key Instruction for Data Entry Department• Converting Data Entry to XML files through automation tools• Manual checking for converted files and Proof Reading 100% on Text• Data Conversion (.doc ) file to ( .rtf ) file• Data Converting (.rtf ) file to ( .sgm ) SGML file• Parsing, Validating and Style Sheet checking using (.xsl)• Converting (.EPS ) files of equations to XML ( for eqn. Math-type Software is used)• Uploading error free XML file to 3B2-Pagination• Extracting work: Extracting Paginated files for Electronic Deliverable work• Run-on work: for Paginated Articles

Pondicherry Area, India

• HTML, SGML, XML tagging as per client Document Type Definition• Hard Book to Doc / HTML / SGML / XML conversion• Data content file to SGML / XML conversion, Web PDF• Tracking mails and follow-up, Sound knowledge in MS Office• Developing profile report to analyze source data• Experience in ED – work ( Electronic Deliverable ) Journals & Books Projects• Making E-journals & E-books• Sending archive files to customer• Suggesting several measures to improve the quality and timeliness of the Projects, which also reduces the manual intervention of operators and makes the work easier• Mathml and Tech coding for Equation composing, 3B2 Template knowledge• Can complete a specified module / Project before the time stipulated